MySQL Monitoring tool Small Collection

• Describes some of the common MySQL monitoring tools.

Cacti

• Cacti is a set of graphical analysis tools for network traffic monitoring based on PHP,MYSQL,SNMP and RRDtool development. It uses Snmpget to get data, use RRDtool to draw graphics, and you can completely not need to understand RRDtool complex parameters. It provides very powerful data and user management functions, you can specify that each user can view the tree structure, host and any map, but also with the LDAP combination of user authentication, but also can add their own templates, the function is very powerful and perfect, friendly interface.

• 
  

Mysqlreport

• Mysqlreport is actually just a Perl script, but the monitoring data is very intuitive:

• 
  

• The monitoring indicators, the official website has detailed description.

• Cacti monitoring MySQL data is reference to it, build Apache+perl environment can be accessed. The disadvantage is that it can only be monitored from time to time, without charts and historical data functions.

PhpMyAdmin

• phpmyadmin is more of a MySQL management tool than a MySQL monitoring tool. Compared to some GUI management tools for MySQL clients (such as "MySQL Administrator"), phpMyAdmin is web-mode. PhpMyAdmin is a database management tool that is based on PHP and is web-base in a way that is architected on a web host with MySQL.

• phpmyadmin contains a "status" page, which lists the detailed status information of MySQL and a detailed description of the corresponding indicator on the official website.

• 
  

MySQL Administartor

• MySQL Official management tool;

• There is a simple monitoring function.

Zabbix

• zabbix is a CS-structured monitoring system, the server side listens on port 10051, and the agent listens on port 10050. The user interface uses a PHP-developed web program that stores data in a MySQL database.

• zabbix uses client-side monitoring mode , similar to Jinshan cacti, Zabbix also supports NET-SNMP monitoring.
• zabbix has a wide range of functions and has not been studied in detail. Attach a monitor graph that monitors CPU load with Zabbix:

• 
  

Monyog

• Monyog is a client-side service program that proactively collects MySQL run data.

• At first the focus was on Monyog because it found a problem on the project: too many connections were created.
  The default monitoring of connections is the total number of connections created, and typically we only focus on the number of immediate connections. For applications that frequently create and close connections, the focus is on the total and the problem can be seen at a glance.
  Monitor Chart preview:

• 
  

• It's a pity! Monyog is a fee-based software, from the trial version of the situation, did not find custom features.

Mytop

• A Linux-like top command that specifically monitors the running state of MySQL

• Monitoring command:

     Mytop--host=10.20.192.109--Dbuser=root--password=123456  

  
  Operation Result:

  1MysqlOn 10.20.192.109 (5.0.81)Up 0+00:15:03 [11:51:51]2Queries:35.0qps:0Slow:0.0Se/Inch/Up/De (%): 00/00/00/00QPsnow:0SlowQPs0.0threads:523KeyEfficiency:96.4%BpsInch/Out0.9/114.1NowInch/Out8.4/1.2K4IdUserHost/IpDbTimeCmdQueryOrState 5-------------------------------- 6 root vmvistcn261sp1u 0 Query show full processlist 7 6 root vmxpcn270sp2 sleep 8 ...             

Mtop

• A Linux-like top command that specifically monitors the running state of MySQL

• Monitoring command:

     Mtop--host=10.20.192.109--Dbuser=root--password=123456  

  
  Operation Result:

  1 10.20.192.109Mysqld5.0.81Up 0Days), 0:05Hrs2 52Threads:1Running, 0Cached.Queries/Slow:5/0CacheHit:100%3Openedtables:0rrn:459tlw:0sfj:0smp:0qps:0 4 id user host DB span class= "id" >time command state info 5 root 10.20.212.39:522 Span class= ID >query show full processlist 6 ...             

Other

• Related tools also include:
• Kontrollbase, never fitted up;
• Mycat, pretending not to know how to use.

MySQL Monitoring tool Small Collection