High CPU usage due to MYSQL process

Operating System & Version
CentOS7
cPanel & WHM Version
v86.0.21

sufiyanshaikh

Registered
May 27, 2020
1
0
1
India
cPanel Access Level
Website Owner
Hello,

I have a cPanel server with WordPress website (only 1 user account and only 1 website)
There 100% CPU usage because of MYSQL.
I did a trace of the process and found the below texts.
Please help me to solve this
Seems there is some error and that too its on "loop"

poll([{fd=29, events=POLLIN}, {fd=30, events=POLLIN}], 2, -1) = -1 ENOSYS (Function not implemented)
accept(30, 0x7fff22b71570, [2]) = -1 ENOSYS (Function not implemented)
futex(0x20d8b64, FUTEX_WAKE_OP_PRIVATE, 1, 1, 0x20d8b60, FUTEX_OP_SET<<28|0<<12|FUTEX_OP_CMP_GT<<24|0x1) = -1 ENOSYS (Function not implemented)
futex(0x20d8ba0, FUTEX_WAKE_PRIVATE, 1) = -1 ENOSYS (Function not implemented)
poll([{fd=29, events=POLLIN}, {fd=30, events=POLLIN}], 2, -1) = -1 ENOSYS (Function not implemented)
accept(30, 0x7fff22b71570, [2]) = -1 ENOSYS (Function not implemented)
futex(0x20d8b64, FUTEX_WAKE_OP_PRIVATE, 1, 1, 0x20d8b60, FUTEX_OP_SET<<28|0<<12|FUTEX_OP_CMP_GT<<24|0x1) = -1 ENOSYS (Function not implemented)
futex(0x20d8ba0, FUTEX_WAKE_PRIVATE, 1) = -1 ENOSYS (Function not implemented)
poll([{fd=29, events=POLLIN}, {fd=30, events=POLLIN}], 2, -1) = -1 ENOSYS (Function not implemented)
accept(30, 0x7fff22b71570, [2]) = -1 ENOSYS (Function not implemented)
futex(0x20d8b64, FUTEX_WAKE_OP_PRIVATE, 1, 1, 0x20d8b60, FUTEX_OP_SET<<28|0<<12|FUTEX_OP_CMP_GT<<24|0x1) = -1 ENOSYS (Function not implemented)
futex(0x20d8ba0, FUTEX_WAKE_PRIVATE, 1) = -1 ENOSYS (Function not implemented)
poll([{fd=29, events=POLLIN}, {fd=30, events=POLLIN}], 2, -1) = -1 ENOSYS (Function not implemented)
accept(30, 0x7fff22b71570, [2]) = -1 ENOSYS (Function not implemented)
futex(0x20d8b64, FUTEX_WAKE_OP_PRIVATE, 1, 1, 0x20d8b60, FUTEX_OP_SET<<28|0<<12|FUTEX_OP_CMP_GT<<24|0x1) = -1 ENOSYS (Function not implemented)
futex(0x20d8ba0, FUTEX_WAKE_PRIVATE, 1) = -1 ENOSYS (Function not implemented)
poll([{fd=29, events=POLLIN}, {fd=30, events=POLLIN}], 2, -1) = -1 ENOSYS (Function not implemented)
accept(30, 0x7fff22b71570, [2]) = -1 ENOSYS (Function not implemented)
futex(0x20d8b64, FUTEX_WAKE_OP_PRIVATE, 1, 1, 0x20d8b60, FUTEX_OP_SET<<28|0<<12|FUTEX_OP_CMP_GT<<24|0x1) = -1 ENOSYS (Function not implemented)
futex(0x20d8ba0, FUTEX_WAKE_PRIVATE, 1) = -1 ENOSYS (Function not implemented)
poll([{fd=29, events=POLLIN}, {fd=30, events=POLLIN}], 2, -1) = -1 ENOSYS (Function not implemented)
accept(30, 0x7fff22b71570, [2]) = -1 ENOSYS (Function not implemented)
futex(0x20d8b64, FUTEX_WAKE_OP_PRIVATE, 1, 1, 0x20d8b60, FUTEX_OP_SET<<28|0<<12|FUTEX_OP_CMP_GT<<24|0x1) = -1 ENOSYS (Function not implemented)
futex(0x20d8ba0, FUTEX_WAKE_PRIVATE, 1) = -1 ENOSYS (Function not implemented)
poll([{fd=29, events=POLLIN}, {fd=30, events=POLLIN}], 2, -1) = -1 ENOSYS (Function not implemented)
accept(30, 0x7fff22b71570, [2]) = -1 ENOSYS (Function not implemented)
futex(0x20d8b64, FUTEX_WAKE_OP_PRIVATE, 1, 1, 0x20d8b60, FUTEX_OP_SET<<28|0<<12|FUTEX_OP_CMP_GT<<24|0x1) = -1 ENOSYS (Function not implemented)
poll([{fd=29, events=POLLIN}, {fd=30, events=POLLIN}], 2, -1) = -1 ENOSYS (Function not implemented)
accept(30, 0x7fff22b71570, [2]) = -1 ENOSYS (Function not implemented)
futex(0x20d8b64, FUTEX_WAKE_OP_PRIVATE, 1, 1, 0x20d8b60, FUTEX_OP_SET<<28|0<<12|FUTEX_OP_CMP_GT<<24|0x1) = -1 ENOSYS (Function not implemented)
futex(0x20d8ba0, FUTEX_WAKE_PRIVATE, 1) = -1 ENOSYS (Function not implemented)
poll([{fd=29, events=POLLIN}, {fd=30, events=POLLIN}], 2, -1) = -1 ENOSYS (Function not implemented)
accept(30, 0x7fff22b71570, [2]) = -1 ENOSYS (Function not implemented)
futex(0x20d8b64, FUTEX_WAKE_OP_PRIVATE, 1, 1, 0x20d8b60, FUTEX_OP_SET<<28|0<<12|FUTEX_OP_CMP_GT<<24|0x1) = -1 ENOSYS (Function not implemented)
futex(0x20d8ba0, FUTEX_WAKE_PRIVATE, 1) = -1 ENOSYS (Function not implemented)
poll([{fd=29, events=POLLIN}, {fd=30, events=POLLIN}], 2, -1) = -1 ENOSYS (Function not implemented)
accept(30, 0x7fff22b71570, [2]) = -1 ENOSYS (Function not implemented)
futex(0x20d8b64, FUTEX_WAKE_OP_PRIVATE, 1, 1, 0x20d8b60, FUTEX_OP_SET<<28|0<<12|FUTEX_OP_CMP_GT<<24|0x1) = -1 ENOSYS (Function not implemented)
futex(0x20d8ba0, FUTEX_WAKE_PRIVATE, 1) = -1 ENOSYS (Function not implemented)
poll([{fd=29, events=POLLIN}, {fd=30, events=POLLIN}], 2, -1) = -1 ENOSYS (Function not implemented)
accept(30, 0x7fff22b71570, [2]) = -1 ENOSYS (Function not implemented)
futex(0x20d8b64, FUTEX_WAKE_OP_PRIVATE, 1, 1, 0x20d8b60, FUTEX_OP_SET<<28|0<<12|FUTEX_OP_CMP_GT<<24|0x1) = -1 ENOSYS (Function not implemented)
poll([{fd=29, events=POLLIN}, {fd=30, events=POLLIN}], 2, -1) = -1 ENOSYS (Function not implemented)
accept(30, 0x7fff22b71570, [2]) = -1 ENOSYS (Function not implemented)
futex(0x20d8b64, FUTEX_WAKE_OP_PRIVATE, 1, 1, 0x20d8b60, FUTEX_OP_SET<<28|0<<12|FUTEX_OP_CMP_GT<<24|0x1) = -1 ENOSYS (Function not implemented)
futex(0x20d8ba0, FUTEX_WAKE_PRIVATE, 1) = -1 ENOSYS (Function not implemented)
poll([{fd=29, events=POLLIN}, {fd=30, events=POLLIN}], 2, -1) = -1 ENOSYS (Function not implemented)
accept(30, 0x7fff22b71570, [2]) = -1 ENOSYS (Function not implemented)
futex(0x20d8b64, FUTEX_WAKE_OP_PRIVATE, 1, 1, 0x20d8b60, FUTEX_OP_SET<<28|0<<12|FUTEX_OP_CMP_GT<<24|0x1) = -1 ENOSYS (Function not implemented)
futex(0x20d8ba0, FUTEX_WAKE_PRIVATE, 1) = -1 ENOSYS (Function not implemented)
 

cPanelLauren

Product Owner
Staff member
Nov 14, 2017
13,296
1,261
313
Houston
This really isn't helpful for the issue you're having. You're just running an strace on the MySQL process. What you really need to do is identify what activities are causing so much resource usage. You might start with enabling the slow queries log as well as check the error log. MySQL :: MySQL 5.7 Reference Manual :: 5.4.5 The Slow Query Log