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
Tue, Aug 27 2013 6:47amJoseph 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:55amAndrew wrote:How much data would you say you have stored on your webhosting? You may be hitting a limit.
Tue, Aug 27 2013 6:56amJoseph 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 7:03amAndrew 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:21amJoseph 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.
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