How to optimize mysql server ? We have been constantly hit with high mysql cpu usage on the server. Take a look at the following stats.
Sometimes the load on the server goes above 100 which suggests something is surely wrong with mysql. Any suggestion ?
top - 18:56:38 up 1:43, 2 users, load average: 62.97, 45.77, 39.71
Tasks: 642 total, 8 running, 633 sleeping, 0 stopped, 1 zombie
%Cpu(s): 47.5 us, 25.5 sy, 0.0 ni, 5.9 id, 21.0 wa, 0.0 hi, 0.1 si, 0.0 st
KiB Mem : 32765428 total, 226884 free, 27133108 used, 5405436 buff/cache
KiB Swap: 8388604 total, 425508 free, 7963096 used. 5009972 avail Mem
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
1957 mysql 20 0 27.517g 0.017t 5696 S 1490 54.6 1261:38 /usr/sbin/mysqld
Tasks: 642 total, 8 running, 633 sleeping, 0 stopped, 1 zombie
%Cpu(s): 47.5 us, 25.5 sy, 0.0 ni, 5.9 id, 21.0 wa, 0.0 hi, 0.1 si, 0.0 st
KiB Mem : 32765428 total, 226884 free, 27133108 used, 5405436 buff/cache
KiB Swap: 8388604 total, 425508 free, 7963096 used. 5009972 avail Mem
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
1957 mysql 20 0 27.517g 0.017t 5696 S 1490 54.6 1261:38 /usr/sbin/mysqld
Comment