150 Users on UCP/WebRTC and MariaDB high load

FreePBX Applications / Modules
1

Hi,
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:
n.31766
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?

Thanks
Giuseppe

2

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