Oliver Stark ostark
ostark
/ schema_auto_increment_columns.sql
Created
December 4, 2024 14:17
— forked from bennadel/schema_auto_increment_columns.sql
Looking For Database Performance Bottlenecks And Optimizations Using The Sys Schema In MySQL 5.7
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /** | |
| * Find the amount of auto-increment "space" has been used. This may can help identify | |
| * tables that are running out of available ID values. | |
| */ | |
| SELECT | |
| t.table_name, | |
| t.column_name, | |
| -- The highest possible ID that can be created with this data-type. | |
| t.max_value, | |
| -- The last ID created in this table. |