How to put MySQL in process priority?

U

uuuu2020-10-19 21:27:26

MySQL

uuuu, 2020-10-19 21:27:26

Hey!

The main function on the Debian server is the MySQL server. Is it possible to put MySQL in the highest process priority so that it uses the maximum amount of CPU and memory resources?

Reply

Answer the question

In order to leave comments, you need to log in

3 answer(s)

I

Ilya Evseev, 2020-10-20
@IlyaEvseev

Better not.
If MySQL starts to crowd out auxiliary services (resolved, dhclient, ssh, etc.), it will not seem enough.
First, figure out if there are enough resources.
If not enough, why not?

P

paran0id, 2020-10-19
@paran0id

https://www.freedesktop.org/software/systemd/man/s...
Nice, IOSchedulingClass, IOSchedulingPriority

V

Vitaly Karasik, 2020-10-20
@vitaly_il1

maximum amount of processor and memory resources

It will use the CPU anyway, if nothing else is running
. Memory - settings in my.cnf, this is very important.