Hardware and performance

Hi,

I'm running serveral MySQL databases over here.
I was searching for a optimize script, but finaly I did the folowing:

Symlink /usr/bin/mysqlcheck to /usr/bin/mysqloptimize.

And then put it in cron like this:

3 0 * * 7 root /usr/bin/mysqloptimize -A > /dev/null

I run it once a week due to low transactions that cause overhead in the databases.
But you can run it every night.

Hope this helps.

Kind regards,

Huib