We have been using OPENFIRE 4.2.3 (12 GB RAM and 8 core CPU), currently it server 1000-2500 simultaneous connection at any time of day. During peak hours (4 hours) where server serves 2500 connections, a high CPU load of about (10-20 ) on server is noticed.
Once we get a high CPU load on server, OPENFIRE performance decrease, new clients trying to connect gets Timeout exception on connection, messaging slows down.
We are using MariaDB in connection with OPENFIRE.
On checking the database query statistics, query related ofUser table is taking significant time.
OfUser table might contain 1 million entries.
Cache setting are in the image below,
From what I can see is high load CPU is in connection with DB Query taking time, what should we do in this scenario ?
Should we start purging inactive users data on server ?
What steps to take to optimize cache ?
Why is queries taking time, is indexing not implemented on ofUser table ?