MySQL Errors Due To Disk Space

Connect with other users about what to run on your webhosting (and how to run it) here.
Post Reply
tenub
A semi-regular
A semi-regular
Posts: 29
https://www.youtube.com/channel/UC40BgXanDqOYoVCYFDSTfHA
Joined: Tue Aug 27, 2013 6:28 am

MySQL Errors Due To Disk Space

Post by tenub »

Tue, Aug 27 2013 5:50am
Joseph wrote: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
Cody wrote: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
Joseph wrote: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
Andrew wrote:How much data would you say you have stored on your webhosting? You may be hitting a limit.
Tue, Aug 27 2013 6:55am
Joseph wrote: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
Andrew wrote: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
Joseph wrote: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
Siren wrote: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
User avatar
soja
This is my homepage
This is my homepage
Posts: 2389
Joined: Fri May 18, 2012 3:20 pm

Re: MySQL Errors Due To Disk Space

Post by 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
Not a NFO employee
Post Reply