What happens if the process terminates?

R

Ruslan Sadikhov2015-01-21 22:46:59

linux

Ruslan Sadikhov, 2015-01-21 22:46:59

I display the processes with the "htop" command:

It is at least strange that mysql is not 1 process here and it uses the most memory.
2 questions:
1. Why, when the server is rebooted, when all processes should be reset, they are not reset? MySQL always shows its 21 GB in "htop"
2. What happens if I end mysql processes?

Reply

Answer the question

In order to leave comments, you need to log in

3 answer(s)

V

Vladislav 21rpk, 2015-01-21
@fsdsdfsfdsfsdfsdfsdfsdfsd

1. Your mysql server is probably configured incorrectly. Try adjusting the query_cache_size, key_buffer_size and innodb_buffer_pool_size options.
2. If you kill the processes, there is a high probability that the tables will be damaged and you will have to restore them. Not everything can recover.

V

Vlad Zhivotnev, 2015-01-22
@inkvizitor68sl

VIRT is unused memory.
"Shows the total amount of memory that the program can address at a given time."
Moreover, this is swap + shared libs + directly ram.
It is not worth killing the process - the base will be beaten.
And you have only 4671 MB actually occupied by ram processes in the screenshot.

V

Valentine, 2015-01-22
@ProFfeSsoRr

Well, several processes, because by default htop does not have the option to hide threads, to enable it, press F2 - Display options - Hide user threads and you will see only one mysql line.
Well, 21GB seems to be filled with cache settings in /etc/mysql/my.cnf, but since there is less RAM physically on the server, you need to turn these options down. Read about optimizing mysql for RAM, there are few options and everything is on the internet, and even in Russian.