Hello guys. My name is Tiberio, i’m from Brazil. (Sorry about English mistakes)
I’m trying to solve a performance problem a few weeks and I’ve read many posts and did a lot of research. Already I went over all my application and it seems to be a problem related to operating system tuning.
The Percona runs very well, but at certain points of the day there is an increase in the amount of CPU usage for system processes (CPU Usage Image). After a restart MySQL everything returns to normal for a few hours (for the rest of the day sometimes).
Analyzing the status of INNODB “show engine innodb status” realized that many processes are waiting for Semaphores in “OS WAIT ARRAY INFO” (status image)
Can someone help me? My database is well structured and my application is not causing this performance problems.
Our solution uses (VMWARE virtualized guest O.S.):
CPU: 12 x Intel® Xeon® CPU E5-2687W 0 @ 3.10GHz (socket:1 core:12)
OS: CentOS release 6.6 (Final)
SSD disks (disk cache and controller cache)
We have already applied all the innodb tunning best practices:
We have already applied leap second fix.