April 2013 - discuss - lists.mariadb.org

[Maria-discuss] Spider 3.0 is merged against MariaDB 10.0
by Colin Charles 12 May '13

12 May '13

Hi! Kentoku Shiba has merged the latest Spider 3.0 against MariaDB 10.0: https://code.launchpad.net/~kentokushiba/maria/10.0-spider-3.0 I would like to propose this for merging There is also a complete test suite now, and Kentoku has written some instructions: == testing Spider I pushed Spider into "lp:~kentokushiba/maria/10.0-spider-3.0". It's tested on "CentOS 6.3 x86_64" and "Windows 7 professional 32bit". Test command is the followings. > cd mysql-test > ./mysql-test-run.pl --mysqld=--innodb --suite=spider The following test command can't done yet, because it needs some change for MariaDB. > ./mysql-test-run.pl --mysqld=--innodb --suite=spider/bg Spider's background/parallel search feature works allocate and free result-set from data node on different thread, but MariaDB 10.0's "per thread memory usage" feature can't understand it. > ./mysql-test-run.pl --mysqld=--innodb --suite=spider/handler Table partition feature need to support "handler" command. I have a patch file. In addition, it is awesome to note that Kentoku & his team behind the development of Groonga storage engine have also won an award (Japan OSS Incentive Award): http://ossforum.jp/en/node/1277 Thanks cheers, -colin -- 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/

4 9

[Maria-discuss] Running LinkBench against MariaDB
by Colin Charles 09 May '13

09 May '13

Hi XL, Today, Facebook made LinkBench public (see: https://www.facebook.com/notes/facebook-engineering/linkbench-a-database-be…) It might be useful for us to run LinkBench benchmarks against MariaDB to see how we stack up on this workload The source is here: https://github.com/facebook/linkbench Hoping to see benchmark results for this soon cheers, -colin -- 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 1

[Maria-discuss] aria checksum
by Scott Feldstein 30 Apr '13

30 Apr '13

Hi, I have data which I want to store in the aria storage engine, the data is inserted then never updated or deleted, although the table could be truncated. This data could potentially be replicated in production. The data is inserted in parallel and once the table reaches a certain capacity data is no long inserted into it. My question is, would I want to turn on the checksum for this data? And, if yes, should I use table checksum or page checksum? What are the advantages / disadvantages of this? I tried searching docs and couldn't find a breakdown so if someone could answer this or point me to a doc or discussion that would be great. Right now I am using DYNAMIC row format since I want the smallest footprint possible. thanks, Scott

2 1

[Maria-discuss] New server, switch to MariaDB, different versions
by Tanstaafl 27 Apr '13

27 Apr '13

Hello, My current (8 yr old bare metal) server is currently running mysql 5.1.62, with just a couple of very small databases: postfixadmin and roundcube I am setting up a shiny new virtualized (ESXi host) server, that now has MariaDB 5.5.30 on it... My question is, can I do a dump from my old server running mysql 5.1.62, then restore that dump to my new server running MariaDB 5.5.30, run mysql_upgrade, and have any kind of reasonable expectation of it working? I'd rather not update the current (production) server to MariaDB (I'm gunshy when it comes to major changes on a production system). If not, then my other option would be to downgrade MariaDB on the new server to 5.1.66... but again, I'd rather not do that if it isn't necessary. Thanks - I'm really looking forward to saying goodbye to mysql (for political reasons, the software itself has served me well these 8 years, it's just too bad that they got bought by Oracle)... Charles

3 3

[Maria-discuss] Buildbot for Ubuntu Raring 13.04
by Colin Charles 25 Apr '13

25 Apr '13

Hi! Today Ubuntu released Raring 13.04 and we probably need to setup some VMs for that cheers, -colin -- 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] MariaDB 10.0.2-alpha now available
by Daniel Bartholomew 24 Apr '13

24 Apr '13

