Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.

For new questions please post at magento.stackexchange.com, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email community@magento.com.

Magento Forum

Yet another Magento performance/speed thread! 
 
edbloom
Jr. Member
 
Total Posts:  2
Joined:  2010-01-10
 

Hi there folks,

I’ll get straight to be point - I’m trying to improve Magento performance and have already done a lot to try to improve things.

My current setup:

- VPS with 4GB RAM, 8 core CPU
- ubuntu 12.04
- nginx 1.2.1 w/ extras
- php-fpm 5.3.10 w/ suhosin v0.9.33
- apc
- mysql 5.5.24

fairly standard static PM settings:

pm.max_children = 15
pm.max_requests = 500

unix socket connecting nginx to php backend.

- Magento cache backend: APC
- Block caching enabled

- Varnish & Phoenix full page cache in front of nginx

Speed flys for users who hit Varnish cached pages.

The problems start when users add items to their cart and/or hit cold pages which don’t have cache.

From looking at nginx access logs and mysql query logs - it looks like the DB response time is the biggest bottleneck.

When I throw lots of load at the frontend I can see the requests going through nginx access logs very very slowly (far too slow) while the mysql trace log is going nuts. My ram/cpu is fine the whole time.

Is mysql the big bottleneck at this point?

 
Magento Community Magento Community
Magento Community
Magento Community
 
Zentec
Jr. Member
 
Avatar
Total Posts:  19
Joined:  2012-11-08
 

Are the drives on NFS, that is always a disaster for Magento both PHP and MySQL. Running MySQL on the same server always leads to problems due to them having different requirements on processing. It is always hard to pinpoint these however we have happily run on a similar setup with AWS, CloudFront, RDS, Nginx, PHP-FPM. Magento uses a lot of burstable CPU, it is possible the host is throttling bursts especially with added extensions.

 
Magento Community Magento Community
Magento Community
Magento Community
 
Zentec
Jr. Member
 
Avatar
Total Posts:  19
Joined:  2012-11-08
 

You may be interested in this thread.

 
Magento Community Magento Community
Magento Community
Magento Community
 
MagenX
Enthusiast
 
Total Posts:  791
Joined:  2008-05-26
Dublin
 

im sure it should be like that, varnish has nothing to do if NO_CACHE cookie is there.
what you need to do is test your mysql workload, and configure accordingly.
and install some simple hole-punching cache extension to test.
you can try this one:
http://www.magentocommerce.com/magento-connect/i-speed-performance-booster.html
or this one:
http://www.magentocommerce.com/magento-connect/zoom-full-page-cache-1742.html

but remember, you have to tune mysql and php, server as well, otherwise customers will die waiting for checkout to show-up after speedy product pages smile

send me a message if need help.

 
Magento Community Magento Community
Magento Community
Magento Community
 
Vanquish
Jr. Member
 
Total Posts:  24
Joined:  2012-07-01
 

You may want to refer to this information

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top