Thesql percona 5.7 not releasing memory

memoryMySQLmysql-5.7percona

we are using percona mysql 5.7 version.

MySQL not releasing the memory after operation complete.

we are very much grateful if anyone can guide us to resolve issue.

Thanks

Best Answer

MySQL doesn't "release memory" that is allocated statically, for example innodb_buffer_pool_size. These allocations will consume more memory until they reach the configured limit and then stay there. The only way to "release it" is to reduce the size of those variables. You can reduce innodb_buffer_pool_size at runtime without restarting mysqld on 5.7.