[Maria-discuss] OQGRAPH and query cache
![](https://secure.gravatar.com/avatar/33fb5c08359d9d82c9358b7775aab4b9.jpg?s=120&d=mm&r=g)
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? -- Roberto Spadim SPAEmpresarial Eng. Automação e Controle
![](https://secure.gravatar.com/avatar/548f6a7ca82fc307ee146f412b04905c.jpg?s=120&d=mm&r=g)
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]
![](https://secure.gravatar.com/avatar/33fb5c08359d9d82c9358b7775aab4b9.jpg?s=120&d=mm&r=g)
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
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
![](https://secure.gravatar.com/avatar/33fb5c08359d9d82c9358b7775aab4b9.jpg?s=120&d=mm&r=g)
other doubt
https://github.com/MariaDB/server/blob/10.1/storage/oqgraph/ha_oqgraph.cc#L4...
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
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
: 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
![](https://secure.gravatar.com/avatar/6856a1f0f722fbef5eef6f496fc6fab3.jpg?s=120&d=mm&r=g)
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
other doubt
https://github.com/MariaDB/server/blob/10.1/storage/oqgraph/ha_oqgraph.cc#L4... 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
: 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
: 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@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
![](https://secure.gravatar.com/avatar/33fb5c08359d9d82c9358b7775aab4b9.jpg?s=120&d=mm&r=g)
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
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
wrote: other doubt
https://github.com/MariaDB/server/blob/10.1/storage/oqgraph/ha_oqgraph.cc#L4... 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
: 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
: 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@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
-- Roberto Spadim SPAEmpresarial Eng. Automação e Controle
participants (3)
-
Oleksandr Byelkin
-
Peter Laursen
-
Roberto Spadim