January 2014 - discuss - lists.mariadb.org

[Maria-discuss] New Question: Stable release of 10.0
by AskMonty KB 24 Jan '14

24 Jan '14

Hello, A new question has been asked in "What is in the different MariaDB releases?" by pranava: -------------------------------- Hi, In which month there will be a stable release of 10.0? We are using 5.5.34 and want to upgrade to 10.0 but are waiting for a stable release. Thanks Pranav. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/stable-release-of-100/

1 0

[Maria-discuss] New Question: Asynchronous Replication with Galera Cluster ?
by AskMonty KB 24 Jan '14

24 Jan '14

Hello, A new question has been asked in "Galera" by nicolasblanc: -------------------------------- My question is simple. Today i have a Galera Cluster with 3 nodes to write/read. And i want to put one(more to come) slave (asynchronous replication) to the cluster. As all my writes are located on 1 node, it's ok. But if i change the node on which the writes come... My slave is not synchronized anymore. I had to change the master of the slave to have the new written node as master. It seems that each galera node write only transactions from "real client" to replication binary log, not the ones from wsrep. Is there a way that i can ask to a Galera cluster node to always write commited transaction on the replication binary log ? Even if the transaction come from wsrep and not "real client" ? Thx in advance, -- Nicolas Blanc. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/asynchronous-replication-with-galera-cluster/

1 0

[Maria-discuss] Software patent?
by Peter Laursen 24 Jan '14

24 Jan '14

I occasionally found this in a Google search: http://www.google.nl/patents/US8510270 What does this mean? Are anybody able to explain what the patent covers that has not been used in MySQL replication for 10+ years before the patent? Does this mean any restrictions for utilizing binary log information in applications? -- Peter -- Webyog

4 6

[Maria-discuss] mysqltuner
by Reindl Harald 22 Jan '14

22 Jan '14

