<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<p>Hi Jon</p>
<p><span class="VIiyi" lang="en"><span class="JLqJ4b ChMk0b"
data-language-for-alternatives="en"
data-language-to-translate-into="es" data-phrase-index="0"><span>If
you do a SHOW PROCESSLIST in the mysql console, does it give
you any results?</span></span><span class="JLqJ4b"
data-language-for-alternatives="en"
data-language-to-translate-into="es" data-phrase-index="1"><span>.</span></span><span
class="JLqJ4b ChMk0b" data-language-for-alternatives="en"
data-language-to-translate-into="es" data-phrase-index="2"><span><br>
</span></span></span></p>
<p><span class="VIiyi" lang="en"><span class="JLqJ4b ChMk0b"
data-language-for-alternatives="en"
data-language-to-translate-into="es" data-phrase-index="2"><span>Have
you look at the slow_querys log?</span></span></span> </p>
<p>Regards.<br>
</p>
<div class="moz-cite-prefix">On 3/2/21 17:43, Jon Bonilla (Manwe)
wrote:<br>
</div>
<blockquote type="cite"
cite="mid:20210203174358.44776da0@multivac.sipdoc.net">
<pre class="moz-quote-pre" wrap="">El Wed, 3 Feb 2021 16:55:37 +0100
"Jon Bonilla (Manwe)" <a class="moz-txt-link-rfc2396E" href="mailto:manwe@sipdoc.net"><manwe@sipdoc.net></a> escribió:
</pre>
<blockquote type="cite">
<pre class="moz-quote-pre" wrap="">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.
</pre>
</blockquote>
<pre class="moz-quote-pre" wrap="">
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.
</pre>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
</blockquote>
<pre class="moz-signature" cols="72">--
José María Caballero Alba
Technical Dept.
<a class="moz-txt-link-abbreviated" href="http://www.tecsens.com">www.tecsens.com</a>
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 <a class="moz-txt-link-abbreviated" href="mailto:info@tecsens.com">info@tecsens.com</a> antes de su eliminación.</pre>
</body>
</html>