MySQLMTOP database monitoring system v2.1

MySQLMTOP is an open source MySQL enterprise monitoring system developed by Python+PHP. The system uses Python to implement multi-process data collection and alarming, and PHP to implement WEB display and management. MySQL server does not need to install any Agent. You only need to configure relevant database information on the monitoring WEB interface. After starting the monitoring process, you can query the status, number of connections, QTS, TPS, database traffic, replication, slow performance, etc. of hundreds of MySQL databases. Carry out constant monitoring. It can also send alarm email notifications to the DBA for processing when the database deviates from the set normal operation threshold (such as connection exception, replication exception, replication delay). It also archives historical data and displays the recent status of the database through charts so that DBAs and developers can analyze and diagnose problems encountered.

The main functions and features of MySQL MTOP are as follows

1. Real-time MySQL availability monitoring

Database availability monitoring and measurement allows developers and DBAs to understand whether they are meeting promised service levels.

2. Real-time MySQL status monitoring and alerts

MySQL MTOP continuously monitors MySQL's basic status and performance information, including database connection status, startup time, database, total connections, active processes, QPS, TPS,

Traffic information to and from the MySQL database. Send alarm email notifications when the database status is abnormal or deviates from normal baseline levels.

3. Real-time MySQL replication monitoring

MySQL MTOP automatically discovers your MySQL replication topology and automatically monitors database latency and binlog information, allowing you to understand the performance, availability, and operating status of all MySQL master servers and slave servers. and provide administrators with recommendations for corrections before problems (such as slave server latency) cause downtime.

4. Remotely monitor MySQL in the cloud

Designed for the cloud and virtual machines, it allows you to remotely monitor your MySQL servers without the need for any remote agents.

5. Intuitively manage all MySQL servers

MySQL MTOP provides a web-based interface that allows you to gain a comprehensive and in-depth understanding of database performance, availability, key activities, etc.; intuitively view a server, a customized application group, or all servers. A rich set of real-time and historical graphs will help you drill down into detailed server statistics.

6. Visual MySQL slow query analysis

Monitor real-time query performance, view execution statistics, and filter and locate SQL code that causes performance degradation. Used in conjunction with Information Schema to collect data directly from the MySQL server, no additional software or configuration is required.

7. Performance monitoring

Monitor key metrics affecting MySQL performance. For example, query cache hit rate, Key_buffer_read_hits, Key_buffer_write_hits, Thread_cache_hits, Key_blocks_used_rate, Created_tmp_disk_tables_rate and other information, and adjust and optimize the server core parameters according to relevant performance indicators.