PHP please help, I just got taken down by my hosting company
Posted: Wed Mar 24, 2010 12:19 pm
Hello, I am not a programmer but I just got this from godaddy. How can I change this problematic script? Thanks /D. Froster
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:
EXPLAIN:
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:
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.
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.