Thread: Need help on Problematic query

Need help on Problematic query

Hi friends,

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.

Problematic query:
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'

EXPLAIN:
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.

Kindly help me to solve this issue.