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
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.
Sign up to join this communitywe 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
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.
TRUNCATE
operation, it should be a DROP
+CREATE
operation. Backups read the entire database, so yes, they will result in the buffer pool being filled with the data being backed up.
Oct 8, 2020 at 13:00