URGENT ASSISTANCE REQUIRED.
My website [login to view URL] is down due to database errors. Here is the information provided to me:
"Optimizing the database from your phpMyAdmin will only remove the overhead data gathered for certain tables. it will reduce the size of the database and sometimes will speed it up.
However, your application contains these database calls and running the query above will result with a slow execution time which will be recorded by our Guardian system. If the query takes more than 1 second to be executed, it will be treated as wrong and will be killed.
I was able to confirm that each time you open your website it is starting the slow MySQL query that I offered you in my previous reply. While I was stracing the processing on my end, I confirmed that the query was:
Code:
Executed 1 min ago for 1 sec on Database --> cultur32_karen.
SELECT t.*, tt.*, tr.object_id FROM udemm_terms AS t INNER JOIN udemm_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN udemm_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE [login to view URL] IN ('category', 'post_tag', 'post_format') AND tr.object_id IN (37936, 37748, 37915, 37906, 37863, 7999, 37659, 37750, 34340, 37788, 37773, 37771, 37602, 4803, 37434, 37723, 37717, 37714, 37711, 37703, 33245, 37612, 37430, 37631, 37653, 37649, 37647, 37625, 37203, 37577, 37341, 37505, 37593, 37585, 37579, 37572, 37568, 37564, 37561, 37545, 37533, 37345, 37199, 37510, 37502, 37456, 37219, 37362, 37378, 37445, 37443, 37441, 37423, 37268, 37196, 37192, 37247, 37073, 37248, 37220, 37174, 37214, 37187, 37168, 37128, 37066, 37131, 37133, 37115, 36893, 37089, 37081, 37074, 37064, 37050, 37035, 36945, 36915, 36920, 37021, 36978, 36604, 36930, 35599, 36925, 36954, 36952, 36937, 36901, 36855, 36887, 36600, 1102, 3010, 33391, 36840, 36831, 36821, 36747, 36545, 1299, 36677, 36706, 36700, 36464, 5841, 6764, 36672, 36660, 36652, 36469, 36384, 112, 7348, 4481, 36586, 36579, 7768, 36576, 36309, 36541, 36539, 3432, 36044, 36401, 1064, 35015, 36508 (this goes on and on)
The server is killing the process as it is unnaturally long."
I need this to be optimised ASAP.