PHP, MySQL, JavaScript, Windows 7, Linux
Optimize PHP, Apache & MySQL for performance
Two MySQL tuner scripts
MySQLTuner (Perl) and MySQL Performance Tuning Primer (Shell) are two scripts that can help diagnose MySQL database performance issues, and provide recommendations on how to solve them. While both scripts output similar information, the diagnosis can be slightly different with each script, so I like to use both. Below are directions on how to use them, as well as a few screenshots.
# Download MySQLTuner and MySQL Performance Tuning Primer to ~/scripts. # To avoid having to invoke Perl/SH each time, make both files executable. chmod +x ~/scripts/mysqltuner.pl chmod +x ~/scripts/tuning-primer.sh # After that, give them a go! ~/scripts/mysqltuner.pl ~/scripts/tuning-primer.sh
Configure Apache, PHP, and MySQL for performance
Make sure that your configuration files are setup correctly for your server, application, and load. Enough said?
- A HOWTO on Optimizing PHP with tips and methodologies
- HOWTO: Basic Apache performance tuning (httpd)
- HOWTO: Basic MySQL performance tuning (MySQLd)
- Tuning LAMP systems, Part 2: Optimizing Apache and PHP
- Optimize your Apache VPS for WordPress
Best Practices
Did you know that incrementing a class variable is three times slower than incrementing a local variable? Did you know adding LIMIT 1 to SQL queries for a single row can speed up queries? Simply changing the way you write code can speed things up considerably.
- 63+ best practice to optimize PHP code performance
- Let’s make the web faster – Google Code
- Top 20+ MySQL Best Practices | Nettuts
- Best Practices for Speeding Up Your Web Site
Get a PHP opcode cache
PHP is an interpreted language, and as such it must be “compiled” into a readable format called opcode. An opcode cache basically preserves the compiled data, and allows us to essentially skip a step. This can save much needed resources (CPU, memory, etc.), and lower load time considerably.
WordPress memory usage reduced from 14MB to 1.4MB
September 6, 2009 - 1:48 pm
Tags: eAccelerator, wordpress memory usage, zend optimizer
Posted in PHP, WordPress | 12 comments
About two weeks ago, I wrote a short article called eAccelerator reduces WordPress memory usage which outlined how I was able to reduce WP memory usage to 8MB. While looking into the Zend Framework, I came across Zend Optimizer again, which I hadn’t messed with in a while. I decided to install it on a [...]
eAccelerator reduces WordPress memory usage
August 27, 2009 - 8:45 pm
Tags: cPanel, eAccelerator, EasyApache, WHM, wordpress memory usage
Posted in PHP, WordPress | 8 comments
In my quest to minimize the memory usage of our beloved blogging platform, WordPress, I came across eAccelerator. After using Zend Server, and experiencing the performance boost their caching mechanism created, I started looking for something that would work easily with cPanel/WHM. Lo and behold, there exists a program called eAccelerator which is quoted as [...]
February 1, 2010 - 9:13 am
Just a quick correction – Zend Optimizer is a loader for Zend Guard encoded scripts. It also does some runtime optimizations, but is not an opcode cache.
Zend Optimizer+ (note the “+”) is an opcode cache and is available as part of Zend Server and Zend Server CE (both of which contain other technologies for optimizing performance).
February 1, 2010 - 9:01 pm
Thanks David! I made that correction within the article.
February 8, 2011 - 12:09 pm
APC, a very good opcode cacher, will come standard with PHP 6 onwards. So, I highly recommend using APC from the get go.