- discuss - lists.mariadb.org

[Maria-discuss] Aria_log file
by Richard Dunn 15 Oct '11

15 Oct '11

How do you read the 'aria_log.0000001' file in the data directory? If I open it with a text editor, It appears to be binary, but mysqlbinlog says that it is not. I'm asking because it looks like 5.3.1 is continually (every two minutes) writing to the log, even with no database activity. This impacts automatic sleep on my Macbook Pro.

3 4

[Maria-discuss] MariaDB 5.3.2-beta now available
by Daniel Bartholomew 14 Oct '11

14 Oct '11

The MariaDB project would like to announce the availability of MariaDB 5.3.2-beta, the latest addition to our growing lineup of supported software. MariaDB 5.3.2-beta is a bug-fix update to the previous 5.3.1 and 5.3.0 betas. == About MariaDB 5.3 The MariaDB 5.3 series introduces many new features, includes MariaDB 5.2, and is based on MySQL 5.1. Some highlights of new features in MariaDB 5.3 include: - subquery optimizations that finally make subqueries usable - many optimizer changes, including Classic Hash Join, Batched Key Access, a new implementation of Multi-Range-Read optimizations as well as Index Condition Pushdown - NoSQL-style interfaces via the HandlerSocket plugin as well as dynamic columns - group commit in XtraDB when the binary log is enabled - Microsoft Windows performance improvements These are just some of the highlights, and for a more complete list of changes, please read the What is MariaDB 5.3 page: http://kb.askmonty.org/en/what-is-mariadb-53 == About MariaDB 5.3.2-beta In the MariaDB 5.3.2-beta there are a couple of changes compared to previous 5.3 releases: === User Feedback plugin MariaDB 5.3.2-beta introduces the User Feedback plugin. This plugin is disabled by default. If enabled, it submits anonymous basic MariaDB usage information. This information will be 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 installation of the MSI package. See http://kb.askmonty.org/en/user-feedback-plugin for more information. === Subquery Cache now on by default Starting in MariaDB 5.3.2-beta, the Subquery cache is on by default. In previous versions of MariaDB the cache was off by default. The goal of the subquery cache is to optimize the evaluation of correlated subqueries by storing results together with correlation parameters in a cache and avoiding re-execution of the subquery in cases where the result is already in the cache. See http://kb.askmonty.org/en/subquery-cache for more information. == MariaDB 5.3.2-beta Release Notes, Changelog, Downloads The release notes for MariaDB 5.3.2-beta are available from: http://kb.askmonty.org/en/mariadb-532-release-notes A complete changelog for this beta is available from: http://kb.askmonty.org/en/mariadb-532-changelog Sources, binaries and packages can be downloaded from: http://downloads.askmonty.org/mariadb/5.3.2/ Debian and Ubuntu packages are available from our mirrored apt repositories. A sources.list generator can be found at: http://downloads.askmonty.org/mariadb/repositories/ The project always strives for quality, and being a beta release, we know that not everything may be perfect. Please take some time to report any issues you may encounter at: https://bugs.launchpad.net/maria Enjoy MariaDB 5.3.2-beta & Happy Testing! -- Daniel Bartholomew MariaDB - http://mariadb.org Monty Program - http://montyprogram.com AskMonty Knowledgebase - http://kb.askmonty.org

1 0

[Maria-discuss] Including MariaDB server and client in my package application???
by wahono sri 06 Oct '11

06 Oct '11

May I include MariaDB files in my software package to make easy for user if they don't know about db server and how to install and configure it to use as db server for my application. I'll prefer my users to choose options of installation package : 1. Acosys Version 4 2. MariaDB Client Library 3. MariaDB Server 4. .... Is it allowed by MariaDB licence? I read MariaDB licence but I am confusing to understand it clearly. Thanks Wahono

4 3

[Maria-discuss] Error install from binary tarballs
by wahono sri 30 Sep '11

30 Sep '11

