One of the first steps when addressing a MySQL performance tuning
problem is to perform a system audit of the
physical hardware resources, then identify any obvious
bottlenecks in these resources.
When dealing with CPU, a quick audit should include identifying
the number of CPU cores your server has, and the types of these
cores. The key file on Linux systems is /proc/cpuinfo.
Number of cores can be found via the command cat /proc/cpuinfo
| grep “^processor” | wc -l
You need to look more closely at the file to determine the type
of CPU (e.g. below the model name shows Intel(R) Xeon(R) CPU
X3220 @ 2.40GHz. The combination of knowing the number of
processors (cores) listed and physical id and siblings helps
identify how many CPUs and how many cores per CPU exist.
$ cat /proc/cpuinfo
processor : 0
vendor_id : GenuineIntel
cpu family : 6
model …[Read more]