analyze_wait_events
Identify MySQL performance bottlenecks by analyzing wait events for lock contention, I/O operations, buffer pool usage, and log activities to optimize database performance.
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
| Name | Required | Description | Default |
|---|---|---|---|
| event_category | No | Category of events to analyze | all |
| top_n | No | Number of top events to return |
Input Schema (JSON Schema)
{
"properties": {
"event_category": {
"default": "all",
"description": "Category of events to analyze",
"enum": [
"all",
"io",
"lock",
"buffer",
"log"
],
"type": "string"
},
"top_n": {
"default": 20,
"description": "Number of top events to return",
"type": "integer"
}
},
"required": [],
"type": "object"
}