Issues with Overload of MySQL Queries

Fred replied

3 years ago

Customer Reply

Ok will push to live site and test, we also plan now to delete many of the tags

PenciDesign Supporter replied

3 years ago

Staff Reply

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.

Fred started the conversation

3 years ago

Conversation Start

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.