It has come to our attention that your hosting account, specifically the pnktn database is causing the shared resources to be over-utilized. This, in turn, affects the usage by other customers.
We have disabled your database to return the server to normal usage. To re-enable your database, you will need to correct the following query:
-Problematic query:
Code: Select all
SELECT * , count(*) as count FROM pligg_links , pligg_categories
WHERE category_lang='en' AND category_id=link_category GROUP BY
link_category ORDER BY category_name ASC
id
select_type table type possible_keys key key_len ref rows Extra
1
PRIMARY pligg_categories ALL 31 Using where; Using
temporary; Using filesort
2 DEPENDENT SUBQUERY pligg_links ALL
4619 Using where
This query examines 143189 rows
Problematic query:
Code: Select all
SELECT link_id FROM pligg_links WHERE
link_status='published' ORDER BY (SELECT SUM(vote_value) FROM
pligg_votes WHERE vote_link_id=link_id) DESC LIMIT 15,5
EXPLAIN:
id
select_type table type possible_keys
key key_len ref rows Extra
1
PRIMARY pligg_links ALL
4619 Using where; Using filesort
2 DEPENDENT
SUBQUERY pligg_votes ref link_id link_id
4 pnktn.pligg_links.link_id 37
This
query examines 170903 rows, which is unacceptable in shared hosting.