maria-discuss team mailing list archive

[Roberto Spadim <roberto@xxxxxxxxxxxxx>]

well found this bug at mariadb jira
https://mariadb.atlassian.net/browse/MDEV-5744

that's why query cache should be disabled, but check that it's a problem of
oqgraph engine, that's a BUG!

2014-09-23 15:41 GMT-03:00 Peter Laursen <peter_laursen@xxxxxxxxxx>:

> INSERT DELAYED is on its way _out _in_the_dark anyway.  I blogged this
> http://blog.webyog.com/2012/08/01/insert-delayed-is-gone/ 2 years ago. I
> am not able to really to recall full details from my brain-dead mind, but I
> think all references to INSERT DELAYED are now uninteresting.
>
>
> -- Peter
> -- Webyog
>
> On Tue, Sep 23, 2014 at 7:51 PM, Roberto Spadim <roberto@xxxxxxxxxxxxx>
> wrote:
>
>> other doubt
>>
>> https://github.com/MariaDB/server/blob/10.1/storage/oqgraph/ha_oqgraph.cc#L462
>> when using aria as backstorage, aria engine don't support insert delayed,
>> this will make some problems not?
>>
>>
>> about query cache i didn't found a register_query_cache_table function
>> like aria/innodb/myisam engines, maybe we should change documentation to
>> 'query cache isn't supported with oqgraph' instead of 'needs to be disabled'
>>
>> 2014-09-23 14:13 GMT-03:00 Roberto Spadim <roberto@xxxxxxxxxxxxx>:
>>
>>> i'm thinking about how it work with backend data store
>>> for example...
>>> select somefiled from oq_graph where something..
>>> oq_graph will send some queries to data table (i don't know if it use
>>> sql or internal handler)
>>> data table will return
>>> oq_graph will process and send back data to client, here it can/can't
>>> query cache
>>>
>>>
>>> if data table change, oq_graph don't know and old query cache will
>>> become inconsistent, the point is, why not it need to be disabled? should
>>> be nice a explain about it, i don't know too how it works :/
>>> any other idea?
>>>
>>>
>>> 2014-09-23 12:25 GMT-03:00 Oleksandr Byelkin <sanja@xxxxxxxxxxxxxxxx>:
>>>
>>> Hi!
>>>>
>>>> On 23.09.14 17:25, Roberto Spadim wrote:
>>>>
>>>>> Hi guys, i was reading docs, and found this:
>>>>>
>>>>>   * The query cache needs to be disabled in order to use OQGRAPH
>>>>>     <https://mariadb.com/kb/en/oqgraph/> and, in older versions,
>>>>>     Galera <https://mariadb.com/kb/en/galera/>.
>>>>>
>>>>> Why query cache needs to be disabled with OQGRAPH?
>>>>>
>>>> My guess is that because it can't cooperate with QC and behaviour to
>>>> not match our 2 defaukt patterns (like myisam or transactional). If it fit
>>>> in  one of the patterns it could be switched on.
>>>>
>>>> [skip]
>>>>
>>>
>>>
>>>
>>> --
>>> Roberto Spadim
>>> SPAEmpresarial
>>> Eng. Automação e Controle
>>>
>>
>>
>>
>> --
>> Roberto Spadim
>> SPAEmpresarial
>> Eng. Automação e Controle
>>
>> _______________________________________________
>> Mailing list: https://launchpad.net/~maria-discuss
>> Post to     : maria-discuss@xxxxxxxxxxxxxxxxxxx
>> Unsubscribe : https://launchpad.net/~maria-discuss
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>


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