- discuss - lists.mariadb.org

[Maria-discuss] mariasql client question (zappajs, coffeescript, nodejs)
by klrumpf 05 Feb '13

05 Feb '13

Hi, I have switched from mysql to mariadb using it with the node-mysql client and this has been runing in prod. for some time. I now want to switch to the mariasql client... inspect = require('util').inspect mdbClient = require('mariasql') ... To do the many queries and simplify the source I wanted to write a principal function for queries that simply returns an object (or array) with the query result and then I could just re-use the existing functionality for the render. So I copied this from the examples doSql = (sqlstring) -> c = new mdbClient() c.connect host: 'localhost' db: 'xyz' # NOT database user: 'abc' password: 'defghi' c.on("connect", -> console.log "Client connected" ).on("error", (err) -> console.log "Client error: " + err ).on "close", (hadError) -> console.log "Client closed" c.query(sqlstring).on("result", (res) -> res.on("row", (row) -> console.log "Result row: " + inspect(row) ).on("error", (err) -> console.log "Result error: " + inspect(err) ).on "end", (info) -> console.log "Result finished successfully, number of rows: " + info.numRows ).on "end", -> console.log "Done with all results" c.end() .... and then @get '/': (req,res) -> # LANDING PAGE) result = doSql("select pakz from pkt where pktnr=10001") console.log "919, result = ",result .... @view.... Console log in the doSql functions shows the results correctly but I have been playing around for a while and I can't get the function to return the result for further processing to the @get routine. Seems like I have not understood the scope issues here and probably a few more things, I am still green with this. My questions - what is the correct approach to do pass the query object from the function to the calling program if this is possible at all? - how do I access the individual rows the way I do it with node-mysql like so row[1].myfield ...? - should I create the instance of the mdbClient in the function or rather once at the very beginning of the program, my principal worry being stability even if the db disconnects here and there for some reason? Thanks, hope this is the right list for this, Karl -- Karl-L. Rumpf klrumpf(a)gmail.com Málaga, Spain

2 2

[Maria-discuss] Files under /etc/my.cnf.d/ read by default
by Honza Horak 05 Feb '13

05 Feb '13

