- discuss - lists.mariadb.org

[Maria-discuss] getting all name-value pairs from a dynamic column
by MARK CALLAGHAN 13 Apr '12

13 Apr '12

These docs are excellent -- http://kb.askmonty.org/en/dynamic-columns How do you fetch all name-value pairs from a dynamic column in a format that can be consumed by a client? The client can select the column as is but then must know how mariadb encoded it. The function column_list returns the column names. If there were a function that encoded all name-value pairs as JSON, then the client could do something like this and be able to decode the result: select column_json(dynamic_column_name) from t where ... -- Mark Callaghan mdcallag(a)gmail.com

4 9

[Maria-discuss] Maria/Aria unit test failures
by Brian Evans 11 Apr '12

11 Apr '12

I'm trying to pin down why unit tests fail for the 5.1, 5.2 and 5.3 series of the (m)aria engine. My build tool runs 'make test-unit' and the following errors appear. The build tool does strip out some environment variables, but running from bash directly doesn't change anything. Can anyone provide pointers? Thanks (This is from MariaDB 5.1.62) [16:34:05] ../storage/maria/unittest/ma_test_all-t ..................... 73/830 Failed test '../storage/maria/unittest/../ma_test2 -s -htmp -m10000 -e4096 -K ' (loop iteration 8.) at line 316 (errcode: 256, test: 83) [16:34:05] ../storage/maria/unittest/ma_test_all-t ..................... 85/830 Failed test '../storage/maria/unittest/../ma_test2 -s -htmp -m10000 -e8192 -K ' (loop iteration 9.) at line 316 (errcode: 256, test: 85) Failed test '../storage/maria/unittest/../ma_test2 -s -htmp -m10000 -e16384 -E16384 -K -L ' (loop iteration 10.) at line 316 (errcode: 256, test: 87) [16:34:05] ../storage/maria/unittest/ma_test_all-t ..................... 238/830 Failed test '../storage/maria/unittest/../ma_test2 -s -htmp -m10000 -e4096 -K -S' (loop iteration 8.) at line 316 (errcode: 256, test: 242) Failed test '../storage/maria/unittest/../ma_test2 -s -htmp -m10000 -e8192 -K -S' (loop iteration 9.) at line 316 (errcode: 256, test: 244) [16:34:05] ../storage/maria/unittest/ma_test_all-t ..................... 246/830 Failed test '../storage/maria/unittest/../ma_test2 -s -htmp -m10000 -e16384 -E16384 -K -L -S' (loop iteration 10.) at line 316 (errcode: 256, test: 246) [16:34:05] ../storage/maria/unittest/ma_test_all-t ..................... 399/830 Failed test '../storage/maria/unittest/../ma_test2 -s -htmp -m10000 -e4096 -K -M' (loop iteration 8.) at line 316 (errcode: 256, test: 401) Failed test '../storage/maria/unittest/../ma_test2 -s -htmp -m10000 -e8192 -K -M' (loop iteration 9.) at line 316 (errcode: 256, test: 403) Failed test '../storage/maria/unittest/../ma_test2 -s -htmp -m10000 -e16384 -E16384 -K -L -M' (loop iteration 10.) at line 316 (errcode: 256, test: 405) [16:34:05] ../storage/maria/unittest/ma_test_all-t ..................... 557/830 Failed test '../storage/maria/unittest/../ma_test2 -s -htmp -m10000 -e4096 -K -M -T' (loop iteration 8.) at line 316 (errcode: 256, test: 560) Failed test '../storage/maria/unittest/../ma_test2 -s -htmp -m10000 -e8192 -K -M -T' (loop iteration 9.) at line 316 (errcode: 256, test: 562) [16:34:05] ../storage/maria/unittest/ma_test_all-t ..................... 564/830 Failed test '../storage/maria/unittest/../ma_test2 -s -htmp -m10000 -e16384 -E16384 -K -L -M -T' (loop iteration 10.) at line 316 (errcode: 256, test: 564) [16:34:05] ../storage/maria/unittest/ma_test_all-t ..................... 716/830 Failed test '../storage/maria/unittest/../ma_test2 -s -htmp -m10000 -e4096 -K -M -T -C' (loop iteration 8.) at line 316 (errcode: 256, test: 719) [16:34:05] ../storage/maria/unittest/ma_test_all-t ..................... 721/830 Failed test '../storage/maria/unittest/../ma_test2 -s -htmp -m10000 -e8192 -K -M -T -C' (loop iteration 9.) at line 316 (errcode: 256, test: 721) Failed test '../storage/maria/unittest/../ma_test2 -s -htmp -m10000 -e16384 -E16384 -K -L -M -T -C' (loop iteration 10.) at line 316 (errcode: 256, test: 723) [16:34:05] ../storage/maria/unittest/ma_test_all-t ..................... Dubious, test returned 1 (wstat 256, 0x100) Failed 15/830 subtests

1 0

[Maria-discuss] MariaDB 5.5.23 stable (GA) now available
by Daniel Bartholomew 11 Apr '12

11 Apr '12

The MariaDB project is pleased to announce the immediate availability of MariaDB 5.5.23. This is a stable (GA) release. It includes MariaDB 5.3.6 and MySQL 5.5.23, some performance improvements, and bug fixes. This is the first stable (GA) release in the MariaDB 5.5 series. - - MariaDB 5.5 Links - - - - - - - - - - - - - - - - - - - - - - - - - Release Notes: http://kb.askmonty.org/en/mariadb-5523-release-notes Changelog: http://kb.askmonty.org/en/mariadb-5523-changelog Downloads: http://downloads.askmonty.org/mariadb/5.5.23 .deb Repositories: http://downloads.askmonty.org/mariadb/repositories/ Overview of MariaDB 5.5: http://kb.askmonty.org/en/what-is-mariadb-55 - - SkySQL and MariaDB: Solutions Day - - - - - - - - - - - - - - - - - We'll be co-hosting the the "SkySQL & MariaDB: Solutions Day for the MySQL® Database" one day event on 13 April, 2012, at the Hyatt Regency Santa Clara. During this event, attendees will receive free, hands-on training and consulting on MariaDB and MySQL® database solutions from the experts at SkySQL, MariaDB, Continuent, ScaleDB, Severalnines, Sphinx, and Webyog, among others. SkySQL and MariaDB will bring together industry visionaries, including Michael (Monty) Widenius and David Axmark, the original authors of the MySQL database, to share their insights on current and future trends pertaining to the world's most popular open source database. To learn more about this free event, visit: http://www.skysql.com/events/mysql-solutions-day The schedule for the event is here: http://www.skysql.com/events/mysql-solutions-day/schedule Attendees are also invited to participate in Drizzle Day - a parallel event co-hosted by SkySQL, Percona, and the Drizzle Development Team, featuring tutorials on the Drizzle database. - - MariaDB Crash Course - - - - - - - - - - - - - - - - - - - - - - - The MariaDB-specific book, MariaDB Crash Course, by Ben Forta, is an excellent way to learn more about MariaDB. This book - for beginner to intermediate level users - will get you up and running with MariaDB, even if you've never used a database before. More information is available at: http://forta.com/books/0321799941/ - - User Feedback plugin - - - - - - - - - - - - - - - - - - - - - - - MariaDB includes a User Feedback plugin. This plugin is disabled by default. If enabled, it submits basic, completely anonymous MariaDB usage information. This information is used by the developers to track trends in MariaDB usage to better guide development efforts. If you would like to help make MariaDB better, please add "plugin-load=feedback.so" to your my.cnf file! On Windows, add "feedback=ON" to your my.ini file, or click the checkbox during the installation of the MSI package. See http://kb.askmonty.org/en/user-feedback-plugin for more information. - - Quality - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - The project always strives for quality, but in reality, nothing is perfect. Please take time to report any issues you encounter at: https://bugs.launchpad.net/maria - - Where else to find us - - - - - - - - - - - - - - - - - - - - - - - We're on Facebook: http://www.facebook.com/MariaDB.dbms We're on Twitter: http://twitter.com/#!/mariadb We're on Google Plus: http://gplus.to/mariadb We hope you enjoy MariaDB! -- Daniel Bartholomew MariaDB - http://mariadb.org Monty Program - http://montyprogram.com AskMonty Knowledgebase - http://kb.askmonty.org

1 0

[Maria-discuss] MariaDB 5.3.6 now available
by Daniel Bartholomew 09 Apr '12

09 Apr '12

The MariaDB project is pleased to announce the immediate availability of MariaDB 5.3.6. This is a stable (GA) release. It includes MySQL 5.1.62, some performance improvements, and several bug fixes. Most importantly, MariaDB 5.3.6 includes a fix for a bug which, under certain rare circumstances, allowed a user to connect with an invalid password. This is a serious security issue. We recommend upgrading from older versions as soon as possible. - - MariaDB 5.3 Links - - - - - - - - - - - - - - - - - - - - - - - - - Release Notes: http://kb.askmonty.org/en/mariadb-536-release-notes Changelog: http://kb.askmonty.org/en/mariadb-536-changelog Downloads: http://downloads.askmonty.org/mariadb/5.3.6 .deb Repositories: http://downloads.askmonty.org/mariadb/repositories/ Overview of MariaDB 5.3: http://kb.askmonty.org/en/what-is-mariadb-53 - - SkySQL and MariaDB: Solutions Day - - - - - - - - - - - - - - - - - We'll be co-hosting the the "SkySQL & MariaDB: Solutions Day for the MySQL® Database" one day event on 13 April, 2012, at the Hyatt Regency Santa Clara. During this event, attendees will receive free, hands-on training and consulting on MariaDB and MySQL® database solutions from the experts at SkySQL, MariaDB, Continuent, ScaleDB, Severalnines, Sphinx, and Webyog, among others. SkySQL and MariaDB will bring together industry visionaries, including Michael (Monty) Widenius and David Axmark, the original authors of the MySQL database, to share their insights on current and future trends pertaining to the world's most popular open source database. To learn more about this free event, visit: http://www.skysql.com/events/mysql-solutions-day The schedule for the event is here: http://www.skysql.com/events/mysql-solutions-day/schedule Attendees are also invited to participate in Drizzle Day - a parallel event co-hosted by SkySQL, Percona, and the Drizzle Development Team, featuring tutorials on the Drizzle database. - - MariaDB Crash Course - - - - - - - - - - - - - - - - - - - - - - - The MariaDB-specific book, MariaDB Crash Course, by Ben Forta, is an excellent way to learn more about MariaDB. This book - for beginner to intermediate level users - will get you up and running with MariaDB, even if you've never used a database before. More information is available at: http://forta.com/books/0321799941/ - - User Feedback plugin - - - - - - - - - - - - - - - - - - - - - - - MariaDB includes a User Feedback plugin. This plugin is disabled by default. If enabled, it submits basic, completely anonymous MariaDB usage information. This information is used by the developers to track trends in MariaDB usage to better guide development efforts. If you would like to help make MariaDB better, please add "plugin-load=feedback.so" to your my.cnf file! On Windows, add "feedback=ON" to your my.ini file, or click the checkbox during the installation of the MSI package. See http://kb.askmonty.org/en/user-feedback-plugin for more information. - - Quality - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - The project always strives for quality, but in reality, nothing is perfect. Please take time to report any issues you encounter at: https://bugs.launchpad.net/maria - - Where else to find us - - - - - - - - - - - - - - - - - - - - - - - We're on Facebook: http://www.facebook.com/MariaDB.dbms We're on Twitter: http://twitter.com/#!/mariadb We're on Google Plus: http://gplus.to/mariadb We hope you enjoy MariaDB! -- Daniel Bartholomew MariaDB - http://mariadb.org Monty Program - http://montyprogram.com AskMonty Knowledgebase - http://kb.askmonty.org

1 0

[Maria-discuss] MariaDB 5.1.62 and 5.2.12 now available
by Daniel Bartholomew 06 Apr '12

06 Apr '12

