we are upgrading our plugins to Openfire 4.3.2 from Openfire 3.9.3. We are experiencing a huge performance loss in our performance tests. We are having a hard time to understand why is that.
In our investigations we found that http-bind threads go in a blocked status very often and that the operations on the DB have grown more than ten times compared to v3.9.3.
For example, a performance test run for 5 minutes on OF 3.9.3 gives this
Total # of operations: 5,252 Total time for all operations (ms): 4,446 Average time for each operation (ms): 0.85 Operations per second: 0.00
The same test, for the same amount of time on OF 4.3.2, gives:
Total # of operations: 670,267 Total time for all operations (ms): 429,048 Average time for each operation (ms): 0.64 Operations per second: 0.00
That’s a huge difference!
It looks like the DB is overwhelmed by requests and the http-bind threads get blocked. In our performance environment with 4 CPUs Xeon 2.4GHz and 8GB RAM doesn’t reach 250 users in a room and the chatting experience degrades much earlier than that target. Consider that on the same environment (also same DB), with the same tests and OF 3.9.3 we easily managed 4000 users in a single room.
We have tested with both Oracle and DB2 databases (running on different dedicated machines).
Any help in understanding what the problem could be is appreciated.
P.S. We have taken a thread dump, but I’m not allowed to upload it here (maybe I have to few posts). Please let me know if you need it and I will send it by email.