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!
-
- · banister
- ·
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?
-
- · banister
- ·
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?
-
- · banister
- ·
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.
-
- · Nurke
- ·
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?
-
-
·
Alex T⚜️
-
·
In reply to Nurke
- ·
The issue was in insufficient disk space in /tmp folder as stated above, so it's not UNA problem.
-
·
Alex T⚜️
-
- · Nurke
-
·
In reply to Alex T⚜️
- ·
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...