Hi guys, while we were packaging MariaDB into Fedora (finally) we used the upstream's cnf files structure, which means /etc/my.cnf, that includes all files from directory /etc/my.cnf.d/* using statement !includedir. That works fine when user installs (not updates) the MariaDB packages without having them installed before. The problem is if user has changed /etc/my.cnf before updating -- then /etc/my.cnf doesn't get updated (!includedir won't be added) and we end with files under /etc/my.cnf.d/* but nothing what includes them. That is quite confusing for users that may change something in /etc/my.cnf.d/client.cnf but nothing happens. Since files under /etc/my.cnf.d/* are empty by default it shouldn't do any harm if all files corresponding with /etc/my.cnf.d/*.cnf template get loaded even without !includedir in /etc/my.cnf. Actually I believe that is what users expect to happen when they see files under /etc/my.cnf.d.. So, that's basically what I'm proposing -- read files under /etc/my.cnf.d/* by default, without a need to use !includedir. What do you think? Regards, Honza

1 1

Re: [Maria-discuss] Reading a field's default value from a trigger
by Bruce Kirkpatrick 04 Feb '13

04 Feb '13

For anyone encountering the "Field 'xxx' doesn't have a default value" when running insert/update/replace statement on MariaDB, I found that this is actually caused by the sql mode STRICT_TRANS_TABLES. This also fixes when a trigger updates the default value of the field. I believe the default options for MariaDB windows installer cause this option to be enabled, whereas I had previous never designed my application for the various modes supported. You can also fix the issue by giving every field in the table an explicit default value of 0 or '' except for text/longtext columns. I choose not to do that since I don't know how many other things change with STRICT_TRANS_TABLES. If you change my.ini / my.cnf to sql-mode="", you won't have this error occur anymore. You can run SELECT @@GLOBAL.sql_mode; on your mysql server and mariadb server to compare what the current settings are. This is my first post to the MariaDB mailing list. Sorry if I did it wrong. I've been using MySQL for over 10 years and decided to migrate to MariaDB now. -- Bruce Kirkpatrick<http://www.skyflare.com/> 386-405-4643

2 1

[Maria-discuss] MariaDB's tracking of MySQL changes
by Christian Convey 04 Feb '13

04 Feb '13

Can someone explain the relationship between MySQL and MariaDB code updates? I've read that MariaDB is a drop-in *replacement* for MySQL. But I've also read that MariaDB treats MySQL as an upstream code base. So what's the deal? Does MariaDB have alternative implementations for just some of MySQL's components, and when a new MySQL release comes out, MariaDB updates just those components for which it doesn't have its own versions? [This is a re-post from the #maria IRC channel, where I got no answer.] Thanks, Christian

2 1

[Maria-discuss] MariaDB 5.5.29, 5.3.12, 5.2.14, 5.1.67 now available
by Daniel Bartholomew 31 Jan '13

31 Jan '13

The MariaDB project is pleased to announce the immediate availability of the following new MariaDB versions: 5.5.29, 5.3.12, 5.2.14, & 5.1.67 Appologies in advance for the length of this email but we'd rather send out just one combined announce email instead of an email for each of these releases. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 5.5.29 Stable (GA) - Release Notes: https://kb.askmonty.org/en/mariadb-5529-release-notes - Changelog: https://kb.askmonty.org/en/mariadb-5529-changelog - Downloads: https://downloads.mariadb.org/mariadb/5.5.29 MariaDB 5.3.12 Stable (GA) - Release Notes: https://kb.askmonty.org/en/mariadb-5312-release-notes - Changelog: https://kb.askmonty.org/en/mariadb-5312-changelog - Downloads: https://downloads.mariadb.org/mariadb/5.3.12 MariaDB 5.2.14 Stable (GA) - Release Notes: https://kb.askmonty.org/en/mariadb-5214-release-notes - Changelog: https://kb.askmonty.org/en/mariadb-5214-changelog - Downloads: https://downloads.mariadb.org/mariadb/5.2.14 MariaDB 5.1.67 Stable (GA) - Release Notes: https://kb.askmonty.org/en/mariadb-5167-release-notes - Changelog: https://kb.askmonty.org/en/mariadb-5167-changelog - Downloads: https://downloads.mariadb.org/mariadb/5.1.67 - - Other Links - - - - - - - - - - - - - - - - - - - - - - - - - - - APT and YUM Repository Configuration Generator: https://downloads.mariadb.org/mariadb/repositories/ Overview of MariaDB 5.5: https://kb.askmonty.org/en/what-is-mariadb-55 Overview of MariaDB 5.3: https://kb.askmonty.org/en/what-is-mariadb-53 Overview of MariaDB 5.2: https://kb.askmonty.org/en/what-is-mariadb-52 Overview of MariaDB 5.1: https://kb.askmonty.org/en/what-is-mariadb-51 - - Security Updates - - - - - - - - - - - - - - - - - - - - - - - - - These releases are "bug fix" releases and they include, among other things, fixes for the following security vulnerabilities: - A buffer overflow that can cause a server crash or arbitrary code execution (a variant of CVE-2012-5611) http://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2012-5611 - CVE-2012-5627/MDEV-3915 fast password brute-forcing using the "change user" command http://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2012-5627 https://mariadb.atlassian.net/browse/MDEV-3915 - CVE-2012-5615/MDEV-3909 information leakage about existing user accounts via the protocol handshake http://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2012-5615 https://mariadb.atlassian.net/browse/MDEV-3909 - fixes for DoS attacks - crashes and server lockups https://mariadb.atlassian.net/browse/MDEV-4029 https://mariadb.atlassian.net/browse/MDEV-729 These releases of MariaDB also include all applicable upstream security fixes from MySQL, such as fix for a CVE-2012-5612/MDEV-3908 and other crashes. http://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2012-5612 https://mariadb.atlassian.net/browse/MDEV-3908 - - New Packages - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 5.5.29 includes packages for Fedora 18 "Spherical Cow" and Ubuntu 12.10 "Quantal Quetzal". Visit the Repository Configurator to generate the necessary commands to easily install MariaDB on these and many other distributions. We've also extended the repository configuration tool to provide instructions for distributions which include MariaDB. We've started with Mageia and will be adding others soon. https://downloads.mariadb.org/mariadb/repositories/ - - Discontinued Builds - - - - - - - - - - - - - - - - - - - - - - - Along with the news of new package builds is the news that some old distributions will be deprecated. The MariaDB project tries to support as many different operating systems and Linux distributions as possible. However, when a distribution or OS stops receiving upstream security and other updates it becomes difficult to provide packages for that platform. In such cases, our policy is to deprecate that platform and stop building binary packages for it in our build system. As of 1 Feb 2013, we will stop building and testing packages for the following: - Fedora 16 "Verne" - Debian 5 "Lenny" - Ubuntu 10.10 "Maverick" - Ubuntu 11.04 "Natty" Even after your chosen Linux distribution is deprecated, packages and support are still available. Companies such as SkySQL and Monty Program (among others) provide paid support for all versions of MariaDB and back to even very old MySQL versions. This includes packaged binaries. More information on our deprecation policy can be found at: https://kb.askmonty.org/en/mariadb-deprecation-policy/ - - Archived Releases - - - - - - - - - - - - - - - - - - - - - - - - From the beginning of the MariaDB project in 2009 we've kept all of our old releases online via our network of mirrors. Doing this is great for those few who are interested in old releases, but the disk space required to host all of our old releases is over 130 Gigabytes at present and grows by several gigabytes with each new release. This is too much for some of our mirrors to handle. So, starting with this round of releases our primary mirror will only host the most recent few releases in each series (5.5, 10.0, 5.3, and so on). Mirrors are, of course, free to keep archiving every release, but the primary mirror that they pull from will not. Old releases do have value, so for those that are interested in old releases, we are setting up a simple, no frills, archive server which will host them. Once the server is up and running, links to archived releases on https://downloads.mariadb.org will point at the archive server. During the transition period, links to some old releases may disappear for a short time, but don't worry, they haven't been deleted, they're just being moved! If you have hundreds of spare gigabytes on a fast connection and would also like to host the complete MariaDB archive, contact us at mirror at mariadb.org and we'll include a link your mirror from our archive server. (see https://kb.askmonty.org/en/mirroring-mariadb/ for more information about becoming a mirror) - - 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. - - 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

Re: [Maria-discuss] noinstall package for MariaDB
by Vineet Deodhar 25 Jan '13

25 Jan '13

Thank you. I really appreciate the fast & helpful response on this mailing list. --- Vineet --- On Fri, 25/1/13, Vladislav Vaintroub <wlad(a)montyprogram.com> wrote: From: Vladislav Vaintroub <wlad(a)montyprogram.com> Subject: RE: [Maria-discuss] noinstall package for MariaDB To: "'Vineet Deodhar'" <d_vineet(a)yahoo.com> Date: Friday, 25 January, 2013, 15:10 >Thanks Vladislav. >If I get you right, I should copy & paste the directories EXCEPT the data directory. >Is that correct? This is correct, and this is what you also should normally do when updating zips, even if you are not switching MySQL variants. >I am using Windows at present, but going to switch over to Ubuntu 12.04 LTS soon. :-) >Can you pl. share the mariadb download url for linux? Everything is on https://downloads.mariadb.org/mariadb . For example https://downloads.mariadb.org/mariadb/5.5.28a/#os_group=linux_generic would be tar.gz (if you favor non-install packages, like on Windows, those are the right ones)

1 0

[Maria-discuss] noinstall package for MariaDB
by Vineet Deodhar 25 Jan '13

25 Jan '13

Hi ! At present, I am using MySQL noinstall version (which doesn't require ANY installation). Just copy & paste the folder & start. Is there any way to use MariaDB without installing? (Maybe replace MySQL folder containing the binaries with MariaDB folder? If yes, from where to get the noinstall folder for MariaDB?) Thanks, Vineet

2 2

[Maria-discuss] Compatibility problems switching Glassfish application from MySQL to MariaDB
by Guido Winkelmann 24 Jan '13

24 Jan '13

Hi, I'm having some problems switching one of our Java/Glassfish-based web applications over from MySQL to to MariaDB. Since the MariaDB project advertises the software as a fully compatible drop- in replacement for MySQL, the first thing I did was simply stop the MySQL server, uninstall it, and then install and start MariaDB (5.5.28a, from Gentoo portage). We have got several C/C++ based application that access our MySQL databases. Those took a recompile, but afterwards continued to work as if nothing had happened. I didn't have as much luck with our glassfish-based web frontend though. The first problem was that the existing MySQL connector is apparently unable to connect to MariaDB, so I deleted the existing JDBC Connection Pools and replaced them with new ones using the MariaDB Java Client instead. This worked on the surface, however now I'm getting a lot of exceptions whenever I'm accessing parts of the application that make use of BINARY type columns. According to the developer (of the web application on question), this is because either MariaDB itself or the connector are returning binary columns as type string, causing the persistance layer to attempt to convert them to a string object. Since the binary columns in question contain various unprintable characters, including zero-bytes, this fails. Can someone please help me with these problems? Guido

2 2

[Maria-discuss] 10.0.0 msi pack fails first start
by Federico Razzoli 24 Jan '13

24 Jan '13

Hi I tried to install MariaDB 10.0.0 on Windows XP, MSI package. Apparently the installation worked, but the server fails to start. I paste here the log until the first shutdown, just in case you don't know about this problem. Federico 130124 10:49:47 InnoDB: The InnoDB memory heap is disabled 130124 10:49:47 InnoDB: Mutexes and rw_locks use Windows interlocked functions 130124 10:49:47 InnoDB: Compressed tables use zlib 1.2.3 130124 10:49:47 InnoDB: CPU does not support crc32 instructions 130124 10:49:47 InnoDB: Initializing buffer pool, size = 128.0M 130124 10:49:47 InnoDB: Completed initialization of buffer pool InnoDB: The first specified data file .\ibdata1 did not exist: InnoDB: a new database to be created! 130124 10:49:47 InnoDB: Setting file .\ibdata1 size to 10 MB InnoDB: Database physically writes the file full: wait... 130124 10:49:47 InnoDB: Log file .\ib_logfile0 did not exist: new to be created InnoDB: Setting log file .\ib_logfile0 size to 5 MB InnoDB: Database physically writes the file full: wait... 130124 10:49:48 InnoDB: Log file .\ib_logfile1 did not exist: new to be created InnoDB: Setting log file .\ib_logfile1 size to 5 MB InnoDB: Database physically writes the file full: wait... 130124 10:49:48 InnoDB: Doublewrite buffer not found: creating new 130124 10:49:48 InnoDB: Doublewrite buffer created 130124 10:49:49 InnoDB: 128 rollback segment(s) are active. InnoDB: Creating foreign key constraint system tables InnoDB: Foreign key constraint system tables created 130124 10:49:49 InnoDB: Waiting for the background threads to start 130124 10:49:49 InnoDB: 1.2.0 started; log sequence number 0 130124 10:49:49 [Note] Plugin 'FEEDBACK' is disabled. 130124 10:49:56 InnoDB: FTS optimize thread exiting. 130124 10:49:56 InnoDB: Starting shutdown... 130124 10:49:58 InnoDB: Shutdown completed; log sequence number 1602824 130124 10:50:00 InnoDB: The InnoDB memory heap is disabled 130124 10:50:00 InnoDB: Mutexes and rw_locks use Windows interlocked functions 130124 10:50:00 InnoDB: Compressed tables use zlib 1.2.3 130124 10:50:00 InnoDB: CPU does not support crc32 instructions 130124 10:50:01 InnoDB: Initializing buffer pool, size = 31.0M 130124 10:50:01 InnoDB: Completed initialization of buffer pool 130124 10:50:01 InnoDB: Log file .\ib_logfile0 did not exist: new to be created InnoDB: Setting log file .\ib_logfile0 size to 31 MB InnoDB: Database physically writes the file full: wait... 130124 10:50:02 InnoDB: Log file .\ib_logfile1 did not exist: new to be created InnoDB: Setting log file .\ib_logfile1 size to 31 MB InnoDB: Database physically writes the file full: wait... 130124 10:50:03 InnoDB: highest supported file format is Barracuda. InnoDB: The log sequence number in ibdata files does not match InnoDB: the log sequence number in the ib_logfiles! 130124 10:50:03 InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files... InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer... 130124 10:50:03 InnoDB: 128 rollback segment(s) are active. 130124 10:50:03 InnoDB: Waiting for the background threads to start 130124 10:50:03 InnoDB: 1.2.0 started; log sequence number 1603084 130124 10:50:03 [Note] Plugin 'FEEDBACK' is disabled. 130124 10:50:03 [Note] Event Scheduler: Loaded 0 events 130124 10:50:03 [Note] C:\Programmi\MariaDB 10.0\bin\mysqld.exe: ready for connections. Version: '10.0.0-MariaDB' socket: '' port: 3306 Source distribution 130124 11:03:13 InnoDB: The InnoDB memory heap is disabled 130124 11:03:13 InnoDB: Mutexes and rw_locks use Windows interlocked functions 130124 11:03:13 InnoDB: Compressed tables use zlib 1.2.3 130124 11:03:13 InnoDB: CPU does not support crc32 instructions 130124 11:03:13 InnoDB: Initializing buffer pool, size = 128.0M 130124 11:03:13 InnoDB: Completed initialization of buffer pool InnoDB: Error: log file .\ib_logfile0 is of different size 32505856 bytes InnoDB: than specified in the .cnf file 5242880 bytes! 130124 11:03:14 [ERROR] Plugin 'InnoDB' init function returned error. 130124 11:03:14 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 130124 11:03:15 [Note] Plugin 'FEEDBACK' is disabled. 130124 11:03:16 [ERROR] Unknown/unsupported storage engine: InnoDB 130124 11:03:16 [ERROR] Aborting 130124 11:03:17 [Note] C:/Programmi/MariaDB 10.0/bin/mysqldd: Shutdown complete

1 1

[Maria-discuss] Trouble installing MariaDB 5.5 on Ubuntu 12.04 (& 12.10)
by Aaron Anderson 23 Jan '13

23 Jan '13

Gang, I've installed MariaDB on several Debian/Ubuntu systems in the past few months, without any issues. ~2 days ago on an Unbuntu 12.10 system did an apt-get update/upgrade/dist-upgrade. I believe that MariaDB was updated in that process. After the updates, mysql was "gone" My apps couldn't find it, it wasn't running, etc. I was in a hurry so I had to fall back to the standard mysql package so not a lot of into there. I built a new Ubuntu 12.04 LTS server, added the Maria repo, did an apt-get update/ugprade/dist-upgrade. Rebooted. Here's some output... I'm stuck in this loop. root@nn01:~# apt-get install mariadb-server Reading package lists... Done Building dependency tree Reading state information... Done Some packages could not be installed. This may mean that you have requested an impossible situation or if you are using the unstable distribution that some required packages have not yet been created or been moved out of Incoming. The following information may help to resolve the situation: The following packages have unmet dependencies: mariadb-server : Depends: mariadb-server-5.5 but it is not going to be installed E: Unable to correct problems, you have held broken packages. root@nn01:~# apt-get install mariadb-server-5.5 Reading package lists... Done Building dependency tree Reading state information... Done Some packages could not be installed. This may mean that you have requested an impossible situation or if you are using the unstable distribution that some required packages have not yet been created or been moved out of Incoming. The following information may help to resolve the situation: The following packages have unmet dependencies: mariadb-server-5.5 : Depends: mariadb-client-5.5 (>= 5.5.28-mariadb-a1~precise) but it is not going to be installed Depends: mariadb-server-core-5.5 (>= 5.5.28-mariadb-a1~precise) but it is not going to be installed E: Unable to correct problems, you have held broken packages. root@nn01:~# apt-get install mariadb-client-5.5 Reading package lists... Done Building dependency tree Reading state information... Done Some packages could not be installed. This may mean that you have requested an impossible situation or if you are using the unstable distribution that some required packages have not yet been created or been moved out of Incoming. The following information may help to resolve the situation: The following packages have unmet dependencies: mariadb-client-5.5 : Depends: libdbd-mysql-perl (>= 1.2202) but it is not going to be installed Depends: mariadb-common but it is not going to be installed Depends: libmariadbclient18 (>= 5.5.28-mariadb-a1~precise) but it is not going to be installed Depends: mariadb-client-core-5.5 (>= 5.5.28-mariadb-a1~precise) but it is not going to be installed E: Unable to correct problems, you have held broken packages. root@nn01:~#

2 2

[Maria-discuss] KB Question: Issues with ignore-db-dir
by Daniel Bartholomew 23 Jan '13

23 Jan '13

The following question has been posted to the Knowledgebase: https://kb.askmonty.org/en/issues-with-ignore-db-dir/ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Issues with ignore-db-dir Hello, I see that the ignore-db-dir option has been available since Maria 5.3.9 ( https://kb.askmonty.org/en/mariadb-539-changelog/ ) , however I am finding that MariaDB 5.5.27 is not recognizing the option. When I put "ignore-db-dir=lost+found" in the mysqld section of the my.cnf file or when I attempt to start mysqld with "/etc/init.d/mysql start --ignore-db-dir=lost+found", both times mysql fails to start with the following message: 130111 17:08:57 [ERROR] /usr/sbin/mysqld: unknown variable 'ignore-db-dir=lost+found' 130111 17:08:57 [ERROR] Aborting Is there a patch that I was supposed to apply but haven't ? Or maybe I am misunderstanding how or where to specify the ignore-db-dir option. For reference, the full version as reported by mysqld is: $ mysqld --version mysqld Ver 5.5.27-MariaDB for Linux on x86_64 (MariaDB Server) Thanks, -Said - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- 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] Fwd: [debian-mysql] Bug#688505: MariaDB packaging.
by Colin Charles 19 Jan '13

19 Jan '13

A good wishlist. I think more should vote for this, quite clearly! cheers, -colin Begin forwarded message: > Resent-From: Robert de Bath <robert$(a)debath.co.uk> > From: Robert de Bath <robert$(a)debath.co.uk> > Subject: [debian-mysql] Bug#688505: MariaDB packaging. > Date: 23 September 2012 16:25:39 GMT+08:00 > Resent-To: debian-bugs-dist(a)lists.debian.org > To: submit(a)bugs.debian.org > Resent-Cc: Debian MySQL Maintainers <pkg-mysql-maint(a)lists.alioth.debian.org> > Reply-To: Robert de Bath <robert$(a)debath.co.uk>, 688505(a)bugs.debian.org > > Package: mysql-server > Version: 5.5.24+dfsg-8 > Severity: wishlist > > My very technically savvy webhost has recently switched from MySQL to > MariaDB and claim it's for both technical and political reasons. > > Both of these reasons (better performance and better licensing) appear > to be good reasons for the software to be packaged as a Debian package > and I expect it's getting to the point that someone will do it themselves. > > BUT the software is technically still not a forked variant of MySQL > but a patched version where the maintainers continually resync to the > Oracle releases. For this reason I would like to see it treated as just > a simple MySQL version within Debian. This way the users (ie: me) can > simply switch by prodding apt in the right way. > > For this to work seamlessly (unlike, for example, the recent multimedia > troubles) the MariaDB package should be packaged identically to MySQL, > which IMO is best done by the same Debian maintainers. > > So my request is that you package the MariaDB as a secondary version of > MySQL in such a way that the two packages can be seamlessly switched within the Debian system. > > -- > Rob. (Robert de Bath <robert$ @ debath.co.uk>) > <http://www.debath.co.uk/> > > _______________________________________________ > pkg-mysql-maint mailing list > pkg-mysql-maint(a)lists.alioth.debian.org > http://lists.alioth.debian.org/cgi-bin/mailman/listinfo/pkg-mysql-maint -- 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 3

[Maria-discuss] MariaDB Java Client 1.1.0 Released
by Daniel Bartholomew 16 Jan '13

16 Jan '13

The MariaDB Java Client 1.1.0 has been released. You can download it here: https://downloads.mariadb.org/client-java/1.1.0/ This version focused on fixing all known database metadata bugs and ConnnectorJ incompatibilities. Specific fixes include: - Consistent, compatible with ConnectorJ handling of JDBC catalogs vs schemas vs databases - Implementation of several missing methods in DatabaseMetaData - Better handling of statement timeouts - OSGi-specific entries have been added to MANIFEST.MF so it can be used in OSGi environments - Added support for dumpQueriesOnException=true in the JDBC URL - Added support for IPv6 addresses in the connector - Added SSL support - and more... See the Release Notes and Changelog for more information: - https://kb.askmonty.org/en/mariadb-java-client-110-release-notes - https://kb.askmonty.org/en/mariadb-java-client-110-changelog See also the "About the MariaDB Java Client" page: - https://kb.askmonty.org/en/about-the-mariadb-java-client -- 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] MariaDB installation failed in fedora17, No more mirrors to try!!!
by Haseena L. 14 Jan '13

14 Jan '13

Hi all, Iam trying to install mariadb in fedora17 using the following link : https://kb.askmonty.org/en/installing-mariadb-with-yum/#manually-importi ng-the-mariadb-signing-key It shows an error, there is no mirror for downloading mariadb. Please see the error log : $ sudo yum install MariaDB-server MariaDB-client Loaded plugins: langpacks, presto, refresh-packagekit fedora/metalink | 8.3 kB 00:00 fedora | 4.2 kB 00:00 fedora/primary_db | 12 MB 00:02 fedora/group_gz | 434 kB 00:00 mariadb | 1.9 kB 00:00 mariadb/primary_db | 15 kB 00:00 updates/metalink | 3.7 kB 00:00 updates | 4.7 kB 00:00 updates/primary_db | 5.9 MB 00:44 updates/group_gz | 439 kB 00:00 Resolving Dependencies --> Running transaction check ---> Package MariaDB-client.i686 0:5.5.28a-1 will be installed --> Processing Dependency: MariaDB-common for package: MariaDB-client-5.5.28a-1.i686 ---> Package MariaDB-server.i686 0:5.5.28a-1 will be obsoleting ---> Package mysql.i686 0:5.5.23-1.fc17 will be obsoleted ---> Package mysql-server.i686 0:5.5.23-1.fc17 will be obsoleted --> Running transaction check ---> Package MariaDB-common.i686 0:5.5.28a-1 will be installed --> Finished Dependency Resolution Dependencies Resolved ======================================================================== ======== Package Arch Version Repository Size ======================================================================== ======== Installing: MariaDB-client i686 5.5.28a-1 mariadb 8.4 M MariaDB-server i686 5.5.28a-1 mariadb 32 M replacing mysql.i686 5.5.23-1.fc17 replacing mysql-server.i686 5.5.23-1.fc17 Installing for dependencies: MariaDB-common i686 5.5.28a-1 mariadb 23 k Transaction Summary ======================================================================== ======== Install 2 Packages (+1 Dependent package) Total size: 41 M Total download size: 41 M Is this ok [y/N]: y Downloading Packages: http://yum.mariadb.org/5.5/fedora17-x86/rpms/MariaDB-5.5.28a-fedora17-i6 86-client.rpm: [Errno 12] Timeout on http://yum.mariadb.org/5.5/fedora17-x86/rpms/MariaDB-5.5.28a-fedora17-i6 86-client.rpm: (28, '') Trying other mirror. http://yum.mariadb.org/5.5/fedora17-x86/rpms/MariaDB-5.5.28a-fedora17-i6 86-server.rpm: [Errno 12] Timeout on http://yum.mariadb.org/5.5/fedora17-x86/rpms/MariaDB-5.5.28a-fedora17-i6 86-server.rpm: (28, '') Trying other mirror. Error Downloading Packages: MariaDB-server-5.5.28a-1.i686: failure: rpms/MariaDB-5.5.28a-fedora17-i686-server.rpm from mariadb: [Errno 256] No more mirrors to try. MariaDB-client-5.5.28a-1.i686: failure: rpms/MariaDB-5.5.28a-fedora17-i686-client.rpm from mariadb: [Errno 256] No more mirrors to try. Please help me... Give me the appropriate mirror for downloading mariadb Regards, Haseena ***** Confidentiality Statement/Disclaimer ***** This message and any attachments is intended for the sole use of the intended recipient. It may contain confidential information. Any unauthorized use, dissemination or modification is strictly prohibited. If you are not the intended recipient, please notify the sender immediately then delete it from all your systems, and do not copy, use or print. Internet communications are not secure and it is the responsibility of the recipient to make sure that it is virus/malicious code exempt. The company/sender cannot be responsible for any unauthorized alterations or modifications made to the contents. If you require any form of confirmation of the contents, please contact the company/sender. The company/sender is not liable for any errors or omissions in the content of this message.

1 0

[Maria-discuss] Reporting upstream bugs
by Federico Razzoli 10 Jan '13

10 Jan '13

Hi all. I reported a bug in JIRA - I hit it in MariaDB but it was tagged as "upstream". This brings us to the question: is it ok to report upstream bugs in MariaDB's JIRA? There are 2 reasons why I didn't report it to Oracle. Let me explain. 1) MySQL Ab and Sun never had a lot of data about me or the companies where I worked. They only had my email and my full name, plus some optional info, if I remember correctly. But my old account doesn't work anymore, and the new Oracle's sign up page REQUIRES a lot of data - including a physical address and a work phone. I don't want to provide them too much info about me and my company. 2) I tried to sign up with fake data, but after 2 days I didn't receive a confirm email and my account still doesn't work. They are very slow, or something doesn't work fine in their website, or they detected that some data I wrote is fake (but I got no error message). I think that a company which develops open source software should be glad that people reports bugs, and should make the process easier. If the process is hard, I would prefer to report bugs to MariaDB. But, what does MariaDB think about it? Is it ok to report the bugs to you? Federico Razzoli

3 3

[Maria-discuss] ASFORMENTIONED keyword suggestion
by Eric Wood 26 Dec '12

26 Dec '12

Routinely updating records with 20 or more columns can be exhausting work. Many have asked for this for many years and I was hoping a MariaDB developer would take the reins in implementing a shorter ON DUPLICATE KEY UPDATE syntax: INSERT INTO `tableName` (`a`,`b`,`c`) VALUES (1,2,3) ON DUPLICATE KEY UPDATE `a`=VALUES(`a`), `b`=VALUES(`b`), `c`=VALUES(`c`); INSERT INTO `tableName` SET a=1, b=2, c=3 ON DUPLICATE KEY UPDATE a=1, b=2, c=3; INSERT INTO `tableName` (`a`,`b`,`c`) VALUES (1,2,3) ON DUPLICATE KEY UPDATE ASFORMENTIONED; INSERT INTO `tableName` SET a=1, b=2, c=3 ON DUPLICATE KEY UPDATE ASFORMENTIONED; Something like this would certainly make SQL enjoyable again. -Eric Wood

1 0

[Maria-discuss] DrizzleJDBC 1,2
by Marcus Eriksson 06 Dec '12

06 Dec '12

Hi I just released DrizzleJDBC 1.2 DrizzleJDBC is a BSD licensed JDBC driver for MySQL/MariaDB/Drizzle It is in maven central: <dependency> <groupId>org.drizzle.jdbc</groupId> <artifactId>drizzle-jdbc</artifactId> <version>1.2</version> </dependency> Changelog; - IPv6 support, enclose the IP in brackets, [::1] ( https://github.com/krummas/DrizzleJDBC/issues/10) - Correct behavior if getInt on larger than MAXINT values ( https://github.com/krummas/DrizzleJDBC/issues/9) - Fix ssl support, was not possible to close connection ( https://github.com/krummas/DrizzleJDBC/issues/8) - Support InputStream in LOAD DATA INFILE ( https://github.com/krummas/DrizzleJDBC/issues/7) - support getting columns using <table>.<column> ( https://github.com/krummas/DrizzleJDBC/issues/6) - use single quotes (https://github.com/krummas/DrizzleJDBC/pull/5) - clean up unicode support (https://github.com/krummas/DrizzleJDBC/pull/4) - Fix NPE bug when timestamp is null, patch by Tim Rickettsl on launchpad - set FOUND ROWS by default (https://github.com/krummas/DrizzleJDBC/issues/2 ) Report bugs/feature requests etc on github; https://github.com/krummas/DrizzleJDBC /Marcus

3 3

[Maria-discuss] partitioning by timestamp field
by Said Ramirez 30 Nov '12

30 Nov '12

Hello, I am trying to setup a range partitioned table using 5.5.27-MariaDB-log MariaDB Server using a timestamp field. According to the documents, I should be able to use unix_timestamp(ts) as my partitioning function ( http://dev.mysql.com/doc/refman/5.5/en/partitioning-range.html ) . I find, however, that it is not possible to use unix_timestamp using mariadb because with mariadb the unix_timestamp function returns an floating point value: mariadb> select unix_timestamp('2012-12-01'); +------------------------------+ | unix_timestamp('2012-12-01') | +------------------------------+ | 1354320000.000000 | +------------------------------+ 1 row in set (0.00 sec) However the MySQL version of unix_timestamp returns an int value: myqsl> select unix_timestamp('2012-12-01'); +------------------------------+ | unix_timestamp('2012-12-01') | +------------------------------+ | 1354320000 | +------------------------------+ 1 row in set (0.06 sec) How have people worked around this issue? What other ways can I partition by a timestamp in MariaDB ? Thanks, -Said

2 1

Re: [Maria-discuss] Contact Form: Ruslan Kutliakhmetov
by Sergei Golubchik 17 Nov '12

17 Nov '12

Hi, Ruslan! First, please use email for questions of this kind. We have a mailing list maria-discuss(a)lists.launchpad.net - it's much easier to follow the discussion there, and many more people will see your question, so you'll have a better chance of getting a fast and helpful reply. On Nov 17, Ruslan Kutliakhmetov wrote: > ------------------------------------------------ > Hi. I installed on the linux debian MarinaDB 10 for linux debian. > I watched that she doesn't installed. Log: > root @ debian :/ home / tran # apt-get install mariadb-server-5.2 mariadb-client-5.2 > Reading package lists ... Done > Building dependency tree > Reading state information ... Done > Some packages could not be installed. Perhaps you are asking the impossible, > or using the unstable distribution that some required > packages have not yet been created or been moved out of Incoming. > The following information may help you: > > The following packages have unmet dependencies: > mariadb-client-5.2: Depends: mariadb-client-core-5.2 (> = 5.2.12-mariadb115 ~ squeeze) but it is not installed > E: Broken packages > ------------------------------------------------ I don't understand what you are trying to do. Are you installing MariaDB 10.0.0 release? If yes, why do you specify "5.2" in the apt-get command line? If you want to install MariaDB 5.2.12 - why do you mention 10.0? May be, you are trying to upgrade or downgrade? Regards, Sergei

1 0

[Maria-discuss] KB Question: Drop-in replacement on Debian
by Daniel Bartholomew 17 Nov '12

17 Nov '12

The following question has been posted to the Knowledgebase: https://kb.askmonty.org/en/drop-in-replacement-on-debian/ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Is there a way to make MariaDB install over MySQL on a Debian machine? I have my puppet master, which is running Debian/sid. It has puppet-dashboard, which utilizes MySQL 5.5.28. Much to my dismay, I am unable to install MariaDB over it: - - - - - The following packages have unmet dependencies: libmariadbclient18 : Depends: libmysqlclient18 (= 5.5.28-mariadb1~wheezy) but 5.5.28+dfsg-1 is to be installed E: Unable to correct problems, you have held broken packages. - - - - - But if I try to uninstall the parts of MySQL, then apt wishes to uninstall everything, up to and including puppet-dashboard: - - - - - The following packages were automatically installed and are no longer required: dbconfig-common libaio1 libhttpclient-ruby1.8 mysql-server-core-5.5 rake ruby-dbi ruby-deprecated unzip zip Use 'apt-get autoremove' to remove them. The following packages will be REMOVED: libdbd-mysql-perl libdbd-mysql-ruby libmysqlclient18 mysql-client mysql-client-5.5 mysql-server mysql-server-5.5 puppet-dashboard ruby-dbd-mysql ruby-mysql - - - - - This is unacceptable for a live box... Is there something else I can do to make the install less painful? - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 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

3 2

[Maria-discuss] mDB logs off when there are several ssh under same user
by klrumpf 15 Nov '12

15 Nov '12

4 6

[Maria-discuss] KB Question: Aria Max Table Size
by Daniel Bartholomew 14 Nov '12

14 Nov '12

The following question has been posted in the Knowledgebase: https://kb.askmonty.org/en/aria-max-table-size/ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Aria looks to be a safer robust replacement to MyISAM for data warehousing. However, I was unable to find any mention of maximum table sizes for tables in various row formats. Upon creating tables and getting information in SequelPro, I saw the following: Aria Dynamic: 4GB Aria Fixed: 20GB Aria Page: 64GB This would seem counterproductive as MyISAM supports 256TB. Is there an official statistic on the maximum amount of data that Aria can handle? - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 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] MariaDB 10.0.0 Alpha now available
by Daniel Bartholomew 12 Nov '12

12 Nov '12

The MariaDB project is pleased to announce the immediate availability of MariaDB 10.0.0. 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 first 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. Do not use alpha releases on production systems. - - MariaDB 10.0 Links - - - - - - - - - - - - - - - - - - - - - - - - - Release Notes: http://kb.askmonty.org/en/mariadb-1000-release-notes Changelog: http://kb.askmonty.org/en/mariadb-1000-changelog Downloads: http://downloads.mariadb.org/mariadb/10.0.0 APT and YUM Repository Configuration Generator: http://downloads.mariadb.org/mariadb/repositories/ Overview of MariaDB 10.0: http://kb.askmonty.org/en/what-is-mariadb-100 - - 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. - - 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 - - - - - - - - - - - - - - - - - - - - - - - - - - We've created a CafePress store which offers an exclusive t-shirt or other item in return for a donation to the MariaDB project: - http://www.cafepress.com/mariadb Please check it out and let us know what you think! All proceeds go directly to support MariaDB development, so don't think of it as purchasing a t-shirt, think of it as donating to support a worthy project and awesome product... and you get a t-shirt as a nice bonus! If you would like to contribute to MariaDB in other ways, please see our "contributing" and "donations" pages in the Knowledgebase: - https://kb.askmonty.org/en/contributing - https://kb.askmonty.org/en/donations 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] TRUNCATE TABLE becomes hang sometimes
by Haseena L. 10 Nov '12

10 Nov '12

Hi, Now Iam trying to migrate from MySQL to MariaDB. Why does the TRUNCATE TABLE statement hang sometimes? What are the reasons for this type of issue? This problem doesn't happen with MySQL, only with MariaDB. The hanging statement is simply: TRUNCATE TABLE sampledb.datatable; What can cause this to happen, and how could I fix it? Another one observation is if the table have some data, may be one or two rows, then the truncate query works successfully. Else the table have a lot of data, query becomes hang. If the same table have more than one connetion, then the truncate table query hangs. How I fix it??? Now Iam blocking. Engine I selected is MyISAM. Thanks and Regards, Haseena ***** Confidentiality Statement/Disclaimer ***** This message and any attachments is intended for the sole use of the intended recipient. It may contain confidential information. Any unauthorized use, dissemination or modification is strictly prohibited. If you are not the intended recipient, please notify the sender immediately then delete it from all your systems, and do not copy, use or print. Internet communications are not secure and it is the responsibility of the recipient to make sure that it is virus/malicious code exempt. The company/sender cannot be responsible for any unauthorized alterations or modifications made to the contents. If you require any form of confirmation of the contents, please contact the company/sender. The company/sender is not liable for any errors or omissions in the content of this message.

2 1

[Maria-discuss] TRUNCATE TABLE becomes hang sometimes
by Haseena L. 06 Nov '12

06 Nov '12

Hi, Now Iam trying to migrate from MySQL to MariaDB. Why does the TRUNCATE TABLE statement hang sometimes? What are the reasons for this type of issue? This problem doesn't happen with MySQL, only with MariaDB. The hanging statement is simply: TRUNCATE TABLE sampledb.datatable; What can cause this to happen, and how could I fix it? Another one observation is if the table have some data, may be one or two rows, then the truncate query works successfully. Else the table have a lot of data, query becomes hang. If the same table have more than one connetion, then the truncate table query hangs. How I fix it??? Now Iam blocking. Engine I selected is MyISAM. Thanks and Regards, Haseena ***** Confidentiality Statement/Disclaimer ***** This message and any attachments is intended for the sole use of the intended recipient. It may contain confidential information. Any unauthorized use, dissemination or modification is strictly prohibited. If you are not the intended recipient, please notify the sender immediately then delete it from all your systems, and do not copy, use or print. Internet communications are not secure and it is the responsibility of the recipient to make sure that it is virus/malicious code exempt. The company/sender cannot be responsible for any unauthorized alterations or modifications made to the contents. If you require any form of confirmation of the contents, please contact the company/sender. The company/sender is not liable for any errors or omissions in the content of this message.

1 0

[Maria-discuss] MariaDB 5.5.28 now available
by Daniel Bartholomew 22 Oct '12

22 Oct '12

The MariaDB project is pleased to announce the immediate availability of MariaDB 5.5.28. This is a stable (GA) release. - - MariaDB 5.5 Links - - - - - - - - - - - - - - - - - - - - - - - - - Release Notes: http://kb.askmonty.org/en/mariadb-5528-release-notes Changelog: http://kb.askmonty.org/en/mariadb-5528-changelog Downloads: http://downloads.mariadb.org/mariadb/5.5.28 APT and YUM Repository Configuration Generator: http://downloads.mariadb.org/mariadb/repositories/ Overview of MariaDB 5.5: http://kb.askmonty.org/en/what-is-mariadb-55 - - 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. - - 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 - - - - - - - - - - - - - - - - - - - - - - - - - - We've created a CafePress store which offers an exclusive t-shirt or other item in return for a donation to the MariaDB project: - http://www.cafepress.com/mariadb Please check it out and let us know what you think! All proceeds go directly to support MariaDB development, so don't think of it as purchasing a t-shirt, think of it as donating to support a worthy project and awesome product... and you get a t-shirt as a nice bonus! If you would like to contribute to MariaDB in other ways, please see our "contributing" and "donations" pages in the Knowledgebase: - https://kb.askmonty.org/en/contributing - https://kb.askmonty.org/en/donations 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] can I expect deb files of mariadb-galera soon?
by Jan Kirchhoff 12 Oct '12

12 Oct '12

Hi, We are currently using mariadb a lot over here with traditional replication and I'd like to test the galera alpha in the next weeks. I have two brand-new machines with plenty of SAS disks, some SSDs and 128GB of RAM over here with Ubuntu 12.10 alpha ready to do some testing with our real-world workloads. Before I start compiling myself or mess with binary tar.gz-releases: can I expect deb-releases within the next 2 weeks? That would make life much easier for me and I'd delay starting all the testing by a few days if I knew I would then have debs to start right away. regards Jan

2 3

[Maria-discuss] mariadb : possible copyright issues?
by Vineet Deodhar 03 Oct '12

03 Oct '12

I am using MySQL at present. I came across MariaDB, a drop-in replacement for MySQL. 2 simple questions-- 1) File names in MariaDB, in many cases, are same as those in MySQL. Wouldn't that attract objection from Oracle as 'breach of the copyright' ? 2) May I use MariaDB for commercial distribution (with or without using its source) ? Whether the license is similar to MIT license? Thanks, Vineet

3 2

[Maria-discuss] KB Question:Slow Performance for some queries
by Daniel Bartholomew 03 Oct '12

03 Oct '12

The following question has been posted to the Knowledgebase: https://kb.askmonty.org/en/slow-performance-for-some-queries/ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Slow Performance for some queries Hi there, I have discovered some very low performing queries on our MariaDB version 5.3.7. The query shows up with "string results in query cache" The query: explain select distinct `config`.`agent_id` AS `agent_id`, `config`.`agent_name` AS `agent_name`, `agent`.`agent_version` AS `agent_version`, `config`.`agent_os` AS `agent_os`, `agent`.`agent_os_version` AS `agent_os_version`, `config`.`pconfig_line` AS `pconfig_line`, `config`.`appclass` AS `appclass`, `config`.`instance` AS `instance`, `config`.`parameter` AS `parameter`, `config`.`value` AS `value`, substring_index(substring_index(`config`.`variable`, '/', '4ö'), '/', -(1)) AS `NT_Drive`, `config`.`agent_config_date` AS `agent_config_date`, `config`.`rule_type_name` AS `rule_type_name` from (`agent_config_detail_view` `config` left join `agent` ON ((`agent`.`agent_id` = `config`.`agent_id`))) where (((`config`.`rule_type_id` = 'ccbe914e30c6ec6e3aa5c4780a3525d6') or (`config`.`rule_type_id` = '0091efee7f9b5f0e27211eb7226d0a23') or (`config`.`rule_type_id` = '6311ae17c1ee52b36e68aaf4ad066387')) and ((`config`.`variable` = '/AgentSetup/FILESYSTEM.filterList') or (`config`.`variable` = '/AgentSetup/FILESYSTEM.filterType') or (`config`.`variable` like '/AS/EVENTSPRING/PARAM_SETTINGS/THRESHOLDS/FILESYSTEM%') or (`config`.`variable` like '/RecoveryActions/NT_LOGICAL_DISKS/%/LDldFreeSpacePercent/Mode')) and (`config`.`agent_config_date` > ((select max(`s`.`agent_config_date`) from `agent_config` `s`) - interval 24 hour))) order by `config`.`agent_name` , `config`.`appclass` Here is the explain for the query in question: id select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY a ALL PRIMARY NULL NULL NULL 7083 "Using temporary; Using filesort" 1 PRIMARY agent eq_ref PRIMARY PRIMARY 34 new_budm.a.agent_id 1 1 PRIMARY b ref PRIMARY,fk_agent_config_agent1,IX_agent_config_date fk_agent_config_agent1 34 new_budm.a.agent_id 3 "Using where" 1 PRIMARY c ref agent_config_rule_fk_agent_config_id,agent_config_rule_fk_rule_id agent_config_rule_fk_agent_config_id 34 new_budm.b.agent_config_id 947 1 PRIMARY d eq_ref PRIMARY,IX_rule_variable PRIMARY 34 new_budm.c.fk_rule_id 1 "Using where" 1 PRIMARY e ref fk_rule_rule_type_rule_type1,fk_rule_rule_type_rule fk_rule_rule_type_rule 34 new_budm.c.fk_rule_id 1 "Using where" 1 PRIMARY f eq_ref PRIMARY PRIMARY 34 new_budm.e.fk_rule_type_id 1 2 SUBQUERY NULL NULL NULL NULL NULL NULL NULL "Select tables optimized away" The query cache (innodb_buffer_pool_size) is set to 8192M. Other queries are running fine (perfomance can always be better). Thank you and regards, Patrick - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 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] Json Explain
by Peter Laursen 30 Sep '12

30 Sep '12

Is Explain output in Json format planned in MariaDB (refer http://glebshchepa.blogspot.in/2012/04/optimizer-new-explain-formatjson.html) ? If so when? and will the implementation details and output format be fully identical to Oracle/MySQL 5.6? (I did not find it mentioned here: http://monty-says.blogspot.dk/2012/09/now-is-good-time-to-be-part-of-future… http://blog.mariadb.org/mariadb-directions/ .. sorry if I overlooked it somewhere) -- Peter -- Webyog

4 8

[Maria-discuss] MariaDB 5.5.27 now available
by Daniel Bartholomew 10 Sep '12

10 Sep '12

The MariaDB project is pleased to announce the immediate availability of MariaDB 5.5.27. This is a stable (GA) release. - - MariaDB 5.5 Links - - - - - - - - - - - - - - - - - - - - - - - - - Release Notes: http://kb.askmonty.org/en/mariadb-5527-release-notes Changelog: http://kb.askmonty.org/en/mariadb-5527-changelog Downloads: http://downloads.mariadb.org/mariadb/5.5.27 APT and YUM Repository Configuration Generator: http://downloads.mariadb.org/mariadb/repositories/ Overview of MariaDB 5.5: http://kb.askmonty.org/en/what-is-mariadb-55 - - 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. - - 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 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] MariaDB Galera Cluster 5.5.25 Alpha now available
by Daniel Bartholomew 06 Sep '12

06 Sep '12

The MariaDB project is pleased to announce the immediate availability of MariaDB Galera Cluster 5.5.25 Alpha. This is an Alpha release. What is it? * A straight merge of MariaDB 5.5.25 with Galera Cluster by Codership * An alpha release which should not be used in production environments * Using the Galera replication methodology, users get: * Synchronous, multi-master replication with guaranteed data consistency. * This solution provides both read & write scalability The links below have more information. Compatibility? MariaDB Galera Cluster is fully data-compatible with MariaDB or MySQL, as it will work with the standard databases created by these products. There are next to none or very minimal application changes that are required to make the solution work. Where can I get it? See the links below. What's next? The plan is for a rapid release cycle to heavily test the performance and usage of MariaDB Galera Cluster in different environments. Please file bugs at: https://mariadb.atlassian.net Quotes: Seppo Jaakola, CEO for Codership "It's great that we are working closely with an upstream provider of a MySQL-compatible binary, MariaDB. We no longer have to spend time coding against out-of-tree changes as we're part of MariaDB. The excellent MariaDB engineering team constantly releases new versions of MariaDB with high quality assurance (QA). Codership will continue to collaborate closely with the MariaDB engineering team to improve the product and make new versions of the MariaDB Galera Cluster available." Michael "Monty" Widenius, CEO for Monty Program Ab "We've received a significant amount of requests for a MariaDB based Galera cluster and today we're proud to deliver that. We're currently preparing ourselves and our partners for a rollout of the GA product and related professional services via SkySQL to run critical systems on top of MariaDB Galera Cluster." The MariaDB Team will together with Codership work on customer requests and demands in the areas of cluster and replication. Please contact us if you are interested in any services we can offer around Galera, MariaDB or MySQL. http://montyprogram.com/contact - - MariaDB Galera Cluster 5.5.25 Links - - - - - - - - - - - - - - - - Release Notes: http://kb.askmonty.org/en/mariadb-galera-5525-release-notes Changelog: http://kb.askmonty.org/en/mariadb-galera-5525-changelog Downloads: http://downloads.mariadb.org/mariadb-galera/5.5.25 YUM Repository Configuration Generator: http://downloads.mariadb.org/mariadb-galera/repositories (APT repositories are not available at this time.) Overview of MariaDB Galera Cluster 5.5: http://kb.askmonty.org/en/what-is-mariadb-galera-cluster More information: http://kb.askmonty.org/en/galera - - Where else to find us - - - - - - - - - - - - - - - - - - - - - - - http://mariadb.org We're also on: Facebook: http://fb.com/MariaDB.dbms Twitter: http://twitter.com/mariadb Google+: http://google.com/+mariadb Follow, friend, and add us to your circles to keep up to date with MariaDB! -- MariaDB: An Enhanced Drop-in Replacement for MySQL

1 0

[Maria-discuss] KB entry on SQLyog and MONyog
by Peter Laursen 31 Aug '12

31 Aug '12

Hi! We would like to update the AskMonty Knowledgebase entry on MONyog and SQLyog appearing here: http://kb.askmonty.org/en/monyog-sqlyog/ It will not be an advertisement but a listing of 15-20 main features of each of the programs. We would have the same 'level of details' for both programs as HeidiSQL has currently. Maybe also it would be better to independent entries for each program? The question is: can we just go ahead and do ourselves or should we share content for discussion/approval here first? Regards Peter Laursen Webyog

3 2

[Maria-discuss] KB Question: Future of MariaDB?
by Daniel Bartholomew 27 Aug '12

27 Aug '12

The following question has been posted to the Knowledgebase: http://kb.askmonty.org/en/future-of-mariadb/ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Future of MariaDB? Where I work, we depend heavily on MySQL. We were recently made aware that Oracle may be slowly closing the source of MySQL; though we are a Sun customer, we depend heavily (and prefer) open source. I mentioned this to my boss and his response was to ask of the future of MariaDB -- because if this project doesn't survive, we're stuck with having to find yet another DB -- in that case, we might have to drink the Oracle koolaid if it comes to that, or move to PostgreSQL (something I've never touched). Commentary on these topics would be interesting to hear. - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 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://gplus.to/mariadb Facebook - http://fb.com/MariaDB.dbms Knowledgebase - http://kb.askmonty.org Monty Program - http://montyprogram.com

2 1

[Maria-discuss] help tables are obsolete
by Federico Razzoli 18 Aug '12

18 Aug '12

Hello I suppose that you are not going to document MariaDB's features in the help tables. Thought, I think you don't know that the MariaDB 5.5.25 help tables still have MySQL 5.1 contents. This means that: * MySQL 5.5 features (like SIGNAL) are not documented * Existing contents point to MySQL 5.1 documentation. I hope that this feedback is useful. Best greetings, Federico Razzoli

2 1

[Maria-discuss] Debian Wheezy repo for MariaDB?
by Terry 15 Aug '12

15 Aug '12

Hi, Now that Debian Wheezy has gone into a freeze, are there any plans to package MariaDB for Wheezy in the near future? Thanks. -- Terry

2 1

[Maria-discuss] "libmysqlclient.so.18 no version information" issue
by Terry 07 Aug '12

07 Aug '12

Hello, I am a relative newbie learning about Linux/MariaDB. I have a test server running Debian Squeeze 6.0.4 with MariaDB 5.5 installed from the MariaDB Squeeze repository. Everything worked great. I upgraded Squeeze to Wheezy (do have a back up so no issue reverting if necessary). Upgrade went rather smoothly. MariaDB running fine. Everything else working fine. On the first night after the upgrade, cron ran and I received several errors: /usr/lib/libmysqlclient.so.18: no version information available (required by exim4) /usr/lib/libmysqlclient.so.18: no version information available (required by /usr/lib/libmu_auth.so.4) The errors don't seem to cause any problems. I still get the e-mails sent by cron. Exim4 is running fine and I have no problems sending or receiving mail. MariaDB is doing fine and my test websites are performing as expected. Can someone give me a hint about where to start looking for the solutio to this? I've googled this and really couldn't find much info about it. Is this because the MariaDB deb package from the repo was built against Squeeze? If so, would the error be corrected if I downloaded the source and built it against Wheezy? Thanks. -- Terry

2 2

[Maria-discuss] MariaDB 5.5 compile error
by Brian Evans 07 Aug '12

07 Aug '12

Hi, I would like some assistance in figuring out a compile error in MariaDB 5.5 series (tested on 5.5.25). I'm trying to create a minimal (client only) build of 5.5.25. This is the cmake configure command used: cmake --no-warn-unused-cli -C /var/tmp/portage/dev-db/mariadb-5.5.25/work/mariadb-5.5.25_build/gentoo_common_config.cmake -DCMAKE_INSTALL_PREFIX=/usr -DCMAKE_INSTALL_PREFIX=/usr -DMYSQL_DATADIR=/var/lib/mysql -DSYSCONFDIR=/etc/mysql -DINSTALL_BINDIR=bin -DINSTALL_DOCDIR=share/doc/mariadb-5.5.25 -DINSTALL_DOCREADMEDIR=share/doc/mariadb-5.5.25 -DINSTALL_INCLUDEDIR=include/mysql -DINSTALL_INFODIR=share/info -DINSTALL_LIBDIR=lib64/mysql -DINSTALL_MANDIR=share/man -DINSTALL_MYSQLDATADIR=/var/lib/mysql -DINSTALL_MYSQLSHAREDIR=share/mysql -DINSTALL_MYSQLTESTDIR=share/mysql/mysql-test -DINSTALL_PLUGINDIR=lib64/mysql/plugin -DINSTALL_SBINDIR=sbin -DINSTALL_SCRIPTDIR=share/mysql/scripts -DINSTALL_SQLBENCHDIR=share/mysql -DINSTALL_SUPPORTFILESDIR=/usr/share/mysql -DWITH_COMMENT=Gentoo Linux mariadb-5.5.25 -DWITHOUT_UNIT_TESTS=1 -DNOT_FOR_DISTRIBUTION=1 -DDEFAULT_CHARSET=latin1 -DDEFAULT_COLLATION=latin1_swedish_ci -DWITHOUT_SERVER=1 -DWITHOUT_EMBEDDED_SERVER=1 -DENABLED_LOCAL_INFILE=1 -DINSTALL_SQLBENCHDIR= -DWITH_SSL=system -DWITH_ZLIB=system -DWITHOUT_LIBWRAP=1 -DWITHOUT_READLINE=1 -DWITHOUT_ARCHIVE_STORAGE_ENGINE=1 -DWITHOUT_BLACKHOLE_STORAGE_ENGINE=1 -DWITHOUT_CSV_STORAGE_ENGINE=1 -DWITHOUT_FEDERATED_STORAGE_ENGINE=1 -DWITHOUT_HEAP_STORAGE_ENGINE=1 -DWITHOUT_INNOBASE_STORAGE_ENGINE=1 -DWITHOUT_MYISAMMRG_STORAGE_ENGINE=1 -DWITHOUT_MYISAM_STORAGE_ENGINE=1 -DWITHOUT_PARTITION_STORAGE_ENGINE=1 -DWITHOUT_INNOBASE_STORAGE_ENGINE=1 -DCMAKE_BUILD_TYPE=RelWithDebInfo -DCMAKE_INSTALL_DO_STRIP=OFF -DCMAKE_USER_MAKE_RULES_OVERRIDE=/var/tmp/portage/dev-db/mariadb-5.5.25/work/mariadb-5.5.25_build/gentoo_rules.cmake /var/tmp/portage/dev-db/mariadb-5.5.25/work/mysql gives the following error during build /var/tmp/portage/dev-db/mariadb-5.5.25/work/mysql/mysys/waiting_threads.c:196:21: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’ before ‘key_WT_RESOURCE_cond’ make[2]: *** [mysys/CMakeFiles/mysys.dir/waiting_threads.c.o] Error 1 However, if i build the full server, I get no error. cmake configure with no error: cmake --no-warn-unused-cli -C /var/tmp/portage/dev-db/mariadb-5.5.25/work/mariadb-5.5.25_build/gentoo_common_config.cmake -DCMAKE_INSTALL_PREFIX=/usr -DCMAKE_INSTALL_PREFIX=/usr -DMYSQL_DATADIR=/var/lib/mysql -DSYSCONFDIR=/etc/mysql -DINSTALL_BINDIR=bin -DINSTALL_DOCDIR=share/doc/mariadb-5.5.25 -DINSTALL_DOCREADMEDIR=share/doc/mariadb-5.5.25 -DINSTALL_INCLUDEDIR=include/mysql -DINSTALL_INFODIR=share/info -DINSTALL_LIBDIR=lib64/mysql -DINSTALL_MANDIR=share/man -DINSTALL_MYSQLDATADIR=/var/lib/mysql -DINSTALL_MYSQLSHAREDIR=share/mysql -DINSTALL_MYSQLTESTDIR=share/mysql/mysql-test -DINSTALL_PLUGINDIR=lib64/mysql/plugin -DINSTALL_SBINDIR=sbin -DINSTALL_SCRIPTDIR=share/mysql/scripts -DINSTALL_SQLBENCHDIR=share/mysql -DINSTALL_SUPPORTFILESDIR=/usr/share/mysql -DWITH_COMMENT=Gentoo Linux mariadb-5.5.25 -DWITHOUT_UNIT_TESTS=1 -DNOT_FOR_DISTRIBUTION=1 -DDEFAULT_CHARSET=latin1 -DDEFAULT_COLLATION=latin1_swedish_ci -DENABLED_LOCAL_INFILE=1 -DEXTRA_CHARSETS=all -DMYSQL_USER=mysql -DMYSQL_UNIX_ADDR=/var/run/mysqld/mysqld.sock -DWITHOUT_READLINE=1 -DWITH_ZLIB=system -DWITHOUT_LIBWRAP=1 -DDISABLE_SHARED=OFF -DWITH_debug=OFF -DWITH_DEBUG=OFF -DWITH_Debug=OFF -DWITH_EMBEDDED_SERVER=OFF -DWITH_profiling=ON -DWITH_PROFILING=ON -DWITH_Profiling=ON -DENABLE_DTRACE=OFF -DWITH_SSL=system -DCMAKE_EXE_LINKER_FLAGS=-ljemalloc -DWITH_SAFEMALLOC=OFF -DWITH_ARCHIVE_STORAGE_ENGINE=1 -DWITH_BLACKHOLE_STORAGE_ENGINE=1 -DWITH_CSV_STORAGE_ENGINE=1 -DWITH_HEAP_STORAGE_ENGINE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_MYISAMMRG_STORAGE_ENGINE=1 -DWITH_MYISAM_STORAGE_ENGINE=1 -DWITH_PARTITION_STORAGE_ENGINE=1 -DWITH_FEDERATED_STORAGE_ENGINE=ON -DWITH_PBXT_STORAGE_ENGINE=OFF -DWITH_OQGRAPH_STORAGE_ENGINE=OFF -DWITH_SPHINX_STORAGE_ENGINE=OFF -DWITH_FEDERATEDX_STORAGE_ENGINE=ON -DCMAKE_BUILD_TYPE=RelWithDebInfo -DCMAKE_INSTALL_DO_STRIP=OFF -DCMAKE_USER_MAKE_RULES_OVERRIDE=/var/tmp/portage/dev-db/mariadb-5.5.25/work/mariadb-5.5.25_build/gentoo_rules.cmake /var/tmp/portage/dev-db/mariadb-5.5.25/work/mysql gentoo_common_config.cmake contains: SET (LIB_SUFFIX 64 CACHE STRING "library path suffix" FORCE) SET (CMAKE_INSTALL_LIBDIR /usr/lib64 CACHE PATH "Output directory for libraries") I'm at a loss why one way works and the the other doesn't. Thank you.

2 4

[Maria-discuss] Questions about GIS functionality (vs MySQL, InnoDB, PostGIS...)
by Henrik Ingo 06 Aug '12

06 Aug '12

Hi Holyfoot, others I've been reading up on the state of GIS functionality. It would be great if I can get some answers directly from the source! 1) Comparing MariaDB and what's there in MySQL 5.6.1: are these identical but independent implementations? If there are differences, what are they? 2) Apparently PostGIS requires to do all kinds of gymnastics both when installing and when doing version upgrades. MySQL/MariaDB spatial functions are just there to be used, right? 3) Speaking of PostGIS, its manual reveals that their GiST R-tree index actually only works on the bounding rectangles of shapes. Is this the case also for MyISAM/Aria R-tree indexes, or would MariaDB actually filter the result set to only return shapes that are within the search shape for real. And btw, does the search shape have to be a box, or can it be any shape? 4) Lack of InnoDB R-tree indexes... What would it take to do that? Is the current implementation re-usable in any way (ie just store current R-tree indexes into InnoDB pages...) or would it have to be a separate implementation? 5) Euclidean geometrics only... PostGIS and SQLite use the separate GEOS library (and cousins like PROJ.4). Why isn't this used in the MySQL/MariaDB implementation? It seems to me, you could get accurate handling of different (non-euclidean) projections by using these libraries, "for free". henrik -- henrik.ingo(a)avoinelama.fi +358-40-8211286 skype: henrik.ingo irc: hingo www.openlife.cc My LinkedIn profile: http://www.linkedin.com/profile/view?id=9522559

2 3

[Maria-discuss] MariaDB repositories - GPG keys and website distro version references
by Arjen Lentz 02 Aug '12

02 Aug '12

Hi Daniel The repository tool on mariadb.com is awesome! I spotted a few things, hope you find the feedback of use: 1) On Debian/Ubuntu, apt-get will require a valid gpg key in its keyring to accept the packages. As root, you can do gpg --keyserver keyserver.ubuntu.com --recv-keys 1BB943DB gpg --export 1BB943DB | apt-key add - ... the other stuff apt-get update although sudo apt-key adv --recv-keys --keyserver keyserver.ubuntu.com 1BB943DB should also work. This adds your key and after that apt-get update will add the repo info to its package database so packages can be installed/upgraded. That said, the nicer method from Karmic (9.10) is sudo apt-get install python-software-properties sudo add-apt-repository <path> sudo apt-get update where <path> is the url you now represent for adding into the apt software sources. The distro tag (natty, etc) and 'main' get sorted out automatically by default. (so the first method needs to be displayed for 8.04 (Hardy) 2) the repo install info on mariadb.com does not show which new package names become available for installation/upgrade. It'd be great if it were to show a list of "now you can install the server by doing "sudo apt-get install/upgrade ...", if you want just the command line client do ..., for the client libraries do ... 3) the distro names currently don't show version numbers, e.g. Ubuntu Natty is not identified as 11.04 For both Ubuntu and Debian it'd be handy to have the numbers there also as it's clearer for users; some people are fine with the naming, others need the numbers. Cheers, Arjen. -- Arjen Lentz, Exec.Director @ Open Query (http://openquery.com) Australian peace of mind for your MySQL infrastructure. Follow us at http://openquery.com/blog/ & http://twitter.com/openquery

2 1

[Maria-discuss] KB Question: Upgrading MariaDB version
by Daniel Bartholomew 01 Aug '12

01 Aug '12

The following question has been posted to the Knowledgebase: http://kb.askmonty.org/en/upgrading-mariadb-version/ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Upgrading MariaDB version OS: RHEL 6.2 (2.6.32-279.1.1.el6.x86_64) I originally installed MariaDB version mariadb-5.1.61-Linux-x86_64 (using generic linux tarball) and was able to copy data under mariadb install and restarted mariadb. Everything with respect from transition of MySQL to MariaDB worked great. Now I am trying to upgrade MariaDB version mariadb-5.1.61-Linux-x86_64 to mariadb-5.5.25-linux-x86_64 (generic linux tarball). I shutdown the 5.1 MariaDB instance, re-created the link to point to the 5.5 distro. Then I restarted MariaDB instance and attempted to upgrade the database using mysql_upgrade -u root -p It looks it made it through information_schema and mysql databases without issue, but ran into some trouble with the database that I had copied in from original MySQL 5.1 instance (database= sahtest, sahtest.ACCESS_ACCOUNTS, Error: Table 'sahtest.ACCESS_ACCOUNTS' doesn't exist, Status: Operation failed). This error happens for all of the tables in the sahtest database. It also tried to Repair the tables of the sahtest database, failing with same error. mysql_upgrade finishes, so then I connect to mariadb and list databases. sahtest is there. If I say use sahtest; show tables; all the tables are there and look ok. Am I on the right track with how to install and upgrade from 5.1 to 5.5 version of MariaDB? TIA, Scott - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 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://gplus.to/mariadb Facebook - http://fb.com/MariaDB.dbms Knowledgebase - http://kb.askmonty.org Monty Program - http://montyprogram.com

1 0

[Maria-discuss] KB Question: InnoDB recovery under Maria
by Daniel Bartholomew 01 Aug '12

01 Aug '12

The following question has been posted to the Knowledgebase: http://kb.askmonty.org/en/innodb-recovery-under-maria/ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - InnoDB recovery under Maria Hi, I have been using MySQL for various embedded situation over the years. I am currently working on a new version of an existing project which I'm also migrating to MariaDB (I think I prefer Monty's style!). OK. Some tables in this database get update from an external source in a complex manner, so I am using InnoDB on these table with a transaction to ensure the operation is either completed or completely abandoned. This is an embedded app, and it can be interupted abruptly, leaving the InnoDB tables blocked. The procedure in this case is to set InnoDB recover to 4, dump the database, manually delete the InnoDB files, restart normally, restore, and then force an update from the external source. I'm hoping I will eventually be able to solve this using Aria tables, but in the meantime is there any way I can automate the process. I don't need to recover the data in the InnoDB tables following a crash, I just need to know that it has happened so I can get a new dataset. Thanks in advance for any help or suggestions. - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 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://gplus.to/mariadb Facebook - http://fb.com/MariaDB.dbms Knowledgebase - http://kb.askmonty.org Monty Program - http://montyprogram.com

1 0

[Maria-discuss] Did we drop source for IBMDB2I?
by Colin Charles 28 Jul '12

28 Jul '12

Hi! Reading: http://kb.askmonty.org/en/mariadb-versus-mysql-features/ "IBMDB2I. Oracle removed this in MySQL 5.1.55 but we have kept the code in MariaDB until the version 5.5." I'm not so sure. I looked for this engine in a 5.5.25 tarball in storage/ and didn't see it. It is in 5.3 tree trunk, but not 5.5 Is this an oversight? Or have we decided to remove the engine? 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/

2 1

[Maria-discuss] KB Question: GROUP BY trick has been optimized away
by Daniel Bartholomew 23 Jul '12

23 Jul '12

The following question has been posted to the Knowledgebase: https://kb.askmonty.org/en/group-by-trick-has-been-optimized-away/ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - GROUP BY trick has been optimized away Group-by trick example: Find the most populous city in each state: SELECT state, city, population, COUNT(*) AS num_cities FROM ( SELECT state, city, population FROM us ORDER BY state, population DESC ) p GROUP BY state ORDER BY state; +-------+-------------+------------+------------+ | state | city | population | num_cities | +-------+-------------+------------+------------+ | AK | Anchorage | 276263 | 16 | | AL | Birmingham | 231621 | 58 | | AR | Little Rock | 184217 | 40 | | AZ | Phoenix | 1428509 | 51 | | CA | Los Angeles | 3877129 | 447 | ... That was the output in MySQL 5.1. But with MariaDB 5.5.23, I get: +-------+-------------------+------------+------------+ | state | city | population | num_cities | +-------+-------------------+------------+------------+ | AK | Anchorage | 276263 | 16 | | AL | Alabaster | 26738 | 58 | | AR | Arkadelphia | 11062 | 40 | | AZ | Apache Junction | 34904 | 51 | | CA | Adelanto | 21955 | 447 | ... The EXPLAIN plan do longer shows a subquery, as if the inner ORDER BY has been thrown away. Granted, there is nothing in the definition of MySQL (much less in the SQL standard) that requires that Los Angeles should be bigger than Adelanto. But the replacement code for this 'trick' is quite messy. Am I correct in deducing (from the outside, looking in) that MariaDB's optimizations are the cause of the change? - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 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://gplus.to/mariadb Facebook - http://fb.com/MariaDB.dbms Knowledgebase - http://kb.askmonty.org Monty Program - http://montyprogram.com

1 0

[Maria-discuss] KB Question: DROP TABLE Syntax Causing Memory Leak
by Daniel Bartholomew 23 Jul '12

23 Jul '12

The following question has been posted to the Knowledgebase: https://kb.askmonty.org/en/drop-table-syntax-causeing-memory-leak/ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - DROP TABLE Syntax Causing Memory Leak I have a Server with 2 Xeon E5645 total 12cores and 24 threads on a X8DAH+-F-B Motherboard and 96Gigs of Memory and 4 Terabytes of hard drive space. We are running the newest stable release of MariaDB 5.5.25. every night I run a PHP script to bring a large data set roughly 500K records or so into a XtraDB Table I use as a "SWAP" table. I processing,filtering, massaging the data in this table then insert this processed data into other tables where it can be accessed by a web application. At the end of this Script I DROP this "SWAP" table. This Script runs 24 times a day and does not seem to have much issues. But For Some reason seemingly randomly the DROP table Command while checking permissions to drop the Table will lockup the database. I have tried truncate too and it seems to have the same issue. The innodb_buffer_pool_size=35G. Any Ideas what the problem could be or where to start looking? Noctechie - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 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://gplus.to/mariadb Facebook - http://fb.com/MariaDB.dbms Knowledgebase - http://kb.askmonty.org Monty Program - http://montyprogram.com

1 0

[Maria-discuss] MariaDB 5.5.25 now available
by Daniel Bartholomew 22 Jun '12

22 Jun '12

The MariaDB project is pleased to announce the immediate availability of MariaDB 5.5.25. This is a stable (GA) release. It includes MariaDB 5.3 and MySQL 5.5.25. - - MariaDB 5.5 Links - - - - - - - - - - - - - - - - - - - - - - - - - Release Notes: http://kb.askmonty.org/en/mariadb-5525-release-notes Changelog: http://kb.askmonty.org/en/mariadb-5525-changelog Downloads: http://downloads.mariadb.org/mariadb/5.5.25 APT and YUM Repository Configuration Generator: http://downloads.mariadb.org/mariadb/repositories/ Overview of MariaDB 5.5: http://kb.askmonty.org/en/what-is-mariadb-55 - - Where else to find us - - - - - - - - - - - - - - - - - - - - - - - We're on: Facebook: http://www.facebook.com/MariaDB.dbms Twitter: http://twitter.com/#!/mariadb Google+: http://gplus.to/mariadb Follow, friend, and add us to your circles to keep up to date with MariaDB! - - 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 - - - - - - - - - - - - - - - - - - - - - - - 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/ - - 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] 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] MariaDB 5.5.24 now available
by Daniel Bartholomew 31 May '12

31 May '12

The MariaDB project is pleased to announce the immediate availability of MariaDB 5.5.24. This is a stable (GA) release. It includes MariaDB 5.3.7 and MySQL 5.5.24. This version of MariaDB introduces new RPM packages for RHEL 5, CentOS 5 & 6, and Fedora 16. We have also created YUM repositories for those distributions. Setup instructions are available here: http://kb.askmonty.org/en/installing-mariadb-with-yum/ We are also now offering packages for BSD 9, MacOS X 10.5 (will be available within 24 hours), and Ubuntu 12.04 "Precise" (via our Ubuntu APT repository). - - MariaDB 5.5 Links - - - - - - - - - - - - - - - - - - - - - - - - - Release Notes: http://kb.askmonty.org/en/mariadb-5524-release-notes Changelog: http://kb.askmonty.org/en/mariadb-5524-changelog Downloads: http://downloads.askmonty.org/mariadb/5.5.24 APT and YUM Repository Configuration Generator: http://downloads.askmonty.org/mariadb/repositories/ Overview of MariaDB 5.5: http://kb.askmonty.org/en/what-is-mariadb-55 - - 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

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

25 Apr '12

On 4/14/2012 1:31 AM, Oleksandr Byelkin wrote: > 11.04.2012 23:51, Brian Evans написал: >> 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 ..................... > > Could you describe condition of running (OS, 32/64 bit and so on). I > can't repeat it so need more information. > > [skip] Sure. This is output from my build tool which lists important libraries and the environment used. OS is Gentoo Linux. Architecture is x86_64. Portage 2.1.10.49 (default/linux/amd64/10.0, gcc-4.5.3, glibc-2.13-r4, 2.6.38-gentoo-r6 x86_64) ================================================================= System uname: Linux-2.6.38-gentoo-r6-x86_64-Intel-R-_Xeon-TM-_CPU_3.40GHz-with-gentoo-2.0.3 Timestamp of tree: Thu, 29 Mar 2012 19:30:01 +0000 app-shells/bash: 4.2_p20 dev-lang/python: 2.7.2-r3, 3.1.4-r3, 3.2.2 dev-util/cmake: 2.8.6-r4 dev-util/pkgconfig: 0.26 sys-apps/baselayout: 2.0.3 sys-apps/openrc: 0.9.8.4 sys-apps/sandbox: 2.5 sys-devel/autoconf: 2.68 sys-devel/automake: 1.9.6-r3, 1.11.1 sys-devel/binutils: 2.21.1-r1 sys-devel/gcc: 4.5.3-r1 sys-devel/gcc-config: 1.5-r2 sys-devel/libtool: 2.4-r1 sys-devel/make: 3.82-r1 sys-kernel/linux-headers: 3.1 (virtual/os-headers) sys-libs/glibc: 2.13-r4 CBUILD="x86_64-pc-linux-gnu" CFLAGS="-O2 -pipe -march=nocona" CHOST="x86_64-pc-linux-gnu" CXXFLAGS="-O2 -pipe -march=nocona" LANG="en_US.UTF-8" LDFLAGS="-Wl,-O1 -Wl,--as-needed" MAKEOPTS="-j5"

2 3

Re: [Maria-discuss] MariaDB & InnoDB native aio disabled
by Axel Schwenke 25 Apr '12

25 Apr '12

Hi Jocelyn, jocelyn fournier wrote: > > I've just figured out after installing MariaDB 5.5.23 on two server (one > directly from the x64 binary, and the other using the debian packing) > that innodb_use_native_aio is OFF on the two servers. ... > Am I missing something ? No, you are right. It seems both the tar.gz and deb packages provided by us are built without libaio. For the deb packages, we regard this a bug and I created this bug report: https://bugs.launchpad.net/maria/+bug/988204 For the tar.gz packages, we are rather reluctant to add additional dependencies like libaio. Unless deb, a tar.gz package cannot announce such dependencies, so users might end with a dysfunctional installation without a warning. We will review this decision internally. Thank you for reporting this problem! Axel Schwenke Senior Performance Engineer, MariaDB Services AB

1 0