[ILUG] mysql "best practice" question
John P. Looney
valen at tuatha.org
Wed Apr 14 15:57:28 IST 2004
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
More information about the ILUG