[Spce-user] mariadb 300% CPU no queries

[Kirill Solomko]

Hi Jon,

Please ensure that mysql.encryption.threads value is set to ”1” in the constants.yml

The fix is available starting from mr8.1.1 and should be available also in mr7.5.7 nearest time.

Cheers,
Kirill

> On 03.02.2021, at 16:55, Jon Bonilla (Manwe) <manwe at sipdoc.net> wrote:
> 
> Hi all
> 
> I had a clean 7.5.6 CE install. Did initial configuration and realized that
> 7.5.7 was out. Run ngcp-upgrade. 
> 
> After the upgrade mysql was using 300% CPU. Nothing in the processlist. 
> 
> Checking with pidstat the threadid  of the 4 threads eating CPU are not listed
> in the processlist. 
> 
> Stopped kamailio-proxy,mediator,rateomat... everything. Enabled general_log...
> there's nothing running queries and CPU 300%. 
> 
> Repeated the same procedure in another server and 300% CPU again.
> 
> I have no idea how to debug this. 
> 
> Attached pidstat and mysql processlist capture.
> 
> 
> cheers,
> 
> Jon
> 
> 
> -- 
> PekePBX, the multitenant PBX solution
> https://pekepbx.com
> -- 
> Spce-user mailing list
> Spce-user at lists.sipwise.com
> http://lists.sipwise.com/mailman/listinfo/spce-user_lists.sipwise.com

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20210208/90a40b3f/attachment-0002.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: pidstat.png
Type: image/png
Size: 365587 bytes
Desc: not available
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20210208/90a40b3f/attachment-0004.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: processlist.png
Type: image/png
Size: 89713 bytes
Desc: not available
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20210208/90a40b3f/attachment-0005.png>