Mysql Performance Monitoring - Graphical Tool

One simple method of mysql performance monitoring is using the free tool MysqlMonitorTool.  It allows you to connect to a set of mysql instances and view charts showing some basic performance information including the following:

• connections
• inserted rows per second
• updated rows per second
• deleted rows per second
• read rows per second
• slow queries per second
• queries per second

The following shows the display:

The tool is fairly easy to use as follows:

• Download and unzip from http://sourceforge.net/projects/mysqlmt/
• Create a batch or executable script that points to the tool's jar file:  java -jar MysqlMonitorTool.jar
• Run the batch script
• Click server configuration, then click "add new server", then enter your server configuration (servername, host, port, username, password) for one or more mysql instances.
• Click "add new server group" and create a server group and add the servers you created to the group.
• Connect and the app will connect to your instances and provide the following tabs:
• ProcessList
• charts
• Status Vars
• Server Vars
• Recording (to record chart output)