I want to share with you a situation I have been watching to see if anyone has had a similar experience and could share the experience with the aim of finding an explanation for the situation.
First I start with say that my database server has the following characteristics:
CPU: Dual Xeon Hex (6) Core 2.53GHz Westmere H/T
Mem: 64GB DDR3
Disc: Intel X25-M MLC 80 GB (4)
OS: CentOS - 64 bit
The point is that I keep daily the server behavior and have frequently observed major peaks occur in the processor usage, sometimes reaching 1500% above where memory is always in 3.5 Gb of consumption.
Could someone tell me the reason for this behavior and if indeed the configuration of MySQL is the most suitable for this server?