PHP, MySQL, JavaScript, Windows 7, Linux
Posts tagged zend optimizer
Optimize PHP, Apache & MySQL for performance
Jan 21st
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
WordPress memory usage reduced from 14MB to 1.4MB
Sep 6th
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 whim. The results were unexpected…
| WordPress memory usage* | |
|---|---|
| Standard PHP installation | 14MB |
| eAccelerator | 8MB |
| eAccelerator & Zend Optimizer | 1.4MB |
| * WP memory usage recorded by TPC! Memory Usage | |