表数据过大，查询数据总量太慢怎么办

select TABLE_ROWS from information_schema.TABLES where TABLE_SCHEMA='db_name' and TABLE_NAME='table_name';

替换如上库名，表名