September 2011 - 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] 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 29 Sep '11

29 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

[Maria-discuss] failed to initialize plugins error
by Patrick Galbraith 10 Sep '11

10 Sep '11

Hi all! Moin moin, Privet! I have the latest 5.3 compiled as well as a client's own storage engine. The compile, link, all went well. I do notice they only compile their engine statically, but see symbols for it in mysqld: ... 000000000081d4f0 T filepro_rkey 000000000081d9f0 T filepro_rnext 000000000081da80 T filepro_rprev 000000000081d350 T filepro_rrange 000000000081db20 T filepro_rrnd 000000000081ddc0 T filepro_scan 000000000081dde0 T filepro_scan_init 0000000000e747c8 B filepro_share_list 0000000000e52ea0 D filepro_storage_engine 000000000081de00 T filepro_update 000000000081e020 T filepro_write 0000000000e74798 b ha_filepro_exts ... So, when I start mysqld, I get the error: "[ERROR] Failed to initialize plugins." If I run this with strace, I don't see it trying to load a particular shared library file, just it logging messages to the log, opening replication log and index. So, not sure what I need to load with "plugin_load". When I configured MariaDB top compile, I used the following (per what the client uses with their successful build of MySQL 5.1.30) ./configure --with-plugins=all --without-plugin-oqgraph --with-charset=utf8 --enable-assembler --enable-profiling --enable-community-features --without-plugin-ndbcluster --prefix=/usr/local/maria I'm guessing that I'm missing something obvious and simple? Thank you in advance for any help! Patrick

3 2

[Maria-discuss] Native SQL-Connector for LibreOffice/OpenOffice
by Daniel Bartholomew 07 Sep '11

07 Sep '11

A new question has been posted to the Knowledgebase: http://kb.askmonty.org/en/native-sql-connector-for-libreofficeopenoffice --------------------------------------------------------------------- Hello, I have been using OO/LO for years and have used both the Java-Connector but also ODBC under both Debian-Linux and Windows-Vista. When it became available I switched to the Native MySQL-Connector as delivered by MySQL. Oracle now has obviously got rid of that connector. Is there or are there any plany for a native connector to LO/OO in MariaDB? Thanks for your help and regards H. Stoellinger Salzburg --------------------------------------------------------------------- Thanks. -- Daniel Bartholomew MariaDB - http://mariadb.org Monty Program - http://montyprogram.com AskMonty Knowledgebase - http://kb.askmonty.org

1 0