analyze_auto_increment
Identify auto-increment columns at risk of overflow by analyzing current values against maximum limits and usage percentages to prevent data loss.
Instructions
Analyze auto-increment columns for potential overflow.
Checks:
Current value vs maximum value for column type
Usage percentage
Tables approaching overflow
Note: This tool only analyzes user/custom tables and excludes MySQL system tables (mysql, information_schema, performance_schema, sys) by default.
Based on MySQLTuner's auto-increment analysis.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| warning_threshold_pct | No | Warning threshold percentage | |
| schema_name | No | Filter by specific schema |
Input Schema (JSON Schema)
{
"properties": {
"schema_name": {
"description": "Filter by specific schema",
"type": "string"
},
"warning_threshold_pct": {
"default": 75,
"description": "Warning threshold percentage",
"type": "number"
}
},
"required": [],
"type": "object"
}