Issue with checking MySQL databases

Posted On // Leave a Comment

I'm running mysqlcheck, and it's extremely slow (over an hour for a 500MB SQL file)


I checked the errors log and realised it's because /tmp is filling up.


/tmp is only 16MB, and there's no way to increase it. I added a tmpdir= /path to my.cnf but mysqlcheck ignores it. --tmpdir= doesn't work either


Thanks


http://ift.tt/1dvHQ0Z

0 comments:

Post a Comment