Hi there,
Apologies for cross-posting...
Does anyone know of any good tools - third party or otherwise - that
will check your MySQL database for potential problems? I'm thinking of
corrupted data files, memory problems, performance tweaks etc.
Thanks,
Matt
matthewjbarr@gmail.com wrote:
> Does anyone know of any good tools - third party or otherwise - that
> will check your MySQL database for potential problems? I'm thinking of
> corrupted data files, memory problems, performance tweaks etc.
The possible problems in the categories you mention are too numerous and
varied to be handled by one tool. You have to use a mixture of several
tools, as well as careful analysis on your part. There is no automated
way to optimize everything about your database.
Read the docs on optimization, and maintenance, and follow the advice
within.
http://dev.mysql.com/doc/refman/5.0/en/optimization.html
http://dev.mysql.com/doc/refman/5.0/en/table-maintenance.htm l
Regards,
Bill K.