18609 MySQL Optimistations needed

Hi I need further optimisations on our database for our website. [login to view URL] (database is disabled). Background: There are too many connections from our site to the shared server, we need to reduce it further. You would also need to liase with our host company PIPEX to resolve the problems. Here is a snapshot of the process list which caused problems for the server: +-------+---------+---------------+-----------+---------+------+----------------------+------------------------------------------------------------------------------------------------------+ | Id | User | Host | db | Command | Time | State | Info | +-------+---------+---------------+-----------+---------+------+----------------------+------------------------------------------------------------------------------------------------------+ | 33700 | mobile | localhost | mobiledb | Query | 0 | Sending data | | select product_review.heading_id ,product_review.review_heading_value from product_review | | 33907 | mobile | localhost | mobiledb | Query | 2 | Sending data | | select product_review.heading_id ,product_review.review_heading_value from product_review | | 33956 | mobile | localhost | mobiledb | Query | 2 | Sending data | | select product_review.heading_id ,product_review.review_heading_value from product_review | | 34214 | mobile | localhost | mobiledb | Query | 2 | Sending data | | select product_review.heading_id ,product_review.review_heading_value from product_review | | 34281 | mobile | localhost | mobiledb | Query | 0 | Sending data | | select product_review.heading_id ,product_review.review_heading_value from product_review | | 34338 | mobile | localhost | mobiledb | Query | 2 | Sending data | | select product_review.heading_id ,product_review.review_heading_value from product_review | | 34382 | mobile | localhost | mobiledb | Query | 1 | Sending data | | select product_review.heading_id ,product_review.review_heading_value from product_review | | 34392 | mobile | localhost | mobiledb | Query | 1 | Sending data | | select product_review.heading_id ,product_review.review_heading_value from product_review | | 34415 | mobile | localhost | mobiledb | Sleep | 0 | | | | 34431 | mobile | localhost | mobiledb | Query | 2 | Sending data | | select product_review.heading_id ,product_review.review_heading_value from product_review | | 34454 | mobile | localhost | mobiledb | Query | 0 | Sending data | | select product_review.heading_id ,product_review.review_heading_value from product_review | | 34459 | mobile | localhost | mobiledb | Query | 2 | Sending data | | select product_review.heading_id ,product_review.review_heading_value from product_review | | 34478 | mobile | localhost | mobiledb | Query | 3 | Writing to net | | select product_review.heading_id ,product_review.review_heading_value from product_review | | 34495 | mobile | localhost | mobiledb | Query | 2 | Sending data | | select product_review.heading_id ,product_review.review_heading_value from product_review | | 34532 | mobile | localhost | mobiledb | Query | 3 | Sending data | | select product_review.heading_id ,product_review.review_heading_value from product_review | | 34554 | mobile | localhost | mobiledb | Query | 2 | Sending data | | select product_review.heading_id ,product_review.review_heading_value from product_review | | 34589 | mobile | localhost | mobiledb | Query | 0 | Sending data | | select product_review.heading_id ,product_review.review_heading_value from product_review | | 34603 | mobile | localhost | mobiledb | Query | 2 | Sending data | | select product_review.heading_id ,product_review.review_heading_value from product_review | | 34646 | mobile | localhost | mobiledb | Query | 0 | Sending data | | select product_review.heading_id ,product_review.review_heading_value from product_review | | 34660 | webdate | localhost | webdatedb | Query | 0 | Copying to tmp | table | SELECT DISTINCT [login to view URL], [login to view URL], [login to view URL], [login to view URL], | p.marital_status, [login to view URL], [login to view URL], [login to view URL] F | | 34662 | a4hlive | [login to view URL] | a4hlivedb | Sleep | 0 | | | | 34663 | root | localhost | | Query | 0 | | show processlist | +-------+---------+---------------+-----------+---------+------+----------------------+------------------------------------------------------------------------------------------------------+