analyze_wait_events
Identify MySQL performance bottlenecks by analyzing wait events for locks, I/O operations, buffer pool usage, and log activities to detect resource contention and saturation issues.
Instructions
Analyze MySQL wait events to identify bottlenecks.
Wait events indicate what processes are waiting for:
Lock waits (row locks, table locks)
I/O waits (disk operations)
Buffer pool waits
Log waits
Mutex and semaphore waits
This helps identify:
I/O bottlenecks
Lock contention patterns
Resource saturation
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| event_category | No | Category of events to analyze | all |
| top_n | No | Number of top events to return |