The MariaDB project is pleased to announce the immediate availability of MariaDB 5.1.62 and 5.2.12. Both of these are stable (RC) releases and include MySQL 5.1.62 and several bug fixes. Most importantly, MariaDB 5.1.62 and 5.2.12 include a fix for a bug that under certain rare circumstances allowed a user to connect with an invalid password. This is a serious security issue. We recommend upgrading from older versions as soon as possible. - - MariaDB 5.1.62 Links - - - - - - - - - - - - - - - - - - - - - - - - Release Notes: http://kb.askmonty.org/en/mariadb-5162-release-notes Changelog: http://kb.askmonty.org/en/mariadb-5162-changelog Downloads: http://downloads.askmonty.org/mariadb/5.1.62 .deb Repositories: http://downloads.askmonty.org/mariadb/repositories/ Overview of MariaDB 5.1: http://kb.askmonty.org/en/what-is-mariadb-51 - - MariaDB 5.2.12 Links - - - - - - - - - - - - - - - - - - - - - - - Release Notes: http://kb.askmonty.org/en/mariadb-5212-release-notes Changelog: http://kb.askmonty.org/en/mariadb-5212-changelog Downloads: http://downloads.askmonty.org/mariadb/5.2.12 .deb Repositories: http://downloads.askmonty.org/mariadb/repositories/ Overview of MariaDB 5.2: http://kb.askmonty.org/en/what-is-mariadb-52 - - SkySQL and MariaDB: Solutions Day - - - - - - - - - - - - - - - - - We'll be co-hosting the the "SkySQL & MariaDB: Solutions Day for the MySQL® Database" one day event on 13 April, 2012, at the Hyatt Regency Santa Clara. During this event, attendees will receive free, hands-on training and consulting on MariaDB and MySQL® database solutions from the experts at SkySQL, MariaDB, Continuent, ScaleDB, Severalnines, Sphinx, and Webyog, among others. SkySQL and MariaDB will bring together industry visionaries, including Michael (Monty) Widenius and David Axmark, the original authors of the MySQL database, to share their insights on current and future trends pertaining to the world's most popular open source database. To learn more about this free event, visit: http://www.skysql.com/events/mysql-solutions-day The schedule for the event is here: http://www.skysql.com/events/mysql-solutions-day/schedule Attendees are also invited to participate in Drizzle Day - a parallel event co-hosted by SkySQL, Percona, and the Drizzle Development Team, featuring tutorials on the Drizzle database. - - User Feedback plugin - - - - - - - - - - - - - - - - - - - - - - - MariaDB includes a User Feedback plugin. This plugin is disabled by default. If enabled, it submits basic, completely anonymous MariaDB usage information. This information is used by the developers to track trends in MariaDB usage to better guide development efforts. If you would like to help make MariaDB better, please add "plugin-load=feedback.so" to your my.cnf file! On Windows, add "feedback=ON" to your my.ini file, or click the checkbox during the installation of the MSI package. See http://kb.askmonty.org/en/user-feedback-plugin for more information. - - Quality - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - The project always strives for quality, but in reality, nothing is perfect. Please take time to report any issues you encounter at: https://bugs.launchpad.net/maria - - Where else to find us - - - - - - - - - - - - - - - - - - - - - - - We're on Facebook: http://www.facebook.com/MariaDB.dbms We're on Twitter: http://twitter.com/#!/mariadb We're on Google Plus: http://gplus.to/mariadb We hope you enjoy MariaDB! -- Daniel Bartholomew MariaDB - http://mariadb.org Monty Program - http://montyprogram.com AskMonty Knowledgebase - http://kb.askmonty.org

1 1

[Maria-discuss] MariaDB 5.1.61 and 5.2.11 now available
by Daniel Bartholomew 02 Apr '12

02 Apr '12

The MariaDB project is pleased to announce the immediate availability of MariaDB 5.1.61 and 5.2.11. Both of these are stable (RC) releases and include MySQL 5.1.61 and several bug fixes. Please see the "What is MariaDB 5.1" page for an overview of MariaDB 5.1: http://kb.askmonty.org/en/what-is-mariadb-51 Please see the "What is MariaDB 5.2" page for an overview of MariaDB 5.2: http://kb.askmonty.org/en/what-is-mariadb-52 - - MariaDB 5.1.61 Release Notes, Changelog, Downloads - - - - - - - The release notes for MariaDB 5.1.61 are available at: http://kb.askmonty.org/en/mariadb-5161-release-notes A changelog for this release is available at: http://kb.askmonty.org/en/mariadb-5161-changelog Sources, binaries and packages can be downloaded from: http://downloads.askmonty.org/mariadb/5.1.61 - - MariaDB 5.2.11 Release Notes, Changelog, Downloads - - - - - - - The release notes for MariaDB 5.2.11 are available at: http://kb.askmonty.org/en/mariadb-5211-release-notes A changelog for this release is available at: http://kb.askmonty.org/en/mariadb-5211-changelog Sources, binaries and packages can be downloaded from: http://downloads.askmonty.org/mariadb/5.2.11 Debian and Ubuntu packages for both releases are available from our mirrored apt repositories. A sources.list generator can be found at: http://downloads.askmonty.org/mariadb/repositories/ - - SkySQL and MariaDB: Solutions Day - - - - - - - - - - - - - - - - - We'll be co-hosting the the "SkySQL & MariaDB: Solutions Day for the MySQL® Database" one day event on 13 April, 2012, at the Hyatt Regency Santa Clara. During this event, attendees will receive free, hands-on training and consulting on MariaDB and MySQL® database solutions from the experts at SkySQL, MariaDB, Continuent, ScaleDB, Severalnines, Sphinx, and Webyog, among others. SkySQL and MariaDB will bring together industry visionaries, including Michael (Monty) Widenius and David Axmark, the original authors of the MySQL database, to share their insights on current and future trends pertaining to the world's most popular open source database. To learn more about this free event, visit http://www.skysql.com/events/mysql-solutions-day The schedule for the event is here: http://www.skysql.com/events/mysql-solutions-day/schedule Attendees are also invited to participate in Drizzle Day - a parallel event co-hosted by SkySQL, Percona, and the Drizzle Development Team, featuring tutorials on the Drizzle database. - - User Feedback plugin - - - - - - - - - - - - - - - - - - - - - - - MariaDB includes a User Feedback plugin. This plugin is disabled by default. If enabled, it submits basic, completely anonymous MariaDB usage information. This information is used by the developers to track trends in MariaDB usage to better guide development efforts. If you would like to help make MariaDB better, please add "plugin-load=feedback.so" to your my.cnf file! On Windows, add "feedback=ON" to your my.ini file, or click the checkbox during the installation of the MSI package. See http://kb.askmonty.org/en/user-feedback-plugin for more information. - - Quality - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - The project always strives for quality, but in reality, nothing is perfect. Please take time to report any issues you encounter at: https://bugs.launchpad.net/maria - - Where else to find us - - - - - - - - - - - - - - - - - - - - - - - We're on Facebook: http://www.facebook.com/MariaDB.dbms We're on Twitter: http://twitter.com/#!/mariadb We're on Google Plus: http://gplus.to/mariadb We hope you enjoy MariaDB! -- Daniel Bartholomew MariaDB - http://mariadb.org Monty Program - http://montyprogram.com AskMonty Knowledgebase - http://kb.askmonty.org

1 0

[Maria-discuss] Test failure with 5.5.22 on plugins.unix_socket
by Brian Evans 30 Mar '12

30 Mar '12

I'm getting a strange error with 5.5.22 (and 5.5.21) in the test runs. plugins.unix_socket [ fail ] Test ended at 2012-03-30 11:16:46 CURRENT_TEST: plugins.unix_socket mysqltest: At line 15: Can't initialize replace from 'replace_result $USER USER' The result from queries just before the failure was: install plugin unix_socket soname 'auth_socket.so'; # # with named user # Is this a test program issue? Brian

2 2

[Maria-discuss] MariaDB 5.5.22 release candidate now available
by Daniel Bartholomew 30 Mar '12

30 Mar '12

The MariaDB project is pleased to announce the immediate availability of MariaDB 5.5.22 release candidate (RC). MariaDB 5.5.22 is the first RC release in the 5.5 series. We hope to follow it up soon with a stable (GA) 5.5 release. Please test this release thoroughly! This is the third 5.5-based release. The MariaDB 5.5 series is the combination of MariaDB 5.3 and MySQL 5.5 with a few extra features and bug fixes. Please read the "What is MariaDB 5.5" page for an overview: http://kb.askmonty.org/en/what-is-mariadb-55 - - MariaDB 5.5.22 RC Release Notes, Changelog, Downloads - - - - - - - The release notes for MariaDB 5.5.22 RC are available at: http://kb.askmonty.org/en/mariadb-5522-release-notes A changelog for this release is available at: http://kb.askmonty.org/en/mariadb-5522-changelog Sources, binaries and packages can be downloaded from: http://downloads.askmonty.org/mariadb/5.5.22/ Debian and Ubuntu packages are available from our mirrored apt repositories. A sources.list generator can be found at: http://downloads.askmonty.org/mariadb/repositories/ - - About MariaDB 5.5 - - - - - - - - - - - - - - - - - - - - - - - - - The MariaDB 5.5 series is the combination of MariaDB 5.3 and MySQL 5.5. Please read the "What is MariaDB 5.5" page for details: http://kb.askmonty.org/en/what-is-mariadb-55 - - SkySQL and MariaDB: Solutions Day - - - - - - - - - - - - - - - - - We'll be co-hosting the the "SkySQL & MariaDB: Solutions Day for the MySQL® Database" one day event on 13 April, 2012, at the Hyatt Regency Santa Clara. During this event, attendees will receive free, hands-on training and consulting on MariaDB and MySQL® database solutions from the experts at SkySQL, MariaDB, Continuent, ScaleDB, Severalnines, Sphinx, and Webyog, among others. SkySQL and MariaDB will bring together industry visionaries, including Michael (Monty) Widenius and David Axmark, the original authors of the MySQL database, to share their insights on current and future trends pertaining to the world's most popular open source database. To learn more about this free event, visit http://www.skysql.com/events/mysql-solutions-day The schedule for the event is here: http://www.skysql.com/events/mysql-solutions-day/schedule Attendees are also invited to participate in Drizzle Day – a parallel event co-hosted by SkySQL, Percona, and the Drizzle Development Team, featuring tutorials on the Drizzle database. - - User Feedback plugin - - - - - - - - - - - - - - - - - - - - - - - MariaDB includes a User Feedback plugin. This plugin is disabled by default. If enabled, it submits basic, completely anonymous MariaDB usage information. This information is used by the developers to track trends in MariaDB usage to better guide development efforts. If you would like to help make MariaDB better, please add --plugin-load=feedback.so to your my.cnf file! On Windows, add "feedback=ON" to your my.ini file, or click the checkbox during the installation of the MSI package. See http://kb.askmonty.org/en/user-feedback-plugin for more information. - - Quality - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - The project always strives for quality, but in reality, nothing is perfect. Please take time to report any issues you encounter at: https://bugs.launchpad.net/maria - - Where else to find us - - - - - - - - - - - - - - - - - - - - - - - We're on Facebook: http://www.facebook.com/MariaDB.dbms We're on Twitter: http://twitter.com/#!/mariadb We're on Google Plus: http://gplus.to/mariadb We hope you enjoy MariaDB! -- Daniel Bartholomew MariaDB - http://mariadb.org Monty Program - http://montyprogram.com AskMonty Knowledgebase - http://kb.askmonty.org

1 0

[Maria-discuss] Blog post: What about the subqueries?
by Colin Charles 30 Mar '12

30 Mar '12

Hi! This came up on my radar: http://mysqlmaniac.com/2012/what-about-the-subqueries/ MariaDB does wonderfully for Q1, but not so well for Q2 on some specific queries. These were made with the MediaWiki extension called DynamicPageList (http://www.mediawiki.org/wiki/Extension:DynamicPageList_%28third-party%29) -- Colin Charles, http://bytebot.net/blog/ | twitter: @bytebot | skype: colincharles MariaDB: Community developed. Feature enhanced. Backward compatible. Download it at: http://www.mariadb.org/ Open MariaDB/MySQL documentation at the Knowledgebase: http://kb.askmonty.org/

1 0

Re: [Maria-discuss] Compiling 5.5.20 on OS X
by Richard Dunn 27 Mar '12

27 Mar '12

