Activation of Offline Presence Plugin about tigase-server HOT 4 CLOSED

Could you be more specific regarding "consumption of server and db resources grows to the roof and may start failing other proceses."

Do you mean CPU? Memory? Storage of the DB?

The plugin uses cache but it also relies on database to persist presence data. Number of DB requests could be significant in case of frequent reconnects (mobile OS without stream management for example).

from tigase-server.

What we are seeing exactly is an increase on RDS metrics regarding, delete throughput, insert latency, presence number and 85% con CPU.
I see cache size is not that big but possibly this will happen for a few minutes and then the values will become stable again, maybe right?

from tigase-server.

OK, it seems that mostly RDS metrics are affected thus it would indicate higher number of queries which in turn would suggest that indeed increasing cache size (and thus reducing number of queries) should help.

If you are using RDS, do you have performance insights enabled and could share information from it? Which queries are the biggest offenders? I would assume TigUpdatePairs and select pval from tig_pairs…

from tigase-server.

Thank You!
Would try and see what can be done.
Actually yes, all regarding tig_pairs are very paintful buut we are also encountering issues with normal selects and counts to tig_users.

from tigase-server.