| Bug #108798 | Mysql server 8.0.17 : CPU utilization is high (500%) | ||
|---|---|---|---|
| Submitted: | 17 Oct 2022 10:21 | Modified: | 17 Oct 2022 13:24 |
| Reporter: | Amritha Prabhu | Email Updates: | |
| Status: | Not a Bug | Impact on me: | |
| Category: | MySQL Server | Severity: | S2 (Serious) |
| Version: | 8.0.17 | OS: | Red Hat (8.3) |
| Assigned to: | CPU Architecture: | Other (x86_64) | |
[17 Oct 2022 10:23]
Amritha Prabhu
Mysql process list and InnoDB status
Attachment: mysqlcheck.txt (text/plain), 56.14 KiB.
[17 Oct 2022 13:24]
MySQL Verification Team
Hi Mr. Prabhu, Thank you for your bug report. However, it is not a bug. First of all, you are using an outdated release, that is no longer supported. Second, what you are reporting are expected results if your computer has 4 (four) or more cores. The fact that there are no slow queries with that utilisation of the CPU cores is a proof that our server performs brilliantly on your setup. Not a bug.
Description: Mysql server running is consuming high CPU compare to the load on mysql. No slow quirey are found during runtime. top - 12:30:36 up 47 days, 20:58, 1 user, load average: 8.44, 7.52, 9.46 Tasks: 252 total, 2 running, 250 sleeping, 0 stopped, 0 zombie %Cpu(s): 77.4 us, 5.3 sy, 0.0 ni, 11.6 id, 4.4 wa, 0.6 hi, 0.6 si, 0.0 st MiB Mem : 16023.3 total, 157.2 free, 11779.7 used, 4086.4 buff/cache MiB Swap: 32768.0 total, 27870.0 free, 4898.0 used. 3912.7 avail Mem PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND 1684373 mysql 20 0 10.3g 4.1g 15216 S 467.5 26.1 80744:37 mysqld 1685200 root 20 0 14.9g 3.6g 4532 S 112.5 23.1 6945:10 java 1684870 root 20 0 13.8g 972708 7372 S 85.0 5.9 11651:57 java 3418988 ems 20 0 65676 5268 4208 R 2.5 0.0 0:01.93 top 1 root 20 0 245224 5236 3180 S 0.0 0.0 11:53.96 systemd 2 root 20 0 0 0 0 S 0.0 0.0 0:05.35 kthreadd 3 root 0 -20 0 0 0 I 0.0 0.0 0:00.00 rcu_gp How to repeat: Specific to few servers