It’s been a long standing belief that MyISAM tables are significantly faster than InnoDB tables when performing mostly read applications as would be the case for the majority of web applications out there. It’s one of those things that everybody just took at face value. Well, the guys over at
MySQL Performance Blog have shot down that myth.
In a posting titled InnoDB vs MyISAM vs Falcon benchmarks – part 1, their primary goal was to benchmark the new Falcon storage engine against MyISAM and InnoDB. Of course, the by-product is that we also have benchmarks for MyISAM vs. InnoDB. The results they present should make anybody think twice about which storage engine to use in their next project.
Here are some interesting links regarding PHP performance tips. I hope you find them all as informative as I have.
5 PHP Performance Tips You Probably Don’t Want To Hear: Marco has some good tips that aren’t like many of the other performance tips you’ll find.
A HOWTO on Optimizing PHP: John Lim with a very detailed article on optimizing PHP.
Accelerating PHP Applications: Slides from a talk by Ilia Alshanetsky. Updated slides in PDF form found here.
Cluesheet – Tips for PHP Developers: Interesting “clue sheet” that has a section on performance.
How to install Alternative PHP Cache: Justin Silverton tells us how to install APC, a opcode cache for PHP.
Textpattern, out of the box, is a very fast CMS. In fact, when comparing it to other content management systems, it wins hands down in most cases. Even given this great out of the box performance, wouldn’t it be nice to be able to serve pages even faster? I decided to see just want tweaks would speed up Textpattern, and what wouldn’t. Read on to see what I tried and how it affected the number of pages served.
Click here to read more
The Apache web server can use up a pretty large chunk of RAM. The last thing you need in a high traffic situation is to start swapping. One way to avoid swapping is to make sure Apache is utilizing the smallest amount of memory possible. One quick and easy way to accomplish this is to stop loading unnecessary modules.
Click here to read more
Over the past day I've been going through a few web applications and preparing them in the event they get digged or slashdotted. One of my primary goals was to cache as much data to disk, rather than hitting the database for it each time. Now, most of the web applications I have written myself, so I didn't have the luxury of some type of premade mod or plugin. In one case, this textpattern installation, I did have that luxury.
Click here to read more