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

WordPress Trac wp-trac at lists.automattic.com
Sat Jul 10 10:04:11 UTC 2010

#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:
 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

More information about the wp-trac mailing list