Skip to main content

The filesystem “/tmp” mounted at “/tmp” reached “critical” status because you currently use 100%

Comments

10 comments

  • ffeingol
    The #sql-temptable are temporary tables created by MySQL. You'll need to track down what's creating those large files to solve your issue. The fun part is tracking it down. You'll need to be able to catch it while the table is being created and then look at the MySQL process list to see what user is creating them. It should be safe to delete all the #sql-temptable* as they are only temporary tables.
    0
  • cPRex Jurassic Moderator
    What @ffeingol said. You'd specifically be looking for code like this in MySQL queries:
    0
  • ffeingol
    It could be a number of things other than "create temporary table". Aggregates (things like count, etc.) can cause MySQL to automatically/internally create a temp table to calculate the results.
    0
  • SimpleSonic
    Another option (Not for beginners) is to increase the size of /tmp:
    0
  • DennisMidjord
    Another option (Not for beginners) is to increase the size of /tmp:
    0
  • SimpleSonic
    That will not fix the underlying issue, though. It will only increase the time it takes for the /tmp partion to run out of space.

    But, it will provide you with more time to find and fix the underlying issue.
    0
  • rafael.martinez
    Hello, A few months ago I had the same problem and I solved it using the "tmpwatch" project You can find more information at:
    0
  • cPRex Jurassic Moderator
    tmpwatch also just clears the data, and doesn't find the database issue.
    0
  • max101
    I found out which user and script it is. It's the software called "xenforo" If i restart the server without deleting those #sqltemptable files. Xenforo starts working again and the #sqltemptable fiiles disappear. I didn't have to delete them. But it all restarts every 24 hours again. I will keep searching to see why it's doing that.
    0
  • ffeingol
    xenforo is forum software. You/your client may be able to search the xenforo site/support/forum to see if anyone else is having similar issues.
    0

Please sign in to leave a comment.