CentOS - Jan 2006 - 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

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:

http://www.databasejournal.com/features/mysql/article.php/3110171

Mike

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
> http://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

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:

http://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:
"http://www.nobaloney.net/contactus.html"