- discuss - lists.mariadb.org

[Maria-discuss] PBXT issues
by Alexandre Almeida 06 May '10

06 May '10

Hi Guys, I am setting an enviroment with MariaDB + PBXT, but, I am pretty much disappointed. Do you know if this time (see below) makes sense? Five hours to create a PBXT table with 10mio records... It's too much!!! See my steps: create table telpbxt like telinno; Query OK, 0 rows affected (0,50 sec) fis-> alter table telpbxt engine = pbxts; Query OK, 0 rows affected, 1 warning (0,07 sec) Records: 0 Duplicates: 0 Warnings: 0 fis-> alter table telpbxt engine = pbxt; Query OK, 0 rows affected (0,26 sec) Records: 0 Duplicates: 0 Warnings: 0 fis-> show create table telpbxt; +--------- +-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Table | Create Table | +--------- +-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | telpbxt | CREATE TABLE `telpbxt` ( `cpf` bigint(20) DEFAULT NULL, `nome` varchar(100) DEFAULT NULL, `log` varchar(100) DEFAULT NULL, `endereco` varchar(100) DEFAULT NULL, `comp1` varchar(100) DEFAULT NULL, `comp2` varchar(100) DEFAULT NULL, `bairro` varchar(100) DEFAULT NULL, `cidade` varchar(100) DEFAULT NULL, `cep` varchar(100) DEFAULT NULL, `ddd` varchar(100) DEFAULT NULL, `telefone` varchar(100) DEFAULT NULL, KEY `idx2` (`nome`(10)) ) ENGINE=PBXT DEFAULT CHARSET=latin1 | +--------- +-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0,00 sec) fis-> insert into telpbxt select * from tel; Query OK, 10262048 rows affected (5 hours 2 min 22,14 sec) Records: 10262048 Duplicates: 0 Warnings: 0

4 11

[Maria-discuss] bug or not bug? ;-)
by Alexandre Almeida 05 May '10

05 May '10

Guys, everytime I run the following command: show global status like 'created%tmp%tables' the created_tmp_tables is incremented by 1. Is that right? I mean, which relationship between a show global (that will perform a minimum select at information_schema) and a new temporary table? I would appreciate your comments. Alex

2 2

[Maria-discuss] New Maria Docs list
by Daniel Bartholomew 05 May '10

05 May '10

All, I've created a new "Maria Docs" Launchpad team and mailing list for documentation-related discussions (including things like documentation for current and upcoming releases of MariaDB, planning and discussion of the askmonty.org knowledgebase, and so on). The group is open to everyone. https://launchpad.net/~maria-docs Thanks! -- Daniel Bartholomew Monty Program - http://askmonty.org

1 0

[Maria-discuss] MariaDB shutdowns silently
by Joshua Partogi 23 Apr '10

23 Apr '10

Dear all, I am currently running MariaDB in production and I often found it would shutdown itself silently after inactivity. The application itself is using Ruby on Rails. I have disabled the max_timeout settings in my.cnf but the problem still occurs. Is there anything else I should watch out for to prevent this issue continuing to occur? Thank you very much for your assistance. Kind regards, Joshua -- http://twitter.com/scrum8

6 8

[Maria-discuss] What is the future of MariaDB
by Joshua Partogi 20 Apr '10

20 Apr '10

All, Many people were feeling uncertain whether to use MySQL when Sun was bought by Oracle. I was one of those people and that is why I chose MariaDB for my product now. But I need to know what is the plan for MariaDB in the future? Would there be any chance that MariaDB will be sold to another company just like MySQL got sold to Sun? Or would MariaDB always be a community owned? Kind regards, Joshua -- http://twitter.com/projexion

5 4

Re: [Maria-discuss] Fwd: MySQL Open Space
by Kristian Nielsen 09 Apr '10

09 Apr '10

