SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes'
|
View:
New views
8 Messages
—
Rating Filter:
Alert me
|
 |
SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes'
by Jeremi Bergman
::
Rate this Message:
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? _______________________________________________ wp-hackers mailing list wp-hackers@... http://lists.automattic.com/mailman/listinfo/wp-hackers |
|
|
Re: SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes'
by Thomas Belknap
::
Rate this Message:
Try checking your template or going back to the default. Don't know why
someone would query the db directly like that, but its the next most obvious "just reboot" kind of answer.. }8{D> On Mon, Oct 26, 2009 at 5:15 PM, Jeremi Bergman <jeremib@...> 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? > _______________________________________________ > wp-hackers mailing list > wp-hackers@... > http://lists.automattic.com/mailman/listinfo/wp-hackers > wp-hackers mailing list wp-hackers@... http://lists.automattic.com/mailman/listinfo/wp-hackers |
|
|
Re: SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes'
by Jeremi Bergman
::
Rate this Message:
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@...> 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@... http://lists.automattic.com/mailman/listinfo/wp-hackers |
|
|
Re: SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes'
by Dion Hulse (dd32)
::
Rate this Message:
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@...>: > 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@...> 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@... > http://lists.automattic.com/mailman/listinfo/wp-hackers > wp-hackers mailing list wp-hackers@... http://lists.automattic.com/mailman/listinfo/wp-hackers |
|
|
Re: SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes'
by Peter Westwood
::
Rate this Message:
On 26 Oct 2009, at 21:15, Jeremi Bergman 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' > This query is run by wp_load_alloptions() and should run once per page load. If it is running more than once then it is likely that you have a broken object caching plugin installed. Look for a file called object-cache.php in wp-content. Cheers -- Peter Westwood http://blog.ftwr.co.uk | http://westi.wordpress.com C53C F8FC 8796 8508 88D6 C950 54F4 5DCD A834 01C5 _______________________________________________ wp-hackers mailing list wp-hackers@... http://lists.automattic.com/mailman/listinfo/wp-hackers |
|
|
Re: SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes'
by Jeremi Bergman
::
Rate this Message:
That was it, I renamed object-cache.php to object-cache.php.old and no
longer see all those entries! Thanks so much. This is what file was there: /* Name: Memcached Description: Memcached backend for the WP Object Cache. Version: 2.0 URI: http://dev.wp-plugins.org/browser/memcached/ Author: Ryan Boren ..... On Mon, Oct 26, 2009 at 5:25 PM, Peter Westwood <peter.westwood@...>wrote: > > On 26 Oct 2009, at 21:15, Jeremi Bergman 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' >> >> > This query is run by wp_load_alloptions() and should run once per page > load. > > If it is running more than once then it is likely that you have a broken > object caching plugin installed. > > Look for a file called object-cache.php in wp-content. > > Cheers > -- > Peter Westwood > http://blog.ftwr.co.uk | http://westi.wordpress.com > C53C F8FC 8796 8508 88D6 C950 54F4 5DCD A834 01C5 > > > _______________________________________________ > wp-hackers mailing list > wp-hackers@... > http://lists.automattic.com/mailman/listinfo/wp-hackers > -- Jeremi Bergman 865-622-7134 _______________________________________________ wp-hackers mailing list wp-hackers@... http://lists.automattic.com/mailman/listinfo/wp-hackers |
|
|
Re: SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes'
by Peter Westwood
::
Rate this Message:
On 26 Oct 2009, at 21:29, Jeremi Bergman wrote: > That was it, I renamed object-cache.php to object-cache.php.old and no > longer see all those entries! Thanks so much. > > This is what file was there: > > /* > Name: Memcached > Description: Memcached backend for the WP Object Cache. > Version: 2.0 > URI: http://dev.wp-plugins.org/browser/memcached/ > Author: Ryan Boren > ..... > So you had the memcached object cache installed an it was not working correctly. I guess something is wrong with your memcached setup. Cheers -- Peter Westwood http://blog.ftwr.co.uk | http://westi.wordpress.com C53C F8FC 8796 8508 88D6 C950 54F4 5DCD A834 01C5 _______________________________________________ wp-hackers mailing list wp-hackers@... http://lists.automattic.com/mailman/listinfo/wp-hackers |
|
|
Re: SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes'
by Jeremi Bergman
::
Rate this Message:
Thank so much. I've been working on this thing all day, I should have just
started with the experts! I'm sure there are differing opinions, but what are some good options for object caching, or is the built in good in-and-of itself? On Mon, Oct 26, 2009 at 5:30 PM, Peter Westwood <peter.westwood@...>wrote: > > On 26 Oct 2009, at 21:29, Jeremi Bergman wrote: > > That was it, I renamed object-cache.php to object-cache.php.old and no >> longer see all those entries! Thanks so much. >> >> This is what file was there: >> >> /* >> Name: Memcached >> Description: Memcached backend for the WP Object Cache. >> Version: 2.0 >> URI: http://dev.wp-plugins.org/browser/memcached/ >> Author: Ryan Boren >> ..... >> >> > So you had the memcached object cache installed an it was not working > correctly. > > I guess something is wrong with your memcached setup. > > > Cheers > -- > Peter Westwood > http://blog.ftwr.co.uk | http://westi.wordpress.com > C53C F8FC 8796 8508 88D6 C950 54F4 5DCD A834 01C5 > > _______________________________________________ > wp-hackers mailing list > wp-hackers@... > http://lists.automattic.com/mailman/listinfo/wp-hackers > -- Jeremi Bergman 865-622-7134 _______________________________________________ wp-hackers mailing list wp-hackers@... http://lists.automattic.com/mailman/listinfo/wp-hackers |
| Free embeddable forum powered by Nabble | Forum Help |
