get_statements_with_full_scans
Identify MySQL queries performing full table scans to detect performance bottlenecks. Find statements that don't use indexes or use non-optimal indexes for targeted optimization.
Instructions
Get statements that perform full table scans.
Full table scans can severely impact performance on large tables. Identifies queries that:
Don't use any index
Use a non-optimal index
These queries are prime candidates for index optimization.
Note: This tool excludes queries against MySQL system schemas (mysql, information_schema, performance_schema, sys) to focus on user/application query analysis.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No | Maximum statements to return | |
| min_rows_examined | No | Minimum rows examined threshold |
Input Schema (JSON Schema)
{
"properties": {
"limit": {
"default": 25,
"description": "Maximum statements to return",
"type": "integer"
},
"min_rows_examined": {
"default": 100,
"description": "Minimum rows examined threshold",
"type": "integer"
}
},
"required": [],
"type": "object"
}