So I am maintaining a mysql server, and every couple of days in irregular intervals the boot disk fills up almost completely in a matter of moments (often into the 99,X% range), before emptying soon after.

I am assuming that these are ibtmp tables for the occasional badly optimized query. The slow log is empty and I am not sure what exactly is the culprit here. Until I find out, am I in danger of the disk filling up completely and consequent outages or is this acceptable and are there safeguards against that?

  • The safeguard for that would be mounting a separate file system for MySQL data path (and also separate file systems for /tmp and /home, while you are at it). You do need to identify the queries using excessive temp space and see if they can be optimised. – mustaccio Feb 12 at 15:03
  • OS? MYSQL version? Disk capacity? Data size? Transactions rate? DB and tables number? etc, etc , etc? – Jesus Uzcanga Feb 12 at 15:09
  • What are these temporary files and where do you find them? Are they in tmpdir or in the datadir? – akuzminsky Feb 12 at 16:38
  • I am assuming that these are ibtmp Check, and either make sure that this assumption is correct, or find the real reason. – Akina Feb 12 at 18:10
  • 1
    Please understand that - going by the comments listed above - there are follow ups right since you asked this question. Which means the question is going to be a matter of interest to developer community. But it lacks details. Please add details of what @JesusUzcanga and akuzminsky asked for. Help us to help you AND help the whole community get the knowledge from this post in future too. – Natarajan N Napoleon Feb 13 at 4:35

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.