[ILUG] mysql "best practice" question

[John P. Looney]

 Today, someone asked me to have a look at some slow PHP. It turns out
they were doing a select on a table. Simple table, with nothing in it.

 But, it was 60MB in size. It took two seconds for a "select *" to
complete. Bad. So, I ran myiasmchk and myasmpack on it, and it reduced to
1k in size, and selects worked *instantly*.

 This makes me happy.

 Is there any problem with writing a script to go through every database
on the system, and run those two commands automatically every weekend, on
every table ? 

 It seems to be a the postgres equivalent of "vaccuum", which is really
needed on a busy system (and I was so happy when I discovered the
pg_autovaacuum stuff).

john