- discuss - lists.mariadb.org

[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