Shulou(Shulou.com)06/01 Report--

What is the MySQL monitoring tool mysql-monitor? I believe that many inexperienced people are at a loss about this, so this article summarizes the causes and solutions of the problem. Through this article, I hope you can solve this problem.

1. Overview

Mysql-monitor MYSQL monitoring tools, optimization tools, various tools into one java spring boot project

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

two。 Code architecture

3. Back-end service

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

3.1 Database of back-end services

Spring.datasource.driverClassName = com.mysql.jdbc.Driverspring.datasource.url = jdbc:mysql://localhost:3306/mysql_monitor?useUnicode=true&characterEncoding=utf-8&useSSL=truespring.datasource.username = rootspring.datasource.password = 12345678

This is modified according to your own needs.

For scripts run by SQL, please create the table first in doc/sql/mysql_monitor.sql, and then run the main class.

4. Front-end service

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

Because the front and rear ends are separated, the original html+jquery+ajax operation backend is used and displayed, which solves the cross-domain problem. Just open the page directly.

4.1 configuration

The configuration file for the front end 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 requested by the backend.

5. The effect is as follows

5.1 Database list page

5.2 Database details page

5.3 Table list Page

5.4 details page

5.5 sql Analysis Interface

More features will be developed later. Waiting.

7. target

The ultimate goal is to achieve the integration of mysql operation, maintenance and monitoring, and only for MySQL, regardless of other databases. The main goal is to achieve

In the future, developers only need to be able to use MySQL and use this tool to automatically help us analyze the bad aspects of the table and the poor writing of SQL.

Let developers rely on this to be a MySQL DBA.

The features that come to mind at present

SQL performs optimization, developers, write a SQL, do not know whether the performance is good or not, just click on the page to enter SQL, and then simulate various

Execution, and drawn into a table, showing the various optimizations of the SQL execution. Antlr should be used for lexical analysis and grammatical analysis.

Automatically analyze the table structure, for example, set varchar (100), if your data only uses 50 bytes, then calculate the space lost in your field, disk

Automatically sample the index to form a tree, which is displayed on the page, so that we can have a rough picture of the index we have built.

A large number of performance monitoring charts

After reading the above, have you mastered what the MySQL monitoring tool mysql-monitor is? If you want to learn more skills or want to know more about it, you are welcome to follow the industry information channel, thank you for reading!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.