November 2012 - discuss - lists.mariadb.org

[Maria-discuss] explain for insert/update/delete
by MARK CALLAGHAN 11 Jul '25

11 Jul '25

Does MariaDB have any plans to support explain for insert/update/delete/replace/CTAS? There have been feature requests open for a very long time on official MySQL without any progress. I have had a few problems in production from 'bad' delete statements that had a very different plan than the select statement with the same where clause. The only way to check for a bad plan today is to use SHOW INNODB STATUS to determine whether the statement locks all rows in a table. http://bugs.mysql.com/bug.php?id=14745 http://bugs.mysql.com/bug.php?id=35355 -- Mark Callaghan mdcallag(a)gmail.com

2 1

[Maria-discuss] Fwd: [debian-mysql] Bug#688505: MariaDB packaging.
by Colin Charles 19 Jan '13

19 Jan '13

A good wishlist. I think more should vote for this, quite clearly! cheers, -colin Begin forwarded message: > Resent-From: Robert de Bath <robert$(a)debath.co.uk> > From: Robert de Bath <robert$(a)debath.co.uk> > Subject: [debian-mysql] Bug#688505: MariaDB packaging. > Date: 23 September 2012 16:25:39 GMT+08:00 > Resent-To: debian-bugs-dist(a)lists.debian.org > To: submit(a)bugs.debian.org > Resent-Cc: Debian MySQL Maintainers <pkg-mysql-maint(a)lists.alioth.debian.org> > Reply-To: Robert de Bath <robert$(a)debath.co.uk>, 688505(a)bugs.debian.org > > Package: mysql-server > Version: 5.5.24+dfsg-8 > Severity: wishlist > > My very technically savvy webhost has recently switched from MySQL to > MariaDB and claim it's for both technical and political reasons. > > Both of these reasons (better performance and better licensing) appear > to be good reasons for the software to be packaged as a Debian package > and I expect it's getting to the point that someone will do it themselves. > > BUT the software is technically still not a forked variant of MySQL > but a patched version where the maintainers continually resync to the > Oracle releases. For this reason I would like to see it treated as just > a simple MySQL version within Debian. This way the users (ie: me) can > simply switch by prodding apt in the right way. > > For this to work seamlessly (unlike, for example, the recent multimedia > troubles) the MariaDB package should be packaged identically to MySQL, > which IMO is best done by the same Debian maintainers. > > So my request is that you package the MariaDB as a secondary version of > MySQL in such a way that the two packages can be seamlessly switched within the Debian system. > > -- > Rob. (Robert de Bath <robert$ @ debath.co.uk>) > <http://www.debath.co.uk/> > > _______________________________________________ > pkg-mysql-maint mailing list > pkg-mysql-maint(a)lists.alioth.debian.org > http://lists.alioth.debian.org/cgi-bin/mailman/listinfo/pkg-mysql-maint -- Colin Charles, http://bytebot.net/blog/ | twitter: @bytebot | skype: colincharles MariaDB: Community developed. Feature enhanced. Backward compatible. Download it at: http://www.mariadb.org/ Open MariaDB/MySQL documentation at the Knowledgebase: http://kb.askmonty.org/

3 3

[Maria-discuss] DrizzleJDBC 1,2
by Marcus Eriksson 06 Dec '12

06 Dec '12