Henrik Ingo <hingo(a)askmonty.org> writes: > Didn't you have something about Buildbot you wanted to do? Maybe even have > someone from Drizzle join - depending on what you had planned to talk about. I have not planned anything. But I'm happy to do a session going through various aspects of Buildbot if there is an interest. - Kristian. > ---------- Forwarded Message ---------- > > Subject: MySQL Open Space > Date: Friday 09 April 2010 > From: Colin Charles <byte(a)bytebot.net> > To: "Sheeri K. Cabral" <awfief(a)gmail.com>, Brian Aker <brian(a)tangent.org>, > Henrik Ingo <hingo(a)askmonty.org>, Giuseppe Maxia <giuseppe(a)mysql.com>, Peter > Zaitsev <pz(a)percona.com>, Arjen Lentz <arjen(a)openquery.com> > > Hi! > > You know there is a MySQL open space on the schedule for the > conference, in the same room that the MySQL Camp was held last year > > For the space to be properly utilised, I was wondering if people would > like to run side sessions there. > > Its on Tuesday (http://en.oreilly.com/mysql2010/public/schedule/detail/12348 > ), Wednesday (http://en.oreilly.com/mysql2010/public/schedule/detail/12349 > ) and also on Thursday (but possibly in a different room). > > http://forge.mysql.com/wiki/MySQL_Conference_Open_Space_2010 > > That should help, I think *grin* > > Please feel free to pass it around and see if we get lots of side > content. Things that weren't accepted. Things that require more than a > BoF. > > Cheers, > -c

2 1

[Maria-discuss] Generic Linux Build requirements
by Brian Evans 06 Apr '10

06 Apr '10

http://askmonty.org/wiki/index.php/Building_MariaDB:Generic_Linux says: * gcc 2.95.2 or later However, according to [1] , Gentoo claims that GCC 4.3 is required due the use of c++ templates in the server. [2] also states that GCC-4 is absolutely required with a failing build log. [1] http://bugs.gentoo.org/show_bug.cgi?id=307251#c5 [2] http://bugs.gentoo.org/show_bug.cgi?id=284946

3 4

[Maria-discuss] MariaDB 5.1.44 has been released
by Colin Charles 06 Apr '10

06 Apr '10

Dear MariaDB users, MariaDB 5.1.44, a new branch of the MySQL database which includes all major open source storage engines, myriad bug fixes, and many community patches, has been released. This release is based on MySQL 5.1.44. In includes performance improvements with Maria temporary tables, removal of mutexes and the aim of removing compiler errors is being achieved quite well! For an overview of what's new in MariaDB 5.1.44, please see: http://askmonty.org/wiki/Manual:MariaDB_5.1.44_Release_Notes For information on installing MariaDB 5.1.44 on new servers or upgrading to MariaDB 5.1.44 from previous releases, please see: http://askmonty.org/wiki/Manual:Installation MariaDB is available in source and binary form for a variety of platforms and is available from the download pages at: http://askmonty.org/wiki/MariaDB:Download:MariaDB_5.1.44 It is also our pleasure to announce that we have a partnership with Webyog to offer their tools for trial and at a discounted rate if purchased within 30 days. Find out more at: http://askmonty.org/downloads/links/webyog http://askmonty.org/wiki/MariaDB:Download#Software_Partner_Downloads We welcome and appreciate your feedback, bug reports, bug fixes, patches, and participation on our mailing list. Find out more at: http://askmonty.org/wiki/MariaDB#How_can_I_participate_in_the_development_o… Enjoy! -- Colin Charles, http://bytebot.net/blog/ "First they ignore you, then they laugh at you, then they fight you, then you win." -- Mohandas Gandhi

4 3

[Maria-discuss] Problems with Foreign Key
by Alexandre Almeida 06 Apr '10

06 Apr '10

Hi all, Any idea why I am getting this error: A) ERROR ALTER TABLE login -> ADD CONSTRAINT fk_db_perfil FOREIGN KEY (id_perfil) -> REFERENCES db_perfil (id_perfil) -> ON DELETE NO ACTION -> ON UPDATE NO ACTION;ERROR 1005 (HY000): Can't create table 'dbhomo_aa.#sql-c1f_281' (errno: 150)dbhomo_aa-> dbhomo_aa-> B) HERE IT WORKS dbhomo_aa-> ALTER TABLE login ADD CONSTRAINT fk_db_perfil FOREIGN KEY (id_perfil) REFERENCES dbhomo.db_perfil (id_perfil) ON DELETE NO ACTION ON UPDATE NO ACTION; Query OK, 35199 rows affected (3,27 sec) Records: 35199 Duplicates: 0 Warnings: 0 Note that when I change the database to the original database the command works as expected. Both tables are innodb, the permissions are fine. Thanks, Alex

2 1

[Maria-discuss] Reliable tarball source
by Brian Evans 02 Apr '10

02 Apr '10

I just noticed that MariaDB 5.1.44 was posted on askmonty.org but not lauchpad. What will be the most reliable URL to pull the latest source tarball when it is released? I'd prefer to make it automated as Gentoo can simply relate a build script name to a version.

2 1

[Maria-discuss] Why isn't SO_SNDTIMEO used?
by MARK CALLAGHAN 21 Mar '10

21 Mar '10

I describe how read/write is done for sockets in mysqld. http://www.facebook.com/note.php?note_id=122655300932 Can someone explain the history of this code? -- Mark Callaghan mdcallag(a)gmail.com

4 7

[Maria-discuss] Maria on Solaris X86
by Jim Grill 18 Mar '10

18 Mar '10

