Not the answer you need?
Register and ask your own question!

percona 5.7 use 100% one cpu core without and queries.

otakuotaku EntrantInactive User Role Beginner
I run latest percona 5.7 from official repo on ubuntu 16.04 . I have same problem on 2 servers.
Mysql dont have any queries in queue, iotop dont show any disk io, service mysql restart dont help.


mysql> show processlist;
+----+
+
+
+
+
+
+
+
+
+
| Id | User | Host | db | Command | Time | State | Info | Rows_sent | Rows_examined |
+----+
+
+
+
+
+
+
+
+
+
| 4 | root | localhost | NULL | Query | 0 | starting | show processlist | 0 | 0 |
+----+
+
+
+
+
+
+
+
+
+
1 row in set (0.00 sec)

Htop
https://habrastorage.org/files/d50/2cd/b3f/d502cdb3f86e4e0588897bd8aefb61d7.png

Top
https://habrastorage.org/files/5de/bf8/e3f/5debf8e3f9304850b4792e786f42f377.png

Iotop
https://habrastorage.org/files/282/937/eb1/282937eb17854522a79c8ae4c648b000.png

strace -p 32183
strace: Process 32183 attached
strace: [ Process PID=32183 runs in x32 mode. ]
strace: [ Process PID=32183 runs in 64 bit mode. ]
futex(0x2f3deec, FUTEX_CMP_REQUEUE_PRIVATE, 1, 2147483647, 0x2f3dec0, 6888) = 1
futex(0x2f3dec0, FUTEX_WAKE_PRIVATE, 1) = 1
futex(0x2f3deec, FUTEX_CMP_REQUEUE_PRIVATE, 1, 2147483647, 0x2f3dec0, 6890) = 1
futex(0x2f3dec0, FUTEX_WAKE_PRIVATE, 1) = 1
futex(0x2f3deec, FUTEX_CMP_REQUEUE_PRIVATE, 1, 2147483647, 0x2f3dec0, 6892) = 1
futex(0x2f3dec0, FUTEX_WAKE_PRIVATE, 1) = 1
futex(0x2f3deec, FUTEX_CMP_REQUEUE_PRIVATE, 1, 2147483647, 0x2f3dec0, 6894) = 1
futex(0x2f3dec0, FUTEX_WAKE_PRIVATE, 1) = 1
futex(0x2f3deec, FUTEX_CMP_REQUEUE_PRIVATE, 1, 2147483647, 0x2f3dec0, 6896) = 1
futex(0x2f3dec0, FUTEX_WAKE_PRIVATE, 1) = 1
futex(0x2f3deec, FUTEX_CMP_REQUEUE_PRIVATE, 1, 2147483647, 0x2f3dec0, 6898) = 1
futex(0x2f3dec0, FUTEX_WAKE_PRIVATE, 1) = 1
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.