一个不可思议的MySQL慢查分析与解决

status = 2 ;

+----+-------------+-----------+------+----------------+------+---------+------+--------+-------------+

+----+-------------+-----------+------+----------------+------+---------+------+--------+-------------+

+----+-------------+-----------+------+----------------+------+---------+------+--------+-------------+

1 row in set ( 0.00 sec)

-- 萌芽biz_date + status

-- 关键点：rows: 980632 ;type:ALL

mysql > desc select * from testtable WHERE biz_date <= '2017-08-21 00:00:00' and status = 2 limit 100 ;

+----+-------------+-----------+-------+----------------+----------------+---------+------+--------+-----------------------+

+----+-------------+-----------+-------+----------------+----------------+---------+------+--------+-----------------------+

+----+-------------+-----------+-------+----------------+----------------+---------+------+--------+-----------------------+

1 row in set

　　推荐阅读

　　“互联网+”经济模式对民商事审判的影响与应对

党的十九大年夜申报提出，在深化供给侧构造性改革中，推动互联网、大年夜数据、人工智能和实体经济深度融合。是以，为赓续加强经济立异力和竞争力，我国经济体系体例中“互联网+”经济模式将>>>详细阅读

地址：http://www.17bianji.com/lsqh/38638.html