Many 'transients' created in database

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: https://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.