October 2014 - discuss - lists.mariadb.org

[Maria-discuss] New Question: Historical data, nightly snapshots
by AskMonty KB 18 Oct '14

18 Oct '14

Hello, A new question has been asked in "MariaDB Documentation" by bjquinn: -------------------------------- I have an application where I need to take nightly snapshots of a large InnoDB database (10s of GB) and then have them available to be queried alongside the current data. My underlying filesystem is (or at least can be) ZFS, so actually creating the snapshots is easy enough. But how do I connect to the files contained in the snapshot so that I can query the tables via MariaDB? If it's easier through another storage engine, I could consider that, though I do need row locking in the current data. The historical data would be read only (obviously) and wouldn't need to be changed. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/historical-data-nightly-snapshots/

1 0

[Maria-discuss] New MariaDB 10.1 and MariaDB Galera Cluster releases
by Daniel Bartholomew 17 Oct '14

17 Oct '14

The MariaDB project is pleased to announce the immediate availability of the following new releases: - MariaDB Galera Cluster 5.5.40-stable - MariaDB Galera Cluster 10.0.14-stable - MariaDB 10.1.1-alpha See the Release Notes and Changelogs for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB Galera Cluster 5.5.40 - Release Notes: https://mariadb.com/kb/en/mgc-5540-release-notes - Changelog: https://mariadb.com/kb/en/mgc-5540-changelog - Downloads: https://downloads.mariadb.org/mariadb-galera/5.5.40 MariaDB Galera Cluster 10.0.14 - Release Notes: https://mariadb.com/kb/en/mgc-10014-release-notes - Changelog: https://mariadb.com/kb/en/mgc-10014-changelog - Downloads: https://downloads.mariadb.org/mariadb-galera/5.5.40 About MariaDB Galera Cluster: - https://mariadb.com/kb/en/what-is-mariadb-galera-cluster/ MariaDB 10.1.1 - Release Notes: https://mariadb.com/kb/en/mariadb-1011-release-notes - Changelog: https://mariadb.com/kb/en/mariadb-1011-changelog - Downloads: https://downloads.mariadb.org/mariadb/10.1.1 About MariaDB 10.1: - https://mariadb.com/kb/en/what-is-mariadb-101/ APT and YUM Repository Configuration Generator: - https://downloads.mariadb.org/mariadb/repositories/ - - MariaDB Webinars - - - - - - - - - - - - - - - - - - - - - - - - - There are several upcoming MariaDB-focused webinars and many previously held ones available to watch on an on-demand basis at: - https://mariadb.com/news-events/webinars - - MariaDB Books - - - - - - - - - - - - - - - - - - - - - - - - - - There is an ever-growing library of MariaDB books available to help you get the most out of MariaDB. See the MariaDB Books page for details and links: - https://mariadb.com/kb/en/mariadb/books/ - - 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 or my.ini file! See http://mariadb.com/kb/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 the MariaDB Foundation, please see the "contributing" and "donations" pages. We also have merchandise available in a cafepress store. All proceeds go to support the MariaDB Foundation. - https://mariadb.com/kb/en/contributing - https://mariadb.org/en/donate/ - http://www.cafepress.com/mariadb We hope you enjoy MariaDB! -- MariaDB Website - http://mariadb.org Twitter - http://twitter.com/mariadb Google+ - http://google.com/+mariadb Facebook - http://fb.com/MariaDB.dbms Knowledge Base - http://mariadb.com/kb

1 0

Re: [Maria-discuss] .ibd files remaining after DROP TABLE
by Andrew Braithwaite 17 Oct '14

17 Oct '14

Hi, It only seems to happen when replicating DROP TABLE IF NOT EXISTS from a master, not when running it directly on that server. I can replicate this problem every time. Thanks, Andrew On 17 September 2014 15:49, Jan Lindström <jan.lindstrom(a)skysql.com> wrote: > Hi, > > Not at least normally both should be deleted, but maybe not immediately. > Can you provide a example ? > > R: Jan > > On Wed, Sep 17, 2014 at 4:36 PM, Andrew Braithwaite < > andrew.braithwaite(a)graze.com> wrote: > >> Hi, >> >> After dropping tables on my MariaDB 10.0.13 database server, the .frm >> files are removed but the .ibd files remain behind. >> >> Has anyone seen this before? >> >> Thanks.... Andrew >> >> mysqld Ver 10.0.13-MariaDB-1~trusty for debian-linux-gnu on x86_64 ( >> mariadb.org binary distribution) >> >> DISTRIB_ID=Ubuntu >> DISTRIB_RELEASE=14.04 >> DISTRIB_CODENAME=trusty >> DISTRIB_DESCRIPTION="Ubuntu 14.04.1 LTS" >> NAME="Ubuntu" >> VERSION="14.04.1 LTS, Trusty Tahr" >> ID=ubuntu >> ID_LIKE=debian >> PRETTY_NAME="Ubuntu 14.04.1 LTS" >> VERSION_ID="14.04" >> HOME_URL="http://www.ubuntu.com/" >> SUPPORT_URL="http://help.ubuntu.com/" >> BUG_REPORT_URL="http://bugs.launchpad.net/ubuntu/" >> >> _______________________________________________ >> Mailing list: https://launchpad.net/~maria-discuss >> Post to : maria-discuss(a)lists.launchpad.net >> Unsubscribe : https://launchpad.net/~maria-discuss >> More help : https://help.launchpad.net/ListHelp >> >> > > > -- > > -- > > Jan Lindström, Principal Engineer > SkySQL - The MariaDB Company > > skype: jan_p_lindstrom > > www.skysql.com > <http://www.google.com/url?q=http%3A%2F%2Fwww.skysql.com%2F&sa=D&sntz=1&usg=…> > > [image: Twitter] > <http://www.google.com/url?q=http%3A%2F%2Ftwitter.com%2Fskysql&sa=D&sntz=1&u…> > [image: Blog] > <http://www.google.com/url?q=http%3A%2F%2Fwww.skysql.com%2Fblog%2F&sa=D&sntz…> > [image: Facebook] > <http://www.google.com/url?q=http%3A%2F%2Fwww.facebook.com%2Fskysql&sa=D&snt…> > [image: LinkedIn] > <http://www.google.com/url?q=http%3A%2F%2Fwww.linkedin.com%2Fcompany%2F12142…> > [image: Google+] <https://plus.google.com/117544963211695643458/posts> >

