[wp-hackers] SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes'

[DD32]

That is the query WordPress makes to load all the options on every page load.

You possibly have a few things wrong:
1. You're being DDOS'd by someone requesting the same page over and
over and over and over agaiin
2. You have a high-load website and need to install a caching plugin
3. Your wp_options table is corrupt
4. Your wp_options table includes an incredibly large option (What
permasructure are you using?)
5. Your MySQL server is configured incorrect (Enabling the query cache
usually speeds things up significantly)

Thats all i can think of right now.. But it depends on the server
situation.. How much time is the query taking? How much time is every
page load taking? Howm many pageloads a minute? etc.

2009/10/27 Jeremi Bergman <jeremib at gmail.com>:
> Just to make sure it was nothing with my theme, I set it to the default
> thing, and see the same thing...
>
>           ......
>           2128 Query       SELECT option_name, option_value FROM wp_options
> WHERE autoload = 'yes'
>           2128 Query       SELECT option_name, option_value FROM wp_options
> WHERE autoload = 'yes'
>           2128 Query       SELECT option_name, option_value FROM wp_options
> WHERE autoload = 'yes'
>           2128 Query       SELECT option_name, option_value FROM wp_options
> WHERE autoload = 'yes'
>           2128 Query       SELECT option_name, option_value FROM wp_options
> WHERE autoload = 'yes'
>           2128 Query       SELECT option_name, option_value FROM wp_options
> WHERE autoload = 'yes'
>           2128 Query       SELECT option_name, option_value FROM wp_options
> WHERE autoload = 'yes'
>           2128 Query       SELECT option_name, option_value FROM wp_options
> WHERE autoload = 'yes'
>           2128 Query       SELECT option_name, option_value FROM wp_options
> WHERE autoload = 'yes'
>           2128 Query       SELECT option_name, option_value FROM wp_options
> WHERE autoload = 'yes'
>           2128 Query       SELECT option_name, option_value FROM wp_options
> WHERE autoload = 'yes'
>           2128 Query       SELECT option_name, option_value FROM wp_options
> WHERE autoload = 'yes'
>           2128 Query       SELECT option_name, option_value FROM wp_options
> WHERE autoload = 'yes'
>           2128 Query       SELECT option_name, option_value FROM wp_options
> WHERE autoload = 'yes'
>           2128 Query       SELECT option_name, option_value FROM wp_options
> WHERE autoload = 'yes'
>           2128 Query       SELECT option_name, option_value FROM wp_options
> WHERE autoload = 'yes'
>           2128 Query       SELECT option_name, option_value FROM wp_options
> WHERE autoload = 'yes'
>           2128 Query       SELECT option_name, option_value FROM wp_options
> WHERE autoload = 'yes'
>           2128 Query       SELECT option_name, option_value FROM wp_options
> WHERE autoload = 'yes'
>           2128 Query       SELECT option_name, option_value FROM wp_options
> WHERE autoload = 'yes'
>           2128 Query       SELECT option_name, option_value FROM wp_options
> WHERE autoload = 'yes'
>           2128 Query       SELECT option_name, option_value FROM wp_options
> WHERE autoload = 'yes'
> 091026 17:15:02       2128 Query       SELECT option_name, option_value FROM
> wp_options WHERE autoload = 'yes'
>           2128 Query       SELECT option_name, option_value FROM wp_options
> WHERE autoload = 'yes'
>           2128 Quit
>
>
> On Mon, Oct 26, 2009 at 5:15 PM, Jeremi Bergman <jeremib at gmail.com> wrote:
>
>> Every page load my mysql log fills up and zips by with the same query:
>> SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes'
>>
>>
>> I have disabled every plugin, reloaded the page, and I still see this.  I
>> believe this query over and over is reaking havoc on my server, eventually
>> bringing it down.
>>
>> Is this normal?
>>
>
>
>
> --
> Jeremi Bergman
> 865-622-7134
> _______________________________________________
> wp-hackers mailing list
> wp-hackers at lists.automattic.com
> http://lists.automattic.com/mailman/listinfo/wp-hackers
>