mysqltuner seems to be no longer maintained while you should not take any recommendation blindly it was really usefull over the years, with MariaDB some values are looking wrong Up for: 3d 17h 7m 44s (15M q [47.927 qps], 477K conn, TX: 33B, RX: 3B) [OK] Query cache efficiency: 48.1% (10M cached / 21M selects) 21M selects out of 15M queries as example :-) it would be pretty cool have a compareable tool (maybe native code) in the MariaDB setup - sadly Bash/PHP are my skills :-( ______________________________________ >> MySQLTuner 1.2.0 - Major Hayden <major(a)mhtx.net> >> Bug reports, feature requests, and downloads at http://mysqltuner.com/ >> Run with '--help' for additional options and output filtering Please enter your MySQL administrative login: root Please enter your MySQL administrative password: -------- General Statistics -------------------------------------------------- [--] Skipped version check for MySQLTuner script [OK] Currently running supported MySQL version 5.5.34-MariaDB-log [OK] Operating on 64-bit architecture -------- Storage Engine Statistics ------------------------------------------- [--] Status: -Archive -BDB -Federated -InnoDB -ISAM -NDBCluster [--] Data in MyISAM tables: 472M (Tables: 4995) [--] Data in PERFORMANCE_SCHEMA tables: 0B (Tables: 17) [!!] Total fragmented tables: 141 -------- Security Recommendations ------------------------------------------- [OK] All database users have passwords assigned -------- Performance Metrics ------------------------------------------------- [--] Up for: 3d 17h 7m 44s (15M q [47.927 qps], 477K conn, TX: 33B, RX: 3B) [--] Reads / Writes: 92% / 8% [--] Total buffers: 1.8G global + 1.8M per thread (500 max threads) [OK] Maximum possible memory usage: 2.6G (26% of installed RAM) [OK] Slow queries: 0% (2/15M) [OK] Highest usage of available connections: 8% (44/500) [OK] Key buffer size / total MyISAM indexes: 256.0M/189.1M [OK] Key buffer hit rate: 100.0% (328M cached / 71K reads) [OK] Query cache efficiency: 48.1% (10M cached / 21M selects) [OK] Query cache prunes per day: 0 [OK] Sorts requiring temporary tables: 1% (737 temp sorts / 55K sorts) [!!] Joins performed without indexes: 1140 [OK] Temporary tables created on disk: 22% (45K on disk / 201K total) [OK] Thread cache hit rate: 99% (44 created / 477K connections) [OK] Table cache hit rate: 36% (5K open / 14K opened) [OK] Open file limit used: 1% (10K/750K) [OK] Table locks acquired immediately: 99% (1M immediate / 1M locks) -------- Recommendations ----------------------------------------------------- General recommendations: Run OPTIMIZE TABLE to defragment tables for better performance Adjust your join queries to always utilize indexes Variables to adjust: join_buffer_size (> 1.0M, or always use indexes with joins)

2 2

[Maria-discuss] Statistics/Counters for number SHOW INDEX FROM queries
by Markus Uckelmann 22 Jan '14

22 Jan '14

Hi all, We have a lot of SHOW INDEX FROM queries coming from our ORM layer. Usually there is a mechanism to prevent this but it doesn't seem to work at the moment. To better analyze the problem it would be helpful if we could see how many such queries happened on a server. Is there a counter or a statistic which can provide us this information? We use MariaDB 5.5. Cheers, Shorty

3 4

[Maria-discuss] start mariadb randomly fails or answers with wrong response to systemd
by Reindl Harald 20 Jan '14

20 Jan '14

i have for at least 5 years a backup server with two mysql-instances * one replication instance listening on port 3307 * one "live" service * a script once a hour stop both instances and rsync replication->live * after that start both intances again * looking at the mysqld logs i am pretty sure there is nothing wrong and only the non.zero response causes systemd to restart the daemon one time well, with MariaDB on Fedora 19 systemd cries about failing service at the same time there is nothing in the mysql-errorlog (both instances using the same) the systemd-units are configured to restart the daemon again if it fails what replaces the mysqld_safe scripts and is done this way unchanged since summer 2011 with MySQL 5.5.x has anybody an idea what causes the "mysqld.service" instance to respond with status 1 instead 0 causing systemd to consider the service as failed while there is nothing uncommon in the mysqld-logs? the "Error reading relay log event: slave SQL thread was killed" as well as "Error reading packet from server" are not relevant in that context because they are from the not failing "replication.service" and normal due shutdown the slave (well, i dislike "error" in that context, but that's OT) interesting is that i have 3 machine-pairs with the 100% identical logic two of them are failing this way nearly every hour (backup schedule 60 minutes) while the one with 5000 tables is running perfect all the time any information i could provide additional to the logs and configs below? ___________________________________________________________________________ Jan 7 20:21:04 localhost backups: stop replication service Jan 7 20:21:04 localhost systemd[1]: Stopping MySQL Replication... Jan 7 20:21:04 localhost systemd[1]: Stopped MySQL Replication. Jan 7 20:21:04 localhost backups: stop live database Jan 7 20:21:04 localhost systemd[1]: Stopping MariaDB Database... Jan 7 20:21:04 localhost systemd[1]: Stopped MariaDB Database. Jan 7 20:21:04 localhost backups: backup replication data to '/data/mysql_data/' Jan 7 20:21:04 localhost backups: backup replication data finished Jan 7 20:21:04 localhost backups: start MySQL-Replication-Service Jan 7 20:21:04 localhost systemd[1]: Starting MySQL Replication... Jan 7 20:21:04 localhost systemd[1]: Started MySQL Replication. Jan 7 20:21:04 localhost backups: start MySQL-Live-Service Jan 7 20:21:04 localhost systemd[1]: Starting MariaDB Database... Jan 7 20:21:04 localhost systemd[1]: mysqld.service: control process exited, code=exited status=1 Jan 7 20:21:04 localhost systemd[1]: Failed to start MariaDB Database. Jan 7 20:21:04 localhost systemd[1]: Unit mysqld.service entered failed state. Jan 7 20:21:04 localhost backups: database backup finished Jan 7 20:21:05 localhost systemd[1]: mysqld.service holdoff time over, scheduling restart. Jan 7 20:21:05 localhost systemd[1]: Stopping MariaDB Database... Jan 7 20:21:05 localhost systemd[1]: Starting MariaDB Database... Jan 7 20:21:06 localhost systemd[1]: Started MariaDB Database. ___________________________________________________________________________ 140107 20:21:04 [Note] /usr/libexec/mysqld: Normal shutdown 140107 20:21:04 [Note] Event Scheduler: Purging the queue. 0 events 140107 20:21:04 [Note] Error reading relay log event: slave SQL thread was killed 140107 20:21:04 [ERROR] Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013) 140107 20:21:04 [Note] Slave I/O thread killed while reading event 140107 20:21:04 [Note] Slave I/O thread exiting, read up to log 'bin.000002', position 245 140107 20:21:04 [Note] /usr/libexec/mysqld: Shutdown complete 140107 20:21:04 [Note] /usr/libexec/mysqld: Normal shutdown 140107 20:21:04 [Note] Event Scheduler: Purging the queue. 0 events 140107 20:21:04 [Note] /usr/libexec/mysqld: Shutdown complete 140107 20:21:04 [Note] Plugin 'InnoDB' is disabled. 140107 20:21:04 [Note] Plugin 'FEDERATED' is disabled. 140107 20:21:04 [Note] Plugin 'FEEDBACK' is disabled. 140107 20:21:04 [Note] Plugin 'InnoDB' is disabled. 140107 20:21:04 [Note] Plugin 'FEDERATED' is disabled. 140107 20:21:04 [Note] Plugin 'FEEDBACK' is disabled. 140107 20:21:04 [Note] Event Scheduler: Loaded 0 events 140107 20:21:04 [Note] /usr/libexec/mysqld: ready for connections. Version: '5.5.34-MariaDB' socket: '/var/lib/mysql/mysql.sock' port: 0 thelounge 140107 20:21:04 [Note] Event Scheduler: Loaded 0 events 140107 20:21:04 [Note] /usr/libexec/mysqld: ready for connections. Version: '5.5.34-MariaDB' socket: '/var/lib/mysql/mysql_replication.sock' port: 0 thelounge 140107 20:21:04 [Note] Slave SQL thread initialized, starting replication in log 'bin.000002' at position 245, relay log './mysql-relay-bin.000016' position: 523 140107 20:21:04 [Note] /usr/libexec/mysqld: Normal shutdown 140107 20:21:04 [Note] Event Scheduler: Purging the queue. 0 events 140107 20:21:04 [Note] /usr/libexec/mysqld: Shutdown complete 140107 20:21:04 [Note] Slave I/O thread: connected to master 'replication@masterserver:3306',replication started in log 'bin.000002' at position 245 140107 20:21:05 [Note] Plugin 'InnoDB' is disabled. 140107 20:21:05 [Note] Plugin 'FEDERATED' is disabled. 140107 20:21:05 [Note] Plugin 'FEEDBACK' is disabled. 140107 20:21:05 [Note] Event Scheduler: Loaded 0 events 140107 20:21:05 [Note] /usr/libexec/mysqld: ready for connections. Version: '5.5.34-MariaDB' socket: '/var/lib/mysql/mysql.sock' port: 0 thelounge ___________________________________________________________________________ /usr/lib/systemd/system/mysqld.service [Unit] Description=MariaDB Database Before=postfix.service dovecot.service dbmail-imapd.service dbmail-lmtpd.service dbmail-pop3d.service dbmail-postfix-policyd.service [Service] Type=simple PIDFile=/var/run/mysqld/mysqld.pid ExecStart=/usr/libexec/mysqld --defaults-file=/etc/my.cnf --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/lib/mysql/mysql.sock --open-files-limit=750000 --basedir=/usr --user=mysql ExecStartPost=/usr/libexec/mysqld-wait-ready $MAINPID Restart=always RestartSec=1 TimeoutSec=300 LimitNOFILE=infinity LimitMEMLOCK=infinity OOMScoreAdjust=-1000 SysVStartPriority=64 PrivateTmp=true CapabilityBoundingSet=~CAP_SYS_PTRACE ReadOnlyDirectories=/etc ReadOnlyDirectories=/usr InaccessibleDirectories=/boot InaccessibleDirectories=/home InaccessibleDirectories=/root Restart=always InaccessibleDirectories=/usr/local/scripts InaccessibleDirectories=/var/lib/rpm InaccessibleDirectories=/var/lib/yum InaccessibleDirectories=/var/spool [Install] WantedBy=multi-user.target ___________________________________________________________________________ /usr/lib/systemd/system/replication.service [Unit] Description=MySQL Replication [Service] Type=simple PIDFile=/var/run/mysqld/mysqld_replication.pid ExecStart=/usr/libexec/mysqld --defaults-file=/etc/my-replication.cnf --pid-file=/var/run/mysqld/mysqld_replication.pid --socket=/var/lib/mysql/mysql_replication.sock --open-files-limit=30000 --basedir=/usr --user=mysql Restart=always RestartSec=1 TimeoutSec=300 LimitNOFILE=infinity LimitMEMLOCK=infinity OOMScoreAdjust=-1000 SysVStartPriority=64 PrivateTmp=true CapabilityBoundingSet=~CAP_SYS_PTRACE ReadOnlyDirectories=/etc ReadOnlyDirectories=/usr InaccessibleDirectories=/boot InaccessibleDirectories=/home InaccessibleDirectories=/root InaccessibleDirectories=/usr/local/scripts InaccessibleDirectories=/var/lib/rpm InaccessibleDirectories=/var/lib/yum InaccessibleDirectories=/var/spool [Install] WantedBy=multi-user.target

2 5

[Maria-discuss] Top voted features for MariaDB 10.1
by Rasmus Johansson 19 Jan '14

19 Jan '14

Hi, Yesterday Daniel Bartholomew published a blog post about voting for features in MariaDB 10.1, https://blog.mariadb.org/what-do-you-want-to-see-in-mariadb-10-1/ . To make it easier to follow which the most wanted (most votes) features are I pulled together a list in JIRA for anyone interested. It can be found here https://mariadb.atlassian.net/secure/Dashboard.jspa?selectPageId=11500 . The page doesn't require login, but if you want to vote you need to log in. BR, Rasmus -- Rasmus Johansson, VP Engineering MariaDB | t: +358 50 499 9589 | Skype: ratzpo

2 1

[Maria-discuss] mydumper halting replication by creating innodb table in mysql db
by Daniel Black 18 Jan '14

18 Jan '14

1 1

[Maria-discuss] Galera on Fedora
by David Timothy Strauss 15 Jan '14

15 Jan '14

The documentation currently warns against using Galera with Fedora [1]. Is that advice still true with Fedora 19+, which defaults to MariaDB? I can see some activity in the bug tracker [2], but nothing the last few months. In a related topic, when are RPMs for Fedora 20 [3] planned? Is there any way I can sponsor work to improve the situation? [1] https://mariadb.com/kb/en/installing-mariadb-with-yum/#installing-mariadb-g… [2] https://mariadb.atlassian.net/browse/MDEV-4141 [3] http://yum.mariadb.org/5.5-galera/

2 1

[Maria-discuss] trademarks
by Federico Razzoli 08 Jan '14

08 Jan '14

I found contradictory information about whom the MariaDB trademark belongs to: "The MariaDB Foundation also holds the trademark of the MariaDB server and owns mariadb.org. This ensures that the official MariaDB development tree will always be open for the MariaDB developer community." https://mariadb.com/kb/en/mariadb-foundation/ "SkySQL and MariaDB are trademarks or registered trademarks of SkySQL Corporation Ab in the European Union and United States of America and/or other countries." http://www.skysql.com/about/legal/trademarks If the last statement is true, I have several questions about the other statement I quoted and some other statements in the Foundation's site. If the last statement is false, I suggest it is fixed, because it is confusing. Regards, Federico

3 2