Hello, I’m having trouble getting MariaDB 5.1.42 working on Solaris 10x86. I’ve tried both the Binary package (mariadb-5.1.42-solaris11-i386) and building from source (mariadb-5.1.42). I don't know if it's something in the binary package or source code, something goofy on my system, or something goofy with how I'm building it. I'm assuming the latter, but thought I might bring it up anyway just in case it might help others running Solaris. :-) I can’t get the binary dist to startup. Here’s the error log from the binary dist (note the hostname missing from the error log name)… $ cat data/.err 100212 09:54:33 mysqld_safe Starting mysqld daemon with databases from /data01/mydata/mariadb-bin-tst/data ld.so.1: mysqld: fatal: relocation error: file bin/mysqld: symbol strnlen: referenced symbol not found 100212 09:54:33 mysqld_safe mysqld from pid file /data01/mydata/mariadb-bin-tst/mysql.pid ended I’m using SunStudio 12.1 to build from source. Here’s my configure and make: export PATH=/product01/sunstudio12.1/bin:${PATH} export LD_LIBRARY_PATH=/usr/lib:/usr/local/lib make distclean ASFLAGS="-m64" \ CC="cc-5.0" \ CFLAGS="-Xa -xstrconst -g -mt -D_FORTEC_ -m64" \ CXX="CC" \ CXXFLAGS="-noex -g -mt -D_FORTEC_ -m64" \ LIBS=-lmtmalloc \ ./configure \ --prefix=/product01/mysql/mariadb-5.1.42 \ --localstatedir=/product01/mysql/mariadb-5.1.42/data \ --libexecdir=/product01/mysql/mariadb-5.1.42/bin \ --with-extra-charsets=all \ --enable-thread-safe-client \ --enable-local-infile \ --with-zlib-dir=bundled \ --with-big-tables \ --with-readline \ --with-named-curses-libs=-lcurses \ --enable-assembler \ --enable-static \ --enable-shared /usr/sfw/bin/gmake [SNIP] gmake[1]: Entering directory `/home/mysql/jgrill/mariadb-5.1.42/dbug' source='dbug.c' object='dbug.o' libtool=no \ DEPDIR=.deps depmode=none /bin/bash ../depcomp \ cc-5.0 -DHAVE_CONFIG_H -I. -I. -I../include -I../include -I../include -Xa -xstrconst -g -mt -D_FORTEC_ -m64 -DHAVE_RWLOCK_T -DUNIV_SOLARIS -c dbug.c source='sanity.c' object='sanity.o' libtool=no \ DEPDIR=.deps depmode=none /bin/bash ../depcomp \ cc-5.0 -DHAVE_CONFIG_H -I. -I. -I../include -I../include -I../include -Xa -xstrconst -g -mt -D_FORTEC_ -m64 -DHAVE_RWLOCK_T -DUNIV_SOLARIS -c sanity.c rm -f libdbug.a ar cru libdbug.a dbug.o sanity.o ranlib libdbug.a source='my_main.c' object='my_main.o' libtool=no \ DEPDIR=.deps depmode=none /bin/bash ../depcomp \ cc-5.0 -DHAVE_CONFIG_H -I. -I. -I../include -I../include -I../include -Xa -xstrconst -g -mt -D_FORTEC_ -m64 -DHAVE_RWLOCK_T -DUNIV_SOLARIS -c my_main.c source='factorial.c' object='factorial.o' libtool=no \ DEPDIR=.deps depmode=none /bin/bash ../depcomp \ cc-5.0 -DHAVE_CONFIG_H -I. -I. -I../include -I../include -I../include -Xa -xstrconst -g -mt -D_FORTEC_ -m64 -DHAVE_RWLOCK_T -DUNIV_SOLARIS -c factorial.c /bin/bash ../libtool --preserve-dup-deps --tag=CC --mode=link cc-5.0 -Xa -xstrconst -g -mt -D_FORTEC_ -m64 -DHAVE_RWLOCK_T -DUNIV_SOLARIS -o factorial my_main.o factorial.o libdbug.a ../mysys/libmysys.a ../strings/libmystrings.a -lpthread -lthread -lposix4 -lsocket -lnsl -lm -lmtmalloc -lpthread -lthread libtool: link: cc-5.0 -Xa -xstrconst -g -mt -D_FORTEC_ -m64 -DHAVE_RWLOCK_T -DUNIV_SOLARIS -o factorial my_main.o factorial.o libdbug.a ../mysys/libmysys.a ../strings/libmystrings.a -lpthread -lthread -lposix4 -lsocket -lnsl -lm -lmtmalloc -lpthread -lthread -mt ld: warning: file libdbug.a ignored: unable to locate archive symbol table ld: warning: file ../mysys/libmysys.a ignored: unable to locate archive symbol table ld: warning: file ../strings/libmystrings.a ignored: unable to locate archive symbol table Undefined first referenced symbol in file my_thread_global_init my_main.o ld: fatal: Symbol referencing errors. No output written to factorial gmake[1]: *** [factorial] Error 1 gmake[1]: Leaving directory `/home/mysql/jgrill/mariadb-5.1.42/dbug' gmake: *** [all-recursive] Error 1 Here's my OS release information: # cat /etc/release Solaris 10 10/09 s10x_u8wos_08a X86 Copyright 2009 Sun Microsystems, Inc. All Rights Reserved. Use is subject to license terms. Assembled 16 September 2009 Thanks for taking the time to read this far. :-) Any help would be greatly appreciated. I've tried everything I can think of and have spent many hours doing so. I'm pretty excited to try out XtraDB, PBXT, and, of course, MariaDB. -- - Jim Grill

2 2

[Maria-discuss] Gentoo Ebuilds for MariaDB on GitHub
by Brian Evans 17 Mar '10

17 Mar '10

I have posted the build scripts for Gentoo onto GitHub. They can be found here: http://github.com/grknight/mariadb-gentoo Gentoo downstream uses git over bzr so I thought it was the best choice. Feel free to pull from it.

3 7

[Maria-discuss] problems with innodb
by Alexandre Almeida 12 Mar '10

12 Mar '10

Hi guys, I am building MariaDB from source and it doesn't come with innodb. I have tried the parameters: all and innobase. Is there anything else I can pass on command line to get innodb running at my MariaDB? Many thanks, Alex

3 4

[Maria-discuss] askmonty.org moving to a new server this Thursday (25 Feb)
by Daniel Bartholomew 25 Feb '10

25 Feb '10

