Mysql processor, Oscommerce, Dabatabase, Tables Issue need fixed

Cancelled

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'

Skills: Database Administration, MySQL, OSCommerce, PHP, Website Testing

See more: sn it, peak 10, home maintenance company, testing p, mysql index, hosting issue, fix mysql query, need fixed, need website testing, mysql help table, pass query, 2013 query, sir please look, website testing projects, oscommerce table, excessive mysql activity caused running process locks table, 5400, php table maintenance, oscommerce hidden products, bids oscommerce, product_info oscommerce fix, home user mysql, mysql query example, mysql large projects, hosting company list

About the Employer:
( 0 reviews ) jacksonville, United States

Project ID: #4183001

20 freelancers are bidding on average $350 for this job

kagg

Please refer PM for oscommerce experience and other details. Thanks

$300 USD in 2 days
(255 Reviews)
7.9
mistersoft

Hello! I am OSC expert and can optimize queries, add pages cache, etc. Complex problem solving. Thanks!

$400 USD in 4 days
(392 Reviews)
7.5
SunrisePHP

Hi, We have throughly read your requirements and believe that we can deliver exceptional results. We hope you will consider using our services. Best Regards,

$252 USD in 12 days
(520 Reviews)
7.3
saiSoftIndia

I have read your requirements and think that I would be a great fit for this project

$250 USD in 4 days
(291 Reviews)
7.2
tomaszbg

Hello, Default OSCommerce setup could be really slow when there are tons of products and lots of customers are trying to browse at the same time. There are 2 steps that could be taken. More details in the P.M.

$295 USD in 9 days
(580 Reviews)
6.7
KPRITSolutions

We have gone through your requirement and would happy to share that project is very much in line with our technical strength and ability. We have 10+ yrs oscommerce shopping cart websites designing & development expert More

$250 USD in 2 days
(62 Reviews)
6.4
Fourtek1

We need to check the coding and adjust to make it fast. Provide us the server details and we will do this task within NO time. Check PMB

$600 USD in 4 days
(29 Reviews)
6.1
ItIndia

We have optimized data base and sql queries to take care of mysql issues. oscommerce uses MyISAM engine which will lock complete table. So a single wrong query will lock your tables resulting in many issues. A More

$500 USD in 8 days
(127 Reviews)
5.9
frkSuna

I can fix it immediately. Please check PMB

$300 USD in 3 days
(109 Reviews)
5.9
aroel

I can help you solving this issue, please refer to PM

$250 USD in 0 days
(72 Reviews)
5.8
meet2amitvw

Hello Thanks for the sharing requirement. I went through your description and ready to work with you. You will work directly with one person and that's me. No mediators. No managers. No subcontractors. I will More

$251 USD in 2 days
(46 Reviews)
5.6
pablotorres

i can do it

$250 USD in 14 days
(62 Reviews)
5.3
luheav

I can help, please check your PMB.

$350 USD in 4 days
(11 Reviews)
5.0
yanotcook

I am ready to fix immediately. Please check PM for details.

$250 USD in 1 day
(30 Reviews)
4.8
binhtq

I am very well familiar with oscommerce. I have throughly read your requirements. I can get this done for you. Best Regards,

$250 USD in 4 days
(18 Reviews)
4.8
Monkdesigns

hi - I'm an oscommerce developer living and working in south Florida. There are 5 very important changes needing to be made to the site which individually would improve the performance but when all are combined dramati More

$300 USD in 2 days
(4 Reviews)
4.5
webdevit

oscommerce/php team

$600 USD in 6 days
(6 Reviews)
2.6
rajdac123

I have outlined the methodology to improve the response time. I had come across a similar situation many times when our database grew to about 1GB. Doing that optimization increased by 2.5 times. The approach followed More

$300 USD in 2 days
(1 Review)
0.5
ahbeeahkao

This is typical issue for e-commerce. You might be missing out something there. Give me a chance and I will show you the tricks.

$700 USD in 7 days
(0 Reviews)
0.0
herculanopinto

Not knowing the DB architecture, table sizes nor system memory is hard to guarantee results, but there are many ways to optimize databases and queries.

$300 USD in 7 days
(0 Reviews)
0.0