mafiouso

hello, my host has warned me about overusing server resources, due to locked/ sleep
below is a example of the issue
any advice to sorting this out would be great. thanks!

05:21:20 up 11 days, 16:37, 1 user, load average: 4.39, 6.23, 8.16
USER TTY FROM LOGIN@ IDLE JCPU PCPU WHAT
====================

| 138858 | _osc3 | localhost | _osc | Query | 83 | Sending data | select count(distinct p.products_id) as total from ((products p) left join manufacturers m using(ma |
| 138871 | _osc3 | localhost | _osc | Query | 44 | Locked | update products_description set products_viewed = products_viewed+1 where products_id = '1067' and l |
| 138873 | _osc3 | localhost | _osc | Query | 41 | Locked | update products_description set products_viewed = products_viewed+1 where products_id = '1067' and l |
| 138879 | _osc3 | localhost | _osc | Query | 31 | Locked | select products_name from products_description where products_id = '2666' and language_id = '1' |
| 138890 | ideasonc_tabbled | localhost | ideasonc_tabbled | Sleep | 0 | | |
| 138891 | root | localhost | | Query | 0 | | show processlist |

generallythe site works perfect, but will randomly start to lag until the sql is reset.

thank you