My Oracle Support Banner

MySQL Enterprise Monitor Graph Formula and Logic (Doc ID 1938083.1)

Last updated on NOVEMBER 11, 2021

Applies to:

MySQL Enterprise Monitor - Version 2.3 and later
Information 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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.