"Grigor, Peter" wrote:
>
> You need to run [analyze table] to create the index stats...do this
> reasonable often (once a day for a well-used table).
This script will be run on servers around the world by regular people,
not sys admins. I will have no control over their databases.
> Running [o
You need to run [analyze table] to create the index stats...do this
reasonable often (once a day for a well-used table).
Running [optimize table] on the table recreates index stats AND
reorganizes/defrags/coalesces data pages...do this once a week or so.
Look up the mysqlcheck utility--it lets yo
