id,summary,reporter,owner,description,type,status,priority,milestone,component,version,severity,resolution,keywords,cc
14258,"wp_options and MySQL's ""log-queries-not-using-indexes"" config",pkirk,,"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@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"".",enhancement,closed,normal,,Database,,normal,wontfix,,