Some indicators of MySQL monitoring items

Monitor item description Problem

The number of page created by MySQL Innodb_pages_created in the InnoDB table.

The number of page read from InnoDB buffer pool by Innodb_pages_read.

The number of page written by Innodb_pages_written to the InnoDB table.

The number of Innodb_buffer_pool_reads physical read requests.

The number of Innodb_buffer_pool_read_requests logical read requests.

The number of rows that Innodb_rows_read reads from the InnoDB table.

The number of rows deleted by Innodb_rows_deleted from the InnoDB table.

The number of rows that Innodb_rows_updated updates in the InnoDB table.

The number of rows that Innodb_rows_inserted inserts into the InnoDB table.

The number of statements executed on the Questions Server side, excluding statements in the stored procedure.

Com_select Com_xxx represents the number of times the xxx command was executed.

Com_delete

Com_delete_multi

Com_insert

Com_insert_select

Com_replace

Com_replace_select

Com_load

Com_update

Com_update_multi

Com_commit

Com_rollback

The number of statements executed on the Queries Server side, including statements in the stored procedure.

The amount of data sent out by the Bytes_sent Server.

The amount of data received by the Bytes_received Server.

The number of join queries that Select_full_join needs to scan the data table.

The number of range search on related tables in the Select_full_range_join join query.

The number of range queries on the first table in the Select_range join query.

The number of indexes not used in the Select_range_check join query.

The number of full table scans performed on the first table in the Select_scan join query.

Maximum number of max_connections concurrent connections.

The maximum number of concurrent connections reached by Max_used_connections. Greater than 800

The number of times Aborted_connects failed to connect to Server.

The number of times that Aborted_clients Client did not properly close the connection to Server.

The number of times Connections attempted to connect to Server.

The number of merge passes in the Sort_merge_passes Sort process.

The number of range in the Sort_range Sort process.

The number of rows in the Sort_rows Sort procedure.

The number of full table scans in the Sort_scan Sort process.

The number of disk temporary tables created by Created_tmp_disk_tables.

The number of temporary files created by Created_tmp_files.

The number of temporary tables created by Created_tmp_tables.

The number of threads cached by Threads_cached.

The number of threads currently open by Threads_connected.

The number of threads created by Threads_created.

The number of threads that Threads_running runs at the same time. Greater than 5

The number of Handler_commit commit statements.

The number of Handler_rollback rollback statements.

The number of Handler_savepoint savepoint statements.

The number of Handler_savepoint_rollback rollback to SavePoint.

The number of data requests that Handler_write inserts into the table.

The number of data requests in the Handler_update update table.

Handler_delete deletes the number of data requests from the table.

The number of indexes scanned from scratch by Handler_read_first.

The number of requests that Handler_read_key reads records based on the index.

The number of requests that Handler_read_next reads the next record in the index.

The number of requests that Handler_read_prev read the previous record in the index.

The number of requests read by Handler_read_rnd based on a fixed location.

Handler_read_rnd_next reads the number of requests from one record to the next.

The number of Slow_queries slow queries. Greater than 2

Alive survival is equal to 0.

Running_slave replication is equal to 0

Seconds_Behind_Master delay is greater than 10