We have MySQL
(version 8.x) with InnoDB
engine. We were doing weekly MySQL restart (for rotating log files, like slow-query, error log etc) earlier and our RAM usage was in under control. Sometime back we started using mysqladmin flush-logs
without restarting MySQL process.
After this we are seeing the memory usage increases proportional to time.
Does flush-logs remove’s slow-query.log
and host_name.err
log files from RAM or keep them as cached?
We are keeping 4 old log files and only renaming (mv
command) them in flush-log operation. Will moving them to another folder helps?
4