Closed

Mysql processor, Oscommerce, Dabatabase, Tables Issue need fixed

This project received 21 bids from talented freelancers with an average bid price of $345 USD.

Get free quotes for a project like this
Employer working
Project Budget
$250 - $750 USD
Total Bids
21
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/[url removed, login to view]
noetoys 5674 0.4 0.0 324000 13508 ? SN 07:40 0:00 /usr/bin/php /home/noetoys/public_html/[url removed, login to view]
noetoys 5738 0.3 0.0 323980 13492 ? SN 07:40 0:00 /usr/bin/php /home/noetoys/public_html/[url removed, login to view]
noetoys 5784 0.4 0.0 323912 13504 ? SN 07:40 0:00 /usr/bin/php /home/noetoys/public_html/[url removed, login to view]
noetoys 5791 0.4 0.0 323980 13488 ? SN 07:40 0:00 /usr/bin/php /home/noetoys/public_html/[url removed, login to view]
noetoys 6547 5.0 0.0 324048 13488 ? SN 07:40 0:00 /usr/bin/php /home/noetoys/public_html/[url removed, login to view]
noetoys 27181 0.0 0.0 324000 13508 ? SN 07:36 0:00 /usr/bin/php /home/noetoys/public_html/[url removed, login to view]
noetoys 27194 0.0 0.0 324000 13504 ? SN 07:36 0:00 /usr/bin/php /home/noetoys/public_html/[url removed, login to view]
noetoys 27580 0.0 0.0 328924 18564 ? SN 07:36 0:00 /usr/bin/php /home/noetoys/public_html/[url removed, login to view]
noetoys 27584 0.0 0.0 328924 18568 ? SN 07:36 0:00 /usr/bin/php /home/noetoys/public_html/[url removed, login to view]
noetoys 28802 0.0 0.0 324236 13488 ? SN 07:37 0:00 /usr/bin/php /home/noetoys/public_html/[url removed, login to view]
noetoys 28865 0.0 0.0 324236 13492 ? SN 07:37 0:00 /usr/bin/php /home/noetoys/public_html/[url removed, login to view]
noetoys 29840 0.0 0.0 258560 13448 ? SN 07:37 0:00 /usr/bin/php /home/noetoys/public_html/[url removed, login to view]

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'

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online