← Back to team overview

maria-discuss team mailing list archive

Re: Spider and query cache

 

hi kentoku! i will try with mysql server
but i got one question, why mariadb don't support VP? is something
different that block using VP ?

2014-09-23 14:44 GMT-03:00 kentoku <kentokushiba@xxxxxxxxx>:

> Hi Roberto,
>
> Thank you for testing VP.
> I'll think about this feature.
>
> Thanks,
> Kentoku
>
>
> 2014-09-21 18:10 GMT+09:00 Roberto Spadim <roberto@xxxxxxxxxxxxx>:
> > Hi! Well i'm checking vp isn't part of mariadb today :/ maybe we should
> port
> > it first and after jmplement new features, right?
> >
> > Em domingo, 21 de setembro de 2014, Oleksandr Byelkin
> > <sanja@xxxxxxxxxxxxxxxx> escreveu:
> >
> >> Hi!
> >>
> >> On 21.09.14 05:06, Roberto Spadim wrote:
> >> [skip]
> >>>
> >>>
> >>> sounds crazy? :)
> >>> ok i know that query cache have some problems with mutex, but it's
> >>> another history we could have a better hit rate with this feature (at
> least
> >>> when correctly used)
> >>> check that query cache become inconsistent if we change data1 or data2
> >>> outside vp table
> >>>
> >>>
> >>
> >> It is doable if put a lot of hooks of asking engine about tables.
> >>
> >> There is already hooks now used in table invalidation. But it works
> slowly
> >> (relatively) because having no open table difficult to give engine full
> >> information and so each such hook will cause semi-open process and so
> if we
> >> have miss it looks like double opening overhead.
> >>
> >> So, in price of total overhead we can make it, the question is if it
> help
> >> so much that gain will be more then overhead in average... As usual I
> have
> >> doubts about it (need a proof).
> >>
> >> [skip]
> >
> >
> >
> > --
> > Roberto Spadim
> > SPAEmpresarial
> > Eng. Automação e Controle
> >
>



-- 
Roberto Spadim
SPAEmpresarial
Eng. Automação e Controle

Follow ups

References