Re: DIAGNOSTIC MYSQL

2007-09-14 Thread Baron Schwartz
Krishna Chandra Prajapati wrote: Hi Bullington, MySQL Monitering Service is a paid one. There is any open source free software which can moniter mysql heaths and tells the changes need to be done on system variables. You get what you pay for. Try mysqlreport, nagios, and innotop. Baron --

Re: DIAGNOSTIC MYSQL

2007-09-14 Thread Jeremy Cole
Hi Krishna, No, nothing like what you're asking for exists free or open source. Look into Groundwork and Nagios, though they will not do any really fancy monitoring directly out of the box, with a bit of configuration you can get most of what you want. Regards, Jeremy Krishna Chandra Praja

Re: DIAGNOSTIC MYSQL

2007-09-13 Thread Krishna Chandra Prajapati
Hi Bullington, MySQL Monitering Service is a paid one. There is any open source free software which can moniter mysql heaths and tells the changes need to be done on system variables. Regards, Prajapati On 9/13/07, J.R. Bullington <[EMAIL PROTECTED]> wrote: > > You can also try the MySQL Monito

re: DIAGNOSTIC MYSQL

2007-09-13 Thread J.R. Bullington
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.

Re: DIAGNOSTIC MYSQL

2007-09-13 Thread Techwww
--- Krishna Chandra Prajapati <[EMAIL PROTECTED]> wrote: > 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. > You can use mysql-