Hi David
I recently moved my sites to dedicated server. I moved them because my sites were causing the shared server to fail.
I am still having the same problem the last 2 days my server load has risen over 200. I am told something in mysql is not closing. here is the message I got.
Its been rebooted. Something is not closing mySQL connections. Check with your programmer
is there anything you can think of that would cause this?
Thank You
Dean
Hi David
This isn't being caused by importing it just happens during the day at random. Guessing when a user is looking or searching a site.
Thank You
Dean
Hi Dean,
I'm wondering if you're being crawled heavily at the moment - that could account for a significant load increase. Have you come across this thread regarding MySQL configuration:
http://www.pricetapestry.com/node/732
Cheers,
David.
Hello Dean,
I don't know of any problems that would cause this.
Do you have many thousands of products? The highest loads that are caused are generally the DELETE FROM when importing individual merchant feeds; so you may find that importing all at once solves the problem - using the command line script (which should be no problem on a dedicated server as you should have SSH access) - using:
import.php @ALL...check the following page for more info:
http://www.pricetapestry.com/node/7
Cheers,
David.