If a handler of certain table exists, we don't remove the dictionary entry
even if the hendler is not used.
So, we shouhld use "FLUSH TABLES" to close such handler
or use "small table_cache" to close such handler automatocally.
Vadim Tkachenko wrote:
> Yasufumi,
>
>
> So you cleaning dictionary cache only by FLUSH TABLE ?
>
> I think it will not work, we should make it automatically.
>
> FLUSH TABLE is very expensive and performance hurt command
Vadim,
If a handler of certain table exists, we don't remove the dictionary entry
even if the hendler is not used.
So, we shouhld use "FLUSH TABLES" to close such handler
or use "small table_cache" to close such handler automatocally.
Vadim Tkachenko wrote:
> Yasufumi,
>
>
> So you cleaning dictionary cache only by FLUSH TABLE ?
>
> I think it will not work, we should make it automatically.
>
> FLUSH TABLE is very expensive and performance hurt command