All, I'm sending this to both Maria Developers and Maria Discuss to make sure it gets to everyone, sorry for any duplicates. Just a heads up for everyone: I will be moving the askmonty.org website from its current home to a new server this Thursday, 25 Feb. If all goes according to plan, the website will remain up during the move but will be read-only during the actual switch. askmonty.org is the only domain/website that will be impacted by this move, websites on any other domain (such as buildbot.askmonty.org) are not part of this move and will continue to function normally. I will send a notice out on Thursday when I start the process, and a final one once the move is complete and I've tested that things are working properly. Thanks! -- Daniel Bartholomew Monty Program - http://askmonty.org

3 4

[Maria-discuss] MariaDB 5.1.42 has been released
by Colin Charles 18 Feb '10

18 Feb '10

Dear MariaDB users, MariaDB 5.1.42, a new branch of the MySQL database which includes all major open source storage engines, myriad bug fixes, and many community patches, has been released. We are very proud to have made our first final release, and we encourage you to test it out and use it on your systems. For an overview of what's new in MariaDB 5.1.42, please see: http://askmonty.org/wiki/index.php/Manual:MariaDB_5.1.42_Release_Notes For information on installing MariaDB 5.1.42 on new servers or upgrading to MariaDB 5.1.42 from previous releases, please see: http://askmonty.org/wiki/index.php/Manual:Installation MariaDB is available in source and binary form for a variety of platforms and is available from the download pages at: http://askmonty.org/wiki/index.php/MariaDB:Download:MariaDB_5.1.42 It is also our pleasure to announce that we have a partnership with Webyog to offer their tools for trial and at a discounted rate if purchased within 30 days. Find out more at: http://askmonty.org/downloads/links/webyog http://askmonty.org/wiki/index.php/MariaDB:Download#Software_Partner_Downlo… We welcome and appreciate your feedback, bug reports, bug fixes, patches, and participation on our mailing list. Find out more at: http://askmonty.org/wiki/index.php/MariaDB#How_can_I_participate_in_the_dev… Enjoy! -- Colin Charles, http://bytebot.net/blog/ "First they ignore you, then they laugh at you, then they fight you, then you win." -- Mohandas Gandhi

3 4

[Maria-discuss] Josh Berkus on community
by Kurt von Finck 16 Feb '10

16 Feb '10

Nice set of points on bad community management raised by Josh Berkus. http://lwn.net/SubscriberLink/370157/31a2534da9d465d3/ Do you disagree with any? Are there any things you would add? Do you think our projects suffer from any of these problems, and what constructive criticism do you have? Also, is there stuff you'd like to see the Maria community do? I think these points are a good jumping-off point to make sure we do things right. -- ./k kurt von finck http://www.mneptok.com public key: keyserver.ubuntu.com key id: 5229D26A fingerprint: 127A A484 ADBF A5AD E7FB 8CD2 8913 18F4 5229 D26A Music is the space between the notes. - Debussy

5 4

[Maria-discuss] virtual columns
by Federico Razzoli 05 Feb '10

05 Feb '10

I've read that MariaDB 5.2 will support virtual columns and I've read the virtual columns' specifications: http://forge.mysql.com/wiki/MySQL_virtual_columns_ref_manual I think there is a problem in that document. In CREATE TABLE and in ALTER TABLE commands you can create a virtual column. The syntax allows to specify that the column is STORED, if you wish. But it does not allow to specify that it's NOT STORED. This causes a little problem: one can not switch a STORED column to NOT STORED - one must to DROP and re-ADD the column. Also, I have a question: will virtual columns be able to use UDF's? Cheers, Federico

2 2

[Maria-discuss] FYI: askmonty.org/buildbot is moving to buildbot.askmonty.org/buildbot
by Daniel Bartholomew 04 Feb '10

04 Feb '10

All, This is an FYI for everyone that uses our buildbot web interface: Due to an upcoming server move I am in the process of moving our buildbot web interface from http://askmonty.org/buildbot to http://buildbot.askmonty.org/buildbot Both of the above currently work (and point at the same data), but as of Friday 5 Feb 2010 at approx 09:00 US Eastern time, http://askmonty.org/buildbot will turn into a redirect. The redirect will handle all of your old bookmarks (i.e. they should still work), but I thought I should at least let everyone know so that you aren't surprised by the move. I've already updated all of the links I could find on the askmonty.org wiki. And if you are wondering why I kept the /buildbot subdirectory in place on the new subdomain, well, it was easier and safer to keep it in place, so I did. If you connect directly to http://buildbot.askmonty.org you will automatically be redirected to the /buildbot subdir. Thanks! -- Daniel Bartholomew Monty Program - http://askmonty.org

1 0

[Maria-discuss] Replication and auto-increment
by Brian Evans 29 Jan '10

29 Jan '10

I was reading over the replication discussion on maria-developers I thought I'd share some thoughts that are not so technical as I do not understand the back end that well. Our system is currently a master-master WAN replication setup, each writing to a different DB with an offline process to do copies. Our databases extensively uses auto-increments on tables (more than necessary, but that's another story). Would future developments allow synchronous replication to occur on a single database when the WAN link has a single point of failure(SPoF)? How might an auto-increment system handle such a failure? This SPoF is our network link that can be a transient problem out of our control. Both sides may need to keep inserting data during this transient issue. This is usually not an issue 99% of the time, but it's better to prepare for downtime than trying to fix data errors in that 1%.

5 6

[Maria-discuss] MariaDB Twitter account
by Colin Charles 21 Dec '09

21 Dec '09

