Re: [Maria-discuss] OQGRAPH and query cache

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 blog

Re: [Maria-discuss] Spider and query cache

hum, i'm reading source... some changes to handler and something at sql_class related to xid_? plugins, fields soon i will compile and test ___ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe

Re: [Maria-discuss] Spider and query cache

ok =] some minutes to download and after start compile and tests if i not answer soon i got some other job, but i will get back =] 2014-09-23 15:34 GMT-03:00 kentoku : > >> hi kentoku! i will try with mysql server > >> but i got one question, why mariadb don't support VP? is something > >> differ

Re: [Maria-discuss] OQGRAPH and query cache

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 -- Web

Re: [Maria-discuss] 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 ? It is need some changes for MariaDB. > now i saw 10.0.9 at 'last' name, i will try it :) Please use this for now. source code http://spiderformysql

Re: [Maria-discuss] Spider and query cache

https://launchpad.net/vpformysql/trunk/1.1-for-5.5.34-10.0.9/+download/vp-src-1.1-for-5.5.34-10.0.9.tgz now i saw 10.0.9 at 'last' name, i will try it :) news i post here 2014-09-23 14:54 GMT-03:00 Roberto Spadim : > hi kentoku! i will try with mysql server > but i got one question, why mariadb

Re: [Maria-discuss] 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 : > Hi Roberto, > > Thank you for testing VP. > I'll think about this feature. > > Thanks, > Kentoku > > > 2014-09-21 18:1

Re: [Maria-discuss] OQGRAPH and query cache

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 eng

Re: [Maria-discuss] Spider and query cache

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 : > 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 2

Re: [Maria-discuss] OQGRAPH and query cache

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 ca

Re: [Maria-discuss] OQGRAPH and query cache

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 and, in older versions, Galera . Why query cache needs to b

[Maria-discuss] OQGRAPH and query cache

Hi guys, i was reading docs, and found this: - The query cache needs to be disabled in order to use OQGRAPH and, in older versions, Galera . Why query cache needs to be disabled with OQGRAPH? -- Roberto Spadim SP

Re: [Maria-discuss] R: transactions and UNLOCK TABLES

nice, i will include the information about lock innodb tables to your bug request just to help a better explain at mysql docs 2014-09-23 8:50 GMT-03:00 Federico Razzoli : > Thank you for your clarification, Elena. Based on this information, I find > the MySQL manual confusing, so I have reported

Re: [Maria-discuss] R: transactions and UNLOCK TABLES

+1 =) mysql manual sometimes don't help, that's why i really prefer mariadb kb i think that many years ago mysql implement this nontransactional like locks to innodb just to allow guys porting from myisam to innodb using old apps without rewriting the lock/unlock to begin/commit if you are using

Re: [Maria-discuss] R: transactions and UNLOCK TABLES

Thank you for your clarification, Elena. Based on this information, I find the MySQL manual confusing, so I have reported a bug: http://bugs.mysql.com/bug.php?id=74033 Unless it turns out that I'm still missing something, I will also check the kb. Regards Federico

Re: [Maria-discuss] R: transactions and UNLOCK TABLES

Hi Federico, On 23.09.2014 12:50, Federico Razzoli wrote: Let's make the snippet simpler. Only one table, non-transactional, please look at the difference from what docs say and the real behaviour. If one could explain what UNLOCK TABLES exactly does, it would be great. MariaDB [test]> SELECT

[Maria-discuss] R: transactions and UNLOCK TABLES

Let's make the snippet simpler. Only one table, non-transactional, please look at the difference from what docs say and the real behaviour. If one could explain what UNLOCK TABLES exactly does, it would be great. MariaDB [test]> SELECT @@in_transaction, @@autocommit; +--+

Re: [Maria-discuss] transactions and UNLOCK TABLES

I would never use LOCK TABLES on InnoDB, look again my first test case and you'll see that it's different from what documentation says :) Federico Mar 23/9/14, Roberto Spadim ha scritto: Oggetto: Re: [Maria-discuss] transactions and UNLOCK TABLES