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@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@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.
On Fri, 2006-01-20 at 16:09, Benjamin Smith wrote:
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.
On the other hand, mysql isn't particularly bright about optimizing queries, so if you do something like join data from three tables while sorting by something in one of them you can expect things to crunch as the tables grow to the point where it has to write temp files to hold things before the sort.
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
-
Benjamin Smith -
Jeff Lasman -
John Plemons -
Les Mikesell -
Mike Kercher