Innodb数据表性能瓶颈在哪里？

1.观察项目发现，业务数据量越来越大，从每日10几万条记录升级到每日几百万条记录。业务表已经总数据量已经很庞大了。需要考虑性能瓶颈和对应方案了。
查看innodb缓存池

SHOW VARIABLES LIKE 'innodb_buffer_pool_size'

业务表大小查询

SELECT 
table_rows,
TABLE_NAME,
CONCAT(ROUND(SUM(data_length)/(1024*1024*1024),2),'G') DATA,
CONCAT(ROUND(SUM(index_length)/(1024*1024*1024),2),'G') idx
 FROM `information_schema`.`TABLES`  WHERE `TABLE_NAME` IN ('t_park_record','t_ocr_flow','t_ocr_image','t_record') AND 
`TABLE_SCHEMA`='prod_bj_cpsdb' GROUP BY TABLE_NAME;