High usage MySQL wp_options select

  • Resolved babobo

    (@babobo)


    3 years ago

    I’m using the plugin on my website (https://papelariarainha.com.br/) and we have ~13k products.

    Our developers noticed that this plugin was slowing down the website, and one of the reason is some processes, for example:

    “SkyVerge\WooCommerce\PluginFramework\v5_10_0\SV_WP_Background_Job_Handler::is_process_running”

    This process is making this query 16 times, and it is running almost every 2 minutes:

    UPDATE wp_options SET option_value = ? WHERE option_name = ?

    This one too:

    SELECT COUNT(*) FROM wp_options WHERE option_name LIKE ? AND ( option_value LIKE ? OR option_value LIKE ? )

    And also this one:

    SELECT option_value FROM wp_options WHERE option_name LIKE ? AND ( option_value LIKE ? OR option_value LIKE ? ) ORDER BY option_id ASC LIMIT ?

Viewing 3 replies - 1 through 3 (of 3 total)
  • con

    (@conschneider)

    Engineer

    Hi @babobo

    The class method your developers mentioned is not doing much. It checks for running jobs and cleans up transients. It is a small maintenance job. https://github.com/woocommerce/facebook-for-woocommerce/blob/42012d4347324db05d379b74471479fe9c35db85/includes/fbbackground.php#L60

    Given your product volume you probably are using non standard methods. Your developers can try and increase the CRON interval to decrease queries or if there is a custom CRON active maybe skip this function all together.

    Kind regards,

    Thread Starter babobo

    (@babobo)

    This job takes 30,100ms to finish, and it runs almost every minute, so half of the time our server is busy running this job.

    So you’re suggesting to increase the interval of all jobs or can I increase only for this job?

    con

    (@conschneider)

    Engineer

    Hi @babobo

    > This job takes 30,100ms to finish, and it runs almost every minute, so half of the time our server is busy running this job.

    I am not surprised. With that amount of products your backup jobs are probably always running, so the check just keeps on checking. But I can only speculate.

    > So you’re suggesting to increase the interval of all jobs or can I increase only for this job?

    I would first dive into the activity of WC_Facebookcommerce_Background_Process and determine whether something is stuck or whether the check is just there because of sheer volume / amount.

    Then look at: facebook_for_woocommerce_daily_heartbeat_cron which is the cron and the connected Action Scheduler jobs facebook_for_woocommerce_hourly_heartbeat. If your sync schedule is working ok, you might just be able to live without the check, but this would have to be tested.

    Kind regards,

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘High usage MySQL wp_options select’ is closed to new replies.