Hi I just released DrizzleJDBC 1.2 DrizzleJDBC is a BSD licensed JDBC driver for MySQL/MariaDB/Drizzle It is in maven central: <dependency> <groupId>org.drizzle.jdbc</groupId> <artifactId>drizzle-jdbc</artifactId> <version>1.2</version> </dependency> Changelog; - IPv6 support, enclose the IP in brackets, [::1] ( https://github.com/krummas/DrizzleJDBC/issues/10) - Correct behavior if getInt on larger than MAXINT values ( https://github.com/krummas/DrizzleJDBC/issues/9) - Fix ssl support, was not possible to close connection ( https://github.com/krummas/DrizzleJDBC/issues/8) - Support InputStream in LOAD DATA INFILE ( https://github.com/krummas/DrizzleJDBC/issues/7) - support getting columns using <table>.<column> ( https://github.com/krummas/DrizzleJDBC/issues/6) - use single quotes (https://github.com/krummas/DrizzleJDBC/pull/5) - clean up unicode support (https://github.com/krummas/DrizzleJDBC/pull/4) - Fix NPE bug when timestamp is null, patch by Tim Rickettsl on launchpad - set FOUND ROWS by default (https://github.com/krummas/DrizzleJDBC/issues/2 ) Report bugs/feature requests etc on github; https://github.com/krummas/DrizzleJDBC /Marcus

3 3

[Maria-discuss] partitioning by timestamp field
by Said Ramirez 30 Nov '12

30 Nov '12

Hello, I am trying to setup a range partitioned table using 5.5.27-MariaDB-log MariaDB Server using a timestamp field. According to the documents, I should be able to use unix_timestamp(ts) as my partitioning function ( http://dev.mysql.com/doc/refman/5.5/en/partitioning-range.html ) . I find, however, that it is not possible to use unix_timestamp using mariadb because with mariadb the unix_timestamp function returns an floating point value: mariadb> select unix_timestamp('2012-12-01'); +------------------------------+ | unix_timestamp('2012-12-01') | +------------------------------+ | 1354320000.000000 | +------------------------------+ 1 row in set (0.00 sec) However the MySQL version of unix_timestamp returns an int value: myqsl> select unix_timestamp('2012-12-01'); +------------------------------+ | unix_timestamp('2012-12-01') | +------------------------------+ | 1354320000 | +------------------------------+ 1 row in set (0.06 sec) How have people worked around this issue? What other ways can I partition by a timestamp in MariaDB ? Thanks, -Said

2 1

Re: [Maria-discuss] Contact Form: Ruslan Kutliakhmetov
by Sergei Golubchik 17 Nov '12

17 Nov '12

Hi, Ruslan! First, please use email for questions of this kind. We have a mailing list maria-discuss(a)lists.launchpad.net - it's much easier to follow the discussion there, and many more people will see your question, so you'll have a better chance of getting a fast and helpful reply. On Nov 17, Ruslan Kutliakhmetov wrote: > ------------------------------------------------ > Hi. I installed on the linux debian MarinaDB 10 for linux debian. > I watched that she doesn't installed. Log: > root @ debian :/ home / tran # apt-get install mariadb-server-5.2 mariadb-client-5.2 > Reading package lists ... Done > Building dependency tree > Reading state information ... Done > Some packages could not be installed. Perhaps you are asking the impossible, > or using the unstable distribution that some required > packages have not yet been created or been moved out of Incoming. > The following information may help you: > > The following packages have unmet dependencies: > mariadb-client-5.2: Depends: mariadb-client-core-5.2 (> = 5.2.12-mariadb115 ~ squeeze) but it is not installed > E: Broken packages > ------------------------------------------------ I don't understand what you are trying to do. Are you installing MariaDB 10.0.0 release? If yes, why do you specify "5.2" in the apt-get command line? If you want to install MariaDB 5.2.12 - why do you mention 10.0? May be, you are trying to upgrade or downgrade? Regards, Sergei

1 0

[Maria-discuss] KB Question: Drop-in replacement on Debian
by Daniel Bartholomew 17 Nov '12

17 Nov '12

The following question has been posted to the Knowledgebase: https://kb.askmonty.org/en/drop-in-replacement-on-debian/ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Is there a way to make MariaDB install over MySQL on a Debian machine? I have my puppet master, which is running Debian/sid. It has puppet-dashboard, which utilizes MySQL 5.5.28. Much to my dismay, I am unable to install MariaDB over it: - - - - - The following packages have unmet dependencies: libmariadbclient18 : Depends: libmysqlclient18 (= 5.5.28-mariadb1~wheezy) but 5.5.28+dfsg-1 is to be installed E: Unable to correct problems, you have held broken packages. - - - - - But if I try to uninstall the parts of MySQL, then apt wishes to uninstall everything, up to and including puppet-dashboard: - - - - - The following packages were automatically installed and are no longer required: dbconfig-common libaio1 libhttpclient-ruby1.8 mysql-server-core-5.5 rake ruby-dbi ruby-deprecated unzip zip Use 'apt-get autoremove' to remove them. The following packages will be REMOVED: libdbd-mysql-perl libdbd-mysql-ruby libmysqlclient18 mysql-client mysql-client-5.5 mysql-server mysql-server-5.5 puppet-dashboard ruby-dbd-mysql ruby-mysql - - - - - This is unacceptable for a live box... Is there something else I can do to make the install less painful? - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Thanks. -- Daniel Bartholomew Google+ - http://gplus.to/dbart Twitter - http://twitter.com/daniel_bart MariaDB: An Enhanced Drop-in Replacement for MySQL Website - http://mariadb.org Twitter - http://twitter.com/mariadb Google+ - http://google.com/+mariadb Facebook - http://fb.com/MariaDB.dbms Knowledgebase - http://kb.askmonty.org Monty Program - http://montyprogram.com

3 2

[Maria-discuss] mDB logs off when there are several ssh under same user
by klrumpf 15 Nov '12

15 Nov '12

4 6

[Maria-discuss] KB Question: Aria Max Table Size
by Daniel Bartholomew 14 Nov '12

14 Nov '12

The following question has been posted in the Knowledgebase: https://kb.askmonty.org/en/aria-max-table-size/ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Aria looks to be a safer robust replacement to MyISAM for data warehousing. However, I was unable to find any mention of maximum table sizes for tables in various row formats. Upon creating tables and getting information in SequelPro, I saw the following: Aria Dynamic: 4GB Aria Fixed: 20GB Aria Page: 64GB This would seem counterproductive as MyISAM supports 256TB. Is there an official statistic on the maximum amount of data that Aria can handle? - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Thanks. -- Daniel Bartholomew Google+ - http://gplus.to/dbart Twitter - http://twitter.com/daniel_bart MariaDB: An Enhanced Drop-in Replacement for MySQL Website - http://mariadb.org Twitter - http://twitter.com/mariadb Google+ - http://google.com/+mariadb Facebook - http://fb.com/MariaDB.dbms Knowledgebase - http://kb.askmonty.org Monty Program - http://montyprogram.com

1 0

[Maria-discuss] MariaDB 10.0.0 Alpha now available
by Daniel Bartholomew 12 Nov '12

12 Nov '12

The MariaDB project is pleased to announce the immediate availability of MariaDB 10.0.0. This is an alpha release. MariaDB 10.0 is the development version of MariaDB. It is built on the MariaDB 5.5 series with backported features from MySQL 5.6 and entirely new features not found anywhere else. This is the first 10.0-based release, and we are releasing it now to get it into the hands of any who might want to test it. Not all features planned for the MariaDB 10.0 series are included in this release. Additional features will be pushed in future releases. Do not use alpha releases on production systems. - - MariaDB 10.0 Links - - - - - - - - - - - - - - - - - - - - - - - - - Release Notes: http://kb.askmonty.org/en/mariadb-1000-release-notes Changelog: http://kb.askmonty.org/en/mariadb-1000-changelog Downloads: http://downloads.mariadb.org/mariadb/10.0.0 APT and YUM Repository Configuration Generator: http://downloads.mariadb.org/mariadb/repositories/ Overview of MariaDB 10.0: http://kb.askmonty.org/en/what-is-mariadb-100 - - 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 (my.ini on Windows) file! See http://kb.askmonty.org/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 - - - - - - - - - - - - - - - - - - - - - - - - - - We've created a CafePress store which offers an exclusive t-shirt or other item in return for a donation to the MariaDB project: - http://www.cafepress.com/mariadb Please check it out and let us know what you think! All proceeds go directly to support MariaDB development, so don't think of it as purchasing a t-shirt, think of it as donating to support a worthy project and awesome product... and you get a t-shirt as a nice bonus! If you would like to contribute to MariaDB in other ways, please see our "contributing" and "donations" pages in the Knowledgebase: - https://kb.askmonty.org/en/contributing - https://kb.askmonty.org/en/donations We hope you enjoy MariaDB! -- MariaDB: An Enhanced Drop-in Replacement for MySQL Website - http://mariadb.org Twitter - http://twitter.com/mariadb Google+ - http://google.com/+mariadb Facebook - http://fb.com/MariaDB.dbms Knowledgebase - http://kb.askmonty.org Monty Program - http://montyprogram.com

1 0

[Maria-discuss] TRUNCATE TABLE becomes hang sometimes
by Haseena L. 10 Nov '12

10 Nov '12

Hi, Now Iam trying to migrate from MySQL to MariaDB. Why does the TRUNCATE TABLE statement hang sometimes? What are the reasons for this type of issue? This problem doesn't happen with MySQL, only with MariaDB. The hanging statement is simply: TRUNCATE TABLE sampledb.datatable; What can cause this to happen, and how could I fix it? Another one observation is if the table have some data, may be one or two rows, then the truncate query works successfully. Else the table have a lot of data, query becomes hang. If the same table have more than one connetion, then the truncate table query hangs. How I fix it??? Now Iam blocking. Engine I selected is MyISAM. Thanks and Regards, Haseena ***** Confidentiality Statement/Disclaimer ***** This message and any attachments is intended for the sole use of the intended recipient. It may contain confidential information. Any unauthorized use, dissemination or modification is strictly prohibited. If you are not the intended recipient, please notify the sender immediately then delete it from all your systems, and do not copy, use or print. Internet communications are not secure and it is the responsibility of the recipient to make sure that it is virus/malicious code exempt. The company/sender cannot be responsible for any unauthorized alterations or modifications made to the contents. If you require any form of confirmation of the contents, please contact the company/sender. The company/sender is not liable for any errors or omissions in the content of this message.

2 1