Issue with checking MySQL databases

hostnoob

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

noosVPS

Note that line:

tmpdir=/path

... should be in /etc/my.cnf under block:

[mysqld]

Restart mysql service and check again.

hostnoob

@noosVPS said:
Note that line:

tmpdir=/path

... should be in /etc/my.cnf under block:

[mysqld]

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

noosVPS

hostnoob said: Working fine now, only took 30 seconds. Thanks again

Cool. You're welcome!