maria-discuss team mailing list archive
-
maria-discuss team
-
Mailing list archive
-
Message #01843
Re: Spider and query cache
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
Follow ups
References
-
Spider and query cache
From: Roberto Spadim, 2014-05-29
-
Re: Spider and query cache
From: Colin Charles, 2014-05-30
-
Re: Spider and query cache
From: Roberto Spadim, 2014-05-30
-
Re: Spider and query cache
From: kentoku, 2014-06-03
-
Re: Spider and query cache
From: Roberto Spadim, 2014-06-03
-
Re: Spider and query cache
From: kentoku, 2014-06-18
-
Re: Spider and query cache
From: Roberto Spadim, 2014-06-18
-
Re: Spider and query cache
From: Roberto Spadim, 2014-06-26
-
Re: Spider and query cache
From: Roberto Spadim, 2014-09-21
-
Re: Spider and query cache
From: Oleksandr Byelkin, 2014-09-21