3 2

[Maria-discuss] Aborted connection (Unknown error)
by Florent Bautista 15 Oct '14

15 Oct '14

Hi all, I'm getting annoying errors when I want to switch clients from MySQL to MariaDB. I use Debian Wheezy, and MariaDB 10.0 repositories, then I install mariadb-common & libmariadbclient. Then I restart services using MySQL Client Library and I have a lot of warnings like these on my MariaDB Server (with Galera or not) : [Warning] Aborted connection 136305 to db: 'db' user: 'user' host: 'xx.xx.xx.xx' (Unknown error) I do not have more information in logs. This is not a network problem, because it occurs with 127.0.0.1 too. What do I miss ? Thank you a lot. Florent

2 2

[Maria-discuss] MariaDB 5.5.40 now available
by Daniel Bartholomew 09 Oct '14

09 Oct '14

The MariaDB project is pleased to announce the immediate availability of MariaDB 5.5.40 This is a Stable (GA) release. See the Release Notes and Changelog for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 5.5.40 - Release Notes: https://mariadb.com/kb/en/mariadb-5540-release-notes - Changelog: https://mariadb.com/kb/en/mariadb-5540-changelog - Downloads: https://downloads.mariadb.org/mariadb/5.5.40 About MariaDB 5.5: - https://mariadb.com/kb/en/what-is-mariadb-55/ APT and YUM Repository Configuration Generator: - https://downloads.mariadb.org/mariadb/repositories/ - - MariaDB Webinars - - - - - - - - - - - - - - - - - - - - - - - - - There are several upcoming MariaDB-focused webinars and many previously held ones available to watch on an on-demand basis at: - https://mariadb.com/news-events/webinars - - MariaDB Books - - - - - - - - - - - - - - - - - - - - - - - - - - There is an ever-growing library of MariaDB books available to help you get the most out of MariaDB. See the MariaDB Books page for details and links: - https://mariadb.com/kb/en/mariadb/books/ - - 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 or my.ini file! See http://mariadb.com/kb/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 the MariaDB Foundation, please see the "contributing" and "donations" pages. We also have merchandise available in a cafepress store. All proceeds go to support the MariaDB Foundation. - https://mariadb.com/kb/en/contributing - https://mariadb.org/en/donate/ - http://www.cafepress.com/mariadb We hope you enjoy MariaDB! -- MariaDB Website - http://mariadb.org Twitter - http://twitter.com/mariadb Google+ - http://google.com/+mariadb Facebook - http://fb.com/MariaDB.dbms Knowledge Base - http://mariadb.com/kb

1 0

Re: [Maria-discuss] MariaDB,TokuDB and FusionIO
by Christophe Le Roux 02 Oct '14

02 Oct '14

Hi Jan, Thank you for your answer. I am writing to the TokuDB community. I hope for good news ☺ Cordialement, [Claranet]<http://www.claranet.fr/> [Linkedin]<http://www.linkedin.com/company/claranet> [Twitter]<https://twitter.com/#!/Claranet_FR> [Youtube]<http://www.youtube.com/user/ClaranetFR> [Gartner MQ]<http://www.claranet.fr/propos-de/gartner.html> De : Jan Lindström [mailto:jan.lindstrom@mariadb.com] Envoyé : mardi 30 septembre 2014 10:38 À : Christophe Le Roux; Maria Discuss Objet : Re: [Maria-discuss] MariaDB,TokuDB and FusionIO Hi, On Tue, Sep 30, 2014 at 11:27 AM, Christophe Le Roux <christophe.le.roux(a)fr.clara.net<mailto:christophe.le.roux@fr.clara.net>> wrote: About NVM compression, is it a hardware compression doing by the FusionIO controller or is it a software compression doing by the CPU of the server ? Compression is done by CPU in the MariaDB server (InnoDB/XtraDB storage engine). About Atomic Write, I understand there is missing code to have this feature to the TokuDB engine. Should I ask to the Mariadb dev team or the Tokutek dev team (or SanDisk/FusionIO dev team ?) to add it (maybe it’s technically no doable ?)? I would start from Tokutek dev team, I do not know fully how database tables are stored on Tokutek, but I do not see immediately a reason why atomic writes would not be possible. Do you think this can boost performances for huge TokuDB tables ? Atomic will boost performance but only if database is stored on device that supports atomic writes. R: Jan

4 5