Support » Plugin: WP Ultimate Recipe » WP Ultimate Recipe is crashing our site

  • Hi, for the last 4 nights our site has been crashing at peak time, and we looked into why and found out this sql queries was returning lots of row data… can you suggest a way to stop this happening???

    mysql> SELECT count(*) FROM wp_options WHERE autoload=’yes’;
    +———-+
    | count(*) |
    +———-+
    | 544 |
    +———-+

    Recommended threshold is about 200

    mysql> SELECT option_name, length(option_value) AS option_value_length FROM wp_options WHERE autoload=’yes’ ORDER BY option_value_length DESC LIMIT 10;
    +————————–+———————+
    | option_name | option_value_length |
    +————————–+———————+
    | wpurp_custom_template_70 | 256327 |
    | wpurp_custom_template_97 | 200941 |
    | wpurp_custom_template_0 | 200573 |
    | wpurp_cache_temp | 155907 |
    | wpurp_cache | 155907 |
    | wpurp_custom_template_94 | 132052 |
    | wpurp_custom_template_95 | 124650 |
    | wpurp_custom_template_98 | 103845 |
    | wpurp_custom_template_1 | 103490 |
    | wpurp_custom_template_99 | 103490 |
    +————————–+———————+

    https://wordpress.org/plugins/wp-ultimate-recipe/

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Brecht

    (@brechtvds)

    You could disable autoload for the templates that are not actually being used, but apart from that all of those things are needed. That wpurp_cache setting is large, but that prevents tons of further queries from being needed, for example.

    Were you getting any errors in your PHP error log?

    Brecht

    Thread Starter scamp50

    (@scamp50)

    Is there a way to disable the templates, or delete them without updating the database?

    Plugin Author Brecht

    (@brechtvds)

    If you’re using the Premium plugin you can remove any template you don’t need in the Template Editor. If you’re using the free version those will only be the default templates and you need those to display the recipes.

    Brecht

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘WP Ultimate Recipe is crashing our site’ is closed to new replies.