So, this is mostly related to a table cache content. It may also be related to temporary tables in memory, with these settings:
tmp_table_size=100M max_heap_table_size=100M
Next time, please, try to capture the output of
show engine innodb status\G
just before and immediately after FLUSH TABLES. I want to check if we get any changes in InnoDB memory allocation.
So, this is mostly related to a table cache content. It may also be related to temporary tables in memory, with these settings:
tmp_table_size=100M table_size= 100M
max_heap_
Next time, please, try to capture the output of
show engine innodb status\G
just before and immediately after FLUSH TABLES. I want to check if we get any changes in InnoDB memory allocation.