Using phpmyadmin it is safe to run the following sql statements
use yourwordpressdb;
delete from wp_options where option_name like “%_transient_%”;
delete from wp_options where option_name like “%displayed_galleries_%”;
Doing so on 3 wordpress sites using large nextgen galleries reduced mysql load on the server from 27% of the CPU to 12%
Nextgen needs to make it’s own tables for these as a wp_options is called on every page load.
Using phpmyadmin it is safe to run the following sql statements
select the database then the wp_options table; The click the sql tab;
Paste these in
delete from wp_options where option_name like "%_transient_%";
delete from wp_options where option_name like "%displayed_galleries_%";
Doing so on 3 wordpress sites using large nextgen galleries reduced mysql load on the server from 27% of the CPU to 9.5%
Nextgen needs to make it’s own tables for these as a select * from wp_options where autoload is yes statement is called on every page load.
@gsghert01 – I would recommend installing the latest public beta release which should correct this issue for you. You can find more details on the beta version here: http://www.nextgen-gallery.com/nextgen-gallery-latest-beta/
@bl968 – Thanks for the suggestions, I would also suggest you look at the beta release as well.
– Cais.
Thanks Photocrati. I had some other issues with the website and won’t have a chance to install this version until later in the week.
and also thank bl968.That was step 1 for me.
@gsghert01 – The “beta” will most likely be out as the stable release later this week.
– Cais.
