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

[Jon Bonilla (Manwe)]

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
-------------- 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/e2615111/attachment-0001.sig>