[Spce-user] mysql 100% cpu after upgrade to mr6.5.2

[Rene Krenn]

A hotfix is released:

ngcp-api-tools (6.5.2.2+0~mr6.5.2.2) unstable; urgency=medium

  [ Rene Krenn ]
  * [5903153] TT#48198 TT#48196 use ?no_count=true in fraud scripts

Can you re-check with it in place?

-----Ursprüngliche Nachricht-----
Von: Jon Bonilla (Manwe) [mailto:manwe at sipdoc.net] 
Gesendet: Dienstag, 4. Dezember 2018 13:37
An: Rene Krenn <rkrenn at sipwise.com>
Cc: spce-user at lists.sipwise.com
Betreff: Re: [Spce-user] mysql 100% cpu after upgrade to mr6.5.2

El Tue, 4 Dec 2018 10:26:01 +0100
"Jon Bonilla (Manwe)" <manwe at sipdoc.net> escribió:



Increasing the bufferpool didn't help much:

# Time: 181204 13:30:36
# User at Host: soap[soap] @ localhost []
# Thread_id: 495  Schema: provisioning  QC_hit: No # Query_time: 7234.126810  Lock_time: 0.002703  Rows_sent: 1  Rows_examined:
4587190760 # Rows_affected: 0
SET timestamp=1543926636;
SELECT COUNT( * ) FROM (SELECT bpinfo.id,



--
https://pekepbx.com
https://www.issabel.com/multitenant