get_statements_with_errors
Identify MySQL queries that generate errors or warnings to detect problematic application SQL statements and improve database reliability.
Instructions
Get statements that produce errors or warnings.
Identifies queries with:
Error counts
Warning counts
Error rates
Helps identify problematic application queries.
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 | |
| errors_only | No | Only show statements with errors (not warnings) |
Input Schema (JSON Schema)
{
"properties": {
"errors_only": {
"default": false,
"description": "Only show statements with errors (not warnings)",
"type": "boolean"
},
"limit": {
"default": 25,
"description": "Maximum statements to return",
"type": "integer"
}
},
"required": [],
"type": "object"
}