- discuss - lists.mariadb.org

[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

[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

[Maria-discuss] Is there any java connector for MariaDB than the one from Mysql(mysql-java-5.1.6.jar) ?
by Daniel Bartholomew 01 Sep '11

01 Sep '11

A new question has been posted to the Knowledgebase: http://kb.askmonty.org/en/is-there-any-java-connector-for-mariadb-than-the-… ---------------------------------------------------------------------- For licensing purposes, we try to remove any link to MySQL connectors, we found for Delphi and .NET, but we did not yet find any for java. Does anyone know a third party components that can be used as java connector for MariaDB ? ---------------------------------------------------------------------- Thanks. -- Daniel Bartholomew MariaDB - http://mariadb.org Monty Program - http://montyprogram.com AskMonty Knowledgebase - http://kb.askmonty.org

1 0

Re: [Maria-discuss] GUI/Workbench for MariaDB Aria?
by Peter Laursen 31 Aug '11

31 Aug '11

'transactional' in Aria will eanable crash recovery for the table. It will not make the table transactional (ie. START TRANSACTION, COMMIT, ROLLBACK etc.) are still ignored. Probably it was originaly intended to have it trasactional over time but I do not think focus is there at the moment. Byt yes .. it is just a checkbox and would be simple to add to any GUI (conditionally if engine = ARIA). But I think that if people want (user-)tables with the Aria engine you would use '1' in most if not all cases (temproary tables created by server internally is another thing). -- Peter On Wed, Aug 31, 2011 at 07:47, Ansgar Becker <ansgar.becker(a)googlemail.com>wrote: > Hi all, > I'm a bit unsure what this option really does, now that Peter said it > doesn't make a table transactional, but I'm sure there is a reason for why > it exists. So I'll see if I can add a checkbox right besides the engine drop > down, which is enabled only if Aria is selected. Also I need to read out > this attribute in existing tables, which needs some adjustment in my CREATE > TABLE parser. > > Ansgar > > Am 30.08.2011 19:31, schrieb Peter Laursen: > > We have the same request for SQLyog: > http://code.google.com/p/sqlyog/issues/detail?id=538 > > Of course a client is never engine-specific. But that is not the same > that a client has GUI fucntionalities to su > > @Vlad you probably know that your company (Monty Program) and mine > (Webyog) are partners (what means customers will gain a rebate to our > products when comming from Monty Program website. Check it out or ask Monty > himself). Not that I would mind that Ansgar adds this to Heidi. But > basically we never found it very important. Even if ARIA is set to > transactioanl = 1 , it is not transactional. it has crash recovery what is > not the same. > > > Peter > Webyog > > On Tue, Aug 30, 2011 at 19:11, Vladislav Vaintroub <wlad(a)montyprogram.com>wrote: > >> I'm forwarding this to Ansgar, as a feature request for HeidiSQL. May be >> tricky to add it as Aria-specific option, currently CREATE TABLE >> options/checkboxes in HeidiSQL seem to be not engine dependent to me. >> >> > -----Original Message----- >> > From: maria-discuss- >> > bounces+wlad=montyprogram.com(a)lists.launchpad.net [mailto:maria- >> > discuss-bounces+wlad=montyprogram.com(a)lists.launchpad.net] On Behalf >> > Of Daniel Bartholomew >> > Sent: Dienstag, 30. August 2011 18:50 >> > To: Maria Discuss >> > Subject: [Maria-discuss] GUI/Workbench for MariaDB Aria? >> > >> > New question on the Knowledgebase: >> > >> > http://kb.askmonty.org/en/guiworkbench-for-mariadb-aria >> > >> > Does anybody know a good GUI/Work bench tool to handle ARIA >> > transactional=1/0 and row_format=PAGE situations? >> > >> > Thanks. >> > >> > -- >> > Daniel Bartholomew >> > MariaDB - http://mariadb.org >> > Monty Program - http://montyprogram.com >> > AskMonty Knowledgebase - http://kb.askmonty.org >> > >> > >> > _______________________________________________ >> > 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 >> >> >> _______________________________________________ >> 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 >> > > >

1 0

[Maria-discuss] Good GUI
by md＠rpzdesign.com 30 Aug '11

30 Aug '11

Hello: I have been using Navicat to administer my Oracle/Sun based MySQL servers for years. (www.navicat.com) Now I am switched over to MariaDB 2.8 using ARIA engine. What do MariaDB users recommend of good GUI front end that allows me to manage ARIA Create Table Transactional=0|1 Row_format=PAGE setting. Most Tools do not support all of the MariaDB settings in the table setup dialogs. Suggestions appreciated... md

3 2