延迟关联优化SQL一例
昨日下午和今日凌晨出现较多告警 经排查发现时又下面SQL导致SELECT * FROM pre_forum_post ORDER BY pid ASC LIMIT 7332000,1000Limit愈来愈大,导致走全表扫描加文件排序root@localhost 10:23: [forum_longtugamev2_db]> explain SELECT * F...
