1 Topic by misceh

  • misceh
  • Member
  • Offline
  • Registered: 2015-02-03
  • Posts: 22

Topic: High CPU usage by mySQL

==== REQUIRED BASIC INFO OF YOUR IREDMAIL SERVER ====
- iRedMail version (check /etc/iredmail-release): 1.3
- Deployed with iRedMail Easy or the downloadable installer? downloadable installer
- Linux/BSD distribution name and version: CentOS 7.9
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): LDAP
- Web server (Apache or Nginx): Nginex
- Manage mail accounts with iRedAdmin-Pro? yes
- [IMPORTANT] Related original log or error message is required if you're experiencing an issue.
====

In NetData, mySQL always use 100% of CPU (= 1 core of CPU, see attachment). When use top command,  mysqld always use 100% of CPU. RAM usage is low for mySQL and is normal.

In NetDate, it also noticed InnoDB Buffer Pool Requests have very high reads value (see attachment). Not sure if this is related.

The email server is working fine. Any way to troubleshoot this high CPU usage issue?

Thanks!

Post's attachments

mySQL_high_CPU_NetData_20210301.jpg 98.11 kb, file has never been downloaded. 

mySQL_innoDB_NetData_20210301.jpg 118.38 kb, file has never been downloaded. 

You don't have the permssions to download the attachments of this post.

----

Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.

2 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 30,770

Re: High CPU usage by mySQL

Besides mysql, any other program / process causes high CPU usage? even just shortly / temporarily.

3 Reply by misceh

  • misceh
  • Member
  • Offline
  • Registered: 2015-02-03
  • Posts: 22

Re: High CPU usage by mySQL

The process "apps.plugin" is 2nd highest, alway keep 0 - 8% usage of CPU in TOP.

Other that that, is sogo, python, etc. occasionally usage only.

4 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 30,770

Re: High CPU usage by mySQL

What's the hardware spec of CPU and RAM?