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
3
- Percona can't help you?Gerard H. Pille– Gerard H. Pille2020-10-08 12:19:16 +00:00Commented Oct 8, 2020 at 12:19
- @GerardH.Pille ok I should raise the question on percona mysql forum.devops– devops2020-10-08 12:23:10 +00:00Commented Oct 8, 2020 at 12:23
- If it isn't swapping, don't worry.Rick James– Rick James2020-10-17 21:45:58 +00:00Commented Oct 17, 2020 at 21:45
Add a comment |
1 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.
- Thanks for quick reply. we have reduced innodb buffer pool from 13 GB to 8 GB. we have hosted it on 16GB RAM machine. when I am doing any backup operation and truncate operation on db tables I found sudden increase of RAM I have also attached db config if any config require let me know thanks. pastebin.com/PuiLqgSKdevops– devops2020-10-08 12:46:27 +00:00Commented Oct 8, 2020 at 12:46
- Enable innodb_file_per_table if it isn't already on, I don't see it in your config. This should help avoid any anomalies with
TRUNCATEoperation, it should be aDROP+CREATEoperation. Backups read the entire database, so yes, they will result in the buffer pool being filled with the data being backed up.Gordan Bobić– Gordan Bobić2020-10-08 13:00:20 +00:00Commented Oct 8, 2020 at 13:00 -