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
- 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?