You can also try the MySQL Monitoring Service. It's a great tool that looks at your server's health and tells you if any changes need to be made.
It's especially helpful in tuning your server variables, query cache, and index usage. It also sends mail if you need / want it. ---------------------------------------- From: "Krishna Chandra Prajapati" <[EMAIL PROTECTED]> Sent: Thursday, September 13, 2007 10:25 AM To: MySql <mysql@lists.mysql.com> Subject: DIAGNOSTIC MYSQL Hi All, Is there is any script or tool that can diagnostic the mysql. It can check for the errors, give suggestion, give reports and send emails. It can check the mysql system variables and give suggestion. Thanks, Prajapati