Why does MysQL take a lot of resources on the server?

V

Victoria Erofeeva2020-06-15 19:16:29

MySQL

Victoria Erofeeva, 2020-06-15 19:16:29

There is a site on Bitrix, Business edition.
Tell me, what could be the reason that MySQL takes too many resources?
Server overhead:

MySQL consumes 28 gigabytes!

Here are the parameters that Business shows on the "Performance Monitor: DB Server" page Server Statistics

What could be the reason?

Reply

Answer the question

In order to leave comments, you need to log in

3 answer(s)

L

Lazy @BojackHorseman MySQL, 2020-06-15
@webdefvika

there is only 20GB buffer innodb_buffer_pool_size

V

Vitaly Karasik, 2020-06-15
@vitaly_il1

As far as I can see, the server as a whole is not overloaded.
So if there are no performance issues and the system is stable, I see no reason to change MySQL settings.
MySQL needs memory to perform optimally.

A

Anton, 2020-06-15
@anton99zel

It is necessary to calculate the recommended size innodb_buffer_pool_size via Buffer pool hit rate
https://habr.com/ru/company/bitrix/blog/148874/

214 days

Not bad)