Key monitoring Content
The monitoring information provided is equivalent to that of Oracle Awr/statspack, which is more practical and powerful than any existing open source, commercial MySQL monitoring tool, and is used in dozens of MySQL testing and production environment databases throughout the company and is continuously refined and updated based on actual usage results.
Zero
Http://pan.baidu.com/s/1qYKntoC
First, the source system configuration
• Recommended Percona server 5.6/mariadb+, support MYSQL,PERCONA,MARIADB 5.6, 5.7.
• The source system OS version is redhat/centos,6.3/6.5 tested, Windows does not support;
• Installing Lsof,yum install lsof;
• Open MYSQL/SSH related ports;
• Enable Performance_schema,userstat parameters;
• Create Perf_stat user, grant select Performance_schema select/truncate permissions;
MySQL Client login database, execute apache-tomcat-7.0.69-mysqlawr\deploy\com.medsoft.perfstat-1.0.4-snapshot\initsql\ Src-db-createuser.sql
Second, Mysqlawr warehouse configuration
0. Only dependent on JDK 7 and above.
1. Create a storage table structure and user
MySQL Client login database, execute apache-tomcat-7.0.69-mysqlawr\deploy\com.medsoft.perfstat-1.0.4-snapshot\initsql\ Perfstat-db-init.sql.
2. Configure the MySQL instance to monitor
Double-click apache-tomcat-7.0.69-mysqlawr/bin/startup.sh (Linux) or Startup.bat (Windows) to start the MYSQLAWR monitoring server.
HTTP://IP:8080 can open the main page, such as
Click Database configuration settings to monitor the MySQL instance
MySQL awr 1.0.4 GA official release