Re: Optimize All Tables

[Alex Sadykov]

Figured it out.

i setup 2 scripts

1. run_optimize_mydb.sh

#!/bin/sh
HOSTNAME=`/bin/hostname`
/mydb/backup/optimize_mydb.sh $* | /usr/bin/mail -s "Optimization of mydb complete on $HOSTNAME" [e-mail]


2.optimize_mydb.sh

#!/bin/sh
#this script optimizes all mydb tables
#Runs a flush tables command afterwards
date
mysqlcheck --databases mydb --optimize -ublah -plah;
mysql -ublah -pblah mydb -e'flush tables';
date

then i setup cron to execute ./run_optimize_mydb.sh
Once it's done i get an email like this:

From: root [mailto:[e-mail]]
Sent: Thursday, July 17, 2008 9:43 AM
To: [e-mail]
Subject: Optimization of mydb complete on hostname

Thu Jul 17 09:43:28 EDT 2008
mydb.table1 OK
mydb.table2 OK
mydb.table2 OK
Thu Jul 17 09:45:28 EDT 2008

I've got chained replication setup and it turns out all slave databases get optimized also.

If anyone can suggest how to have it all in one file I would greatly appreciate it.
Thank you.



Edited 2 time(s). Last edit at 07/17/2008 12:02PM by Alex Sadykov.