MySQL Enterprise Monitor Graph Formula and Logic
(Doc ID 1938083.1)
Last updated on MAY 10, 2023
Applies to:
MySQL Enterprise Monitor - Version 2.3 and laterInformation in this document applies to any platform.
Purpose
Explain each of the graphs used in MySQL Enterprise Monitor and how they gather data.
Scope
This is designed to help both support staff and customers understand how MEM calculates the graphs.
Details
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Purpose |
| Scope |
| Details |
| Server Related Graphs |
| Agent Reporting Delay |
| Binlog Cache Efficiency |
| Binlog IO Usage |
| Binlog Space Usage |
| Connections |
| Connections - Aborted |
| Connections - Cache |
| Connections - Maximum |
| CPU Utilization |
| Database Activity |
| Database Transactions |
| Disk IO Operations |
| Disk IO Usage |
| Disk Space Usage |
| Hit Ratios |
| InnoDB Adaptive Hash Index Memory |
| InnoDB Adaptive Hash Index Searches |
| InnoDB Buffer Pool |
| InnoDB Buffer Pool Page Activity |
| InnoDB Buffer Pool Pending Operations |
| InnoDB Change Buffer Activity |
| InnoDB Change Buffer Usage |
| InnoDB Compression Time |
| InnoDB Data Dictionary Memory |
| InnoDB Datafile IO Usage |
| InnoDB Doublewrite Buffer Activity |
| InnoDB Open Files |
| InnoDB OS File Access |
| InnoDB Redo Log Checkpoint Lag |
| InnoDB Redo Log IO Usage |
| InnoDB Redo Log Pending Writes |
| InnoDB Row Details |
| InnoDB Row Lock Time |
| InnoDB Row Lock Time Statistics |
| InnoDB Row Lock Waits |
| InnoDB Row Locks Current |
| InnoDB Semaphores |
| InnoDB Transaction History |
| InnoDB Transaction Lock Memory |
| InnoDB Transactions |
| InnoDB Undo Logs |
| Load Average |
| Memory Usage - Agent |
| Memory Usage - OS Resident |
| Memory Usage - OS Virtual |
| MyISAM Data File IO Usage |
| MyISAM Index File IO Usage |
| MyISAM Key Buffer Activity |
| MyISAM Key Buffer Usage |
| Network - Database Throughput |
| Network - Interface Throughput |
| Opened Tables |
| Prepared Statement API |
| Prepared Statement API Invalidations |
| Prepared Statement SQL |
| Prepared Statement Utilization |
| Query Cache Average Free Block Size |
| Query Cache Average Query Size |
| Query Cache Efficiency |
| Query Cache Fragmentation |
| Query Cache Low mem Prunes |
| Query Cache Memory |
| Query Cache Queries |
| Replication Master Semi-Sync Transactions |
| Replication Master SEmi-Sync Wait Time Averages |
| Replication Master Semi-Sync Waiting Sessions |
| Replication Master Semi-Sync Waits |
| Replication Slave Delay |
| Replication Slave Relay Log Space Usage |
| Row Access Statistics |
| Row Accesses |
| Row Accesses Index Usage Ratio |
| Row Writes |
| Slow Queries |
| Sort Activity |
| Swap IO Operations |
| Table Lock Wait Ratio |
| Table Locks |
| Temporary Tables |
| References |