maria-developers team mailing list archive
-
maria-developers team
-
Mailing list archive
-
Message #06629
Re: Rev 3915: MDEV-5388 - Reduce usage of LOCK_open: unused_tables
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
>
Follow ups
References