select table_schema, table_name,count(0)
from (
SELECT distinct table_schema, table_name, index_name
FROM information_schema.STATISTICS
) a
group by table_schema, table_name
having count(0) > 10
order by count(0) desc;
mysql检查索引过多表
最新推荐文章于 2024-09-15 20:24:46 发布