SEO Framework crashing our MySQL servers because of high loads

  • Resolved frostydog

    (@frostydog)


    7 years, 6 months ago

    Hi. It seems like The SEO Framework is causing my MySQL server to crash because of very high loads. We have a very large and popular website based on WordPress with more than 10 years worth of content, with about 50k published posts.

    As far as we can see, TSF is updating thousands of records on the wp_options table, which in turn overloads the server and crashed it (we have very high end and powerful equipment running our database).

    This also happened to us with Yoast SEO plugin and it was big part of the reason we switched to The SEO Framework, but after months without problems, now it seems like the plugin is also overloading our database servers.

    As soon as we deactivate TSF, load falls and everything goes back to normal, so we know this is a problem with the plugin.

Viewing 6 replies - 1 through 6 (of 6 total)
  • Plugin Author Sybre Waaijer

    (@cybr)

    Hi @frostydog,

    TSF only maintains a few options, I’ve dived into it in this blog post. It shouldn’t be any more extravagant compared to other plugins, in general.

    I do have a suspicion for causation, and I’m currently improving how it works for update 2.9.4. Could you try the following?

    Prior to activating TSF, could you add the following snippet to your theme’s functions.php file and see if it works?

    add_action( 'init', function() {
	$tsf = function_exists( 'the_seo_framework' ) ? the_seo_framework() : null;
	if ( isset( $tsf ) ) {
		remove_action( 'pre_get_posts', array( $tsf, 'adjust_search_filter' ), 9999 );
		remove_action( 'pre_get_posts', array( $tsf, 'adjust_archive_query' ), 9999 );
	}
} );

    Cheers!

    Thread Starter frostydog

    (@frostydog)

    Thanks for the super fast response. Code added, and plugin re-enabled. Lets see if it works ??

    Thread Starter frostydog

    (@frostydog)

    Yup, this is working. No more db saturation ??

    Plugin Author Sybre Waaijer

    (@cybr)

    That’s great to hear @frostydog

    In 2.9.4 there will be an option that will allow you to fine-tune the behavior. The settings will also be reflected upon in the in-post SEO settings meta box.

    Thread Starter frostydog

    (@frostydog)

    Sounds amazing. Thanks again for the super fast response!

    Plugin Author Sybre Waaijer

    (@cybr)

    Hi @frostydog,

    2.9.4 has been released. Please note that the snippet above no longer has any effect.

    You can find the new options to achieve what the snippet did, and more, in your dashboard: SEO Settings -> General -> Performance.

    Cheers!

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘SEO Framework crashing our MySQL servers because of high loads’ is closed to new replies.