[Spce-user] mariadb 300% CPU no queries

[José María Caballero Alba]

Hi Jon

If you do a SHOW PROCESSLIST in the mysql console, does it give you any 
results?.

Have you look at the slow_querys log?

Regards.

On 3/2/21 17:43, Jon Bonilla (Manwe) wrote:
> El Wed, 3 Feb 2021 16:55:37 +0100
> "Jon Bonilla (Manwe)" <manwe at sipdoc.net> escribió:
>
>> 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.
>>
>
> Answering myself, after some long long time it stops. I did
> ngcp-initial-configuration in another pristine server and I have the 300% CPU.
>
> If I restart mysql in the one upgraded I have the 300% issue back again. Will
> try to measure how long it takes to stop.
>
>
>
>
>
>
-- 
José María Caballero Alba

Technical Dept.

www.tecsens.com
Sense & Technology

(T) +34 902 88 40 80 ext.109


Voice Solutions,

Internet, Networks & Security,

Private Cloud Services,

IT Consulting & Outsourcing



AVISO LEGAL

Este mensaje electrónico y sus documentos anexos, si los hay, son privados, confidenciales y de uso exclusivo para el/los destinatario/s. Queda prohibida cualquier difusión, reproducción parcial o total de su contenido, sin nuestra autorización. Si usted no es el destinatario señalado, rogamos nos lo comunique remitiendo el mensaje a la dirección info at tecsens.com antes de su eliminación.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20210204/6a2b05ba/attachment-0002.html>