mysql 查询记录数大于一千万的表
SELECT table_schema, table_name, table_rows
FROM INFORMATION_SCHEMA.TABLES
WHERE table_schema NOT IN ('mysql', 'performance_schema', 'information_schema', 'sys')
AND table_rows > 10000000;
SELECT table_schema, table_name, table_rows
FROM INFORMATION_SCHEMA.TABLES
WHERE table_schema NOT IN ('mysql', 'performance_schema', 'information_schema', 'sys')
AND table_rows > 10000000;