MySQL Workload Graphs Overview
This section provides a complete reference for all MySQL Workload Graphs in Performance Analyzer (dd-ui), featuring interactive resource charts, query runtimes, and storage distribution across MySQL databases and schemas.
Available MySQL Workload Graphs
1. Workload & CPU Metrics
- Daily DB Load (DB and CPU Time Count): Overall MySQL workload execution time and CPU session activity.
2. Storage & Schema Distribution
- Schema - Daily Storage Size: Daily storage trends aggregated across MySQL database schemas.
- Table - Daily Storage Size: Daily storage consumption broken down by individual MySQL tables.
- Schema Storage Details: Detailed storage breakdown across MySQL schemas and engine tables.
3. Query Runtimes & Execution Ranks
- Queries - Max Execution Time: MySQL queries ranked by single-execution peak runtime (seconds).
- Query - Most Executed Queries: MySQL queries ranked by total execution call count.
4. Disk IO & Table Operations
- IO - Top IO Activity Tables: MySQL tables ranked by overall disk I/O activity.
- IO - Top Read Activity Tables: MySQL tables ranked by read I/O operations.
- IO - Top Write Activity Tables: MySQL tables ranked by write I/O operations.
5. Dependencies
- MySQL Dependency Graph: Query-to-table dependencies and Hot Edges interaction relationships for MySQL.