Quick Install Guide for Apache+PHP+Firebird

Read More »

Advertisements

Firebird v2.5 Alpha 1 really makes a differance

While on vacation I’ve been working on a pet-project that has been around for many years now. The service is a mobile device chat and is powered by Firebird and PHP.

There used to be lots of problems handling more than 400 simultaneous users, but after a DB upgrade to Firebird v2.5 Alpha 1 things really look different.

Previously the DB machine (Dualcore) had one of the CPU’s running at 100% and the other not doing much (FB was Superserver) but after the switch the TOTAL CPU now ranges between 10% and 50% on the DB machine. At the same time the WebServer CPU load also decreased and is constantly under 60% where it used to be over 95% all the time!

So by just switching to the new DB engine a tremendous performance gain was achieved! Also a lot less errors are reported to the PHP error logs. The ones still coming are a deadlocks, but around 30 / 24h which is a lot less than it used to be!

To the Firebird team I want to say “THANK YOU for making a great database engine” !

Apache, PHP and Firebird Performance Tuning

In the last post I commented that I had a test-bed application, based on Apache, PHP and Firebird, and once the problem with the images was solved I could finally start doing the actual performance testing/tuning that I originally wanted to do.

The only major changes from the last post is that I’ve now upgraded the database engine to the “Firebird v2.5 Alpha 1” that supports SMP, and that the application now contains more base data in the tables.Read More »

Apache Serves Images Slowly

Today I had a really interesting and strange problem with the Apache WWW server. It served images very slowly under even light loads and there was really no explanation for this. The CPU on the host machine almost idle and network throughput was nominal too.

After some digging on the internet I found other people also had had this problem, and had suggested various methods to remedy this, like enabling caching and putting images on a separate machine and disabling the KeepAlive feature. Read More »

Performance Testing Blog – And so it begins

Today it begins, my Performance Testing and Performance Engineering blog, where I’ll outline some of the things I will encounter in this field…

I hope this is going to be a fun and informative place for all of you, but only time and your feedback can determine that!

Helpful tools

The tools I use mostly at work is LoadRunner from HP, but I also use a myriad of other utilities that assist me. The one biggest helpful “utility” i use is probably¬† Delphi, since I can make DLL’s and custom made applications that assist me in the testing process.

Also PHP and Apache are valuable help, since most of my testing is web based. Other very useful tools are WireShark (Network Analyzer) and FireBug (Firefox plugin, HTML analysis).