I use PCLinuxOS and I can't install from RPM or from binary. I got this message from /data/localhost.localhost.err 110930 22:52:06 mysqld_safe Starting mysqld daemon with databases from ./data 110930 22:52:06 [ERROR] mysqld: File '/usr/local/mysql/data/aria_log_control' not found (Errcode: 13) 110930 22:52:06 [ERROR] mysqld: Got error 'Can't open file' when trying to use aria control file '/usr/local/mysql/data/aria_log_control' 110930 22:52:06 [ERROR] Plugin 'Aria' init function returned error. 110930 22:52:06 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed. 110930 22:52:06 [ERROR] Failed to initialize plugins. 110930 22:52:06 [ERROR] Aborting 110930 22:52:06 [Note] ./bin/mysqld: Shutdown complete 110930 22:52:06 mysqld_safe mysqld from pid file ./data/localhost.localdomain.pid ended 110930 22:54:34 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data 110930 22:54:34 [ERROR] ./bin/mysqld: ambiguous option '--o' (old-alter-table, optimizer_switch) 110930 22:54:34 [ERROR] Aborting 110930 22:54:34 mysqld_safe mysqld from pid file /usr/local/mysql/data/localhost.localdomain.pid ended 110930 22:56:00 mysqld_safe Starting mysqld daemon with databases from ./data 110930 22:56:00 [ERROR] ./bin/mysqld: ambiguous option '--o' (old-alter-table, optimizer_switch) 110930 22:56:00 [ERROR] Aborting 110930 22:56:00 mysqld_safe mysqld from pid file ./data/localhost.localdomain.pid ended 110930 23:00:45 mysqld_safe Starting mysqld daemon with databases from ./data 110930 23:00:45 [ERROR] ./bin/mysqld: ambiguous option '--o' (old-alter-table, optimizer_switch) 110930 23:00:45 [ERROR] Aborting 110930 23:00:45 mysqld_safe mysqld from pid file ./data/localhost.localdomain.pid ended 110930 23:01:00 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data 110930 23:01:01 [ERROR] ./bin/mysqld: ambiguous option '--o' (old-alter-table, optimizer_switch) 110930 23:01:01 [ERROR] Aborting 110930 23:01:01 mysqld_safe mysqld from pid file /usr/local/mysql/data/localhost.localdomain.pid ended 110930 23:01:10 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data 110930 23:01:10 [ERROR] ./bin/mysqld: ambiguous option '--o' (old-alter-table, optimizer_switch) 110930 23:01:10 [ERROR] Aborting 110930 23:01:10 mysqld_safe mysqld from pid file /usr/local/mysql/data/localhost.localdomain.pid ended 110930 23:03:41 mysqld_safe Starting mysqld daemon with databases from ./data 110930 23:03:41 [ERROR] ./bin/mysqld: ambiguous option '--o' (old-alter-table, optimizer_switch) 110930 23:03:41 [ERROR] Aborting 110930 23:03:41 mysqld_safe mysqld from pid file ./data/localhost.localdomain.pid ended How to fix this error? Thanks

2 1

[Maria-discuss] New KB Question: MariaDB 5.2.x server RPM fails on upgrades - error: scriptlet failed, exit status 1
by Daniel Bartholomew 30 Sep '11

30 Sep '11

A new question has been posted to the Knowledgebase: MariaDB 5.2.x server RPM fails on upgrades - error: scriptlet failed, exit status 1 http://kb.askmonty.org/en/mariadb-52x-server-rpm-fails-on-upgrades-error-sc… --------------------------------------------------------------------- This problem occurs on CentOS 5.5/5.6/6.0 32bit and 64bit from first time I used MariaDB 5.2.3 all the way to 5.2.9 upgrade. It happens 1) via manual RPM upgrade from RPM downloaded at http://downloads.askmonty.org/mariadb/5.2/#file_type=rpm or 2) via ourdelta YUM REPO update http://ourdelta.org/centos (yum update MariaDB*). Problem, MariaDB-server-5.2.x RPM updates fails and needs manually removing previous version MariaDB-server-5.2.x RPM before the new update installs. error error: %pre(MariaDB-server-5.2.9-102.el5.x86_64) scriptlet failed, exit status 1 error: install: %pre scriptlet failed (2), skipping MariaDB-server-5.2.9-102.el5 full details below ... (continued in the KB) --------------------------------------------------------------------- Thanks. -- Daniel Bartholomew MariaDB - http://mariadb.org Monty Program - http://montyprogram.com AskMonty Knowledgebase - http://kb.askmonty.org

2 2

[Maria-discuss] Microseconds support in MariaDB 5.3.
by Peter Laursen 28 Sep '11

28 Sep '11

I noticed: http://askmonty.org/blog/the-2-year-old-mariadb/ "The support for microseconds in TIMESTAMP, DATETIME, and TIME". I fully agree the 'full seconds support only' has been a sever limitation in MySQL. But I have two concerns with ths: 1) 'noisyness'. On not very fast systems the last digits of a TIME in microseconds should not be considered too much important. It depends on what else the system is doing at the time. I think for lots of users milliseconds and not microseconds would be better/more relevant. It is not always a lot of digits can be proven true. When we went to school we were all taught not to present results in natural sciences more accurate than the accuracy of data sources and measurements. Providing too many digits in a resuslt actually caused a lower score in my highschool! 2) Compability. There is a problem with UPDATES. A client/application written for MySQL may assume 'full seconds support only' and may generate the current MySQL format byte format in the WHERE clause (typically if the client reserves a 14 byte buffer for TIMERSTAMPS etc). In SQL: UPDATE table SET column = 'something' WHERE time_column = '01:01:01': .. this update will fail if the currently stored value is '01:01:01:010001'; and the rigth query in the context would be. UPDATE table SET column = 'something' WHERE time_column = '01:01:01:010001'; Ideally I think there should be a configuration parameter and a global variable to SET time_accuracy = full_second|millisecond|microsecond. Did somebody have considerations about same? I definitely think that lots of applications using a TIME|TIMESTAMP|DATETIME column in the WHERE-clause of an UPDATE statement will need some rewrite to be upgradable to MariaDB 5.3 -- Peter

