Hi Sergei, yes, it may make sense. What if I do some testing and implement it along with MDEV-5403 or a separate task? Thanks, Sergey On Thu, Dec 12, 2013 at 11:23:57AM +0100, Sergei Golubchik wrote:
Hi, Sergey!
On Dec 12, Sergey Vojtovich wrote:
Okay, so you only purge one table at time? Since purge is kind of an expensive operation, it's better to amortize the cost of it by purging many tables at once. With current algorithm it is impossible to get multiple tables for purge here, explanation above. But you said that in the next patch it becomes possible, or did I misunderstand? Yes, it becomes possible, but I'd say it is headache of the next patch.
I mean something simpler, actually. Like, when a limit is reached, purge 10 (or 20, or 100, or 10%) tables at once.
Regards, Sergei