Detailed explanation of MySQL monitoring tool mysql-monitor

1. Overview

mysql-monitor MYSQL monitoring tool, optimization tool, various tools in one java spring boot project

Git address: https://github.com/lccbiluox2/mysql-monitor.git

2. Code Architecture

3. Backend Services

The main class of the backend service is com.neo.MySQLMointorApplication

3.1 Database of backend services

spring.datasource.driverClassName = com.mysql.jdbc.Driver
spring.datasource.url = jdbc:mysql://localhost:3306/mysql_monitor?useUnicode=true&characterEncoding=utf-8&useSSL=true
spring.datasource.username = root
spring.datasource.password = 12345678

Modify this according to your needs.

The SQL script is in doc/sql/mysql_monitor.sql Please create a table first, and then run the main class.

4. Front-end service

Front-end main page: web-provider/html/database/database-list.html

Because the front-end and back-end are separated, the most primitive html+jquery+ajax is used to operate the back-end and display it, which solves the cross-domain problem. Just open the page directly.

4.1 Configuration

The front-end configuration file is as follows: web-provider/js/constant.js

//Define several global variables var AppUrl = "http://localhost:8090"; //The request page of the entire page

Mainly configure the address of the backend request.

5. The effect is as follows

5.1 Database List Page

5.2 Database Details Page

5.3 Table List Page

5.4 Table Details Page

5.5 SQL analysis interface

More features will be developed later. . . Waiting. .

7. Goals

The ultimate goal is to achieve integrated MySQL operation, maintenance and monitoring, and only for MySQL, not other databases. The main goal is to enable developers to only need to know how to use MySQL and this tool, which will automatically help us analyze the shortcomings of the table and the shortcomings of SQL writing, so that developers can become MySQL DBA with this.

Features currently considered

• SQL execution optimization: developers write a SQL statement, but do not know whether the performance is good or not. They only need to click on the page to enter the SQL statement, and then various
• Execute and draw a table to show various optimized SQL executions. This requires the use of Antlr for lexical analysis and grammatical analysis.
• Automatically analyze the table structure. For example, if you set varchar(100), and your data only uses 50 bytes, then calculate the space lost by this field and the disk space.
• The automatically sampled index forms a tree diagram and displays it on the page, giving us a rough idea of ​​what the index we created looks like.
• A large number of performance monitoring graphs

This is the end of this article about the MySQL monitoring tool mysql-monitor. For more relevant MySQL monitoring tool content, please search 123WORDPRESS.COM's previous articles or continue to browse the following related articles. I hope everyone will support 123WORDPRESS.COM in the future!