W
W
WebforSelf2021-11-12 17:40:10
linux
WebforSelf, 2021-11-12 17:40:10

Why mysql server can consume so many resources?

Noticed that the server is loaded Pts long.
logged into the monitoring system and there is a process
/usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid 398.3% 2.9%

Why is this happening? yes, there are 20 sites, but I don’t make any requests with the database.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
A
Alexander Karabanov, 2021-11-13
@WebforSelf

Look show full processlist \G
Turn on slow_log and see which queries should be optimized.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question