November 2014 - discuss - lists.mariadb.org

[Maria-discuss] MariaDB 10.0.15 now available
by Daniel Bartholomew 10 Dec '14

10 Dec '14

The MariaDB project is pleased to announce the immediate availability of MariaDB 10.0.15 This is a Stable (GA) release. See the Release Notes and Changelog for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 10.0.15 - Release Notes: https://mariadb.com/kb/en/mariadb-10015-release-notes - Changelog: https://mariadb.com/kb/en/mariadb-10015-changelog - Downloads: https://downloads.mariadb.org/mariadb/10.0.15 About MariaDB 10.0: - https://mariadb.com/kb/en/what-is-mariadb-100/ 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

7 29

[Maria-discuss] MariaDB for OpenSuSE 12.3
by Peter Laursen 06 Dec '14

06 Dec '14

I have OpenSuSE 12.3. It ships with MariaDB 1.0.13 - and with no TokuDB and no Galera options. I would like to upgrade to 10.0.14 and also enable TokuDB. And it does not seem that an upgrade will be available from SuSE software repositories. There are a lot of RPMs in the yum repository http://mirror.23media.de/mariadb/mariadb-10.0.14/yum/. But does anyone know if they will work with SuSE 12.3? Runtime environment (kernel, glibc etc.) should be compatible of course, and also RPMs for Redhat/Fedora/CentOS systems will not alwyas work on SuSE, as SuSE has some specific requirements for the SPECS. When I used SuSE 10.x many years ago, the generic "glibc23" RPMs available worked perfectly. Note: I *only* want to install a server that can be handled by SuSE's YaST package manager! So suggestons for any other solution (such as using the tarball) is not an option. Or it would be last resort. I would not mind give it a try if someone can advise what I should try. I have SuSE running in a VM and I will be able to return to a snapshot of the system easily if something goes wrong. -- Peter

5 23

[Maria-discuss] New Question: Upgrade vom v5.5 to 10 using OpenSuse 13.1 (64bit) and Intel (no AMD)
by AskMonty KB 29 Nov '14

29 Nov '14

Hello, A new question has been asked in "MariaDB community" by thomasschulze. Please answer it at http://mariadb.com/kb/en/upgrade-vom-v55-to-10-using-opensuse-131-64bit-and… as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hi, regarding the upgrade to to v10.0, I found at: http://yum.mariadb.org/10.0/ and https://downloads.mariadb.org/mariadb/repositories/#mirror=23Media&version=… that Intel processors are not support yet, is that true. I assume that installing it from source wouldn't work out as well? How are we able to upgrade to v10, using OpenSuSe 13.1 (64bit); Intel? Does anybody got an idea here? Thanks! -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/upgrade-vom-v55-to-10-using-opensuse-131-64bit-and…

1 0

[Maria-discuss] New Question: Waiting for table metadata lock - during parallel database loads
by AskMonty KB 25 Nov '14

25 Nov '14

Hello, A new question has been asked in "MariaDB community" by stephenwerner. Please answer it at http://mariadb.com/kb/en/waiting-for-table-metadata-lock-during-parallel-da… as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hi, Is there a parameter/system variable that can be set to allow multiple database loads? It seems to be a right handbrake when loading more than one database at a time. Regards, Stephen. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/waiting-for-table-metadata-lock-during-parallel-da…

1 0

[Maria-discuss] MariaDB 10.1 uses huge amount of memory onWndows
by Peter Laursen 23 Nov '14

23 Nov '14

Please see attached imaged - a screenshot of Windows Task manager. I have a lot of MySQL and MariaDB servers installed (all needed for application testing). It is noticeable that MariaDB 10.1 uses around twice as much as much memory as compared to MariaDB 10.0, MySQL 5.6 and 5.7 (5 GB versus 2.5 GB in rough numbers). Even more surprising to me as P_S is not running with 10.1 (as I understand). Further I have MariaDB 10.0 running virtualized in OpenSuSE 12.3 inside Virtualbox. The process for the virtual machine use only around 10% or memory as compared to MariaDB 10.0 running natively on Windows (there is also an active VM running Mint Linux - but MySQL is not running there currently) I also have a number of older MySQL servers (5.0, 5.1 and 5.5) The use much less memory. That is expected as the configuration reserves smaller buffers. Both MariaDB servers in Windows use the configuration created by the installer. MySQL 5.6 adn 57 servers use the MySQL Installer standard "developer machine" configuration. The configuraiton of MariaDB 10 in SuSE is as shipped with the distro (I did not check it actually). None of the servers have been connected to since system was restarted. System has been running for approximately 4 hours and all servers start with Windows. The VM with SuSE has been running for approxmately 2 hours. In the attached image I have framed and starred my observations. I want to emphatize, that I don't face any problems with this at all. I have 32 GB RAM and 4 CPUs each capable of processing 2 parallel threads,and I can run Windows 7 with all the servers you see (and simultaneously use the system iinteractively for Internet browsing, playing media, processing photos, document creation/editing and what else you would do with a desktop system), as well as have the two VMs (both configured with an upper resource limit of 24 GB RAM and 6 CPU threads). The memory may be released if it is required by other processes. I don't think it is a problem to use memory if it is available if it will be released when it is required elsewhere (on the opposite it was a little expensive, so it would be a shame if it was not used at all!) But still I find the find the MariaDB 10.1 number for memory use so much *off* as compared to comparable servers, that I think I should mention the observation here. IMO it should be understood **why** it happens and next it can be decided **if** a fix is necessary or not. -- Peter -- Webyog

