MySQL Errors Due To Disk Space

[tenub]

Tue, Aug 27 2013 5:50am

It seems I've been getting a lot of MySQL errors lately and my theory is that it is due to lack of available disk space, most likely in the tmp folder. Any ideas?

Tue, Aug 27 2013 6:11am

What are the specific errors you have been getting that lead you to believe that disk space is the issue?

Tue, Aug 27 2013 6:45am

I don't remember the exact error, but when I looked it up this morning on stackoverflow, the overwhelming majority of responses suggested that the error results from the temp folder running out of space. Repairing and optimizing each table, despite the above mentioned reasoning for the error, fixed the issue although none of the tables were corrupt. This was the second time my tables have had an issue in the past week though.

Tue, Aug 27 2013 6:47am

How much data would you say you have stored on your webhosting? You may be hitting a limit.

Tue, Aug 27 2013 6:55am

Well, I am storing a bunch of maps (and their required files) in a "server" directory in order for fast downloading to work on my server. I can't tell you the exact total size, but I would guess it to be at least 1-2GB. Other than that I just have some php/js/assets stored in some other directories (probably less than 1MB total). Is the MySQL temp directory on the same disk as other files on the web server or maybe it's shared with other customers' hosted files? I don't know how you guys have things set up.

Tue, Aug 27 2013 6:56am

I have not seen a MySQL error dealing with the temp directory in recent memory. Were both times that the DBs needed to be repaired due to the same issue?

Tue, Aug 27 2013 7:03am

The specific error message did not mention anything about the temp directory, only to repair the table where the error was occurring. The first time, both my "player" tables became corrupt, but I initially thought it was due to someone changing their name in-game to something malicious (but that really shouldn't matter since I am pretty sure everything is escaped before being inserted into the tables). I had to truncate all my tables to fix that problem and I lost everything since I didn't back any of my tables up.

Tue, Aug 27 2013 7:21am

If you would like go ahead and post this in our forums so our website guys can take a look

http://www.nfoservers.com/forums/viewforum.php?f=45

[soja]

You can log into SSH on your web hosting server and check the disk space.

Simply log in using your website identifier as username, and the SSH password found on the "Passwords" tab. You can then run the command "df -h" to see current disk usage. Here is mine at hosted5.nfoservers.com

fdlm@hosted5 ~ $ df -h
Filesystem Size Used Avail Use% Mounted on
rootfs 500G 319G 177G 65% /
/dev/root 500G 319G 177G 65% /
rc-svcdir 1.0M 60K 964K 6% /lib64/rc/init.d
udev 10M 124K 9.9M 2% /dev
shm 1.5G 0 1.5G 0% /dev/shm
/dev/xvda1 107M 28M 74M 27% /boot
/dev/xvdb1 30G 24G 5.4G 82% /ssd

The spacing is really off but you get the idea on the % used.

If you don't know how to use putty, add me on steam and I can show you how:
http://steamcommunity.com/id/soja992