get_active_queries
Monitor currently running MySQL queries to identify performance bottlenecks, detect long-running operations, and find blocking transactions that may be causing database slowdowns.
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
TableJSON 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) |