6 18

[Maria-discuss] (no subject)
by Pierre GOUPIL 22 Nov '14

22 Nov '14

Good morning, Is there a way to have MariaDB run in-memory? I mean, without changing the table engines. I have my production code which needs to be persisted to disk, but for my unit tests, it would be great to have an in-memory DB. I'm in the Java world and I've tried HSQLDB but its SQL implementation is way too different than that of MariaDB. Any ideas? Cheers, Zala -- NoT DeaD which can eternal live, Stranger eons death may die. (HP Lovecraft)

7 9

[Maria-discuss] New Question: link to debugging
by AskMonty KB 21 Nov '14

21 Nov '14

Hello, A new question has been asked in "Compiling MariaDB From Source" by daniel-black. Please answer it at http://mariadb.com/kb/en/link-to-debugging/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- can a link to [[Compiling MariaDB for debugging]] be added to this page? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/link-to-debugging/

1 0

[Maria-discuss] New Question: how to compile tokudb engine in MariaDB 10.0.14
by AskMonty KB 20 Nov '14

20 Nov '14

Hello, A new question has been asked in "SQL Language Structure" by wenfangzhang. Please answer it at http://mariadb.com/kb/en/how-to-compile-tokudb-engine-in- mariadb-10014/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- I want to ues tokudb engine for testing in MariaDB 10.0.14, but i don't know how to compile if from source code? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/how-to-compile-tokudb-engine-in-mariadb-10014/

1 0

[Maria-discuss] Can't delete row in table Mariadb-galera
by Carlos R Laguna 19 Nov '14

19 Nov '14

Hello everyone i am try to delete some row from a specific table in my DB however this never take place, i though it was because galera-limitations but my table has a primary key +---------------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------------+--------------+------+-----+---------+-------+ | id | varchar(255) | NO | PRI | NULL | | | actions | varchar(255) | NO | | NULL | | | clientip | char(15) | NO | | NULL | | | date | date | NO | MUL | NULL | | | from_address| varchar(255) | NO | MUL | NULL | | | from_domain varchar(255) | NO | MUL | NULL | | | headers | longtext | NO | | NULL | | | hostname | longtext | NO | | NULL | | | highspam | int(11) | NO | MUL | 0 | | | rblspam | int(11) | NO | | 0 | | | saspam | int(11) | NO | | 0 | | | spam | int(11) | NO | MUL | 0 | | | nameinfected| int(11) | NO | | 0 | | | otherinfected | int(11) | NO | | 0 | | | isquarantined | int(11) | NO | MUL | 0 | | | sascore | double | NO | | NULL | | | scaned | int(11) | NO | | 0 | | | size | int(11) | NO | | NULL | | | blacklisted | int(11) | NO | MUL | 0 | | | spamreport | longtext | NO | | NULL | | | whitelisted | int(11) | NO | MUL | 0 | | | subject | longtext | NO | | NULL | | | time | time | NO | | NULL | | | timestamp | datetime | NO | MUL | NULL | | | to_address | varchar(255) | NO | MUL | NULL | | | to_domain | varchar(255) | NO | MUL | NULL | | | virusinfected | int(11) | NO | | 0 | | +---------------+--------------+------+-----+---------+-------+ this is the script i am running against the db class Command(NoArgsCommand): "Archive messages and delete from messages table" help = _("Deletes records older than QUARANTINE_DAYS_TO_KEEP" " days from the messages table") def handle_noargs(self, **options): #import datetime #from baruwa.messages.models import Message #interval = datetime.timedelta(days=60) #last_date = datetime.datetime.now() - interval #Message.objects.filter(timestamp__lt=last_date).delete() days = getattr(settings, 'QUARANTINE_DAYS_TO_KEEP', 10) conn = connection.cursor() conn.execute( """DELETE FROM messages WHERE id in (SELECT id FROM archive WHERE timestamp < DATE_SUB(CURDATE(), INTERVAL %s DAY)) """ % str(days) ) conn.execute( """INSERT LOW_PRIORITY INTO archive SELECT * FROM messages WHERE timestamp < DATE_SUB(CURDATE(), INTERVAL %s DAY) """ % str(days) ) conn.execute( """DELETE LOW_PRIORITY FROM messages WHERE timestamp < DATE_SUB(CURDATE(), INTERVAL %s DAY) """ % str(days) ) conn.execute('OPTIMIZE TABLE messages') conn.execute('OPTIMIZE TABLE archive') Is this a limitation? or i am facing something else. Thanks in advance for your time. Regards ________________________________________________________________ XII Edicion del Evento Nacional de Informatica para Jovenes. INFOCLUB. Abril. 2015. Ver www.jovenclub.cu ________________________________________________________________ -- Este mensaje ha sido analizado por MailScanner en busca de virus y otros contenidos peligrosos, y se considera que est� limpio.

