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

[Jon Bonilla (Manwe)]

El Tue, 4 Dec 2018 17:36:25 +0100
"Rene Krenn" <rkrenn at sipwise.com> escribió:

> 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?
> 
>


Hi Rene

I did. It didn't have impact:


# Time: 181204 17:00:35
# User at Host: soap[soap] @ localhost []
# Thread_id: 453  Schema: provisioning  QC_hit: No
# Query_time: 7232.378563  Lock_time: 0.002239  Rows_sent: 1  Rows_examined:
4587190760 # Rows_affected: 0
SET timestamp=1543939235;
SELECT COUNT( * ) FROM (SELECT bpinfo.id, bpinfo.reseller_id, bpinfo.interval,
bpinfo.type, IF (bpinfo.fraud_use_reseller_rates > 0,
SUM(cdr.source_reseller_cost), SUM(cdr.source_customer_cost))


ii  ngcp-api-tools       6.5.2.2+0~mr6.5.2.2


-- 
https://pekepbx.com
https://www.issabel.com/multitenant
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 833 bytes
Desc: Firma digital OpenPGP
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20181204/e84d6b60/attachment-0001.sig>