Mysql processor, Oscommerce, Dabatabase, Tables Issue need fixed

CANCELLED
Bids
21
Avg Bid (USD)
$345
Project Budget (USD)
$250 - $750

Project Description:
PLEASE READ AND DONT BID BEFORE YOU HAVE READ..., ALL BIDS with GENERIC i can help sir, look at my list of projects etc will be hidden and ignored.

I HAVE NOTICED WHEN THE WEBSITE loads it takes a long time, i have been having this problem for a while. so my hosting company has sent me this email to fix it.


~
Excessive MySQL activity is caused by (a) a long-running process that locks a table, causing other queries to back up, (b) a query that is not optimized ][example: select all from ... and involving a large or complex query], (c) huge table copies/maintenance during peak hours.


Running Processes:
=============== Pass 1 ===============
noetoys 5400 0.2 0.0 324096 13504 ? SN 07:40 0:00 /usr/bin/php /home/noetoys/public_html/index.php
noetoys 5674 0.4 0.0 324000 13508 ? SN 07:40 0:00 /usr/bin/php /home/noetoys/public_html/index.php
noetoys 5738 0.3 0.0 323980 13492 ? SN 07:40 0:00 /usr/bin/php /home/noetoys/public_html/shopping_cart.php
noetoys 5784 0.4 0.0 323912 13504 ? SN 07:40 0:00 /usr/bin/php /home/noetoys/public_html/index.php
noetoys 5791 0.4 0.0 323980 13488 ? SN 07:40 0:00 /usr/bin/php /home/noetoys/public_html/shopping_cart.php
noetoys 6547 5.0 0.0 324048 13488 ? SN 07:40 0:00 /usr/bin/php /home/noetoys/public_html/product_reviews.php
noetoys 27181 0.0 0.0 324000 13508 ? SN 07:36 0:00 /usr/bin/php /home/noetoys/public_html/index.php
noetoys 27194 0.0 0.0 324000 13504 ? SN 07:36 0:00 /usr/bin/php /home/noetoys/public_html/index.php
noetoys 27580 0.0 0.0 328924 18564 ? SN 07:36 0:00 /usr/bin/php /home/noetoys/public_html/product_info.php
noetoys 27584 0.0 0.0 328924 18568 ? SN 07:36 0:00 /usr/bin/php /home/noetoys/public_html/product_info.php
noetoys 28802 0.0 0.0 324236 13488 ? SN 07:37 0:00 /usr/bin/php /home/noetoys/public_html/shopping_cart.php
noetoys 28865 0.0 0.0 324236 13492 ? SN 07:37 0:00 /usr/bin/php /home/noetoys/public_html/shopping_cart.php
noetoys 29840 0.0 0.0 258560 13448 ? SN 07:37 0:00 /usr/bin/php /home/noetoys/public_html/index.php

Running Queries:
*************************** 1. row ***************************
USER: noetoys_ron5437
DB: noetoys_nights
STATE: Sending data
TIME: 0
COMMAND: Query
INFO: select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '1258'
*************************** 2. row ***************************
USER: noetoys_ron5437
DB: noetoys_nights
STATE: Sending data
TIME: 0
COMMAND: Query
INFO: select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '1259'
*************************** 3. row ***************************
USER: noetoys_ron5437
DB: noetoys_nights
STATE: Sending data
TIME: 0
COMMAND: Query
INFO: select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '1258'
*************************** 4. row ***************************
USER: noetoys_ron5437
DB: noetoys_nights
STATE: Sending data
TIME: 0
COMMAND: Query
INFO: select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '1259'
*************************** 5. row ***************************
USER: noetoys_ron5437
DB: noetoys_nights
STATE: Sending data
TIME: 0
COMMAND: Query
INFO: select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '1258'
*************************** 6. row ***************************
USER: noetoys_ron5437
DB: noetoys_nights
STATE: Sending data
TIME: 0
COMMAND: Query
INFO: select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '1258'

Skills required:
Database Administration, MySQL, OSCommerce, PHP, Website Testing
Hire sensualparty
Project posted by:
sensualparty United States
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


Hire kagg
$ 300
in 2 days
Hire mistersoft
$ 400
in 4 days
$ 252
in 12 days
$ 250
in 4 days
Hire tomaszbg
$ 295
in 9 days
$ 250
in 2 days
$ 600
in 4 days
Hire ItIndia
$ 500
in 8 days
$ 300
in 3 days
$ 250
in 0 days