Hi Colin, I actually get a little farther along (83% instead of 77%), but it looks like we're failing at the same spot -- Linking CXX executable ma_pagecache_consist_1k-t [ 83%] Building C object storage/maria/unittest/CMakeFiles/ma_control_file-t.dir/ma_control_file-t.c.o Linking CXX executable ma_control_file-t [ 83%] Built target ma_control_file-t Scanning dependencies of target ma_pagecache_consist_1k-t [ 83%] Building C object storage/maria/unittest/CMakeFiles/ma_pagecache_consist_1k-t.dir/ma_pagecache_consist.c.o [ 83%] Building C object storage/maria/unittest/CMakeFiles/ma_pagecache_consist_1k-t.dir/test_file.c.o Linking CXX executable ma_pagecache_consist_1k-t Undefined symbols for architecture x86_64: "_key_PAGECACHE_cache_lock", referenced from: _init_pagecache in libaria.a(ma_pagecache.c.o) ld: symbol(s) not found for architecture x86_64 collect2: ld returned 1 exit status make[2]: *** [storage/maria/unittest/ma_pagecache_consist_1k-t] Error 1 make[1]: *** [storage/maria/unittest/CMakeFiles/ma_pagecache_consist_1k-t.dir/all] Error 2 make: *** [all] Error 2 Richard On Mar 27, 2012, at 04:52 , Colin Charles wrote: > Hi! > > On 17 Mar 2012, at 19:21, Richard Dunn wrote: > >> Same problem with MariaDB 5.5.21... >> > > Is this what you see currently? Produced this using 5.5.21 using BUILD/compile-pentium64-max > > [ 77%] Building C object storage/maria/unittest/CMakeFiles/ma_pagecache_consist_64k-t.dir/test_file.c.o > Linking CXX executable ma_pagecache_consist_1kRD-t > Linking CXX executable ma_pagecache_consist_1kWR-t > Undefined symbols for architecture x86_64: > "_key_PAGECACHE_cache_lock", referenced from: > _init_pagecache in libaria.a(ma_pagecache.c.o) > ld: symbol(s) not found for architecture x86_64 > collect2: ld returned 1 exit status > Undefined symbols for architecture x86_64: > "_key_PAGECACHE_cache_lock", referenced from: > _init_pagecache in libaria.a(ma_pagecache.c.o) > ld: symbol(s) not found for architecture x86_64 > collect2: ld returned 1 exit status > make[2]: *** [storage/maria/unittest/ma_pagecache_consist_1kRD-t] Error 1 > make[1]: *** [storage/maria/unittest/CMakeFiles/ma_pagecache_consist_1kRD-t.dir/all] Error 2 > make[2]: *** [storage/maria/unittest/ma_pagecache_consist_1kWR-t] Error 1 > make[1]: *** [storage/maria/unittest/CMakeFiles/ma_pagecache_consist_1kWR-t.dir/all] Error 2 > Linking CXX executable ma_pagecache_consist_64k-t > Undefined symbols for architecture x86_64: > "_key_PAGECACHE_cache_lock", referenced from: > _init_pagecache in libaria.a(ma_pagecache.c.o) > ld: symbol(s) not found for architecture x86_64 > collect2: ld returned 1 exit status > make[2]: *** [storage/maria/unittest/ma_pagecache_consist_64k-t] Error 1 > make[1]: *** [storage/maria/unittest/CMakeFiles/ma_pagecache_consist_64k-t.dir/all] Error 2 > [ 88%] Built target sql > make: *** [all] Error 2 > > >> >> On Mar 4, 2012, at 07:53 , Richard Dunn wrote: >> >>> I've been compiling MySQL and MariaDB on OS X for quite some time now, but this is the first time that I have ever used CMake to build an application. The 'make' step consistently fails with the following: >>> >>> Linking CXX executable ma_pagecache_consist_1k-t >>> Undefined symbols for architecture x86_64: >>> "_key_PAGECACHE_cache_lock", referenced from: >>> _init_pagecache in libaria.a(ma_pagecache.c.o) >>> ld: symbol(s) not found for architecture x86_64 >>> >>> I assume libaria.a is Maria specific. >>> >>> As a sanity check, I downloaded the MySQL source code for 5.5.21 from the MySQL site and I successfully compiled everything with CMake. >>> >>> Has anyone else successfully compiled a 64 bit 5.5.20 MariaDB on OS X? What am I missing? >> >> >> _______________________________________________ >> Mailing list: https://launchpad.net/~maria-discuss >> Post to : maria-discuss(a)lists.launchpad.net >> Unsubscribe : https://launchpad.net/~maria-discuss >> More help : https://help.launchpad.net/ListHelp > > -- > Colin Charles, http://bytebot.net/blog/ | twitter: @bytebot | skype: colincharles > MariaDB: Community developed. Feature enhanced. Backward compatible. > Download it at: http://www.mariadb.org/ > Open MariaDB/MySQL documentation at the Knowledgebase: http://kb.askmonty.org/ >

1 0

Re: [Maria-discuss] Compiling 5.5.20 on OS X
by Richard Dunn 27 Mar '12

27 Mar '12

Hi Sergei, The build log is attached. Thanks for your help! Richard On Mar 26, 2012, at 12:25 , Sergei Golubchik wrote: > Hi, Richard! > > I don't have an OS X build environment at the moment. > I'll try to help you and fix that, but I'll be asking a lot of > questions. Sorry for this. > > On Mar 04, Richard Dunn wrote: >> I've been compiling MySQL and MariaDB on OS X for quite some time now, >> but this is the first time that I have ever used CMake to build an >> application. The 'make' step consistently fails with the following: >> >> Linking CXX executable ma_pagecache_consist_1k-t >> Undefined symbols for architecture x86_64: >> "_key_PAGECACHE_cache_lock", referenced from: >> _init_pagecache in libaria.a(ma_pagecache.c.o) >> ld: symbol(s) not found for architecture x86_64 >> >> I assume libaria.a is Maria specific. > > Can you show the complete build log? > To collect it you can run "make VERBOSE=1 -k >& log". > The file might be quite big, don't forget to gzip it before emailing. > > Regards, > Sergei

1 0

[Maria-discuss] New KB Question: Maximum number of indexes supported by Xtradb
by Daniel Bartholomew 27 Mar '12

27 Mar '12

A new question has been posted to the Knowledgebase: http://kb.askmonty.org/en/maximum-number-of-indexes-supported-by-xtradb ----------------------------------------------------------------------- What is the maximum number of indexes allowed per-table when using the Xtradb storage engine? ----------------------------------------------------------------------- Thanks. -- Daniel Bartholomew MariaDB - http://mariadb.org Monty Program - http://montyprogram.com AskMonty Knowledgebase - http://kb.askmonty.org

1 0

[Maria-discuss] Wrong ordering in MariaDB 5.2.10
by Brian Evans 16 Mar '12

16 Mar '12

We are hitting a wrong ordering in 5.2.10 but it does not happen on a test box using 5.3 series (tried 5.3.3 and 5.3.5). The query can be rewritten and when we do, the range becomes an index scan and produces the correct results. Here are the queries: [Incorrect Order] SELECT SUBSTRING(StockNo, 3, 3) AS $number FROM inv WHERE StockNo LIKE 'JR%' OR StockNo LIKE 'VS%' OR StockNo LIKE 'JB%' OR StockNo LIKE 'JG%' ORDER BY $number DESC LIMIT 1; EXPLAIN Result id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE inv range PRIMARY PRIMARY 66 (NULL) 4 Using where; Using index; Using filesort [Correct Order] SELECT SUBSTRING(StockNo, 3, 3) AS $number FROM inv WHERE LEFT(StockNo,2) IN('JR','VS','JB','JG') ORDER BY $number DESC LIMIT 1; *EXPLAIN Result* id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE inv index (NULL) PRIMARY 66 (NULL) 2496 Using where; Using index; Using filesort Simplified Table Structure: CREATE TABLE `tableinventory` ( `StockNo` varchar(64) NOT NULL DEFAULT '', `ItemDesc` varchar(96) NOT NULL DEFAULT '', PRIMARY KEY (`StockNo`) ) ENGINE=PBXT DEFAULT CHARSET=latin1; All data is using a length of 7 even though it is defined as varchar(64).

2 5

[Maria-discuss] New KB question: Embedded engine?
by Daniel Bartholomew 01 Mar '12

01 Mar '12

A new question has been posted in the Knowledgebase: https://kb.askmonty.org/en/embedded-engine +++++++++++++++++++++++++++++++++++ Hi all, Is there an embedded version of MariaDB? If the answer is yes, then is it possible to connect to it using JDBC (this works for the Firebird embedded server)? TIA and rgs, Paul... +++++++++++++++++++++++++++++++++++ Thanks. -- Daniel Bartholomew MariaDB - http://mariadb.org Monty Program - http://montyprogram.com AskMonty Knowledgebase - http://kb.askmonty.org

1 0

[Maria-discuss] MariaDB 5.3.5 now available!
by Daniel Bartholomew 29 Feb '12

29 Feb '12

The MariaDB project is pleased to announce the immediate availability of MariaDB 5.3.5! MariaDB 5.3.5 is the first stable (GA) release in the 5.3 series. --- MariaDB 5.3.5 Release Notes, Changelog, Downloads ----------------- The release notes are available at: http://kb.askmonty.org/en/mariadb-535-release-notes A changelog is available at: http://kb.askmonty.org/en/mariadb-535-changelog Sources, binaries and packages can be downloaded from: http://downloads.askmonty.org/mariadb/5.3.5/ Debian and Ubuntu packages are available from our mirrored apt repositories. A sources.list generator can be found at: http://downloads.askmonty.org/mariadb/repositories/ --- About MariaDB 5.3 ------------------------------------------------- The MariaDB 5.3 series introduces many new features, includes MariaDB 5.2, and is based on MariaDB 5.1 & MySQL 5.1. Some highlights of new features in MariaDB 5.3 include: - subquery optimizations that finally make subqueries usable - many optimizer changes, including Classic Hash Join, Batched Key Access, a new implementation of Multi-Range-Read optimizations as well as Index Condition Pushdown - NoSQL-style interfaces via the HandlerSocket plugin as well as dynamic columns - group commit in XtraDB when the binary log is enabled - Microsoft Windows performance improvements These are just some of the highlights, and for a more complete list of changes, please read the What is MariaDB 5.3 page: http://kb.askmonty.org/en/what-is-mariadb-53 --- SkySQL and MariaDB: Solutions Day --------------------------------- We'll be co-hosting the the "SkySQL & MariaDB: Solutions Day for the MySQL® Database" one day event on 13 April, 2012, at the Hyatt Regency Santa Clara. During this event, attendees will receive free, hands-on training and consulting on MariaDB and MySQL® database solutions from the experts at SkySQL, MariaDB, Continuent, ScaleDB, Severalnines, Sphinx, and Webyog, among others. SkySQL and MariaDB will bring together industry visionaries, including Michael (Monty) Widenius and David Axmark, the original authors of the MySQL database, to share their insights on current and future trends pertaining to the world's most popular open source database. To learn more about this free event, visit http://www.skysql.com/events/mysql-solutions-day The schedule for the event is here: http://www.skysql.com/events/mysql-solutions-day/schedule Attendees are also invited to participate in Drizzle Day– a parallel event co-hosted by SkySQL, Percona, and the Drizzle Development Team, featuring tutorials on the Drizzle database. --- User Feedback plugin ---------------------------------------------- MariaDB includes a User Feedback plugin. This plugin is disabled by default. If enabled, it submits basic, completely anonymous MariaDB usage information. This information is used by the developers to track trends in MariaDB usage to better guide development efforts. If you would like to help make MariaDB better, please add --plugin-load=feedback.so to your my.cnf file! On Windows, add "feedback=ON" to your my.ini file, or click the checkbox during the installation of the MSI package. See http://kb.askmonty.org/en/user-feedback-plugin for more information. --- MariaDB Crash Course book ----------------------------------------- We would also like to mention the book "MariaDB Crash Course", by Ben Forta. This book - for beginner to intermediate level users - will get you up and running with MariaDB, even if you've never used a database before. More information is available at: http://forta.com/books/0321799941/ --- Quality ----------------------------------------------------------- The project always strives for quality, but in reality, nothing is perfect. Please take time to report any issues you encounter at: https://bugs.launchpad.net/maria We hope you enjoy MariaDB! -- Daniel Bartholomew MariaDB - http://mariadb.org Monty Program - http://montyprogram.com AskMonty Knowledgebase - http://kb.askmonty.org

1 0

[Maria-discuss] MariaDB 5.5.20-alpha now available
by Daniel Bartholomew 27 Feb '12

27 Feb '12

