mysqld is causing for the high CPU load

[keerthiprashanths]

Hello Team,

mysqld is causing for the high CPU load However, mysqld is the process which is utilizing more CPU and in order to lower the CPU usage we need to do the following process:
Please refer the below for your referene:
top - 11:21:52 up 18:51,  2 users,  load average: 74.10, 68.06, 70.94
Tasks: 713 total,   6 running, 707 sleeping,   0 stopped,   0 zombie
Cpu(s): 19.0%us,  2.8%sy,  0.0%ni, 78.1%id,  0.0%wa,  0.0%hi,  0.0%si,  0.0%st
Mem:  32876000k total, 17544612k used, 15331388k free,   649416k buffers
Swap:  4194296k total,        0k used,  4194296k free, 10081008k cached

  PID USER      PR  NI  VIRT  RES  SHR S %CPU %MEM    TIME+  COMMAND
30322 mysql     20   0 8397m 329m 4344 S 129.0  1.0   2870:49 mysqld
22096 apache    20   0  686m  72m 8936 R 44.0  0.2   5:00.20 httpd
2469 apache    20   0  683m  69m 8904 S 37.7  0.2   0:34.06 httpd
32209 apache    20   0  671m  58m 9408 R 34.1  0.2   1:02.81 httpd
please suggest some relevant info to upgrade the tool performance and how to do the sql offloading

[scottwilkerson]

Here is a document on Maximizing Performance in Nagios XI
https://assets.nagios.com/downloads/nag ... ios-XI.pdf

And on page 9 of the Doc there is a link to another doc titled Offloading MySQL To A Remote Server
https://assets.nagios.com/downloads/nag ... Server.pdf

[keerthiprashanths]

Thanks for your quick reply.

Will check and get back to you on the same.

[scottwilkerson]

Thanks for your quick reply.

Will check and get back to you on the same.

thanks. Let us know if you need additional assistance