By joel_guesclin on
I'm finding performance very erratic on my VPS system: sometimes excellent, sometimes awful (mostly in between but tending towards the awful). I can see that memory usage is spiking towards my maximum. I think I need to do some performance investigation, of either PHP or MySQL or both, but my available knowledge and time is very limited. Could anyone recommend a tool which which would give me a quick overview of whether it is PHP or MySQL that is causing most of my memory issues? And indeed any advice as to which of the many performance tools I shuold use would be welcome.
Comments
Same here
Posting to subscribe to thread; I just posted a similar question at http://drupal.org/node/979328 .
There is no such *magic*
There is no such *magic* tools which will optimize your VPS/VDS to best perfomance. There are a lot of things you can do.
- Install NGINX as Proxy Web Server and use it together with Apache or kill apache and use NGINX + FCGI + PHP.
- Use caching systems like memcached, APC or eAccelerator.
- You can use Squid or Varnish to cache the pages.
- Chack your PHP/SQL variables.
As u can see, there a lot of thing to do, but you will need to spend some time for it.
Performance Tuning Drupal
Some good starting points:
Mysql tuner
Analyze Queries using Devel Module
Slow Query log
Drupal accesslog - Remove PHP and pagenot found errors
Drupal handbook Page: http://drupal.org/node/2601
You could checkout a brief article of mine at http://shyamala-drupal.blogspot.com/search/label/performance.
Shyamala
http://www.unimitysolutions.com