If mySQL crashes, automatically run myisamchk on startup. Possible on FreeBSD?

andrewm

I'm trying to think of a way I can modify /usr/local/etc/rc.d/mysql-server.sh so that when it is called after a system reboot it can see if mySQL was not shut down correctly (by checking the PID file maybe?). If it wasn't, then myisamchk would be automatically run before mySQL is started up.

Anyone have any ideas?

Sxooter

Why not just run it every time? Or does it take a really long time?

I use PostgreSQL, which handles restart after abrubt shutdown automatically, so I don't know how long myisam check takes.

Or, you could just use innodb tables. I believe they are self repairing...

andrewm

Nah, it's just that the person restarting the server won't always be computer savvy, so the less they have to do the better.

Sxooter

Right, I was just suggesting ALWAYS assuming the computer was improperly shut down and running the check every time. No user interaction.

andrewm

Originally posted by Sxooter
Right, I was just suggesting ALWAYS assuming the computer was improperly shut down and running the check every time. No user interaction.

Ah, I see, my bad.

We may end up doing that, but the problem is that we have such large tables (one has 40 million+ rows) that myisamchk takes around 10 minutes.

Sxooter

So, how often do you expect to have to restart the server? If it's once in a blue moon, then my suggestion might be workable.

OTOH, if it's a windows box that gets restarted twice a day...

andrewm

Originally posted by Sxooter
So, how often do you expect to have to restart the server? If it's once in a blue moon, then my suggestion might be workable.

OTOH, if it's a windows box that gets restarted twice a day...

I'm sure we'll fall back on just doing it every time if we can't figure something out, but it looks like I might be able to do this by checking the mySQL log files.