1 0

[Maria-discuss] New Question: MariaDB sorting issue
by AskMonty KB 17 Nov '14

17 Nov '14

Hello, A new question has been asked in "MariaDB FAQ" by sagarlotiya. Please answer it at http://mariadb.com/kb/en/mariadb-sorting-issue/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hi, I have one table with 4 million rows and other table with 1 million rows. When I perform join on both the table and perform the sort on the column which is not main table it is behaving really slow. I have tested with 8 GB RAM. Whole database fits in memory. I have also checked with EXPLAIN it is not creating temporary table on disk. How can I get best performance? e.g query. SELECT DISTINCT u0_.id AS id_0, a1_.created_at AS created_at_1 FROM user u0_ LEFT JOIN advertise a1_ ON (a1_.user_id = u0_.id) ORDER BY a1_.created_at DESC LIMIT 10; Also note that all the indexes are properly created so that is not he issue here. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/mariadb-sorting-issue/

1 0

[Maria-discuss] pid file could not be found
by Roth, Sandro 14 Nov '14

14 Nov '14

Hi there I'm having a weird problem after a fresh installation of RHEL6 and MariaDB: [root@server ~]# yum install MariaDB-10.1.1-centos6-x86_64-server.rpm MariaDB-10.1.1-centos6-x86_64-client.rpm MariaDB-10.1.1-centos6-x86_64-compat.rpm MariaDB-10.1.1-centos6-x86_64-common.rpm [...] [root@server ~]# /etc/init.d/mysql status MySQL is not running [FAILED] [root@server ~]# /etc/init.d/mysql start Starting MySQL. [ OK ] [root@server ~]# /etc/init.d/mysql status MySQL is running but PID file could not be found [FAILED] [root@spch9140 ~]# ls -al /var/lib/mysql/server.local-recover.pid -rw-rw---- 1 mysql mysql 6 Nov 14 07:41 /var/lib/mysql/server.local-recover.pid [root@server ~]# more /var/lib/mysql/server.local-recover.pid 25071 [root@server ~]# ps aux | grep 25071 mysql 25071 0.0 2.9 795548 116980 pts/0 Sl 07:41 0:02 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/lib/mysql/server.local.err --pid-file=/var/lib/mysql/server.local.pid --wsrep_recover --log_error=/var/lib/mysql/wsrep_recovery.U7vwNv --pid-file=/var/lib/mysql/server.local-recover.pid root 27665 0.0 0.0 103256 856 pts/0 S+ 08:30 0:00 grep 25071 Also tried version 10.0.14, same issue.. Putting 'pid-file' option into /etc/my.cnf.d/server.cnf doesn't help either :( Anyone seen this too or have a suggestion? Thanks Sandro This email message and any attachments are confidential and may be privileged. If you are not the intended recipient, please notify us immediately and destroy the original transmittal. You are hereby notified that any review, copying or distribution of it is strictly prohibited. Thank you for your cooperation. Header information contained in E-mails to and from the company are monitored for operational reasons in accordance with swiss data protection act.

2 1

[Maria-discuss] 10.1 + Galera
by Tim Callaghan 13 Nov '14

13 Nov '14

3 3

[Maria-discuss] debuginfo packages for MariaDB Galera Cluster 5.5
by Pim Rupert (Lemonbit) 12 Nov '14

12 Nov '14

Where could one find the debuginfo packages for MariaDB Galera Cluster 5.5? I could not find it in the yum channels. - Pim

1 0

[Maria-discuss] New Question: MariaDB configuration file license?
by AskMonty KB 11 Nov '14

11 Nov '14

Hello, A new question has been asked in "MariaDB FAQ" by aled_sage_g. Please answer it at http://mariadb.com/kb/en/mariadb-configuration-file-license/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hi, Are the default MariaDB configuration files licensed under GPL, or is there a more permissive license for it? The context of my question... I am a committer on the apache Brooklyn project [1]. This automates the deployment and runtime management of applications to a range of different clouds. MariaDB can be one of a range of components being deployed and wired together. We have copied the my.cnf configuration file, and templated it so that automated deployment of custom configurations are simpler. However, Apache does not allow inclusion of GPL/LGPL material [2]. We may have to write our own version of the configuration file from scratch, or delete our templated version and resort to `sed` commands to modify the default (yuck!). Aled [1] https://brooklyn.incubator.apache.org/ [2] http://www.apache.org/legal/3party.html -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/mariadb-configuration-file-license/

1 0

[Maria-discuss] New Question: problem of installing and downloading MariaDB
by AskMonty KB 11 Nov '14

11 Nov '14

Hello, A new question has been asked in "MariaDB community" by wenfangzhang: -------------------------------- hello: i have downloaded mariadb-10.0.14-linux-x86_64.tar.gz , but when i decompress this package , it has errors: this packeage is interrupted . i have triede several times, but it still has this problem. and last , i download the source code of this veision mariadb-10.0.14.tar.gz. After installing this , i try to install tokudb engine by using install soname 'ha_tokudb' , but it also has problems :ERROR 1126 (HY000): Can't open shared library '/usr/local/mariadb/lib/plugin/ha_tokudb.so' (errno: 13, cannot open shared object file: No such file or directory). In fact , i want to install the newest version of MariaDB with tokuDB engine . so what can i do ? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/problem-of-installing-and-downloading-mariadb/

1 0

[Maria-discuss] New Question: MariaDB installation
by AskMonty KB 11 Nov '14

11 Nov '14

Hello, A new question has been asked in "Getting Started" by jorgearaya: -------------------------------- How can I install MariaDB on Suse Linux? SUSE Linux Enterprise Server 11 (x86_64) VERSION = 11 PATCHLEVEL = 1 Thanks -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/mariadb-installation/

1 0

[Maria-discuss] New Question: newbie question
by AskMonty KB 07 Nov '14

07 Nov '14

Hello, A new question has been asked in "MariaDB community" by lennartjohansson: -------------------------------- Hi all, I'm a newie to Mariadb but do have a question if a thing we need to do in a project is possible to do at all. We are working with a id-project where Sybase is feeding data into a ldap directory, now we need do to a upgrade witch means that the connector to sybase are lost. To get that to work again we need to have new views build in Sybase and since we dont own the Sybase database that is crazy expenciv. So we thought about using MariaDB as a middleware and store data from Sybase in it and use that instead as data source for our directory. So my question is if it's possible in MariaDB to run a query that reads data from a Sybase DB and store the result? And if so does anybody have any suggestions about best practice how to do that. /Lenanrt -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/newbie-question/

2 1

[Maria-discuss] Maybe a new information schema table for replication?
by Roberto Spadim 06 Nov '14

06 Nov '14

Hi guys, i got one question these days and i don't know how to solve... the question is: "How to see the queries executing by replication thread?" i'm thinking about a information schema plugin to see whats is 'queued' in replication thread, at "master" (write to binlog) and "slave" (executing from binlog) side any idea if this is possible? i didn't checked or read any part of binlog/replication code yet thanks guys! :) -- Roberto Spadim SPAEmpresarial Eng. Automação e Controle

1 0

[Maria-discuss] question regarding innodb compression
by Rohan M C 03 Nov '14

03 Nov '14

Hi all, Due to space constraints we are considering the innodb compression option for some of our larger tables. We're not compressing all the tables, but only a select few to begin with. Our current planned process for this is to SET GLOBAL innodb_file_format=Barracuda; create compressed table, transfer data, and switch innodb_file_format back to Antelope. My question is around having this mix of table file formats in the same database. I've tried test queries and they were fine, but is it ok to have a mix of both Antelope and Barracuda file format tables in the db for a production environment? Thanks, Rohan

3 4