Viewing 6 replies - 1 through 6 (of 6 total)
  • 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.

    Plugin Contributor photocrati

    (@photocrati)

    @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.

    Thread Starter gsghert01

    (@gsghert01)

    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.

    Thread Starter gsghert01

    (@gsghert01)

    and also thank bl968.That was step 1 for me.

    Plugin Contributor photocrati

    (@photocrati)

    @gsghert01 – The “beta” will most likely be out as the stable release later this week.

    – Cais.

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘Many 'transients' created in database’ is closed to new replies.