[Maria-developers] header change in MariaDB 10.2.6 and mysqlclient python binding

Hi ! First of all, congratulations to MariaDB 10.2 GA. mysqlclient (python binding : https://pypi.python.org/pypi/mysqlclient/1.3.10 ) cannot be built with MariaDB 10.2.6 like the following : _mysql.c: In function '_mysql_ConnectionObject_ping': _mysql.c:1911:41: error: 'MYSQL' has no member na

Re: [Maria-developers] better execution plan possible with INNER JOIN of mroonga (or whatever storage engine) ?

h >> INNER JOIN like above ? > > Yes, I believe it is possible. > > I've reported this issue as a bug now: > https://mariadb.atlassian.net/browse/MDEV-7250 Thanks for summarising the topic into this issue. It is quite clear and I could understand the background of t

[Maria-developers] better execution plan possible with INNER JOIN of mroonga (or whatever storage engine) ?

ql/sql_select.cc), and it is possible to modify mroonga to return an estimation of rows if MariaDB has such an API. So here are my questions : * can MariaDB request an 'estimation of rows' to mroonga (or whatever storage engine) ? * can such information help to decide a better ex

[Maria-developers] pcre.h should be installed if MariaDB is built with bundled pcre ?

ll pcre.h as well if MariaDB is built with bundled pcre. What do you think ? -- Kazuhiko Shiozaki, Nexedi SA Senior Consultant Nexedi: Consulting and Development of Free / Open Source Software http://www.nexedi.com/ ERP5: Full Featured High End Open Source ERP

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

not set it only > for that particular kind of transaction? Yes I know. I set it globally only because it was the easiest way without modifying the application at all... Regards, -- Kazuhiko Shiozaki, Nexedi SA Senior Consultant Nexedi: Consulting and Development of Free / Open Source

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

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) >&g

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

db_locks_unsafe_for_binlog when I posted this question... I'm trying using SERIALIZABLE isolation level and will check the performance impact with this change. Regards, -- Kazuhiko Shiozaki, Nexedi SA Senior Consultant Nexedi: Consulting and Development of Free / Open Source Software http:

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

On 18/02/2013 16:31, Kazuhiko Shiozaki wrote: > On 18/02/2013 15:36, Kristian Nielsen wrote: >>> We sometimes (not always, not often but sometimes) have unexpected >>> "Duplicate entry" error on the following table and with the following >>> query : >&g

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

tables) >> >> COMMIT; > > What transaction isolation level are you running these transactions with? It's REPEATABLE-READ. Regards, -- Kazuhiko Shiozaki, Nexedi SA Senior Consultant Nexedi: Consulting and Development of Free / Open Source Software http://www.nexedi.com/ ERP5

[Maria-developers] unexpected "Duplicate entry" error

t we can investigate this issue further ? Thanks in advance ! -- Kazuhiko Shiozaki Nexedi: Consulting and Development of Free / Open Source Software http://www.nexedi.com/ ERP5: Full Featured High End Open Source ERP http://www.erp5.com/ ___ Mailing list:

[Maria-developers] Please try new fulltext storage engine "mroonga"

ny problem like compilation error, test failure, or whatever, please let me know. Thanks in advance ! -- Kazuhiko Shiozaki, Nexedi SA Senior Consultant Nexedi: Consulting and Development of Free / Open Source Software http://www.nexedi.co.jp/ ERP5: Full Featured High End Open Source ERP http://ww