Categories
Database Development

MariaDB reset table index value?

I was wondering what to do when for example your table is reaching it’s maximum index values, I was using this Query to determine the index usage per table: SELECT c.TABLE_NAME, c.COLUMN_TYPE, c.MAX_VALUE, t.AUTO_INCREMENT, IF (c.MAX_VALUE > 0, ROUND(100 * t.AUTO_INCREMENT / c.MAX_VALUE, 2), -1) AS “Usage (%)” FROM (SELECT TABLE_SCHEMA, TABLE_NAME, COLUMN_TYPE, CASE WHEN […]