Mysql 5.7.18 memory continues to increase, and take up is not released, has now been exhausted, began to use swap, what reason is this?

CodePudding user response:

Reduce the innodb_buffer_pool size

CodePudding user response:

reference 1st floor rucypli response:

innodb_buffer_pool under reduced size

CodePudding user response:

reference 1st floor rucypli response:

innodb_buffer_pool under reduced size

Innodb_buffer_pool reduce many times, cut out the memory occupied again, slowly innodb_buffer_pool now only 60% of logistics memory

CodePudding user response:

You put all the buffer, such as cache Settings are checked, see if there are any set too large
Open in such as query cache, you have to use? If you have, what's your configuration?

CodePudding user response:

How much innodb_buffer_pool_size set

CodePudding user response:

See 5.7 thread_pool_size is applied for many threads, USES a lot of memory but because the idle thread, as a result of thread explosion parameter is not set,