Skip to content

Instantly share code, notes, and snippets.

@axhiao

axhiao/explain mysql

Created April 27, 2016 07:27
Show Gist options
  • Save axhiao/0a9ea671a1b0ceb03cc60ee38732f370 to your computer and use it in GitHub Desktop.
Save axhiao/0a9ea671a1b0ceb03cc60ee38732f370 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
explain mysql
explain select * from amortize_order_info_3 force index(PRIMARY) where source_sys = 'pmc' and order_create_gmt >= '2016-03-08 00:00:00' and order_create_gmt<= '2016-03-08 23:59:59' and id >10152664498617 order by id asc limit 1000;
+----+-------------+-----------------------+-------+---------------+---------+---------+------+----------+-------------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+----+-------------+-----------------------+-------+---------------+---------+---------+------+----------+-------------+
| 1 | SIMPLE | amortize_order_info_3 | range | PRIMARY | PRIMARY | 8 | NULL | 30924473 | Using where |
+----+-------------+-----------------------+-------+---------------+---------+---------+------+----------+-------------+
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment