_wp_session Transients Overload

  • eyesocialeyes

    (@eyesocialeyes)


    10 years, 3 months ago

    Hello I am currently experiencing a huge problem with the participants database plugin. When the plugin is activated it creates thousands of transient entries into my wo_options table and crashes my website due to the number of entries created that increase the size of my wp_options table to 100 MB!. They look like this option_name begins with “_wp_session” or “_wp_session_expires__” and option_value (varies depending on entry) = a:1:{s:14:”shortcode_atts”;O:21:”Recursive_ArrayAccess”:2:{s:12:”*container”;a:1:{i:2646;O:21:”Recursive_ArrayAccess”:2:{s:12:”*container”;a:0:{}s:8:”*dirty”;b:0;}}s:8:”*dirty”;b:1;}}. I have 100,000 visiting the site daily answering quizzes developed with the wp-proquiz plugin. If the participant database plugin is not activated then I receive none of these entries. As soon as I enable the participants database plugin the entries flood in as the hits accumulate on my website. What can I do to to prevent these transients from accumulating.

    https://wordpress.org/plugins/participants-database/

Viewing 1 replies (of 1 total)
  • Plugin Author xnau webdesign

    (@xnau)

    10 years, 3 months ago

    I’ve had reports like this before, and I’m not sure what causes it. It seems to be related to a specific server setup, where it loses the session value and then recreates the session instead of reusing it. I haven’t seen this on any of the sites I work with the plugin on, so I don’t know if there is something in the plugin that causes this. Try changing the “use PHP sessions” setting under the advanced tab…it might help.

    To manage the problem in the short term, there are plugins which can keep these entries from building up. Look for “expired transients” in the plugin repo for several options.

Viewing 1 replies (of 1 total)

The topic ‘_wp_session Transients Overload’ is closed to new replies.