So we tried to migrate our site allaboutTRH.com to Soledad theme. We are hosted using WPEngine with a dedicated server.
After migration the site would keep crashing and after further investigations WPEngine support said there are overload on SQL Queries and following is what is causing it.
EXPLAIN SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE t.term_id = 7062 /* From [www.allabouttrh.com/2023/02/07/katie-rost-reveals-shes-working-retail-at-minimum-wage-job-post-rehab/] in [/nas/content/live/allabouttrh/wp-content/themes/soledad/inc/elementor/includes/helper.php:447] */:
So we tried to migrate our site allaboutTRH.com to Soledad theme. We are hosted using WPEngine with a dedicated server.
After migration the site would keep crashing and after further investigations WPEngine support said there are overload on SQL Queries and following is what is causing it.
EXPLAIN SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE t.term_id = 7062 /* From [www.allabouttrh.com/2023/02/07/katie-rost-reveals-shes-working-retail-at-minimum-wage-job-post-rehab/] in [/nas/content/live/allabouttrh/wp-content/themes/soledad/inc/elementor/includes/helper.php:447] */:
*** row 1 *** table: t type: const possible_keys: PRIMARY key: PRIMARY key_len: 8 ref: const rows: 1 Extra: NULL
*** row 2 *** table: tt type: ref possible_keys: term_id_taxonomy key: term_id_taxonomy key_len: 8 ref: const rows: 1 Extra: NULL
We contacted Elementor support and they said it's a theme developer issue and not elementor.
We do have a development site if you need access please let us know.Hi,
The MySQL overload because your site contains a lot of post tags, so the HTML select dropdown can't load properly.
I've changed all the post tags on the back end to the AJAX queries.
Please check again.
Regards,
PenciDesign.
Ok will push to live site and test, we also plan now to delete many of the tags