Slowquery graphical display MySQL slow Log tool

Slowquery graphical display MySQL slow Log tool

Online demo: http://fander.asuscomm.com:8008/slowquery/slowquery.php

Background: as the Sky Rabbit Lepus slow query tool runs in the PHP CI framework, rather than as an independent web page interface, it is difficult to migrate the code and always consider refactoring if you want to connect directly to the automated operation and maintenance platform.

Refer to the open source tool Anemometer graphics display ideas, and integrate the Xiaomi Soar tool, developers click on the slow SQL on the page, will automatically feedback optimization suggestions, thus reducing the human flesh cost of DBA, but also support automatic email alarm function.

Agent client slow log collection and analysis is combined with Percona pt-query-digest tools to achieve.

The steps to install are as follows:

1. Installation of percona-toolkit tools 2, construction of php web mysql environment # yum install httpd mysql php php-mysql-Y3, installation and configuration of Slowquery 4, import of slow query log 5, access interface, view slow query 6, configure email alarm

Specific installation steps: https://github.com/hcymysql/slowquery/blob/master/README.md