Thanks, it seems that innodb_lazy_drop_table has solved the issue. I've enabled it 10 hours ago, no problems so far.
The application constantly creates temporary memory tables and that seems was the issue, as mysql has to drop the tables.
I'll let it run for more time and let you know then.
Laurynas,
Thanks, it seems that innodb_ lazy_drop_ table has solved the issue. I've enabled it 10 hours ago, no problems so far.
The application constantly creates temporary memory tables and that seems was the issue, as mysql has to drop the tables.
I'll let it run for more time and let you know then.