Attempting to reduce RAM, SQL I/O write errors

Greetings to all the UNA family! With TMD Hosting and a dedicated server, I get frequent and frustrating sql I/O write errors to tmp files. I am allowed 4 gigs of RAM, they say.

The issue persists when even a few users are logged in to the site. Once logged in, every page access generates a new sql, notifications-based, i/o error.

Is there a setting or a strategy whereby I can reduce RAM loads? On the Timeline, the number of entries can be reduced, I am aware. I also reduced the number of notification categories. Is there perhaps a rewrite or cache setting I'm overlooking?

When I turned off the Notifications module - the errors stop. Also, if not logged in - again, no sql errors are generated by the Notification Module. Like this one , for example:

(SELECT DISTINCT `bx_notifications_events`.* FROM `bx_notifications_events` LEFT JOIN `bx_notifications_handlers` ON `bx_notifications_events`.`type`=`bx_notifications_handlers`.`alert_unit` AND ((ISNULL(`bx_notifications_settings2users`.`active`) AND .........` bx_notifications_settings2users`.`active`='1')) ORDER BY `bx_notifications_events`.`date` DESC, `bx_notifications_events`.`id` DESC LIMIT 0, 6) ORDER BY `date` DESC, `id` DESC LIMIT 0, 6

Mysql error: Can't create/write to file '/tmp/#sql_482_1.MAD' (Errcode: 5 "Input/output error")

Also, this looks amiss: deflate_module - UNDEFINED -AND- expires_module - UNDEFINED

Much thanks for your consideration!

  • 701
  • More
Replies (6)
    • Why do some sql errors result in the page displaying the error message in a bold red box without the page content? Other sql error messages are only sent through the mail - the actual page displays just fine. What is the difference?

      • Example of page content not being displayed. Other times the same page displays fine but an error is sent via email. I have not adjusted the settings which control whether or not error messages are displayed for troubleshooting purposes.

        Any clues?

        image_transcoder.php?o=sys_images_editor&h=824&dpx=2&t=1670541016

        • If the paths and permissions are correct for the tmp write document, the sql i/o write issue is most likely due to insufficient resources - ram or disc space. Not a UNA, but a hosting issue.

          I hope this helps someone later.

          • Just came accross your post...are you saying that even with tmd dedicated server....there are issues with only a few users online? Cant handle few users without errors?

            • The issue was in insufficient disk space in /tmp folder as stated above, so it's not UNA problem.

              • I know Alex, I was referring to tmd since i got their enterprise cloud and was wondering how soon i would need to upgrade server...

                Login or Join to comment.