WordPress.org

Make WordPress Core

Changes between Initial Version and Version 1 of Ticket #24044, comment 9


Ignore:
Timestamp:
06/09/2013 02:30:24 AM (5 years ago)
Author:
SergeyBiryukov
Comment:

Legend:

Unmodified
Added
Removed
Modified
  • Ticket #24044, comment 9

    initial v1  
    22
    33Before autoload index:
     4{{{
    45mysql> explain select option_name, option_value from wp_options where autoload = 'yes';
    56+----+-------------+------------+------+---------------+------+---------+------+------+-------------+
     
    89|  1 | SIMPLE      | wp_options | ALL  | NULL          | NULL | NULL    | NULL | 1460 | Using where |
    910+----+-------------+------------+------+---------------+------+---------+------+------+-------------+
    10 
     11}}}
    1112After adding index named i1
    12 
     13{{{
    1314mysql> create index i1 on wp_options(autoload, option_name, option_value(50));
    1415
     
    1920|  1 | SIMPLE      | wp_options | ref  | i1            | i1   | 62      | const |  178 | Using where |
    2021+----+-------------+------------+------+---------------+------+---------+-------+------+-------------+
    21 
     22}}}
    2223After the index was created the total rows searched dropped from 1460 to 178.