The MariaDB project is pleased to announce the immediate availability of MariaDB 10.0.2. This is an alpha release. MariaDB 10.0 is the development version of MariaDB. It is built on the MariaDB 5.5 series with backported features from MySQL 5.6 and entirely new features not found anywhere else. This is the third 10.0-based release, and we are releasing it now to get it into the hands of any who might want to test it. Not all features planned for the MariaDB 10.0 series are included in this release. Additional features will be pushed in future releases. See the release notes and changelog for details on what is new in this release. Do not use alpha releases on production systems. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 10.0.2 Alpha - Release Notes: http://kb.askmonty.org/en/mariadb-1002-release-notes - Changelog: http://kb.askmonty.org/en/mariadb-1002-changelog - Downloads: http://downloads.mariadb.org/mariadb/10.0.2 Overview of MariaDB 10.0: http://kb.askmonty.org/en/what-is-mariadb-100 APT and YUM Repository Configuration Generator: http://downloads.mariadb.org/mariadb/repositories/ - - 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 "feedback=ON" to your my.cnf (my.ini on Windows) file! See http://kb.askmonty.org/en/user-feedback-plugin for more information. - - Discontinued Builds - - - - - - - - - - - - - - - - - - - - - - - The MariaDB project tries to support as many different Operating Systems and Linux Distributions as we can. However, when a distribution or OS stops receiving security and other updates it becomes difficult to freely provide packages for that platform. In such cases, our policy is to deprecate that platform and stop providing binary packages for it. Accordingly, this will be the final release of MariaDB 10.0 for the following distributions: - Ubuntu 8.04 LTS "Hardy" - Ubuntu 11.10 "Oneiric" If your chosen Linux Distribution or Operating System is deprecated, packages or support are not completely unavailable. Companies such as SkySQL, Monty Program, and others provide support for all versions of MariaDB back to even very old MySQL versions. This includes packaged binaries. Contact them for more details. More information on the deprecation policy can be found at: https://kb.askmonty.org/en/mariadb-deprecation-policy/ - - Quality - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - The project always strives for quality, but in reality, nothing is perfect. Please take time to report any issues you encounter at: http://mariadb.org/jira - - Support MariaDB - - - - - - - - - - - - - - - - - - - - - - - - - - If you would like to contribute to MariaDB, please see our "contributing" and "donations" pages. We also have merchandise available in a cafepress store. - https://kb.askmonty.org/en/contributing - https://mariadb.org/en/donate/ - http://www.cafepress.com/mariadb We hope you enjoy MariaDB! -- MariaDB: An Enhanced Drop-in Replacement for MySQL Website - http://mariadb.org Twitter - http://twitter.com/mariadb Google+ - http://google.com/+mariadb Facebook - http://fb.com/MariaDB.dbms Knowledgebase - http://kb.askmonty.org Monty Program - http://montyprogram.com

1 0

[Maria-discuss] TokuDB + MariaDB: libjemalloc is important
by Colin Charles 23 Apr '13

23 Apr '13

