analyze_auto_increment
Identify auto-increment columns at risk of overflow by analyzing current values against maximum limits and usage percentages to prevent database errors.
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
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| warning_threshold_pct | No | Warning threshold percentage | |
| schema_name | No | Filter by specific schema |