get_active_queries
Monitor and identify currently running MySQL queries to detect performance bottlenecks, long-running operations, and blocking transactions in real-time.
Instructions
Get currently active queries in MySQL.
Shows:
Running queries with execution time
Long-running queries
Blocked queries waiting on locks
Idle transactions that may be holding locks
Useful for:
Identifying queries causing performance issues
Finding blocking transactions
Monitoring query execution in real-time
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| min_duration_sec | No | Minimum query duration in seconds | |
| show_full_query | No | Show full query text (may be truncated otherwise) |
Input Schema (JSON Schema)
{
"properties": {
"min_duration_sec": {
"default": 0,
"description": "Minimum query duration in seconds",
"type": "number"
},
"show_full_query": {
"default": true,
"description": "Show full query text (may be truncated otherwise)",
"type": "boolean"
}
},
"required": [],
"type": "object"
}