Hi! Continuing on the interest in libjemalloc, and how we have a thread started on in, especially since Percona is building their server going forward using it (see: https://lists.launchpad.net/maria-discuss/msg00788.html) we've also had requests from Team Tokutek, that TokuDB also requires us building with jemalloc for a good experience. I'm adding Tim Callaghan to the discussion, as TokuDB has been building & releasing with it for over a year The other Callaghan who's on this list, Mark, has also made posts about jemalloc: https://www.facebook.com/MySQLatFacebook/posts/486784224710172 & https://www.facebook.com/notes/mysql-at-facebook/using-jemalloc-to-fix-a-pe… Shall we think about using a different malloc implementation? LD_PRELOAD may be the only option we have to change... (oh and test, benchmark, etc.) cheers, -colin -- 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] Fedora test day for replacing MySQL with MariaDB
by Colin Charles 18 Apr '13

18 Apr '13

Hi all, By now you must know of the movement to replace MySQL with MariaDB in Fedora-land (http://fedoraproject.org/wiki/Features/ReplaceMySQLwithMariaDB) One important thing is to ensure that MariaDB is a drop-in replacement. Fedora is a fast-moving high quality Linux distribution, so their focus aims are to ensure that MariaDB and MySQL are compatible, data can be migrated easily and there are minimal/no upgrade issues (and if so, they need to be documented) This is why on 30 April 2013, there is a Fedora test day dedicated to this very important task: http://fedoraproject.org/wiki/Test_Day:2013-04-30_MariaDB I plan to be on IRC for as long as humanly possible on #fedora-test-day (freenode) and will be watching the process closely. If you would like to participate, this is naturally welcome to help new MariaDB users Thanks! cheers, -colin -- 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] jemalloc used in Percona Server 5.5.30
by Colin Charles 13 Apr '13

13 Apr '13

Hi! Steve Meyers, a MariaDB user, is quite excited to see that libjemalloc is used for Percona Server 5.5.30 (http://www.stevemeyers.net/2013/04/percona-server-to-ship-with-jemalloc.html) He's wondering if we'll adopt this A note from the latest release notes: "Percona Server for MySQL will now be shipped with the libjemalloc library. Benchmark showing the impact of memory allocators on MySQL performance can be found in this blogpost." Blogpost: http://www.mysqlperformanceblog.com/2012/07/05/impact-of-memory-allocators-… cheers, -colin -- 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] We're accepted into Google Summer of Code 2013
by Colin Charles 10 Apr '13

10 Apr '13

Subject says it all We need people to sign up as mentors (http://www.google-melange.com/gsoc/homepage/google/gsoc2013) against the MariaDB project Students start opening up soon If you know of projects a student can complete in 3 months over a summer, this is the ideal place to list the task: https://kb.askmonty.org/en/google-summer-of-code-2013/ This is the first time MariaDB is going to participate. Some of you have done this in the past against MySQL or Drizzle. Big win for MariaDB this year! cheers, -colin -- 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] Google Summer of Code 2013 ideas page
by Colin Charles 09 Apr '13

09 Apr '13

Hi all, Team MariaDB wants to participate in Google Summer of Code 2013. We definitely want to ensure that students have lots to do within those three summer months plus continue being MariaDB developers Please contribute to the ideas page: https://kb.askmonty.org/en/google-summer-of-code-2013/ Thanks -- 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] KB Question: Creating forms
by Daniel Bartholomew 08 Apr '13

08 Apr '13

The following question has been posted in the AskMonty Knowledgebase: https://kb.askmonty.org/en/creating-forms/ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Creating forms I am new to MariaDB and MySQL. I am experienced with MS Access. I have an extensive Access DB that I want to convert to MariaDB. I have read MariaDB Crash Course. My question is what front-end do I use to create forms and reports? Is the best approach, use PHP or Python and create a web based application? - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Thanks. -- Daniel Bartholomew Google+ - http://gplus.to/dbart Twitter - http://twitter.com/daniel_bart MariaDB: An Enhanced Drop-in Replacement for MySQL Website - http://mariadb.org Twitter - http://twitter.com/mariadb Google+ - http://google.com/+mariadb Facebook - http://fb.com/MariaDB.dbms Knowledgebase - http://kb.askmonty.org Monty Program - http://montyprogram.com

1 0

[Maria-discuss] KB Question: Client library compatibility
by Daniel Bartholomew 04 Apr '13

04 Apr '13

The following question has been posted to the AskMonty Knowledgebase: https://kb.askmonty.org/en/client-library-compatibility/ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Hi, Two questions : You mention that the MariaDB client library is compatible with MySQL 5.5. What about its actual MariaDB-versionned compatibility ? I also noted that the client library code is in active and constant development. Is it aimed at evolving at the same time as MariaDB, or will we have, as it's the case for MySQL, a client library for each new MariaDB release ? Thanks in advance, Bruno - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Thanks. -- Daniel Bartholomew Google+ - http://gplus.to/dbart Twitter - http://twitter.com/daniel_bart MariaDB: An Enhanced Drop-in Replacement for MySQL Website - http://mariadb.org Twitter - http://twitter.com/mariadb Google+ - http://google.com/+mariadb Facebook - http://fb.com/MariaDB.dbms Knowledgebase - http://kb.askmonty.org Monty Program - http://montyprogram.com

1 0

[Maria-discuss] Single-threaded performance & optimizer overhead
by Colin Charles 03 Apr '13

03 Apr '13

Hi! Mark Callaghan asks this on Facebook: While testing single-threaded performance to compare MySQL 5.1 with 5.6 I think there is much more overhead in the optimizer in 5.6. Do you have benchmark results for a single-threaded workload with fast queries (like SELECT one row by PK from a cached table)? I am curious whether new versions of MariaDB have a similar increase in optimizer overhead. http://bugs.mysql.com/bug.php?id=68825 He also wrote a blog post: http://mysqlha.blogspot.com/2013/04/mysql-56-single-thread-update-only.html Might make a great post at our blog cheers, -colin -- 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/

3 2

Re: [Maria-discuss] [Dbmail] MariaDB and dbmail
by Reindl Harald 03 Apr '13

03 Apr '13

Am 03.04.2013 11:09, schrieb Sergej Pupykin: > At Tue, 02 Apr 2013 19:47:15 +0400, > Sergej Pupykin <ml(a)sergej.pp.ru> wrote: >> Not sure if it caused by migration to mariadb, but problem appeared >> near same time. > > Downgrading back from mariadb 5.5.30 to mysql 5.5.30 solves the > problem. It looks like mariadb has ordering problems or it is not > drop-in replacement of mysql i am CC'ing this to the MariaDB list.......... but "however when I run it from command line it works well" speaks against it - this is highly interesting since more and more distributions are switching to MariaDB including Fedora and i am at preparing the switch too with no problems until now _____________________________ zamri <myzamri(a)gmail.com> wrote: > MariaDB is fully compatible with MySQL. Migration is done. So far so good. Phewww!... > > Now I need to do some research on tuning mariadb if needed. I found that after migration following SQL returns wrong sorted data: SELECT l.part_key, l.part_depth, l.part_order, l.is_header, DATE_FORMAT(ph.internal_date,GET_FORMAT(DATETIME,'ISO')), data FROM dbmail_mimeparts p JOIN dbmail_partlists l ON p.id = l.part_id JOIN dbmail_physmessage ph ON ph.id = l.physmessage_id WHERE l.physmessage_id = <ID> ORDER BY l.part_key,l.part_order ASC; however when I run it from command line it works well. Probably it does not fail always because of not all emails damaged. Not sure if it caused by migration to mariadb, but problem appeared near same time.

3 3

Re: [Maria-discuss] [Dbmail] MariaDB and dbmail
by Sergej Pupykin 03 Apr '13

03 Apr '13

At Wed, 03 Apr 2013 14:35:59 +0400, Sergej Pupykin <ml(a)sergej.pp.ru> wrote: > > Yes, but > > $ systemctl stop postfix dbmail-imapd dbmail-timsieved dbmail-pop3d mysqld > $ pacman -S mysql-clients mysql libmysqlclient > $ systemctl start mysqld postfix dbmail-imapd dbmail-timsieved dbmail-pop3d > $ mysql_upgrade --force > > solves the problem. > > I tested it using telnet to imap port. > ? LOGIN ... > ? SELECT ... > ? FETCH <ID> body[] > and check order of mime parts. > > Also dbmail/libzdb code looks clean. It just get sql query results and > put them to IMAP client... Link to thread start: http://www.mail-archive.com/dbmail%40dbmail.org/msg18179.html

1 0