Please help, my host provider just shut me down due to resources

[defroster]

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

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

 

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:

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.

 

[quasiman]

If you're not a programmer, it must mean you've downloaded this script from somewhere.  The portion they've sent you is probably a small bit of something much larger.

 

I'd say your best bet is to move your web service somewhere that can handle 170K+ examined rows.