Comments on: Trick: recovering from “no space left on device” issues with MySQL https://shlomi-noach.github.io/blog/mysql/trick-recovering-from-no-space-left-on-device-issues-with-mysql Blog by Shlomi Noach Sun, 27 Oct 2013 04:24:17 +0000 hourly 1 https://wordpress.org/?v=5.3.3 By: Shantanu Oak https://shlomi-noach.github.io/blog/mysql/trick-recovering-from-no-space-left-on-device-issues-with-mysql/comment-page-1#comment-221964 Sun, 27 Oct 2013 04:24:17 +0000 https://shlomi-noach.github.io/blog/?p=6487#comment-221964 I do not prefer “pushing the limits” like this on production server. I make sure that there is always “more than enough” free disk space available. But this is a good tip and I will use it on slave / development machines.

]]> By: shlomi https://shlomi-noach.github.io/blog/mysql/trick-recovering-from-no-space-left-on-device-issues-with-mysql/comment-page-1#comment-219914 Sun, 29 Sep 2013 13:43:57 +0000 https://shlomi-noach.github.io/blog/?p=6487#comment-219914 @Shantanu,
Quoting the above: “I have monitoring, but sometimes I’m hoping to make and operation on 97%-99% utilization.”

Of course you must have monitoring on this. And you might be intersted to get notified when the disk space runs over 95%. But what if I want to push the limits for a specific operation? OK, set it for 99%. Cool. This may still leave me with 6GB I could utilize. I may want to push the limits — and history shows that sometimes you may just get by at a close margin.

]]> By: Shantanu Oak https://shlomi-noach.github.io/blog/mysql/trick-recovering-from-no-space-left-on-device-issues-with-mysql/comment-page-1#comment-219894 Sun, 29 Sep 2013 08:46:31 +0000 https://shlomi-noach.github.io/blog/?p=6487#comment-219894 I do not agree with this dummy file hack. The best way is to write a shell script and set it up in crontab that will send an email alert whenever the free disk space is low. (Assuming you do not have nagios or any other monitoring tool in place)

]]> By: Ronald Bradford https://shlomi-noach.github.io/blog/mysql/trick-recovering-from-no-space-left-on-device-issues-with-mysql/comment-page-1#comment-217642 Fri, 23 Aug 2013 19:34:44 +0000 https://shlomi-noach.github.io/blog/?p=6487#comment-217642 Disk full problems vary depending on what type of data it is, and where it is.

Having all data on the root (/) partition is bad, I have had 2 recent experiences where deleting files would not reclaim space (i.e. df stayed at 100% even hours after), the only option was a system restart.

As you say having a dummy file for the @@datadir is a tip I have used in the past.

In my specific post this was a binary log space problem, where this was a dedicate partition. This could also benefit from the dummy file solution.

MySQL acts very differently depending on if the @@tmpdir, @@datadir or @@log-bin partition locations are full.

]]> By: Justin Swanhart https://shlomi-noach.github.io/blog/mysql/trick-recovering-from-no-space-left-on-device-issues-with-mysql/comment-page-1#comment-217623 Fri, 23 Aug 2013 15:03:33 +0000 https://shlomi-noach.github.io/blog/?p=6487#comment-217623 Don’t forget that most ext* filesystems have reserved space that can be allocated in an emergency.

]]>