John Plemons
2006-Jan-20 22:02 UTC
[CentOS] Website running slow and Timing Out, but at random...
I have a site running the current version of Centos 4.2, it has a shopping cart running on it and runs slow and times out at random. The cart is a simple php package using a MySQL database backend. Can any one think of ways to improve the speed in MySQL and Apache, I've had the cart checked by the software vendor, it's working like it should, they are pointing to MySQL or Apache and a maybe... Thank you, John Plemons
Mike Kercher
2006-Jan-20 22:07 UTC
[CentOS] Website running slow and Timing Out, but at random...
centos-bounces at centos.org <> scribbled on Friday, January 20, 2006 4:03 PM:> I have a site running the current version of Centos 4.2, it > has a shopping cart running on it and runs slow and times out > at random. The cart is a simple php package using a MySQL > database backend. > > Can any one think of ways to improve the speed in MySQL and > Apache, I've had the cart checked by the software vendor, > it's working like it should, they are pointing to MySQL or > Apache and a maybe... > > Thank you, > John Plemons > > > > _______________________________________________The mysql query cache helped me a ton! Read here: databasejournal.com/features/mysql/article.php/3110171 Mike
Benjamin Smith
2006-Jan-20 22:09 UTC
[CentOS] Website running slow and Timing Out, but at random...
The best way is to find out what the problem actually is. Have you looked at /var/log/httpd/error_log and related logs? What about MySQL? When it's timing out, what's top report? Does the site ping properly when these failures occur? Your question is sorta like going to a mechanic and saying "My car sometimes doesn't run - what's wrong with it?". Apache/MySQL don't just quit working without a very good reason - stock CentOS 4.2 install will handle mid-level traffic (many millions of hits per month) on commodity hardware with virtually no configuration changes or performance tuning, so problems like you describe are most certainly due to a problem, usually hardware. -Ben On Friday 20 January 2006 14:02, John Plemons wrote:> I have a site running the current version of Centos 4.2, it has a > shopping cart running on it and runs slow and times out at random. The > cart is a simple php package using a MySQL database backend. > > Can any one think of ways to improve the speed in MySQL and Apache, I've > had the cart checked by the software vendor, it's working like it > should, they are pointing to MySQL or Apache and a maybe... > > Thank you, > John Plemons > > > > _______________________________________________ > CentOS mailing list > CentOS at centos.org > lists.centos.org/mailman/listinfo/centos > > -- > This message has been scanned for viruses and > dangerous content by MailScanner, and is > believed to be clean. >-- "The best way to predict the future is to invent it." - XEROX PARC slogan, circa 1978
Jeff Lasman
2006-Jan-21 04:10 UTC
[CentOS] Website running slow and Timing Out, but at random...
On Friday 20 January 2006 02:02 pm, John Plemons wrote:> Can any one think of ways to improve the speed in MySQL and Apache, > I've had the cart checked by the software vendor, it's working like > it should, they are pointing to MySQL or Apache and a maybe...I don't know if this will help you or not; we use it on our shared webhosting servers and it works: help.directadmin.com/item.php?id=44 Jeff -- Jeff Lasman, Nobaloney Internet Services 1254 So Waterman Ave., Suite 50, San Bernardino, CA 92408 Our blists address used on lists is for list email only Phone +1 909 266-9209, or see: "nobaloney.net/contactus.html"