In those emergency days I enabled about 150 users to UCP in order to use the WebRTC phone.
This kind of UCP use created an unusual load on the DB and I see all the cores often at 100% usage.
now that there are only 5 users connected but I still see an impressing “113002” queries in 10 minutes.
From the querylog there are 2 queries that are flooding the db:
SELECT * FROM userman_users WHERE default_extension = ‘S’ LIMIT N
SELECT * FROM userman_groups ORDER BY priority
thoose are responsible for abot 70% of the queries…
Have you any idea about this load and how to avoid it?