WordPress.org

Make WordPress Core

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


Ignore:
Timestamp:
06/09/13 02:30:24 (10 months 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.