[Maria-developers] understanding commit and prepare APIs in MariaDB 5.5

2013-02-20 Thread Zardosht Kasheff
Hello all, I am investigating what our storage engine, TokuDB, needs to do to achieve its best performance in MariaDB 5.5 with respect to preparing and committing transactions, and with respect to binary logging. As I understand, group commit has been added to the binary log in Maria 5.3, and is

Re: [Maria-developers] Rev 3663: MDEV-3819 missing constraints for spatial column types

2013-02-20 Thread Alexey Botchkov
+ERROR HY000: Incorrect POLYGON value: 'POINT' I'm sorry, but you got it backwards :) The value above is POLYGON. The type is POINT. The error message should be ERROR HY000: Incorrect POINT value: 'POLYGON' Regards, Sergei How do you know the difference i wonder :) But fine, fixing th

Re: [Maria-developers] Rev 3663: MDEV-3819 missing constraints for spatial column types

2013-02-20 Thread Sergei Golubchik
Hi, Holyfoot! On Feb 20, holyf...@askmonty.org wrote: > revno: 3663 > revision-id: holyf...@askmonty.org-20130220195237-99gp9p29xemltqcm > parent: vvaintroub@pcbsd-20130219224652-t84v8wepdqvhxfwb > committer: Alexey Botchkov > branch nick: mdev-3819 > timestamp: Wed 2013-02-20 23:52:37 +0400 > me

Re: [Maria-developers] Rev 3663: MDEV-3819 missing constraints for spatial column types

2013-02-20 Thread Sergei Golubchik
Hi, Holyfoot! On Feb 20, holyf...@askmonty.org wrote: > revno: 3663 > revision-id: holyf...@askmonty.org-20130220172419-j5sad8p7t3191kii > parent: vvaintroub@pcbsd-20130219224652-t84v8wepdqvhxfwb > committer: Alexey Botchkov > branch nick: mdev-3819 > timestamp: Wed 2013-02-20 21:24:19 +0400 > me

Re: [Maria-developers] Determining to which project a patch should be sent.

2013-02-20 Thread Christian Convey
Hi Sergei, Thanks, I'll do that. - Christian On Wed, Feb 20, 2013 at 2:50 AM, Sergei Golubchik wrote: > Hi, Christian! > > On Feb 19, Christian Convey wrote: >> Hi guys, >> >> As I work through the Coverity Scan results of MariaDB's trunk, I find >> myself having to research what some functions

Re: [Maria-developers] binlog event of COMMIT statement

2013-02-20 Thread Kristian Nielsen
"nanyi607rao" writes: > I am little confused about binlog event of COMMIT statement, In most of > time, a COMMIT statement corresponds a XID_event in the binlog, but > sometimes is a Query_event. how that happened ? The rule is: If we binlog a transaction (or autocommitted statement) involving

Re: [Maria-developers] unexpected "Duplicate entry" error

2013-02-20 Thread Kazuhiko Shiozaki
Hi Kristian, On 18/02/2013 17:38, Kazuhiko Shiozaki wrote: > On 18/02/2013 16:59, Kristian Nielsen wrote: It's REPEATABLE-READ. >>> >>> And innodb_locks_unsafe_for_binlog is ON, could it be the reason ? >> >> Yes. > (snip) >> With --innodb-locks-unsafe-for-binlog=0, the DELETE from connectio

Re: [Maria-developers] my_hash_sort_bin

2013-02-20 Thread Sergei Golubchik
Hi, Mark! On Feb 19, MARK CALLAGHAN wrote: > > we realized that the hash function used in my_hash_sort_bin is lousy for > this input: test.sbest1, test.sbtest2, ..., test.sbtest10. The problem is > made worse when a small number of hash buckets is used because the hash > function output doesn't d