Am facing an issue on my site, my site has been blocked by godaddy due to Problematic query, This query examines 532,215,396 rows, which is unacceptable in shared hosting.
SELECT t.postcount AS total, d.postcount AS today FROM wp_cp_ad_pop_total AS t
INNER JOIN wp_cp_ad_pop_daily AS d ON t.postnum = d.postnum
WHERE t.postnum = 2689 AND d.time = '2012-06-05'
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE t ALL 1713 Using where
1 SIMPLE d ALL 310692 Using where
Am not a expert programmer, I guess this problem has come after i uploded one plugin, later i clicked one option to delete some data from that plugin. after that i lost connection with my site.
just for more information i had added plugin transposh to convert content in different language, but later this plugin staterd giveing 404 error those error still going up and reached till 1,50,000 errors so i went and clicked auto deleted data.
then my site got blocked. now above mentioned query and generated 532,215,396 rows hence my database is been blocked.
if any one has any idea above this issue, plz help
Kindly help me to solve this issue.