Re: [Maria-developers] Rev 3915: MDEV-5388 - Reduce usage of LOCK_open: unused_tables

Hi, Sergey! On Dec 12, Sergey Vojtovich wrote: > > yes, it may make sense. What if I do some testing and implement it along > with MDEV-5403 or a separate task? Sounds great! > > > > > > Okay, so you only purge one table at time? Since purge is kind > > > > > > of an expensive operation, it's b

Re: [Maria-developers] Rev 3914: MDEV-4956 - Reduce usage of LOCK_open: TABLE_SHARE::tdc.used_tables

Hi, Sergey! On Dec 10, Sergey Vojtovich wrote: > At lp:maria/10.0 > > > revno: 3914 > revision-id: s...@mariadb.org-20131210150036-0hwh1gy4z3jalwsg > parent: b...@mnogosearch.org-20131203101253-mbz05d9jtkb3iycp > committer: Sergey Vojto

Re: [Maria-developers] 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 tabl

Re: [Maria-developers] Issue with index condition pushdown being used with no end_range set

Hello, Does anyone have insight into this? Thanks -Zardosht On Sat, Dec 7, 2013 at 8:51 AM, Zardosht Kasheff wrote: > Hello all, > > I've noticed a scenario with index condition pushdown (ICP) in MariaDB > that leads to really bad performance in TokuDB. I don't know if it is > a bug in ICP or i

Re: [Maria-developers] Rev 3915: MDEV-5388 - Reduce usage of LOCK_open: unused_tables

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 tabl