6 7

[Maria-discuss] New KB Question: Stop/Start MariaDB
by Daniel Bartholomew 27 Sep '11

27 Sep '11

A new question has been posted to the Knowledgebase: http://kb.askmonty.org/en/stopstart-mariadb --------------------------------------------------------------------- When upgrading MariaDb, using DEB package manager,it always fails to stop the server and the upgrade fails. Also the server cannot be stopped from MySQl Workbench. However, I can stop ok from the terminal with the command 'sudo service mysql stop' and then run the update which restarts the server automatically. Not fatal but puzzling. (Using Ubuntu Natty 64 bit). --------------------------------------------------------------------- Thanks. -- Daniel Bartholomew MariaDB - http://mariadb.org Monty Program - http://montyprogram.com AskMonty Knowledgebase - http://kb.askmonty.org

1 0

[Maria-discuss] New KB Question: Index/optimizations in Dynamic Columns
by Daniel Bartholomew 20 Sep '11

20 Sep '11

A new question has been posted to the Knowledgebase: http://kb.askmonty.org/en/indexoptimizations-in-dynamic-columns --------------------------------------------------------------------- Greetz to all... I have been playing with the dynamic columns in MariaDB 5.3... Running your test queries I decided to do an explain on one of them: MariaDB [test]> explain SELECT name FROM t1 WHERE COLUMN_GET(dynstr, 1 as char(10)) = "red"; +----+-------------+-------+------+---------------+------+---------+------+------+-------------+ | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | +----+-------------+-------+------+---------------+------+---------+------+------+-------------+ | 1 | SIMPLE | t1 | ALL | NULL | NULL | NULL | NULL | 4 | Using where | +----+-------------+-------+------+---------------+------+---------+------+------+-------------+ 1 row in set (0.00 sec) I was just curious, do dynamic columns suffer from the same perf penalties at scale that non-indexed or function-based where criteria do? If they currently do, are there currently any plans to index/optimize dynamic columns for super fast at-scale data access? Best, Joshua --------------------------------------------------------------------- Thanks. -- Daniel Bartholomew MariaDB - http://mariadb.org Monty Program - http://montyprogram.com AskMonty Knowledgebase - http://kb.askmonty.org

1 0

[Maria-discuss] MariaDB 5.3.1-beta now available!
by Daniel Bartholomew 12 Sep '11

12 Sep '11

[The following was just sent to the MariaDB 'announce' list (subscribe at http://mariadb.org). Re-posting here for those that are not on that list.] The MariaDB project would like to announce the availability of MariaDB 5.3.1-beta, the latest addition to our growing lineup of supported software. MariaDB 5.3.1-beta is a bug-fix update to the previous 5.3.0-beta. The MariaDB 5.3 series introduces many new features, includes MariaDB 5.2, and is based on MySQL 5.1. Some highlights of new features in MariaDB 5.3 include: - subquery optimizations that finally make subqueries usable - many optimizer changes, including Classic Hash Join, Batched Key Access, a new implementation of Multi-Range-Read optimizations as well as Index Condition Pushdown - NoSQL-style interfaces via the HandlerSocket plugin as well as dynamic columns - group commit in XtraDB when the binary log is enabled - Microsoft Windows performance improvements These are just some of the highlights, and for a full list of changes, please read the What is MariaDB 5.3 page: http://kb.askmonty.org/en/what-is-mariadb-53 A complete changelog for this beta is available from: http://kb.askmonty.org/en/mariadb-531-changelog Sources, binaries and packages can be downloaded from: http://downloads.askmonty.org/mariadb/5.3.1/ Debian and Ubuntu packages are available from repositories. A sources.list generator can be found at: http://downloads.askmonty.org/mariadb/repositories/ The project always strives for quality, and being a beta release, we know that not everything can be perfect. Please take some time to report any issues you may encounter at: https://bugs.launchpad.net/maria Enjoy MariaDB 5.3.1-beta & Happy Testing! -- Daniel Bartholomew MariaDB - http://mariadb.org Monty Program - http://montyprogram.com AskMonty Knowledgebase - http://kb.askmonty.org

1 0

[Maria-discuss] MariaDB compilation on old Linux
by Daniel Bartholomew 12 Sep '11

12 Sep '11

A new question has been posted to the Knowledgebase: http://kb.askmonty.org/en/mariadb-compilation-on-old-linux ---------------------------------------------------------------------- I still have to use MandrakeLinux 10.0 having MySQL v.4.0.22 in its repository. Is it possible to build binary rpm-packages (binary in /usr/bin, data in /var/lib/mysql and etc) of fresh MariaDB on old Linux distribution like MandrakeLinux 10.0 (something like `rpmbuild -bb mysql.spec`)? ---------------------------------------------------------------------- Thanks. -- Daniel Bartholomew MariaDB - http://mariadb.org Monty Program - http://montyprogram.com AskMonty Knowledgebase - http://kb.askmonty.org

1 0