Hi! Does anyone know who runs the MariaDB twitter account? We'd like to get a hold of the login details, so that we can become more relevant on Twitter - i.e. start following people, answering questions, etc. If I don't get a response within 48 hours of this message, I'll contact Twitter to see if we can maybe get the account by them reassigning it to us. Cheers, -c -- Colin Charles, http://bytebot.net/blog/ "First they ignore you, then they laugh at you, then they fight you, then you win." -- Mohandas Gandhi

2 1

[Maria-discuss] Binding to network addresses
by Viljo Hakala 01 Dec '09

01 Dec '09

I am not sure whether this has been discussed. MySQL either binds to all network interfaces/addresses or to only single specified network address. Wouldn't this limitation be nice to have fixed in MariaDB, say I want to bind to 127.0.0.1 and a VIP network address, maybe management network address, but not to all network addresses on a server?

2 2

[Maria-discuss] Default Database Engine
by Richard Dunn 30 Nov '09

30 Nov '09

I have compiled and installed mariadb-5.1.39 on Mac OS X 10.6.2 and installed a 64-bit binary on CentOS 5. In both cases, MyISAM is still the default database engine. I would have expected it to be Maria. Did I miss something? Thanks, Richard

4 5

[Maria-discuss] [Kristian Nielsen] [Maria-developers] FOSDEM 2010
by Kristian Nielsen 11 Nov '09

11 Nov '09

It occured to me that this might be better to send to -discuss to get a wider audience. Sorry if you receive this twice. - Kristian.

1 0

[Maria-discuss] Additional promise to the MCA
by Henrik Ingo 09 Oct '09

09 Oct '09

Hi all As Monty blogged some time ago http://monty-says.blogspot.com/2009/08/thoughts-about-dual-licensing-open.h… ...we want to add a promise to our MariaDB contributors signing the MCA, that we will not use their contributions to restrict other licensees ability to contribute to Open Source. This text has now been approved by a lawyer. The question is, is it understandable? ********************************** Additional promise to contributions under the Monty Program Contributor Agreement Monty Program Ab promises to each contributor assigning rights under the Monty Program Ab Contributor Agreement, that when licensing 'products' (software), that include a contribution, to other 3rd parties, the license will be either i) an Open Source license (www.opensource.org) or ii) another license, in which case: * the other license will NOT restrict the licensee from making his own modifications to the product, including adding other suitably licensed code or other 'materials' from other sources (such as code available under suitable Open Source licenses) * the license will NOT restrict the licensee from publishing his own code or other 'materials' including, but not limited to, under an Open Source license. As a special note, it is observed that the Monty Program Ab Contributor Agreement itself fulfills these requirements. Also note that this promise does not not extend as a requirement to 3rd parties so as to restrict their rights to license products containing contributions. ********************************** We are especially interested to get feedback on the understandability of the last paragraph. henrik -- email: henrik.ingo(a)avoinelama.fi tel: +358-40-5697354 www: www.avoinelama.fi/~hingo book: www.openlife.cc

5 17

Re: [Maria-discuss] Information for release notes
by Daniel Bartholomew 28 Sep '09

28 Sep '09

Also posting this message to maria-discuss for those that might be interested in the changelog, but are not subscribed to maria-developers. On Thu, 24 Sep 2009 15:19:19 +0200, Kristian Nielsen <knielsen(a)knielsen-hq.org> wrote: Kristian> Hi Daniel, Kristian> Kristian> Here is a rough changelog written from reading through bzr Kristian> history. Kristian> Kristian> I took a dump of every commit in MariaDB that is not in MySQL Kristian> 5.1.38, and wrote this summary of the changes. Kristian> Kristian> I don't have sufficient knowledge to parse through all of the Kristian> Maria changes from before MariaDB started. Instead I wrote a Kristian> generic entry for the Maria storage engine, and also added Kristian> entries for what is already written (by Monty I think) on Kristian> http://askmonty.org/wiki/index.php/MariaDB_versus_MySQL Kristian> Kristian> So this is probably the best shot we have at a complete list Kristian> of relevant differences between MySQL and MariaDB. Do let me Kristian> know if anyone finds anything missing or any errors. Kristian> Kristian> Daniel, I hope you can use this as the basis for the release Kristian> notes. This list helps a lot. Thanks! Using the contents of the list, I have created a Changelog page on the wiki: http://askmonty.org/wiki/index.php/Manual:MariaDB_5.1_Changelog I organized the page into two sections: Features, and Bug Fixes. I also added links to the pages in the manual which exist for the changelog entries refer to. Kristian> Maybe this list will also be useful for you to fill out the Kristian> Manual on the Wiki. I am thinking you could check that all Kristian> new features are documented, and add pages for those that are Kristian> not. If not trivial, you could just make a stub page and ask Kristian> on maria-developers@ for someone to fill them out? Stub pages for the manual are easy to create: 1. add a link to the new page to http://askmonty.org/wiki/index.php/Manual:Contents 2. click on the new link 3. enter the following text into the new page: {{stub}} 4. save the new stub page To get things going, I created the following new stub pages for the manual: http://askmonty.org/wiki/index.php/Manual:Mysql_client_--abort-source-on-er… http://askmonty.org/wiki/index.php/Manual:XtraDB_storage_engine http://askmonty.org/wiki/index.php/Manual:Character_Set_Conversion_performa… http://askmonty.org/wiki/index.php/Manual:CHECKSUM_TABLE_performance Other stubs may need to be created, but I don't know which of the remaining topics need documentation or not. For example, does the entry about MariaDB NOT supporting NDB need it's own Manual page or not? Any contributions to the above stubs are *very* welcome. Any contributions to any of the other refman pages are likewise welcome: http://askmonty.org/wiki/index.php/Manual:Contents Henrik> Could the list itself be a basis for a changelog document and Henrik> then we make release notes into a more human readable document? Henrik> I thought that was your intention yesterday on IRC? The changelog page is a good compliment to the release notes page. The changelog is brief and is presented as a series of bullet points. The release notes page is longer with items presented as paragraphs in a more readable way. Thanks. -- Daniel Bartholomew

