[wp-trac] [WordPress Trac] #14258: wp_options and MySQL's "log-queries-not-using-indexes" config

[WordPress Trac]

#14258: wp_options and MySQL's "log-queries-not-using-indexes" config
-------------------------+----------------------
 Reporter:  pkirk        |       Owner:
     Type:  enhancement  |      Status:  closed
 Priority:  normal       |   Milestone:
Component:  Database     |     Version:
 Severity:  normal       |  Resolution:  wontfix
 Keywords:               |     Focuses:
-------------------------+----------------------

Comment (by nigro.simone):

 On MariaDB 10.1.9

 {{{
 SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes'
 (262 total, Query took 0.0156 seconds.)
 }}}

 ----

 {{{
 CREATE INDEX autoload ON wp_options(autoload, option_name);
 SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes'
 (262 total, Query took 0.0000 seconds.)
 }}}

--
Ticket URL: <https://core.trac.wordpress.org/ticket/14258#comment:5>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform