Real-time monitoring of MySQL status

Most of the site's performance bottlenecks will be on the database, so want to monitor the MySQL, the search for the relevant information.

Later and colleagues discussed the next cacti and nagios some old and outdated, graphite more fashionable, and then searched the relevant information, finally made out, the effect is as follows

Can see in real time MySQL Open table number, the number of files, is executing, has been created, the number of connected threads, locks, query cache, table scan related counters, as well as the completed Select,insert, delete, update SQL number, etc. In short, the various state of MySQL at a glance.

The meanings of the specific indicators refer to the following links:

http://lxneng.iteye.com/blog/451985

If you have deployed graphite, then find an agent to collect MySQL status, as follows.

Https://github.com/serialx/mysql-statsd

Installation operation is simple

# downloadGitCloneHttps://GitHub.Com/Serialx/Mysql-Statsd.Gitcd mysql-statsd# installation dependent pip install -rrequirements.txtpip install twisted# configure MySQL connection string, STATSD collector address vi config/example.< span class= "n" >ini# run python mysql- statsd. Py --config config/exampleini 
                

Percona This article is also good, black cacti and nagios, and explain the amount of why graphite+statsd more fashionable.

MYSQL performance monitoring USING STATSD and GRAPHITE

Real-time monitoring of MySQL status