3 3

[Maria-discuss] License for MariaDB 5.1 Reference Manual
by Daniel Bartholomew 24 Sep '09

24 Sep '09

All, What license should we use for the MariaDB 5.1 Reference Manual? Some of the suggestions I've seen on IRC include: FDL : http://www.gnu.org/copyleft/fdl.html CreativeCommons : http://creativecommons.org My personal preference is to use the Creative Commons BY-SA license: http://creativecommons.org/licenses/by-sa/3.0/ This is the license used by Wikipedia and the share-alike part of the license ensures that the content remains open. It's a common license and is well understood and liked by a lot of people. Henrik mentioned the problem of attribution with CC licenses, but I don't think this is an issue with the mediawiki software we're using because of the edit histories and edit summaries, both of which fulfill this requirement. For example, the history page for the PBXT entry in the manual attributes me and Paul McCullagh for our contributions to the article: http://askmonty.org/wiki/index.php?title=Manual:PBXT_storage_engine&action=… I don't have much experience with the FDL, so if someone has reasons why we should use it, please share. Thanks. -- Daniel Bartholomew

3 2

[Maria-discuss] MariaDB 5.1 Reference Manual Introduction
by Daniel Bartholomew 22 Sep '09

22 Sep '09

All, The MariaDB 5.1 Reference Manual is progressing, but it needs an introduction. If you haven't taken a look at it yet, here is the TOC for the manual: http://askmonty.org/wiki/index.php/Manual:Contents At this stage we do not have a full or complete manual. Eventually we will have one, but creating it will take time. The purpose of the MariaDB 5.1 Reference Manual is to just document the differences between MariaDB 5.1 and MySQL 5.1 with the understanding that users can refer to the MySQL 5.1 manual for anything not covered in the MariaDB 5.1 manual. I'm currently working on an outline for the introduction page. One thing I think the intro should have is a version of the above paragraph to set expectations (we don't want users to think that we think our manual is complete). Beyond that, what other things should the introduction include? Also, if anyone knows of anything else which should be added to the manual, please let me know (or jump in and add it). Thanks. -- Daniel Bartholomew

1 0

Re: [Maria-discuss] [Maria-developers] MariaDB and the SCA
by Paul McCullagh 04 Sep '09

04 Sep '09

Hi Arjen, (Also posted to Maria-Discuss, so postings to Maria-Developers can be dropped on follow-up). On Sep 3, 2009, at 1:21 PM, Arjen Lentz wrote: > Hi Henrik, Kristian, > > On 03/09/2009, at 9:05 PM, Henrik Ingo wrote: >> On Thu, Sep 3, 2009 at 12:51 PM, Kristian >> Nielsen<knielsen(a)knielsen-hq.org> wrote: >>> Kristian Nielsen <knielsen(a)knielsen-hq.org> writes: >>> >>>> Davi Arnaut <Davi.Arnaut(a)Sun.COM> writes: >>>> >>>>> I've been monitoring the maria-developers list and there are some >>>>> patches that we would like to gradually incorporate into our >>>>> branches. For a practical example, i would like to merge into 5.1 >>>>> parts of this (http://tinyurl.com/q2ulgt) patch by Kristian. >>> >>>> Negotiations between Monty Program and Sun have started some time >>>> ago on a >>>> deal which would cover how Sun will get the rights it needs (ie. >>>> SCA) to >>>> include the MariaDB code into the MySQL code, and how Monty >>>> Program will >>>> receive compensation for giving these rights. As I understand it, >>>> these >>>> negotiations are however still in the early phase. >>> >>> Apparently, this is moving nowhere :-(. >>> >>> Davi, I'm sorry there has been no progress on this. We discussed >>> this again in >>> MariaDB, and would like to get things working better for now. >>> >>> What Monty suggested was that it would work for Sun if we submit >>> specific >>> patches under a BSD-new license. >>> >>> I realise that the http://tinyurl.com/q2ulgt patch request is now >>> so old that >>> it may be of no interest to you any longer. But if you have a >>> request for this >>> or other patches, please send them. All developers at Monty >>> Program have the >>> ability to submit their work to Sun at their own discretion, so we >>> should be >>> able to make this work on a low-overhead technician-to-technician >>> level. >> >> Thanks for picking this up. I just wanted to confirm this is true and >> we are happy to cooperate. > > > It's how it works with Drizzle. > However, I've blogged and otherwise written and spoken about this > before, it does not make me particularly happy. > > Here's the layout: > - the GPL parts of the code are owned by Sun. > - BSD can be incorporated non-OSS derivatives. > > And the consequenec of this is that Sun is able to perpetuate the > dual licensing model - a model which perhaps worked once upon a type > and did well, but which is definitely outdated, and only abused by > greedy salespeople. As far as I know, with the advent of the BSD licensed libdrizzle (https://launchpad.net/libdrizzle ), which also runs with MySQL (and I assume MariaDB), the dual licensing model is now irrelevant. My reading of the GPL license (http://www.gnu.org/copyleft/gpl.html) is that only programs that link GPL components become part of the greater work. From the GPL section "1. Source Code.": "For example, Corresponding Source includes interface definition files associated with source files for the work, and the source code for shared libraries and dynamically linked subprograms that the work is specifically designed to require, such as by intimate data communication or control flow between those subprograms and other parts of the work." So linked sub-programs are included. But: "However, it does not include the work's System Libraries, or general- purpose tools or generally available free programs which are used unmodified in performing those activities but which are not part of the work." So an unmodified free program like mysqld (the MySQL daemon), are not part of the work. This means that a programming linking libdrizzle, and then accessing mysqld over a communications _channel_ (like TCP, socket, pipe, etc), does not need to be GPL. > By agreeing to this arrangement, contributors ensure that Sun is > able to continue that. > Do you want that? > > "yes" might be a valid choice, on the basis that it might be more > important to get the changes upstream. > But I think the question needs to be asked explicitly. Hence. -- Paul McCullagh PrimeBase Technologies www.primebase.org www.blobstreaming.org pbxt.blogspot.com

4 7

Re: [Maria-discuss] [Maria-developers] MariaDB and the SCA
by Henrik Ingo 03 Sep '09

03 Sep '09

Hi Giuseppe I'm cross-posting to maria-discuss since this is now a non-technical discussion. Please remove maria-developers when replying. On Thu, Sep 3, 2009 at 3:01 PM, Giuseppe Maxia<g.maxia(a)gmail.com> wrote: > Why it's perfectly OK that MariaDB gets MySQL bugfixes for free and > instead it's a rip off if MySQL gets MariaDB bug fixes? Of course, all of the MariaDB source code is available as GPL, just like for MySQL. Sun is not prohibited from using it under the GPL, just like we are using MySQL code. > MariaDB requires the same kind of legal grants that Sun asks, and the > FAQ even states "The MCA is based on Sun's Contributor Agreement. We > think it is one of the best contributor agreements around! " > http://askmonty.org/wiki/index.php/MCA_FAQ We've made some adjustments, but yes, apparently it is one of the best contributor agreements around, the community seems to think. That's why we use it. > So, where is the catch? If Sun asks for the SCA, it's "greedy > salesmen". If MariaDB asks the same thing, it's "protecting the > community". Actually, it is very important that MariaDB copyrights are pooled to one owner, we could get into trouble if we didn't do that. (I won't give the details, so as not to give any ideas.) Same is true for XtraDB, where we have advised Percona to pool the copryights from any non-Percona contributors. It's not like we (MP) want to own everything, but somebody has to do it. Personally my first motivation in favor of pooling copyrights was however entirely benevolent towards MySQL and its users. By having the copyrights pooled in one place (rather than just going all GPL), we are able to assign the code back to Sun (if we so agree), and I'd really like to do that so that all MySQL users, also the commercial licensees would benefit from the MariaDB work. henrik -- email: henrik.ingo(a)avoinelama.fi tel: +358-40-5697354 www: www.avoinelama.fi/~hingo book: www.openlife.cc

3 2

[Maria-discuss] Compile failure on OS
by Sergey Petrunya 24 Aug '09

24 Aug '09

Hi! We're getting a compile error when trying to compile PBXT+Maria on ppc MacOS X: http://askmonty.org/buildbot/builders/macosx-g5-dbg/builds/12/steps/compile… looking at the bottom there, one sees: if ccache gcc -DHAVE_CONFIG_H -I. -I. -I../../../include -I../../../include -I../../../include -I../../../regex -I../../../storage/innobase/include -I../../../sql -I. -g -Wimplicit -Wreturn-type -Wswitch -Wtrigraphs -Wcomment -W -Wchar-subscripts -Wformat -Wparentheses -Wsign-compare -Wwrite-strings -Wunused-function -Wunused-label -Wunused-value -Wunused-variable -Wreorder -Wctor-dtor-privacy -Wnon-virtual-dtor -felide-constructors -fno-exceptions -fno-rtti -DUNIV_MUST_NOT_INLINE -DEXTRA_DEBUG -DFORCE_INIT_OF_VARS -DSAFEMALLOC -DPEDANTIC_SAFEMALLOC -O0 -g3 -gdwarf-2 -fno-implicit-templates -fno-exceptions -fno-rtti -D_P1003_1B_VISIBLE -DSIGNAL_WITH_VIO_CLOSE -DSIGNALS_DONT_BREAK_READ -DIGNORE_SIGHUP_SIGQUIT -DDONT_DECLARE_CXA_PURE_VIRTUAL -MT libpbxt_a-datalog_xt.o -MD -MP -MF ".deps/libpbxt_a-datalog_xt.Tpo" -c -o libpbxt_a-datalog_xt.o `test -f 'datalog_xt.cc' || echo './'`datalog_xt.cc; \ then mv -f ".deps/libpbxt_a-datalog_xt.Tpo" ".deps/libpbxt_a-datalog_xt.Po"; else rm -f ".deps/libpbxt_a-datalog_xt.Tpo"; exit 1; fi lock_xt.h: In function 'void xt_atomic_inc2(volatile u_int16_t*)': lock_xt.h:194: error: '__sync_fetch_and_add' was not declared in this scope lock_xt.h: In function 'void xt_atomic_dec2(volatile u_int16_t*)': lock_xt.h:209: error: '__sync_fetch_and_sub' was not declared in this scope lock_xt.h: At global scope: lock_xt.h:584: warning: 'struct XTRowLockList' only defines private constructors and has no friends lock_xt.h:640: warning: 'struct XTRowLocks' only defines private constructors and has no friends Is PBXT expected to work on MacOS X G5? BR Sergey -- Sergey Petrunia, Software Developer Monty Program AB, http://askmonty.org Blog: http://s.petrunia.net/blog

3 2

Re: [Maria-discuss] Compile failure on OS
by Hakan Kuecuekyilmaz 21 Aug '09

21 Aug '09

See also, Compile fails on Mac OS X PPC https://bugs.launchpad.net/bugs/415475 Best regards, Hakan Am 21.08.2009 um 15:58 schrieb Sergey Petrunya <psergey(a)askmonty.org>: > Hi! > > We're getting a compile error when trying to compile PBXT+Maria on > ppc MacOS X: > > http://askmonty.org/buildbot/builders/macosx-g5-dbg/builds/12/steps/compile… > > looking at the bottom there, one sees: > > if ccache gcc -DHAVE_CONFIG_H -I. -I. -I../../../include -I../../../ > include > -I../../../include -I../../../regex -I../../../storage/innobase/ > include > -I../../../sql -I. -g -Wimplicit -Wreturn-type -Wswitch - > Wtrigraphs > -Wcomment -W -Wchar-subscripts -Wformat -Wparentheses -Wsign-compare > -Wwrite-strings -Wunused-function -Wunused-label -Wunused-value > -Wunused-variable -Wreorder -Wctor-dtor-privacy -Wnon-virtual-dtor > -felide-constructors -fno-exceptions -fno-rtti -DUNIV_MUST_NOT_INLINE > -DEXTRA_DEBUG -DFORCE_INIT_OF_VARS -DSAFEMALLOC - > DPEDANTIC_SAFEMALLOC -O0 > -g3 -gdwarf-2 -fno-implicit-templates -fno-exceptions -fno-rtti > -D_P1003_1B_VISIBLE -DSIGNAL_WITH_VIO_CLOSE -DSIGNALS_DONT_BREAK_READ > -DIGNORE_SIGHUP_SIGQUIT -DDONT_DECLARE_CXA_PURE_VIRTUAL -MT > libpbxt_a-datalog_xt.o -MD -MP -MF ".deps/libpbxt_a-datalog_xt.Tpo" - > c -o > libpbxt_a-datalog_xt.o `test -f 'datalog_xt.cc' || echo > './'`datalog_xt.cc; \ > then mv -f ".deps/libpbxt_a-datalog_xt.Tpo" > ".deps/libpbxt_a-datalog_xt.Po"; else rm -f > ".deps/libpbxt_a-datalog_xt.Tpo"; exit 1; fi > lock_xt.h: In function 'void xt_atomic_inc2(volatile u_int16_t*)': > lock_xt.h:194: error: '__sync_fetch_and_add' was not declared in > this scope > lock_xt.h: In function 'void xt_atomic_dec2(volatile u_int16_t*)': > lock_xt.h:209: error: '__sync_fetch_and_sub' was not declared in > this scope > lock_xt.h: At global scope: > lock_xt.h:584: warning: 'struct XTRowLockList' only defines private > constructors and has no friends > lock_xt.h:640: warning: 'struct XTRowLocks' only defines private > constructors and has no friends > > Is PBXT expected to work on MacOS X G5? > > BR > Sergey > -- > Sergey Petrunia, Software Developer > Monty Program AB, http://askmonty.org > Blog: http://s.petrunia.net/blog > > _______________________________________________ > 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

[Maria-discuss] why does UNION ALL use a temp table?
by MARK CALLAGHAN 03 Aug '09

03 Aug '09

Why does UNION ALL use a temp table? Many users are surprised by this. It would be faster to return rows from each branch of a UNION ALL query directly to the network. -- Mark Callaghan mdcallag(a)gmail.com

3 6

[Maria-discuss] Launchpad RO mode
by Kurt von Finck 22 Jul '09

22 Jul '09

FYI ... > Launchpad will be in read-only mode for an hour on Wednesday, 22nd > July while we roll out new code. > > Going read-only: 22.00 UTC, Wednesday 22 July 2009 > Expected back to normal: 23.00 UTC, Wednesday 22 July 2009 > > There will be a couple of minutes around 22.00 UTC during which > Launchpad is unavailable while we switch into read-only mode, and then > another couple of minutes again when we switch back to read-write. > > Note that’s “UTC”. Actual time in your time zone may be different, > and remember Britain is in BST right now, which is 1 hour later than > UTC. > > Watch this list for details of the new release later this week. > > Best, > -Karl Fogel -- ./k kurt von finck http://www.mneptok.com public key: keyserver.ubuntu.com key id: 5229D26A fingerprint: 127A A484 ADBF A5AD E7FB 8CD2 8913 18F4 5229 D26A Music is the space between the notes. - Debussy

1 0