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/