Hi, John Mancuso wrote:
I am running a fairly large Innodb database on mysql 5.x and would like to know what would be the best variables to monitor (for Nagios)- for instance: threads connected,Innodb_data_pending_reads,Innodb_data_pending_writes, slow queries etc....
This is kind of a bottomless question. Some people just monitor everything, period, in case they ever want to look back.
Good general suggestions are in Kristian's talk from the MySQL conference earlier this year:
http://mysqldump.azundris.com/archives/68-Monitoring-MySQL.html Baron -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]