The MariaDB project is pleased to announce the immediate availability of MariaDB 5.5.20-alpha. MariaDB 5.5.20 is the first Alpha release in the 5.5 series. We hope to follow it up soon with a beta 5.5 release. MariaDB 5.5.20-alpha is a merge of MariaDB 5.3 and MySQL 5.5 with some limited additional bug fixes. This is the first 5.5-based release, and we are releasing it now, intentionally without any extra features, and with it missing some planned features, to get it into the hands of any who might want to test it. Extra features planned for MariaDB 5.5 will be pushed into subsequent releases. **Do not use alpha releases on production systems.** == MariaDB 5.5.20-alpha Release Notes, Changelog, Downloads =========== The release notes for MariaDB 5.5.20-alpha are available at: http://kb.askmonty.org/en/mariadb-5520-release-notes A changelog for this release is available at: http://kb.askmonty.org/en/mariadb-5520-changelog Sources, binaries and packages can be downloaded from: http://downloads.askmonty.org/mariadb/5.5.20/ Debian and Ubuntu packages are available from our mirrored apt repositories. A sources.list generator can be found at: http://downloads.askmonty.org/mariadb/repositories/ == About MariaDB 5.5 ================================================== The MariaDB 5.5 series is the combination of MariaDB 5.3 and MySQL 5.5. Please read the "What is MariaDB 5.5" page for details: http://kb.askmonty.org/en/what-is-mariadb-55 == SkySQL and MariaDB: Solutions Day ================================== We'll be co-hosting the the "SkySQL & MariaDB: Solutions Day for the MySQL® Database" one day event on 13 April, 2012, at the Hyatt Regency Santa Clara. During this event, attendees will receive free, hands-on training and consulting on MariaDB and MySQL® database solutions from the experts at SkySQL, MariaDB, Continuent, ScaleDB, Severalnines, Sphinx, and Webyog, among others. SkySQL and MariaDB will bring together industry visionaries, including Michael (Monty) Widenius and David Axmark, the original authors of the MySQL database, to share their insights on current and future trends pertaining to the world's most popular open source database. To learn more about this free event, visit http://www.skysql.com/events/mysql-solutions-day The schedule for the event is here: http://www.skysql.com/events/mysql-solutions-day/schedule Attendees are also invited to participate in Drizzle Day– a parallel event co-hosted by SkySQL, Percona, and the Drizzle Development Team, featuring tutorials on the Drizzle database. == User Feedback plugin =============================================== MariaDB includes a User Feedback plugin. This plugin is disabled by default. If enabled, it submits basic, completely anonymous MariaDB usage information. This information is used by the developers to track trends in MariaDB usage to better guide development efforts. If you would like to help make MariaDB better, please add --plugin-load=feedback.so to your my.cnf file! On Windows, add "feedback=ON" to your my.ini file, or click the checkbox during the installation of the MSI package. See http://kb.askmonty.org/en/user-feedback-plugin for more information. == MariaDB Crash Course book ========================================== We would also like to mention the book "MariaDB Crash Course", by Ben Forta. This book - for beginner to intermediate level users - will get you up and running with MariaDB, even if you've never used a database before. More information is available at: http://forta.com/books/0321799941/ == Quality ============================================================ The project always strives for quality, but in reality, nothing is perfect. Please take time to report any issues you encounter at: https://bugs.launchpad.net/maria We hope you enjoy MariaDB! -- Daniel Bartholomew MariaDB - http://mariadb.org Monty Program - http://montyprogram.com AskMonty Knowledgebase - http://kb.askmonty.org

1 0

Re: [Maria-discuss] MySQL's future in Debian and Ubuntu
by Alex Esterkin 21 Feb '12

21 Feb '12

As an end user, I would most strongly dislike this. You clearly don't understand how corporate users think and operate, how they work with open source technologies, and how they plan and evolve their technical roadmaps. Last year Ubuntu inflicted enough damage on itself by messing up with UI and display management. Replacing OpenOffice with LibreOffice was not a success story either. A year ago I had plans to migrate my remaining CentOS and Debian servers and test environments to Ubuntu and I recommended using Ubuntu for a couple of server appliance products we had in the works. These plans were revisited and revised in the fall, based on revised Linux distro release and roadmap assessment. As far as MySQL is concerned, I don't care at this point what your Ubuntu server distro plans are, as I have already migrated away from Ubuntu. However, if the discussion about replacing MySQL also spreads into the Fedora Project and CentOS communities, that would give me a very good reason for migrating/porting MySQL apps and products to Postgres. Regards, Alex Esterkin, Former Chief Architect, Infobright On Tue, Feb 7, 2012 at 04:37, Clint Byrum <clint(a)ubuntu.com> wrote: > Many of us in the Free and Open Source software community have seen a > trend regarding Oracle's stewardship of Open source software that it > inherited when it purchased Sun. In particular there were two fairly > large public project blow ups that resulted in OpenOffice splintering, > and the Hudson community (almost?) completely moving to an independent > fork called Jenkins. > > It has been brought to my attention that MySQL may have gone this way > as well, but in a much more subtle way. This started about a year ago, > and has only recently really become obvious. > > A few notable fellows from the MySQL ecosystem have commented: > > Mark Callaghan > http://mysqlha.blogspot.com/2011/02/where-have-bugs-gone.html > (read the comments on this one, very informative, and most of the > commenters are extremely important non-Oracle members of the MySQL > community) > > http://mysqlha.blogspot.com/2011/11/great-work-bug-12704861-was-fixed.html > > Stewart Smith: > http://www.mysqlperformanceblog.com/2011/11/20/bug12704861/ > > And the CVE's are extremely vague: > > http://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2012-0119 > > "Unspecified vulnerability in the MySQL Server component in Oracle MySQL > 5.1.x and 5.5.x allows remote authenticated users to affect availability > via unknown vectors" > > Links to here: > > http://www.oracle.com/technetwork/topics/security/cpujan2012-366304.html > > Which links to here: > > http://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=1390289.1 > > Which requires an account (which I created). I did try to login but got > some kind of failure.. > > "Failure of server APACHE bridge:". > > The bzr commits for the latest MySQL releases also reference log bug#'s > that are thought to belong to the private oracle support system, not > accessible to non-paying customers. > > This is all very troubling, as in a Linux distribution, we must be able > to support our users and track upstream development. > > So what should we, the Debian and Ubuntu MySQL maintainers and users, > do about this? > > Well there is a Jenkins to MySQL's Hudson, a LibreOffice to their > OpenOffice. > > MariaDB 5.3, in release-candidate now, is 100% backward compatible with > MySQL 5.1. It also includes a few speedups and features that can be found > in MySQL 5.5 and Percona Server. It is developed 100% in the open, on > launchpad.net, including a public bug tracker and up to date bzr trees > of the code. > > http://mariadb.org > https://launchpad.net/maria > > I'm writing to the greater Debian and Ubuntu community to ask for your > thoughts on a proposal to drop MySQL in favor of MariaDB. Its clear to > me that Oracle is not going to do work in the open, and this will become > a huge support burden for Linux distributions. The recent CVE's had to > be hunted down and investigated at great difficulty to several people, > since the KB articles referenced and the internal Oracle bug numbers > referenced were not available. > > This will only get harder as the community bug tracker gets further out > of sync with the private one. > > There is some need to consider acting quickly: > > Ubuntu precise, the next LTS release of Ubuntu will be hitting feature > freeze on Feb. 16. The release, due in April, will be supported with > security updates for 5 years. That may be 5 long years of support if > MySQL continues to obscure things. > > Debian wheezy is still quite far off, but it is critical that this be > done and decided by the time the release freeze begins. > > So, here is a suggested plan, given the facts above: > > * Upload mariadb 5.3 to Debian experimental, with it providing > mysql-server, mysql-client, and libmysqlclient-dev. > > * For Ubuntu users, upload these packages to a PPA for testing > applications for compatibility, and rebuild testing. > > * If testing goes well, replace mysql-5.5 with mariadb in both Debian > unstable and Ubuntu precise. If there are reservations about switching > this late in precise's cycle, ship mysql-5.5 in precise, and push off > Ubuntu's transition until the next cycle. > > Before I strike out on this path alone, which, I understand, may sound > a bit radical, I want to hear what you all think. > > Thank you for your time and consideration. > > -- > Clint Byrum <clint(a)ubuntu.com> > Ubuntu Server Team > Debian MySQL Packaging Team >

7 8

[Maria-discuss] MySQL's future in Debian and Ubuntu
by Clint Byrum 17 Feb '12

17 Feb '12

Many of us in the Free and Open Source software community have seen a trend regarding Oracle's stewardship of Open source software that it inherited when it purchased Sun. In particular there were two fairly large public project blow ups that resulted in OpenOffice splintering, and the Hudson community (almost?) completely moving to an independent fork called Jenkins. It has been brought to my attention that MySQL may have gone this way as well, but in a much more subtle way. This started about a year ago, and has only recently really become obvious. A few notable fellows from the MySQL ecosystem have commented: Mark Callaghan http://mysqlha.blogspot.com/2011/02/where-have-bugs-gone.html (read the comments on this one, very informative, and most of the commenters are extremely important non-Oracle members of the MySQL community) http://mysqlha.blogspot.com/2011/11/great-work-bug-12704861-was-fixed.html Stewart Smith: http://www.mysqlperformanceblog.com/2011/11/20/bug12704861/ And the CVE's are extremely vague: http://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2012-0119 "Unspecified vulnerability in the MySQL Server component in Oracle MySQL 5.1.x and 5.5.x allows remote authenticated users to affect availability via unknown vectors" Links to here: http://www.oracle.com/technetwork/topics/security/cpujan2012-366304.html Which links to here: http://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=1390289.1 Which requires an account (which I created). I did try to login but got some kind of failure.. "Failure of server APACHE bridge:". The bzr commits for the latest MySQL releases also reference log bug#'s that are thought to belong to the private oracle support system, not accessible to non-paying customers. This is all very troubling, as in a Linux distribution, we must be able to support our users and track upstream development. So what should we, the Debian and Ubuntu MySQL maintainers and users, do about this? Well there is a Jenkins to MySQL's Hudson, a LibreOffice to their OpenOffice. MariaDB 5.3, in release-candidate now, is 100% backward compatible with MySQL 5.1. It also includes a few speedups and features that can be found in MySQL 5.5 and Percona Server. It is developed 100% in the open, on launchpad.net, including a public bug tracker and up to date bzr trees of the code. http://mariadb.org https://launchpad.net/maria I'm writing to the greater Debian and Ubuntu community to ask for your thoughts on a proposal to drop MySQL in favor of MariaDB. Its clear to me that Oracle is not going to do work in the open, and this will become a huge support burden for Linux distributions. The recent CVE's had to be hunted down and investigated at great difficulty to several people, since the KB articles referenced and the internal Oracle bug numbers referenced were not available. This will only get harder as the community bug tracker gets further out of sync with the private one. There is some need to consider acting quickly: Ubuntu precise, the next LTS release of Ubuntu will be hitting feature freeze on Feb. 16. The release, due in April, will be supported with security updates for 5 years. That may be 5 long years of support if MySQL continues to obscure things. Debian wheezy is still quite far off, but it is critical that this be done and decided by the time the release freeze begins. So, here is a suggested plan, given the facts above: * Upload mariadb 5.3 to Debian experimental, with it providing mysql-server, mysql-client, and libmysqlclient-dev. * For Ubuntu users, upload these packages to a PPA for testing applications for compatibility, and rebuild testing. * If testing goes well, replace mysql-5.5 with mariadb in both Debian unstable and Ubuntu precise. If there are reservations about switching this late in precise's cycle, ship mysql-5.5 in precise, and push off Ubuntu's transition until the next cycle. Before I strike out on this path alone, which, I understand, may sound a bit radical, I want to hear what you all think. Thank you for your time and consideration.

10 16

Re: [Maria-discuss] MySQL's future in Debian and Ubuntu
by Pandu Poluan 17 Feb '12

17 Feb '12

