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” !
Adding to my previous post on Apache, PHP and Firebird performance I have now achieved a new higscore of 155 pages/sec!
In order to achieve this I had to tweak the SQL statements a little (removed the UPPER() parts), modified the firebird.conf a little and moved the DB to another T61p (DualCore 2.2 GHz) machine. Read More »
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 »
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 »
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!
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.