High CPU usage due to MYSQL process

[sufiyanshaikh]

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]

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