150 Users on UCP/WebRTC and MariaDB high load

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
n. 43139
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?


This topic was automatically closed 31 days after the last reply. New replies are no longer allowed.