[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:  new            
 Priority:  normal       |   Milestone:  Awaiting Review
Component:  Database     |     Version:                 
 Severity:  normal       |    Keywords:                 
-------------------------+--------------------------------------------------
 Usually both on production and dev servers MySQL's config parameter "log-
 queries-not-using-indexes" is activated.

 This produce a lot of log entries like that:

 {{{
 # Time: 100710 11:53:28
 # User at Host: xxx[xxx] @ localhost []
 # Query_time: 0.010032  Lock_time: 0.000085 Rows_sent: 275  Rows_examined:
 337
 SET timestamp=1278755608;
 SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes';

 }}}

 Adding a simple index on the "autoload" field in wp_options table resolve
 the "problem".

-- 
Ticket URL: <http://core.trac.wordpress.org/ticket/14258>
WordPress Trac <http://core.trac.wordpress.org/>
WordPress blogging software