New on LowEndTalk? Please Register and read our Community Rules.
Issue with checking MySQL databases
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
Note that line:
... should be in /etc/my.cnf under block:
Restart mysql service and check again.
Thanks a lot, didn't realise it needed to be in the [mysqld] section (I had just added it to the end)
Working fine now, only took 30 seconds. Thanks again
Cool. You're welcome!