This chapter will first explain the importance of monitoring your database server. It will then present several useful tools for monitoring MySQL, including mytop and innotop. It will also discuss MySQL's built in reports, including SHOW FULL PROCESSLIST, SHOW GLOBAL STATUS, and SHOW INNODB STATUS. This chapter will also discuss MySQL's various logs.

1. Overview
   1. Why
   2. How Often
2. Monitoring Tools
   1. MySQL's Built In Reports
   2. mysqlreport
   3. mytop
   4. innotop
   5. Cacti
   6. MySQL Enterprise Montitors
3. Logs
   1. Error Logs
   2. Slow Query Logs
   3. No Index Logs