/tmp partition full of sqlarchive files
Hello,
We're experiencing an issue where occasionally the /tmp partition on the WHM server becomes filled with files with sqlarchive in the name (followed by random characters).
The event is a bit unpredictable (happens ~once per month) and causes downtime for our customers because the database stops responding when it occurs.
I plan to add automation to clear these files when the issue occurs, but that's a workaround. What is the proper way to prevent this from happening?
LP,
Jure
-
Hey there! The ultimate solution is to either figure out what MySQL process is causing these, or change /tmp to be larger to handle the issue. More details on a similar MySQL operation that leads to a full /tmp can be found here:
https://support.cpanel.net/hc/en-us/articles/360060225514-mysqld-fills-tmp-with-file-tmp-sql-MAD
but ultimately this isn't something cPanel has a way to control as this is all handled by the MySQL processes.
0 -
The article you linked mentions files with a different extension. I doubt a user process is creating these files, user accounts don't have access to system /tmp . This is something to do with a process within cPanel.
If an infinite number of files is being created by something going awry, a larger /tmp partition will not change anything.
0 -
Thanks for the additional details. Unfortunately I'm not seeing any other entries for the string "sqlarchive" in our ticket system, so I don't have much else I can provide at this time. It might be best if you created a ticket so this system can be examined directly.
0
Please sign in to leave a comment.
Comments
3 comments