March 2012 - discuss - lists.mariadb.org

[Maria-discuss] explain for insert/update/delete
by MARK CALLAGHAN 11 Jul '25

11 Jul '25

Does MariaDB have any plans to support explain for insert/update/delete/replace/CTAS? There have been feature requests open for a very long time on official MySQL without any progress. I have had a few problems in production from 'bad' delete statements that had a very different plan than the select statement with the same where clause. The only way to check for a bad plan today is to use SHOW INNODB STATUS to determine whether the statement locks all rows in a table. http://bugs.mysql.com/bug.php?id=14745 http://bugs.mysql.com/bug.php?id=35355 -- Mark Callaghan mdcallag(a)gmail.com

2 1

[Maria-discuss] Compiling 5.5.20 on OS X
by Richard Dunn 03 Jun '12

03 Jun '12

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?

5 9

[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] 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