Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!


Issue with checking MySQL databases
New on LowEndTalk? Please Register and read our Community Rules.

All new Registrations are manually reviewed and approved, so a short delay after registration may occur before your account becomes active.

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

Thanks

Comments

  • noosVPSnoosVPS Member
    edited August 2014

    Note that line:

    tmpdir=/path

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

    [mysqld]

    Restart mysql service and check again.

    Thanked by 1hostnoob
  • @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

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

    Cool. You're welcome!

Sign In or Register to comment.