Does anyone know if there is a command / process in MySQL to optimise all tables in all databases on a MySQL server?

I'm getting sick of having to do it manually

__________________
Hosting & Domains|Plesk Vps Hosting|Blog Tips|Films.ie|Gadgets|Monetisation Tips|Movie Chat


Energise your forum! Click here for info

any use sir?
Optimize all your mysql databases automatically [mysql] [php] [database] [optimize]

Looks very interesting. I wonder if it will work on a 3000 table db here. Though depending on the version of MySQL, it might be possible to create some kind of optimisation as a stored procedure.

Regards...jmcc

It looks like it could do the trick.

What could go wrong though? I live in fear of MySQL exploding!

__________________
Hosting & Domains|Plesk Vps Hosting|Blog Tips|Films.ie|Gadgets|Monetisation Tips|Movie Chat


Energise your forum! Click here for info

3000 tables, eh?

there's such a thing as over-normalisation, you know!

__________________
verens.com, webworks.ie
kfm.verens.com

Yep but there is also such a thing as computability. This is one of the smaller dbs for tracking new/deleted/moved domains in com/net/org/biz/info/ie/eu/uk zones from 2000 to 2007. I might have to take a look at optimising the design somewhat but it was designed to handle large amounts of data with the emphasis on computability - dumping a single .com zone's domains and nameservers into a table would result in a table of about 133 Million rows. So even comparing two 133M row tables would take some time. Given the way that the .com has mushroomed over the past year (from about 3G to 4.3G of raw data), the design has held up fairly well. Though it only takes a few seconds to process .ie stats.

I ran a summary table generation today to coallate the stats on all hosters (approximately 1.5 Million) in com/net/org/biz/info/ie since December 2000 to December 2006 and it took approximately 9 hours on an Athlon64 with 3G of RAM. Even with optimisation, big sets of data take a lot of time to process.

Regards...jmcc