On Feb 13, 2012 2:21 PM, "Eddie Bachle" <enb10(a)albion.edu> wrote: > > In general, I am generally an simply an observer on most of these mailing lists, however my concerns with a switch are far less technical and far more practical. I work currently for a college in Michigan which utilizes almost solely Windows servers simply because it is what the IT staff here knows. As a student here, I was brought in to assist with the web server administration, and as time went by because I have a degree of Linux knowledge, I was given permission to put together a Ubuntu LAMP server to serve a couple of interested parties on campus who wanted simply to demo several small scale web apps that were Linux exclusive. This server would serve as an exception to the general rule of our server architecture. However as time has went by and my knowledge looks more like it will be a fixture here after graduation, along with the simple instability of PHP and Apache on the Windows platform, my boss is giving far more consideration to moving to Linux. > > As Linux gains more public recognition, more and more Windows-only organizations will consider using it as an alternative, especially for their web servers. This is especially true because of the fact that each of the necessarily main components of a web server exist in Linux in the same form as the do on Windows and often run much better. Then, the only piece one would need to learn would be the new operating system, not the database, HTTP server, or PHP scripting language software. However, this is going to be a more difficult proposition if the aforementioned advantage is somewhat eliminated. Were I to have to tell my boss that we could switch to Ubuntu but it would mean that would need to use a "MySQL compatible" database if we want to use the native database (which we likely would because it's tested to be stable and it is supported by the developers), then she would be much more hesitant. > > There simply is a much greater sense of trepidation for those who are not significantly Linux savvy if there exists a possibility that they would have to make something work in an unfamiliar environment, especially if it were to happen unexpectedly. If we ported our www website server over to Ubuntu and then 6 months down the road we were to upgrade our Joomla version and there became an issue with MariaDB because it lacks some MySQL feature that it needs, or even that Joomla would fail to recognize Maria as being equivalent to MySQL at some point, then that would be a huge detraction against switching. > > Unless assurances that any software that asks for MySQL will recognize and accept MariaDB equivalents, and that this should always be the case, and that it will retain the stability and recognized benefits of MySQL, I would encourage extreme caution in encouraging a switch. Linux is beginning to grow into areas it previously didn't reach and bringing a far superior web server experience as well as simply a better operating system experience for many and I would not like to see that growth compromised. I would like to say we would still switch, or still heavily consider it for the grains that could be made by using Ubuntu, however realistically, the lack of native MySQL in any OS would be a huge mark against it. Also that being said, if the technical concerns are answered adequately for a vast majority of applications and hardware/OS setups, then I would be totally behind switching to a more open source friendly and compatible database software as there would be little love lost between me and MySQL. > > I hope this perspective helps a bit in considering this decision, > Do remember that there's an alternative to MySQL/MariaDB: PostgreSQL. I'm actually busy migrating the Windows infrastructure, and my target database is PostgreSQL. Note: I am *not* recommending that Ubuntu replaced its default database from MySQL to PostgreSQL; If a company already deployed a MySQL-based app, then it should migrate to MariaDB, if only to prevent being trapped by Oracle into migrating into Oracle. But for those still exploring a migration to Linux, I won't hesitate to push them toward PostgreSQL instead. There are clear benefits of PostgreSQL over MySQL for the enterprise, and vv. Rgds,

9 20

[Maria-discuss] MariaDB 5.3.4-rc now available
by Daniel Bartholomew 16 Feb '12

16 Feb '12

The MariaDB project would like to announce the availability of MariaDB 5.3.4-rc, the latest addition to our growing lineup of supported software. MariaDB 5.3.4-rc is the second Release Candidate release in the 5.3 series. We hope to follow it up soon with a stable (GA) 5.3 release. == MariaDB 5.3.4-rc Release Notes, Changelog, Downloads =============== The release notes for MariaDB 5.3.4-rc are available from: http://kb.askmonty.org/en/mariadb-534-release-notes A complete changelog for this beta is available from: http://kb.askmonty.org/en/mariadb-534-changelog Sources, binaries and packages can be downloaded from: http://downloads.askmonty.org/mariadb/5.3.4/ Debian and Ubuntu packages are available from our mirrored apt repositories. A sources.list generator can be found at: http://downloads.askmonty.org/mariadb/repositories/ == About MariaDB 5.3 ================================================== The MariaDB 5.3 series introduces many new features, includes MariaDB 5.2, and is based on MariaDB 5.1 & MySQL 5.1. Some highlights of new features in MariaDB 5.3 include: - subquery optimizations that finally make subqueries usable - many optimizer changes, including Classic Hash Join, Batched Key Access, a new implementation of Multi-Range-Read optimizations as well as Index Condition Pushdown - NoSQL-style interfaces via the HandlerSocket plugin as well as dynamic columns - group commit in XtraDB when the binary log is enabled - Microsoft Windows performance improvements These are just some of the highlights, and for a more complete list of changes, please read the What is MariaDB 5.3 page: http://kb.askmonty.org/en/what-is-mariadb-53 == User Feedback plugin =============================================== MariaDB 5.3 includes a User Feedback plugin. This plugin is disabled by default. If enabled, it submits basic, completely anonymous MariaDB usage information. This information is used by the developers to track trends in MariaDB usage to better guide development efforts. If you would like to help make MariaDB better, please add --plugin-load=feedback.so to your my.cnf file! On Windows, add "feedback=ON" to your my.ini file, or click the checkbox during the installation of the MSI package. See http://kb.askmonty.org/en/user-feedback-plugin for more information. == MariaDB Crash Course book ========================================== We would also like to mention the book "MariaDB Crash Course", by Ben Forta. This book -- for beginner to intermediate level users -- will get you up and running with MariaDB, even if you've never used a database before. More information is available at: http://forta.com/books/0321799941/ == Quality ============================================================ The project always strives for quality, but in reality, nothing is perfect. Please take time to report any issues you encounter at: https://bugs.launchpad.net/maria We hope you enjoy MariaDB 5.3.4-rc! -- Daniel Bartholomew MariaDB - http://mariadb.org Monty Program - http://montyprogram.com AskMonty Knowledgebase - http://kb.askmonty.org

1 0

Re: [Maria-discuss] MySQL's future in Debian and Ubuntu
by Robbie Williamson 16 Feb '12

16 Feb '12

On 02/13/2012 01:20 AM, Eddie Bachle wrote: > I would like to say we would still switch, or still heavily consider it > for the grains that could be made by using Ubuntu, however > realistically, the lack of native MySQL in any OS would be a huge mark > against it. FTR, we would not *drop* MySQL support. Worst case scenario, we'd place them in partner, much like we did with sun-java. The change would be that our default/recommended DB would be MariaDB. > Also that being said, if the technical concerns are > answered adequately for a vast majority of applications and hardware/OS > setups, then I would be totally behind switching to a more open source > friendly and compatible database software as there would be little love > lost between me and MySQL. One thing to note, the primary motivator for this proposal isn't about moving to a more "open source friendly" application. We have genuine security concerns/issues with how MySQL handles and publishes their security updates. We can't simply update supported prior Ubuntu releases to newer MySQL versions, so we have to backport patches. Their lack of information and access to the bugs addressed makes it *very* time consuming and difficult for our security and SRU teams to do this. If we can resolve these issues, then MySQL's future in main looks much brighter. -Robbie -- Robbie Williamson <robbie(a)ubuntu.com> robbiew[irc.freenode.net] "Don't make me angry...you wouldn't like me when I'm angry." -Bruce Banner

3 3

Re: [Maria-discuss] [debian-mysql] MySQL's future in Debian and Ubuntu
by Colin Charles 16 Feb '12

16 Feb '12

Hi! On 13 Feb 2012, at 15:20, Eddie Bachle wrote: > As Linux gains more public recognition, more and more Windows-only organizations will consider using it as an alternative, especially for their web servers. This is especially true because of the fact that each of the necessarily main components of a web server exist in Linux in the same form as the do on Windows and often run much better. Then, the only piece one would need to learn would be the new operating system, not the database, HTTP server, or PHP scripting language software. However, this is going to be a more difficult proposition if the aforementioned advantage is somewhat eliminated. Were I to have to tell my boss that we could switch to Ubuntu but it would mean that would need to use a "MySQL compatible" database if we want to use the native database (which we likely would because it's tested to be stable and it is supported by the developers), then she would be much more hesitant. I reckon MySQL will always be available -- this discussion is about a supported release, especially from a security POV > There simply is a much greater sense of trepidation for those who are not significantly Linux savvy if there exists a possibility that they would have to make something work in an unfamiliar environment, especially if it were to happen unexpectedly. If we ported our www website server over to Ubuntu and then 6 months down the road we were to upgrade our Joomla version and there became an issue with MariaDB because it lacks some MySQL feature that it needs, or even that Joomla would fail to recognize Maria as being equivalent to MySQL at some point, then that would be a huge detraction against switching. More and more software out there also state it works with MariaDB. While your particular example of Joomla! doesn't, another popular CMS like Drupal has had MariaDB on its list for quite some time. (see: http://drupal.org/requirements -- "Recommended: MySQL (or an equivalent such as MariaDB)") > Unless assurances that any software that asks for MySQL will recognize and accept MariaDB equivalents, and that this should always be the case, and that it will retain the stability and recognized benefits of MySQL, I would encourage extreme caution in encouraging a switch. Linux is beginning to grow into areas it previously didn't reach and bringing a far I can totally understand your concern and assure you that MariaDB developers ensure compatibility and treat it as a very high requirement. Backwards compatible is one of our goals and we've never broken that. Extensive testing and QA helps too naturally cheers, -c -- Colin Charles, http://bytebot.net/blog/ | twitter: @bytebot | skype: colincharles MariaDB: Community developed. Feature enhanced. Backward compatible. Download it at: http://www.mariadb.org/ Open MariaDB/MySQL documentation at the Knowledgebase: http://kb.askmonty.org/

1 0

[Maria-discuss] New KB Question: millisecond part is trimmed away when saving Java Date obj by hibernate
by Daniel Bartholomew 14 Feb '12

14 Feb '12

A new question has been posted in the Knowledgebase: http://kb.askmonty.org/en/millisecond-part-is-trimmed-away-when-saving-java… ---------------------------------------- Hi, I recently upgraded my MySQL DB to MariaDB for millisecond support. I can see the millisecond part in my upgraded database. And I tested the millisecond support by inserting a row to a table of my db. It functions well. But when I use hibernate to save a java.util.Date obj into database, millisecond part is trimmed and in MariaDB date obj is saved as: 2012-02-13 18:40:55.000. Do I need to set up something to activate millisecond support? Or I need to config hibernate for millisecond support? Thanks a lot! ---------------------------------------- Thanks. -- Daniel Bartholomew MariaDB - http://mariadb.org Monty Program - http://montyprogram.com AskMonty Knowledgebase - http://kb.askmonty.org

1 0

Re: [Maria-discuss] MySQL's future in Debian and Ubuntu
by Marc Deslauriers 13 Feb '12

13 Feb '12

On Mon, 2012-02-13 at 02:20 -0500, Eddie Bachle wrote: > In general, I am generally an simply an observer on most of these > mailing lists, however my concerns with a switch are far less > technical and far more practical. I work currently for a college in > Michigan which utilizes almost solely Windows servers simply because > it is what the IT staff here knows. As a student here, I was brought > in to assist with the web server administration, and as time went by > because I have a degree of Linux knowledge, I was given permission to > put together a Ubuntu LAMP server to serve a couple of interested > parties on campus who wanted simply to demo several small scale web > apps that were Linux exclusive. This server would serve as an > exception to the general rule of our server architecture. However as > time has went by and my knowledge looks more like it will be a fixture > here after graduation, along with the simple instability of PHP and > Apache on the Windows platform, my boss is giving far more > consideration to moving to Linux. > > > As Linux gains more public recognition, more and more Windows-only > organizations will consider using it as an alternative, especially for > their web servers. This is especially true because of the fact that > each of the necessarily main components of a web server exist in Linux > in the same form as the do on Windows and often run much better. > Then, the only piece one would need to learn would be the new > operating system, not the database, HTTP server, or PHP scripting > language software. However, this is going to be a more difficult > proposition if the aforementioned advantage is somewhat eliminated. > Were I to have to tell my boss that we could switch to Ubuntu but it > would mean that would need to use a "MySQL compatible" database if we > want to use the native database (which we likely would because it's > tested to be stable and it is supported by the developers), then she > would be much more hesitant. If you prefer MySQL, you'll still be able to manually install it MySQL on Ubuntu and Debian, much like you manually install it on Windows. > > > There simply is a much greater sense of trepidation for those who are > not significantly Linux savvy if there exists a possibility that they > would have to make something work in an unfamiliar environment, > especially if it were to happen unexpectedly. If we ported our www > website server over to Ubuntu and then 6 months down the road we were > to upgrade our Joomla version and there became an issue with MariaDB > because it lacks some MySQL feature that it needs, or even that Joomla > would fail to recognize Maria as being equivalent to MySQL at some > point, then that would be a huge detraction against switching. I predict it will be the opposite. Once distros and people start switching to MariaDB, other projects will be testing on MariaDB by default, and compatibility with MySQL will then become problematic. Marc.

1 0

[Maria-discuss] New KB Question: ODBC
by Daniel Bartholomew 08 Feb '12

08 Feb '12

A new question has been posted to the Knowledgebase: http://kb.askmonty.org/en/mariadb-odbc ==================== Is there an ODBC driver for use with MariaDB that is compatible with the driver provided with MySQL? ==================== Thanks. -- Daniel Bartholomew MariaDB - http://mariadb.org Monty Program - http://montyprogram.com AskMonty Knowledgebase - http://kb.askmonty.org

1 0

[Maria-discuss] New KB Question: Locking SQL_MODE against client changes
by Daniel Bartholomew 05 Feb '12

05 Feb '12

A new question has been posted in the Knowledgebase: http://kb.askmonty.org/en/locking-sql_mode-against-client-changes ==================== Is there any way for locking out sql_mode against client-side changes other than MySQL Proxy (which does not allow for SSL connections)? Perhaps some MariaDB-specific setting? ==================== Thanks. -- Daniel Bartholomew MariaDB - http://mariadb.org Monty Program - http://montyprogram.com AskMonty Knowledgebase - http://kb.askmonty.org

1 0

[Maria-discuss] auth_pam does not compile on OSX
by Terin Stock 20 Jan '12

20 Jan '12

The 5.2.10 version of MariaDB is not compiling for me (using homebrew) on OSX. The error and other information, is as follows. I've resolved the issue for now by passing in --without-plugin-auth_pam to configure. libtool: compile: /usr/bin/llvm-gcc -DHAVE_CONFIG_H -I. -I. -I../../include -I../../include -I/usr/local/Cellar/readline/6.2.1/include -DMYSQL_DYNAMIC_PLUGIN -O3 -w -pipe -march=core2 -msse4 -D_P1003_1B_VISIBLE -DSIGNAL_WITH_VIO_CLOSE -DSIGNALS_DONT_BREAK_READ -DIGNORE_SIGHUP_SIGQUIT -DDONT_DECLARE_CXA_PURE_VIRTUAL -c auth_pam.c -fno-common -DPIC -o .libs/auth_pam_la-auth_pam.o auth_pam.c:107: error: ‘pam_info’ redeclared as different kind of symbol /usr/include/security/openpam.h:104: error: previous declaration of ‘pam_info’ was here make[2]: *** [auth_pam_la-auth_pam.lo] Error 1 $ ./configure --without-docs --without-debug --disable-dependency-tracking --prefix=/usr/local/Cellar/mariadb/5.2.10 --localstatedir=/usr/local/var/mysql --sysconfdir=/usr/local/etc/ --with-extra-charsets=complex --without-readline --enable-assembler --enable-thread-safe-client --with-big-tables --without-plugin-innodb_plugin --with-mysqld-ldflags=-static --with-client-ldflags=-static --with-plugins=max-no-ndb --with-embedded-server --with-libevent C: /usr/bin/llvm-gcc => /usr/llvm-gcc-4.2/bin/llvm-gcc-4.2 CXX: /usr/bin/llvm-g++ => /usr/llvm-gcc-4.2/bin/llvm-g++-4.2 LD: /usr/bin/llvm-gcc => /usr/llvm-gcc-4.2/bin/llvm-gcc-4.2 CFLAGS: -O3 -w -pipe -march=core2 -msse4 CXXFLAGS: -O3 -w -pipe -march=core2 -msse4 -O3 -fno-omit-frame-pointer -felide-constructors CPPFLAGS: -I/usr/local/Cellar/readline/6.2.1/include LDFLAGS: -L/usr/local/Cellar/readline/6.2.1/lib MAKEFLAGS: -j4 -- #Terin Stock

4 5

[Maria-discuss] pam plugin does't compile on FreeBSD
by geoffroy desvernay 09 Jan '12

09 Jan '12

Hi everyone, I'm mariadb's port maintainer for FreeBSD, and I'd like to get it compile before pushing the 5.2.10 update... Seems to be the same problem than under OSX: (with openpam) https://lists.launchpad.net/maria-discuss/msg00506.html Under FreeBSD 9.0RC3 (and 8.2) amd64: libtool: compile: cc -DHAVE_CONFIG_H -I. -I. -I../../include -I../../include -I/usr/local/include -DMYSQL_DYNAMIC_PLUGIN -O2 -pipe -fno-strict-aliasing -MT auth_pam_la-auth_pam.lo -MD -MP -MF .deps/auth_pam_la-auth_pam.Tpo -c auth_pam.c -fPIC -DPIC -o .libs/auth_pam_la-auth_pam.o auth_pam.c:107: error: 'pam_info' redeclared as different kind of symbol /usr/include/security/openpam.h:102: error: previous declaration of 'pam_info' was here *** Error code 1 1 error *** Error code 1 1 error *** Error code 1 1 error *** Error code 1 Sergei Golubchik wrote 'Fixed' in the referenced mail, but I don't know if it's fixed by removing pam support for OSX or ? (did not find any difference in bzr branch 5.2) Should I disable pam support for FreeBSD or is there any patch I could include in the port for 5.2.10 ? Thanks, -- *Geoffroy Desvernay* C.R.I - Administration systèmes et réseaux Ecole Centrale de Marseille

2 2

[Maria-discuss] MariaDB 5.3.3-rc now available
by Daniel Bartholomew 21 Dec '11

21 Dec '11

The MariaDB project would like to announce the availability of MariaDB 5.3.3-rc, the latest addition to our growing lineup of supported software. MariaDB 5.3.3-rc is the first Release Candidate release in the 5.3 series. We hope to follow it up soon with a stable (GA) 5.3 release. == MariaDB 5.3.3-rc Release Notes, Changelog, Downloads =============== The release notes for MariaDB 5.3.3-rc are available from: http://kb.askmonty.org/en/mariadb-533-release-notes A complete changelog for this beta is available from: http://kb.askmonty.org/en/mariadb-533-changelog Sources, binaries and packages can be downloaded from: http://downloads.askmonty.org/mariadb/5.3.3/ Debian and Ubuntu packages (now including Ubuntu 11.10 "Oneiric") are available from our mirrored apt repositories. A sources.list generator can be found at: http://downloads.askmonty.org/mariadb/repositories/ == About MariaDB 5.3.3-rc ============================================= In MariaDB 5.3.3-rc there are a couple of changes compared to previous 5.3 releases: === Performance: Several optimizer features introduced in MariaDB 5.3 have been thoroughly tested, and switched on by default in 5.3.3. These include: * Subquery materialization (materialization=on) http://kb.askmonty.org/en/non-semi-join-subquery-optimizations * Semi-join optimizations (semijoin=on,firstmatch=on,loosescan=on) http://kb.askmonty.org/en/semi-join-subquery-optimizations * Derived table optimization (derived_merge=on,derived_with_keys=on) (Documentation is being worked on) * Index Condition Pushdown (index_condition_pushdown=on) http://kb.askmonty.org/en/index-condition-pushdown * Nested loop join will use its Block-based variant more aggressively http://kb.askmonty.org/en/block-based-join-algorithms * Block-based join for OUTER JOINs (outer_join_with_cache=on) * Block-based join for semi-joins (semijoin_with_cache=on) * Linked join buffers (more aggressive buffering of multi-way joins) (@@join_cache_level==2) Also, DISTINCT and GROUP BY clauses are now removed from subqueries when possible. This allows for more efficient query plans. (backported from MySQL 5.6) === Usability: EXPLAIN output has been improved in MariaDB 5.3.3 to be easier to understand: * The select_type column now shows MATERIALIZED for subqueries that are executed with Materialization (it used to show SUBQUERY, which made it hard to distinguish materialized subqueries from other kinds subqueries). * For a Duplicate Elimination strategy, Start temporary is now shown at the first table from the subquery. See also: http://kb.askmonty.org/en/explain === GIS Operations: GIS precise operations were added in MariaDB 5.3.3 (Documentation for this is still being worked on). == About MariaDB 5.3 ================================================== The MariaDB 5.3 series introduces many new features, includes MariaDB 5.2, and is based on MariaDB 5.1 & MySQL 5.1. Some highlights of new features in MariaDB 5.3 include: - subquery optimizations that finally make subqueries usable - many optimizer changes, including Classic Hash Join, Batched Key Access, a new implementation of Multi-Range-Read optimizations as well as Index Condition Pushdown - NoSQL-style interfaces via the HandlerSocket plugin as well as dynamic columns - group commit in XtraDB when the binary log is enabled - Microsoft Windows performance improvements These are just some of the highlights, and for a more complete list of changes, please read the What is MariaDB 5.3 page: http://kb.askmonty.org/en/what-is-mariadb-53 == User Feedback plugin =============================================== MariaDB 5.3 includes a User Feedback plugin. This plugin is disabled by default. If enabled, it submits anonymous basic MariaDB usage information. This information will be used by the developers to track trends in MariaDB usage to better guide development efforts. If you would like to help make MariaDB better, please add --plugin-load=feedback.so to your my.cnf file! On Windows, add "feedback=ON" to your my.ini file, or click the checkbox during the installation of the MSI package. See http://kb.askmonty.org/en/user-feedback-plugin for more information. == MariaDB Crash Course book ========================================== We would also like to mention the book "MariaDB Crash Course", by Ben Forta. This book -- for beginner to intermediate level users -- will get you up and running with MariaDB, even if you've never used a database before. More information is available at: http://forta.com/books/0321799941/ == Quality ============================================================ The project always strives for quality, but in reality, nothing is perfect. Please take some time to report any issues you encounter at: https://bugs.launchpad.net/maria We hope you enjoy MariaDB 5.3.3-rc! -- Daniel Bartholomew MariaDB - http://mariadb.org Monty Program - http://montyprogram.com AskMonty Knowledgebase - http://kb.askmonty.org

1 0

[Maria-discuss] MariaDB fails to compile with boost
by Terin Stock 21 Dec '11

21 Dec '11

A downstream user is reporting that 5.2.8 (and, after fixing the already reported issue with auth_pam, 5.2.10) does not install with boost 1.48.0 installed. Removing boost from the link path allows MariaDB to compile successfully. I've attached their output, in hopes it will arrive to the list safely. :) -- #Terin Stock

2 1

[Maria-discuss] MariaDB 5.2.10 and 5.1.60 Released
by Daniel Bartholomew 06 Dec '11

06 Dec '11

This email is longer than usual, but that is because we are announcing today the availability of both MariaDB 5.2.10 and 5.1.60, the latest additions to our growing lineup of supported software. MariaDB 5.2.10 and 5.1.60 are primarily bug-fix updates to the previous 5.2.9 and 5.1.55 releases, respectively. == About MariaDB 5.2 MariaDB 5.2 contains features that didn't have time to go into MariaDB 5.1. For all practical purposes it's a drop in replacement for MariaDB 5.1 (and thus MySQL 5.1). The new features in 5.2 are quite isolated and as most have been in use by members in the MySQL community for a long time. Current versions of MariaDB 5.2 are stable. This is equivalent to a MySQL GA release. For a list of the various changes in the MariaDB 5.2 series, please see: * http://kb.askmonty.org/en/what-is-mariadb-52 === PAM authentication plugin in MariaDB 5.2.10 One change in MariaDB 5.2.10 which we want to make you aware of is the inclusion of a new open source PAM authentication plugin. See http://kb.askmonty.org/en/pam-authentication-plugin for more information. === Windows Binaries delayed Due to some issues with our Windows build server, the Windows binaries for 5.2.10 have been delayed. They should be released soon. === MariaDB 5.2.10 Release Notes, Changelog, Downloads See the following pages for more information on MariaDB 5.2.10 and to download it: * http://kb.askmonty.org/en/mariadb-5210-release-notes * http://kb.askmonty.org/en/mariadb-5210-changelog * http://downloads.askmonty.org/mariadb/5.2.10/ == About MariaDB 5.1 MariaDB 5.1 is a binary drop in replacement of MySQL 5.1, but with performance like MySQL 5.5 (thanks to XtraDB), fewer bugs, and more features. Thanks to the extended and improved mysql_upgrade program it's also easier to upgrade from MySQL 5.0 to MariaDB 5.1 than to MySQL 5.1. MariaDB 5.1 is based on MySQL 5.1. In particular, MariaDB 5.1.60 is based on MySQL 5.1.60, with many improvements. For a list of the various improvements in the MariaDB 5.1 series, please see: * http://kb.askmonty.org/en/what-is-mariadb-51 === MariaDB 5.1.60 Release Notes, Changelog, Downloads See the following pages for more information on MariaDB 5.1.60 and to download it: * http://kb.askmonty.org/en/mariadb-5160-release-notes * http://kb.askmonty.org/en/mariadb-5160-changelog * http://downloads.askmonty.org/mariadb/5.1.60/ == Debian & Ubuntu Software Repositories Debian and Ubuntu packages are available from our mirrored apt repositories. A sources.list generator can be found at: http://downloads.askmonty.org/mariadb/repositories/ == MariaDB Crash Course book We would also like to mention the book "MariaDB Crash Course", by Ben Forta. This book -- for beginner to intermediate level users -- will get you up and running with MariaDB, even if you've never used a database before. More information is available at: http://forta.com/books/0321799941/ == Reporting issues The project always strives for quality, and being a beta release, we know that not everything may be perfect. Please take some time to report any issues you may encounter at: https://bugs.launchpad.net/maria Enjoy MariaDB 5.2.10 and 5.1.60! -- Daniel Bartholomew MariaDB - http://mariadb.org Monty Program - http://montyprogram.com AskMonty Knowledgebase - http://kb.askmonty.org

1 1

[Maria-discuss] Oneric DEBs are missing?
by Colin Charles 18 Nov '11

18 Nov '11

Hi! http://mirror.aarnet.edu.au/pub/MariaDB/repo/5.3/ubuntu/dists/ The mirror select tool allows you to choose Oneric as a distribution, but it seems to be missing from all the mirrors This probably needs to be fixed -- Colin Charles, http://bytebot.net/blog/ | twitter: @bytebot | skype: colincharles MariaDB: Community developed. Feature enhanced. Backward compatible. Download it at: http://www.mariadb.org/ Open MariaDB/MySQL documentation at the Knowledgebase: http://kb.askmonty.org/

2 1

[Maria-discuss] MariaDB 5.2.7 to 5.2.9 changes new bugs ?
by GEORGE LIU 13 Nov '11

13 Nov '11

First time posting to this list :) I've been using MariaDB since 5.2.4 for everyone of my side projects without issues. But having a problem while playing with Tungsten Replicator based replication. All worked fine with MariaDB 5.2.7 but since upgrading to MariaDB 5.2.9 via rpm on CentOS 6.0 64bit, I have been having problems getting Tungsten Replicator to play nice. Logged a bug report at http://code.google.com/p/tungsten-replicator/issues/detail?id=256 and the Tungsten Replicator folks say it could be possibly a problem with newer MariaDB 5.2.9 release ? Not sure who I should be contacting or whether or not MariaDB folks have already been made aware of this issue ? cheers

2 1

[Maria-discuss] New KB Question: Connecting to a Mariadb database with visual basic express 2010
by Daniel Bartholomew 08 Nov '11

08 Nov '11

A new question has been posted to the AskMonty Knowledgebase: http://kb.askmonty.org/en/connecting-to-a-mariadb-database-with-visual-basi… ----------------------------------------------------------------------- I have tried everything I know how to do -- to connect to an existing mariadb database with visual basic 2010 express. Can anyone give me any ideas on how to get a proper start. I am trying to connect to the localdb server created by heidi, which is a tcp/ip . Microsoft SQL server is installed. ----------------------------------------------------------------------- Thanks. -- Daniel Bartholomew MariaDB - http://mariadb.org Monty Program - http://montyprogram.com AskMonty Knowledgebase - http://kb.askmonty.org

1 0

[Maria-discuss] PlanetMariaDB glitch - resolved
by Arjen Lentz 07 Nov '11

07 Nov '11

Hi all This morning planetmariadb.org would show no feeds and no content. Config and db was all fine, and an agressive clearing of the rss/output cache appears to have resolved the issue. Not sure what caused the problem though, which is annoying. By the way, if you do spot a problem, please shoot me an email - don't just leave a msg on #maria as that can be missed. thanks! Cheers, Arjen. -- Arjen Lentz, Exec.Director @ Open Query (http://openquery.com) Remote expertise & maintenance for MySQL/MariaDB server environments. Follow us at http://openquery.com/blog/ & http://twitter.com/openquery

1 0

[Maria-discuss] New KB Question: CentOS 5.x/6.x mysql-lib conflicts and postfix
by Daniel Bartholomew 01 Nov '11

01 Nov '11

A new question has been posted to the Knowledgebase: http://kb.askmonty.org/en/centos-5x6x-mysql-lib-conflicts-and-postfix ======================================================================= On a fresh CentOS 5.x/6.x 32bit or 64bit install, mysql 5.0.xx is installed. To install MariaDB 5.2.x rpms, mysql-lib needs to be removed for MariaDB-server to be installed. But removing mysql-lib via yum remove, removes postfix. If later you need to install postfix via yum it still requires mysql-lib, but installing mysql-lib installs mysql 5.0.x server again. yum install postfix Loaded plugins: fastestmirror, refresh-packagekit Loading mirror speeds from cached hostfile * base: mirror.averse.net * extras: mirror.averse.net * rpmforge: apt.sw.be * updates: mirror.averse.net Setting up Install Process Resolving Dependencies --> Running transaction check ---> Package postfix.x86_64 2:2.6.6-2.1.el6_0 set to be updated --> Processing Dependency: mysql-libs for package: 2:postfix-2.6.6-2.1.el6_0.x86_64 --> Finished Dependency Resolution Error: Package: 2:postfix-2.6.6-2.1.el6_0.x86_64 (updates) Requires: mysql-libs You could try using --skip-broken to work around the problem You could try running: rpm -Va --nofiles --nodigest Anyway to properly resolve this ? with MariaDB 5.2/5.3.x version of mysql-lib ?? ======================================================================= Thanks. -- Daniel Bartholomew MariaDB - http://mariadb.org Monty Program - http://montyprogram.com AskMonty Knowledgebase - http://kb.askmonty.org

1 0

[Maria-discuss] Aria_log file
by Richard Dunn 15 Oct '11

15 Oct '11

How do you read the 'aria_log.0000001' file in the data directory? If I open it with a text editor, It appears to be binary, but mysqlbinlog says that it is not. I'm asking because it looks like 5.3.1 is continually (every two minutes) writing to the log, even with no database activity. This impacts automatic sleep on my Macbook Pro.

3 4

[Maria-discuss] MariaDB 5.3.2-beta now available
by Daniel Bartholomew 14 Oct '11

14 Oct '11

The MariaDB project would like to announce the availability of MariaDB 5.3.2-beta, the latest addition to our growing lineup of supported software. MariaDB 5.3.2-beta is a bug-fix update to the previous 5.3.1 and 5.3.0 betas. == About MariaDB 5.3 The MariaDB 5.3 series introduces many new features, includes MariaDB 5.2, and is based on MySQL 5.1. Some highlights of new features in MariaDB 5.3 include: - subquery optimizations that finally make subqueries usable - many optimizer changes, including Classic Hash Join, Batched Key Access, a new implementation of Multi-Range-Read optimizations as well as Index Condition Pushdown - NoSQL-style interfaces via the HandlerSocket plugin as well as dynamic columns - group commit in XtraDB when the binary log is enabled - Microsoft Windows performance improvements These are just some of the highlights, and for a more complete list of changes, please read the What is MariaDB 5.3 page: http://kb.askmonty.org/en/what-is-mariadb-53 == About MariaDB 5.3.2-beta In the MariaDB 5.3.2-beta there are a couple of changes compared to previous 5.3 releases: === User Feedback plugin MariaDB 5.3.2-beta introduces the User Feedback plugin. This plugin is disabled by default. If enabled, it submits anonymous basic MariaDB usage information. This information will be used by the developers to track trends in MariaDB usage to better guide development efforts. If you would like to help make MariaDB better, please add --plugin-load=feedback.so to your my.cnf file! On Windows, add "feedback=ON" to your my.ini file, or click the checkbox during installation of the MSI package. See http://kb.askmonty.org/en/user-feedback-plugin for more information. === Subquery Cache now on by default Starting in MariaDB 5.3.2-beta, the Subquery cache is on by default. In previous versions of MariaDB the cache was off by default. The goal of the subquery cache is to optimize the evaluation of correlated subqueries by storing results together with correlation parameters in a cache and avoiding re-execution of the subquery in cases where the result is already in the cache. See http://kb.askmonty.org/en/subquery-cache for more information. == MariaDB 5.3.2-beta Release Notes, Changelog, Downloads The release notes for MariaDB 5.3.2-beta are available from: http://kb.askmonty.org/en/mariadb-532-release-notes A complete changelog for this beta is available from: http://kb.askmonty.org/en/mariadb-532-changelog Sources, binaries and packages can be downloaded from: http://downloads.askmonty.org/mariadb/5.3.2/ Debian and Ubuntu packages are available from our mirrored apt repositories. A sources.list generator can be found at: http://downloads.askmonty.org/mariadb/repositories/ The project always strives for quality, and being a beta release, we know that not everything may be perfect. Please take some time to report any issues you may encounter at: https://bugs.launchpad.net/maria Enjoy MariaDB 5.3.2-beta & Happy Testing! -- Daniel Bartholomew MariaDB - http://mariadb.org Monty Program - http://montyprogram.com AskMonty Knowledgebase - http://kb.askmonty.org

1 0

[Maria-discuss] Including MariaDB server and client in my package application???
by wahono sri 06 Oct '11

06 Oct '11

May I include MariaDB files in my software package to make easy for user if they don't know about db server and how to install and configure it to use as db server for my application. I'll prefer my users to choose options of installation package : 1. Acosys Version 4 2. MariaDB Client Library 3. MariaDB Server 4. .... Is it allowed by MariaDB licence? I read MariaDB licence but I am confusing to understand it clearly. Thanks Wahono

4 3

[Maria-discuss] Error install from binary tarballs
by wahono sri 30 Sep '11

30 Sep '11

I use PCLinuxOS and I can't install from RPM or from binary. I got this message from /data/localhost.localhost.err 110930 22:52:06 mysqld_safe Starting mysqld daemon with databases from ./data 110930 22:52:06 [ERROR] mysqld: File '/usr/local/mysql/data/aria_log_control' not found (Errcode: 13) 110930 22:52:06 [ERROR] mysqld: Got error 'Can't open file' when trying to use aria control file '/usr/local/mysql/data/aria_log_control' 110930 22:52:06 [ERROR] Plugin 'Aria' init function returned error. 110930 22:52:06 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed. 110930 22:52:06 [ERROR] Failed to initialize plugins. 110930 22:52:06 [ERROR] Aborting 110930 22:52:06 [Note] ./bin/mysqld: Shutdown complete 110930 22:52:06 mysqld_safe mysqld from pid file ./data/localhost.localdomain.pid ended 110930 22:54:34 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data 110930 22:54:34 [ERROR] ./bin/mysqld: ambiguous option '--o' (old-alter-table, optimizer_switch) 110930 22:54:34 [ERROR] Aborting 110930 22:54:34 mysqld_safe mysqld from pid file /usr/local/mysql/data/localhost.localdomain.pid ended 110930 22:56:00 mysqld_safe Starting mysqld daemon with databases from ./data 110930 22:56:00 [ERROR] ./bin/mysqld: ambiguous option '--o' (old-alter-table, optimizer_switch) 110930 22:56:00 [ERROR] Aborting 110930 22:56:00 mysqld_safe mysqld from pid file ./data/localhost.localdomain.pid ended 110930 23:00:45 mysqld_safe Starting mysqld daemon with databases from ./data 110930 23:00:45 [ERROR] ./bin/mysqld: ambiguous option '--o' (old-alter-table, optimizer_switch) 110930 23:00:45 [ERROR] Aborting 110930 23:00:45 mysqld_safe mysqld from pid file ./data/localhost.localdomain.pid ended 110930 23:01:00 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data 110930 23:01:01 [ERROR] ./bin/mysqld: ambiguous option '--o' (old-alter-table, optimizer_switch) 110930 23:01:01 [ERROR] Aborting 110930 23:01:01 mysqld_safe mysqld from pid file /usr/local/mysql/data/localhost.localdomain.pid ended 110930 23:01:10 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data 110930 23:01:10 [ERROR] ./bin/mysqld: ambiguous option '--o' (old-alter-table, optimizer_switch) 110930 23:01:10 [ERROR] Aborting 110930 23:01:10 mysqld_safe mysqld from pid file /usr/local/mysql/data/localhost.localdomain.pid ended 110930 23:03:41 mysqld_safe Starting mysqld daemon with databases from ./data 110930 23:03:41 [ERROR] ./bin/mysqld: ambiguous option '--o' (old-alter-table, optimizer_switch) 110930 23:03:41 [ERROR] Aborting 110930 23:03:41 mysqld_safe mysqld from pid file ./data/localhost.localdomain.pid ended How to fix this error? Thanks

2 1

[Maria-discuss] New KB Question: MariaDB 5.2.x server RPM fails on upgrades - error: scriptlet failed, exit status 1
by Daniel Bartholomew 30 Sep '11

30 Sep '11

A new question has been posted to the Knowledgebase: MariaDB 5.2.x server RPM fails on upgrades - error: scriptlet failed, exit status 1 http://kb.askmonty.org/en/mariadb-52x-server-rpm-fails-on-upgrades-error-sc… --------------------------------------------------------------------- This problem occurs on CentOS 5.5/5.6/6.0 32bit and 64bit from first time I used MariaDB 5.2.3 all the way to 5.2.9 upgrade. It happens 1) via manual RPM upgrade from RPM downloaded at http://downloads.askmonty.org/mariadb/5.2/#file_type=rpm or 2) via ourdelta YUM REPO update http://ourdelta.org/centos (yum update MariaDB*). Problem, MariaDB-server-5.2.x RPM updates fails and needs manually removing previous version MariaDB-server-5.2.x RPM before the new update installs. error error: %pre(MariaDB-server-5.2.9-102.el5.x86_64) scriptlet failed, exit status 1 error: install: %pre scriptlet failed (2), skipping MariaDB-server-5.2.9-102.el5 full details below ... (continued in the KB) --------------------------------------------------------------------- Thanks. -- Daniel Bartholomew MariaDB - http://mariadb.org Monty Program - http://montyprogram.com AskMonty Knowledgebase - http://kb.askmonty.org

2 2

[Maria-discuss] Microseconds support in MariaDB 5.3.
by Peter Laursen 28 Sep '11

28 Sep '11

I noticed: http://askmonty.org/blog/the-2-year-old-mariadb/ "The support for microseconds in TIMESTAMP, DATETIME, and TIME". I fully agree the 'full seconds support only' has been a sever limitation in MySQL. But I have two concerns with ths: 1) 'noisyness'. On not very fast systems the last digits of a TIME in microseconds should not be considered too much important. It depends on what else the system is doing at the time. I think for lots of users milliseconds and not microseconds would be better/more relevant. It is not always a lot of digits can be proven true. When we went to school we were all taught not to present results in natural sciences more accurate than the accuracy of data sources and measurements. Providing too many digits in a resuslt actually caused a lower score in my highschool! 2) Compability. There is a problem with UPDATES. A client/application written for MySQL may assume 'full seconds support only' and may generate the current MySQL format byte format in the WHERE clause (typically if the client reserves a 14 byte buffer for TIMERSTAMPS etc). In SQL: UPDATE table SET column = 'something' WHERE time_column = '01:01:01': .. this update will fail if the currently stored value is '01:01:01:010001'; and the rigth query in the context would be. UPDATE table SET column = 'something' WHERE time_column = '01:01:01:010001'; Ideally I think there should be a configuration parameter and a global variable to SET time_accuracy = full_second|millisecond|microsecond. Did somebody have considerations about same? I definitely think that lots of applications using a TIME|TIMESTAMP|DATETIME column in the WHERE-clause of an UPDATE statement will need some rewrite to be upgradable to MariaDB 5.3 -- Peter

6 7

[Maria-discuss] New KB Question: Stop/Start MariaDB
by Daniel Bartholomew 27 Sep '11

27 Sep '11

A new question has been posted to the Knowledgebase: http://kb.askmonty.org/en/stopstart-mariadb --------------------------------------------------------------------- When upgrading MariaDb, using DEB package manager,it always fails to stop the server and the upgrade fails. Also the server cannot be stopped from MySQl Workbench. However, I can stop ok from the terminal with the command 'sudo service mysql stop' and then run the update which restarts the server automatically. Not fatal but puzzling. (Using Ubuntu Natty 64 bit). --------------------------------------------------------------------- Thanks. -- Daniel Bartholomew MariaDB - http://mariadb.org Monty Program - http://montyprogram.com AskMonty Knowledgebase - http://kb.askmonty.org

1 0

[Maria-discuss] New KB Question: Index/optimizations in Dynamic Columns
by Daniel Bartholomew 20 Sep '11

20 Sep '11

A new question has been posted to the Knowledgebase: http://kb.askmonty.org/en/indexoptimizations-in-dynamic-columns --------------------------------------------------------------------- Greetz to all... I have been playing with the dynamic columns in MariaDB 5.3... Running your test queries I decided to do an explain on one of them: MariaDB [test]> explain SELECT name FROM t1 WHERE COLUMN_GET(dynstr, 1 as char(10)) = "red"; +----+-------------+-------+------+---------------+------+---------+------+------+-------------+ | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | +----+-------------+-------+------+---------------+------+---------+------+------+-------------+ | 1 | SIMPLE | t1 | ALL | NULL | NULL | NULL | NULL | 4 | Using where | +----+-------------+-------+------+---------------+------+---------+------+------+-------------+ 1 row in set (0.00 sec) I was just curious, do dynamic columns suffer from the same perf penalties at scale that non-indexed or function-based where criteria do? If they currently do, are there currently any plans to index/optimize dynamic columns for super fast at-scale data access? Best, Joshua --------------------------------------------------------------------- Thanks. -- Daniel Bartholomew MariaDB - http://mariadb.org Monty Program - http://montyprogram.com AskMonty Knowledgebase - http://kb.askmonty.org

1 0

[Maria-discuss] MariaDB 5.3.1-beta now available!
by Daniel Bartholomew 12 Sep '11

12 Sep '11

[The following was just sent to the MariaDB 'announce' list (subscribe at http://mariadb.org) Re-posting here for those that are not on that list.] The MariaDB project would like to announce the availability of MariaDB 5.3.1-beta, the latest addition to our growing lineup of supported software. MariaDB 5.3.1-beta is a bug-fix update to the previous 5.3.0-beta. The MariaDB 5.3 series introduces many new features, includes MariaDB 5.2, and is based on MySQL 5.1. Some highlights of new features in MariaDB 5.3 include: - subquery optimizations that finally make subqueries usable - many optimizer changes, including Classic Hash Join, Batched Key Access, a new implementation of Multi-Range-Read optimizations as well as Index Condition Pushdown - NoSQL-style interfaces via the HandlerSocket plugin as well as dynamic columns - group commit in XtraDB when the binary log is enabled - Microsoft Windows performance improvements These are just some of the highlights, and for a full list of changes, please read the What is MariaDB 5.3 page: http://kb.askmonty.org/en/what-is-mariadb-53 A complete changelog for this beta is available from: http://kb.askmonty.org/en/mariadb-531-changelog Sources, binaries and packages can be downloaded from: http://downloads.askmonty.org/mariadb/5.3.1/ Debian and Ubuntu packages are available from repositories. A sources.list generator can be found at: http://downloads.askmonty.org/mariadb/repositories/ The project always strives for quality, and being a beta release, we know that not everything can be perfect. Please take some time to report any issues you may encounter at: https://bugs.launchpad.net/maria Enjoy MariaDB 5.3.1-beta & Happy Testing! -- Daniel Bartholomew MariaDB - http://mariadb.org Monty Program - http://montyprogram.com AskMonty Knowledgebase - http://kb.askmonty.org

1 0

[Maria-discuss] MariaDB compilation on old Linux
by Daniel Bartholomew 12 Sep '11

12 Sep '11

A new question has been posted to the Knowledgebase: http://kb.askmonty.org/en/mariadb-compilation-on-old-linux ---------------------------------------------------------------------- I still have to use MandrakeLinux 10.0 having MySQL v.4.0.22 in its repository. Is it possible to build binary rpm-packages (binary in /usr/bin, data in /var/lib/mysql and etc) of fresh MariaDB on old Linux distribution like MandrakeLinux 10.0 (something like `rpmbuild -bb mysql.spec`)? ---------------------------------------------------------------------- Thanks. -- Daniel Bartholomew MariaDB - http://mariadb.org Monty Program - http://montyprogram.com AskMonty Knowledgebase - http://kb.askmonty.org

1 0

[Maria-discuss] failed to initialize plugins error
by Patrick Galbraith 10 Sep '11

10 Sep '11

Hi all! Moin moin, Privet! I have the latest 5.3 compiled as well as a client's own storage engine. The compile, link, all went well. I do notice they only compile their engine statically, but see symbols for it in mysqld: ... 000000000081d4f0 T filepro_rkey 000000000081d9f0 T filepro_rnext 000000000081da80 T filepro_rprev 000000000081d350 T filepro_rrange 000000000081db20 T filepro_rrnd 000000000081ddc0 T filepro_scan 000000000081dde0 T filepro_scan_init 0000000000e747c8 B filepro_share_list 0000000000e52ea0 D filepro_storage_engine 000000000081de00 T filepro_update 000000000081e020 T filepro_write 0000000000e74798 b ha_filepro_exts ... So, when I start mysqld, I get the error: "[ERROR] Failed to initialize plugins." If I run this with strace, I don't see it trying to load a particular shared library file, just it logging messages to the log, opening replication log and index. So, not sure what I need to load with "plugin_load". When I configured MariaDB top compile, I used the following (per what the client uses with their successful build of MySQL 5.1.30) ./configure --with-plugins=all --without-plugin-oqgraph --with-charset=utf8 --enable-assembler --enable-profiling --enable-community-features --without-plugin-ndbcluster --prefix=/usr/local/maria I'm guessing that I'm missing something obvious and simple? Thank you in advance for any help! Patrick

3 2

[Maria-discuss] Native SQL-Connector for LibreOffice/OpenOffice
by Daniel Bartholomew 07 Sep '11

07 Sep '11

A new question has been posted to the Knowledgebase: http://kb.askmonty.org/en/native-sql-connector-for-libreofficeopenoffice --------------------------------------------------------------------- Hello, I have been using OO/LO for years and have used both the Java-Connector but also ODBC under both Debian-Linux and Windows-Vista. When it became available I switched to the Native MySQL-Connector as delivered by MySQL. Oracle now has obviously got rid of that connector. Is there or are there any plany for a native connector to LO/OO in MariaDB? Thanks for your help and regards H. Stoellinger Salzburg --------------------------------------------------------------------- Thanks. -- Daniel Bartholomew MariaDB - http://mariadb.org Monty Program - http://montyprogram.com AskMonty Knowledgebase - http://kb.askmonty.org

1 0

[Maria-discuss] Is there any java connector for MariaDB than the one from Mysql(mysql-java-5.1.6.jar) ?
by Daniel Bartholomew 01 Sep '11

01 Sep '11

A new question has been posted to the Knowledgebase: http://kb.askmonty.org/en/is-there-any-java-connector-for-mariadb-than-the-… ---------------------------------------------------------------------- For licensing purposes, we try to remove any link to MySQL connectors, we found for Delphi and .NET, but we did not yet find any for java. Does anyone know a third party components that can be used as java connector for MariaDB ? ---------------------------------------------------------------------- Thanks. -- Daniel Bartholomew MariaDB - http://mariadb.org Monty Program - http://montyprogram.com AskMonty Knowledgebase - http://kb.askmonty.org

1 0

Re: [Maria-discuss] GUI/Workbench for MariaDB Aria?
by Peter Laursen 31 Aug '11

31 Aug '11

'transactional' in Aria will eanable crash recovery for the table. It will not make the table transactional (ie. START TRANSACTION, COMMIT, ROLLBACK etc.) are still ignored. Probably it was originaly intended to have it trasactional over time but I do not think focus is there at the moment. Byt yes .. it is just a checkbox and would be simple to add to any GUI (conditionally if engine = ARIA). But I think that if people want (user-)tables with the Aria engine you would use '1' in most if not all cases (temproary tables created by server internally is another thing). -- Peter On Wed, Aug 31, 2011 at 07:47, Ansgar Becker <ansgar.becker(a)googlemail.com>wrote: > Hi all, > I'm a bit unsure what this option really does, now that Peter said it > doesn't make a table transactional, but I'm sure there is a reason for why > it exists. So I'll see if I can add a checkbox right besides the engine drop > down, which is enabled only if Aria is selected. Also I need to read out > this attribute in existing tables, which needs some adjustment in my CREATE > TABLE parser. > > Ansgar > > Am 30.08.2011 19:31, schrieb Peter Laursen: > > We have the same request for SQLyog: > http://code.google.com/p/sqlyog/issues/detail?id=538 > > Of course a client is never engine-specific. But that is not the same > that a client has GUI fucntionalities to su > > @Vlad you probably know that your company (Monty Program) and mine > (Webyog) are partners (what means customers will gain a rebate to our > products when comming from Monty Program website. Check it out or ask Monty > himself). Not that I would mind that Ansgar adds this to Heidi. But > basically we never found it very important. Even if ARIA is set to > transactioanl = 1 , it is not transactional. it has crash recovery what is > not the same. > > > Peter > Webyog > > On Tue, Aug 30, 2011 at 19:11, Vladislav Vaintroub <wlad(a)montyprogram.com>wrote: > >> I'm forwarding this to Ansgar, as a feature request for HeidiSQL. May be >> tricky to add it as Aria-specific option, currently CREATE TABLE >> options/checkboxes in HeidiSQL seem to be not engine dependent to me. >> >> > -----Original Message----- >> > From: maria-discuss- >> > bounces+wlad=montyprogram.com(a)lists.launchpad.net [mailto:maria- >> > discuss-bounces+wlad=montyprogram.com(a)lists.launchpad.net] On Behalf >> > Of Daniel Bartholomew >> > Sent: Dienstag, 30. August 2011 18:50 >> > To: Maria Discuss >> > Subject: [Maria-discuss] GUI/Workbench for MariaDB Aria? >> > >> > New question on the Knowledgebase: >> > >> > http://kb.askmonty.org/en/guiworkbench-for-mariadb-aria >> > >> > Does anybody know a good GUI/Work bench tool to handle ARIA >> > transactional=1/0 and row_format=PAGE situations? >> > >> > Thanks. >> > >> > -- >> > Daniel Bartholomew >> > MariaDB - http://mariadb.org >> > Monty Program - http://montyprogram.com >> > AskMonty Knowledgebase - http://kb.askmonty.org >> > >> > >> > _______________________________________________ >> > Mailing list: https://launchpad.net/~maria-discuss >> > Post to : maria-discuss(a)lists.launchpad.net >> > Unsubscribe : https://launchpad.net/~maria-discuss >> > More help : https://help.launchpad.net/ListHelp >> >> >> _______________________________________________ >> Mailing list: https://launchpad.net/~maria-discuss >> Post to : maria-discuss(a)lists.launchpad.net >> Unsubscribe : https://launchpad.net/~maria-discuss >> More help : https://help.launchpad.net/ListHelp >> > > >

1 0