High CPu after 5.6 upgrade 5.7 encryption
We recently upgraded our production MySQL servers from 5.6 to 5.7 and enabled encryption running on Windows 2012. The databases accumulate to about 650GB in size.
We run a Master/Master for HA, with a server onprem and a server instance on Azure with 2 way replication.
Since cutting over to the newer version and enabling encryption we are now seeing high CPU that can sit up around 95-99% CPU when large multiple selects are being done. This seems to only occur on our OnPrem Server, however when cut to our Azure instance we dont see the high cpu or performance degradation. If we kill the large selects that come in the cpu goes down and seems ok when other inserts are occuring.
We ran some test and some of the identified queries that seem to spike the cpu and they dont occur in an old 5.6 unencrypted, however they dont occur on our Azure server either.
Im not convinced that the issue is the onprem server as we have increased the vCPU and Memory which hasnt seemed to help.
Our onprem array runs on pure storage SSD and has 114Gb of Ram with 2 sockets/16 virtual processors. There seems to be some overhead with the either the 5.7 upgrade or encryption that when we run from Azure only "masks" the issue.
Some of the team are not fully convinced that optimizing all the slow queries will fix the issue.
Has anyone had a similar situation to this or have experience with sizing performance for large encrypted databases?
Subject
Written By
Posted
High CPu after 5.6 upgrade 5.7 encryption
May 18, 2017 02:43AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.