1

My MariaDB server is constantly using at least 30-40% CPU even when idle and no queries are being run.

What could possibly cause such a behavior? What should I check?

MariaDB Version: 10.3.22

Thanks!

Improve this question
4
  • It would help to know exactly what OS you are running, as well as screenshots or logs of indicating the CPU being at 30-40% Commented Feb 27, 2020 at 12:59
  • ...and what is that DB used for ? Commented Feb 27, 2020 at 13:24
  • I’m running a linux VPS. I see in the process manager of cpanel that mysql is using 30-40% constant. Commented Feb 27, 2020 at 14:00
  • Please provide a sample of SHOW FULL PROCESSLIST;. Commented Mar 14, 2020 at 3:15

1 Answer 1

Reset to default
0

I suspect you will find something is in fact happening on the server. Enable general log and look what ends up in it.

One possible cause of this is a buggy database connection library on an application that keeps issuing

BEGIN;

or similar all over the place a few hundred times per second without doing anything else.

Improve this answer

You must log in to answer this question.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.