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

[Jon Bonilla (Manwe)]

El Fri, 30 Nov 2018 19:50:07 +0100
"Jon Bonilla (Manwe)" <manwe at sipdoc.net> escribió:


> 
> 
> I think the query is the daily fraud calc. I hacve several of them stuck in
> the server. 
> 
> The lab server is an exact copy of the production server but upgraded to
> version mr6.5.2: 8 cores, 20GB RAM and SSD disks. The CDR has about 8M rows.
> I have 2.8 and 3.8 servers with much more rows and never had an issue before. 
> 
> The complete query is:
> 
> 
> Top shows 766% CPU usage by mysqld, 0%wa 
> 


Any hints on this?


-- 
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/mailman/private/spce-user_lists.sipwise.com/attachments/20181203/58a45597/attachment.sig>