[Spce-user] mysql 100% cpu after upgrade to mr6.5.2
Jon Bonilla (Manwe)
manwe at sipdoc.net
Mon Dec 3 15:56:50 EST 2018
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?
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Size: 833 bytes
Desc: Firma digital OpenPGP
More information about the Spce-user