[Spce-user] mariadb 300% CPU no queries

José María Caballero Alba josem.caballero at tecsens.com
Thu Feb 4 03:05:46 EST 2021

Hi Jon

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

Have you look at the slow_querys log?


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.

Sense & Technology

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

Voice Solutions,

Internet, Networks & Security,

Private Cloud Services,

IT Consulting & Outsourcing


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>

More information about the Spce-user mailing list