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