Changes between Initial Version and Version 1 of Ticket #24044, comment 9
- Timestamp:
- 06/09/2013 02:30:24 AM (12 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Ticket #24044, comment 9
initial v1 2 2 3 3 Before autoload index: 4 {{{ 4 5 mysql> explain select option_name, option_value from wp_options where autoload = 'yes'; 5 6 +----+-------------+------------+------+---------------+------+---------+------+------+-------------+ … … 8 9 | 1 | SIMPLE | wp_options | ALL | NULL | NULL | NULL | NULL | 1460 | Using where | 9 10 +----+-------------+------------+------+---------------+------+---------+------+------+-------------+ 10 11 }}} 11 12 After adding index named i1 12 13 {{{ 13 14 mysql> create index i1 on wp_options(autoload, option_name, option_value(50)); 14 15 … … 19 20 | 1 | SIMPLE | wp_options | ref | i1 | i1 | 62 | const | 178 | Using where | 20 21 +----+-------------+------------+------+---------------+------+---------+-------+------+-------------+ 21 22 }}} 22 23 After the index was created the total rows searched dropped from 1460 to 178.