September 2013 - discuss - lists.mariadb.org

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

08 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

3 3

[Maria-discuss] Fwd: [Dbmail] MariaDB and dbmail
by Reindl Harald 01 Oct '13

01 Oct '13

please can someone from the MariaDB developers MariaDB 5.5.32 is running here on test-machines this is todays feedback of the dbmail core-developer and beause more and more distributions including Fedora/OpenSuSE and AFAIK even RHEL7 switch to MariaDB this is a *serious* problem which is not what a "drop-in replacement" should do and a show-stopper rollout Fedora 19 at all in the near future > Anyway, MariaDB doesn't even pass the basic unit-tests > > Looks like this maybe libzdb related. The ordering of the query > retrieving mime parts is ok on the console, but *not* when looping > over the result in libzdb. > > MariaDB is *no-go* at this moment. Just what I experienced a year > ago or so. I'm sorry, but I don't think I'll hold 3.1.4 for that > not a regression at all. -------- Original-Nachricht -------- Betreff: Re: [Dbmail] MariaDB and dbmail Datum: Tue, 02 Apr 2013 19:47:15 +0400 Von: Sergej Pupykin <ml(a)sergej.pp.ru> An: DBMail mailinglist <dbmail(a)dbmail.org> At Thu, 20 Sep 2012 10:46:52 +0800, zamri <myzamri(a)gmail.com> wrote: > MariaDB is fully compatible with MySQL. Migration is done. So far so good. Phewww!... > > Now I need to do some research on tuning mariadb if needed. I found that after migration following SQL returns wrong sorted data: SELECT l.part_key, l.part_depth, l.part_order, l.is_header, DATE_FORMAT(ph.internal_date,GET_FORMAT(DATETIME,'ISO')), data FROM dbmail_mimeparts p JOIN dbmail_partlists l ON p.id = l.part_id JOIN dbmail_physmessage ph ON ph.id = l.physmessage_id WHERE l.physmessage_id = <ID> ORDER BY l.part_key,l.part_order ASC; however when I run it from command line it works well. Probably it does not fail always because of not all emails damaged. Not sure if it caused by migration to mariadb, but problem appeared near same time.

2 2

[Maria-discuss] 10.x Plans
by Roberto Spadim 01 Oct '13

01 Oct '13

Hi guys, it not a important thing, but could we add the MDEV or the issue track link to https://mariadb.com/kb/en/plans-for-10x/ for example MariaDB 10.0 partly sponsored features Features that are likely to be in 10.0 if we can get more sponsorships FB request: Better monitoring for replication (FB has patch; MP will add) (kristian) (for 5.5 or 10.0) ??? Aria: Concurrent UPDATE & DELETE. MWL#235 (Have partial sponsor) (monty) MDEV-23 Aria: Segmented key cache for Aria (By Igor for 10.0 or 10.1) MDEV-24 Aria: Fast next-not-same handler call (monty) (Target 10.0) MDEV-25 >From MySQL 5.6: Global transaction ID, so the slave state becomes recoverable, and facilitate automatic moving a slave to a new master across multi-level hierarchies. ??? and others.... -- Roberto Spadim

2 5

[Maria-discuss] MariaDB Galera Cluster 5.5.33a Now Available
by Daniel Bartholomew 30 Sep '13

30 Sep '13

The MariaDB project is pleased to announce the immediate availability of MariaDB Galera Cluster 5.5.33a. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB Galera 5.5.33a Stable (GA) - Release Notes: https://mariadb.com/kb/en/mariadb-galera-5533a-release-notes - Changelog: https://mariadb.com/kb/en/mariadb-galera-5533a-changelog - Downloads: https://downloads.mariadb.org/mariadb-galera/5.5.33a Galera docs: https://mariadb.com/kb/en/galera APT and YUM Repository Configuration Generator: - https://downloads.mariadb.org/mariadb/repositories/ - - 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://mariadb.com/kb/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 - - - - - - - - - - - - - - - - - - - - - - - - - - If you would like to contribute to MariaDB, please see our "contributing" and "donations" pages. We also have merchandise available in a cafepress store. - https://mariadb.com/kb/en/contributing - https://mariadb.org/en/donate/ - http://www.cafepress.com/mariadb 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://mariadb.com/kb

1 0

Re: [Maria-discuss] [Maria-developers] [All] MariaDB's best (download) month ever
by Jean Weisbuch 30 Sep '13

30 Sep '13

(this thread was originaly from maria-developpers) The mariadb.com/.org distinction is not really clear as both have a similar layout, designs and duplicate contents, plus distincting both sites from the sole TLD is not the most visible one ; i must admit that the first time i ended up on mariadb.com i thought at first that it was just the mariadb.org website that had a design update. Plus, there is a link to "mariadb.org" on the top menu of mariadb.com, a link to "Community" or "MariaDB Foundation" or a clear title would be better. Le 26/09/2013 10:39, Colin Charles a écrit : > On 25 Sep 2013, at 06:23, MARK CALLAGHAN <mdcallag(a)gmail.com> wrote: > >> Define "we", or even define "MariaDB"? I am confused. At this point mariadb.org looks like a collection of links to #2 and #3 below: > In the context of this email, "we" is Monty Program. Kristian and I both work there, long before we (MP) had to deal with the MariaDB Foundation and SkySQL. > >> 1) mariadb.org / foundation >> 2) mariadb.com / skysql >> 3) askmonty.org >> > As to how we define MariaDB, I think this is worthy of a discussion. Bear with me for a moment. The tl;dr version of the following is such that mariadb.org has always been a collection of links to #2 and #3, with the only exception being #2 didn't exist before and was called montyprogram.com > > Why do we have askmonty.org? Because when the company was announced as Monty Program, a domain squatter registered the domain. We could have paid the chap off, but we chose not to enrich a domain squatter, thus we began legal proceedings to get montyprogram.com. We finally got it, but at this point things like the downloads and the Knowledgebase were on askmonty.org. We had montyprogram.com which served to offer developer support, keep track of some news/press releases, but that was about it. > > After a while, we decided we needed to have mariadb.org. Here we put the user stats collection, the explain analyzer, etc. Eventually downloads moved here. The knowledgebase still remained at askmonty.org. The blog moved from blog.montyprogram.com to blog.mariadb.org > > With the merger of Monty Program with SkySQL, it seems that naturally montyprogram.com would have to be retired. Askmonty.org also got retired. > > But for reasons beyond me (one might presume this has something to do with a branding strategy), there is now a new website called MariaDB.com (which as you allude to above, is SkySQL-owned). > > So, mariadb.org is the foundation's website. mariadb.com belongs to skysql. Now, let's see what has changed from now, compared to a year ago? > * the Knowledgebase seems to have a new URL - kb.askmonty.org is now https://mariadb.com/kb/en/ > > What hasn't changed? The downloads. The blog. > > In fact, mariadb.org hasn't changed much at all. It still has links pointing to askmonty.org and montyprogram.com. As I do not represent the Foundation, it is clear this is something that has to be brought up to the attention of Simon Phipps, as CEO of the Foundation (https://mariadb.org/en/foundation/) > > So the net conclusion? > - We've lost montyprogram.com and askmonty.org (this is good!) > - We've gained mariadb.com (with a potentially confusing offering that has a vague description) > - The knowledgebase from askmonty.org (the only thing that remained there, besides the old worklog tool and wiki) has moved to mariadb.com > - We clearly need to improve the content on mariadb.org > - We need to get rid of/merge content of worklog: http://worklog.askmonty.org/worklog/ > > Does this help answer your questions? Also, I'm not sure if these discussions are meant to be on maria-developers, instead of maria-discuss > > cheers, > -colin

4 4

[Maria-discuss] New Question: ¿can I run MariaDB from a live-dvd?
by AskMonty KB 28 Sep '13

28 Sep '13

Hello, A new question has been asked in "General FAQ" by juanito1969: -------------------------------- Hello there. Greetings from México. I hope you can help me with the next case: I am using a knoppix's live-dvd. My pc has an independent logical-partition used for programs and data storage. I download and unzip and decompress the tarball and put it into the "storage partition". But I don't know how to startup and use MariaDB from the live-dvd and the info. "prepared" in the logical-partition. What do I need to do for use MariaDb that way? Thank you in advance for your help Juan Antonio Vargas. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/can-i-run-mariadb-from-a-live-dvd/

1 0

[Maria-discuss] MySQL bug affects mariaDB
by Peter Laursen 27 Sep '13

27 Sep '13

I think the 'mysql' client with MariaDB has a similar problem as it has with MySQL - refer? http://bugs.mysql.com/bug.php?id=70443 MariaDB installer installs my.ini to /datadir - what with MariaDB is a subfolder to /basedir. The server will look for it correctly as the registry key defining the service has a --default-file specification. But the command line clients don't read the registry key. @Wlad? -- Peter -- Webyog

4 8

[Maria-discuss] Giuseppe Maxia: Forking MySQL/ for how long can forks keep up?
by Colin Charles 27 Sep '13

27 Sep '13

Giuseppe Maxia asks some questions: http://datacharmer.blogspot.hk/2013/09/forking-mysql-for-how-long-can-forks… The comments featuring Justin Swanhart and Stewart Smith make a lot of sense - 5.6 was GA, it wasn't a GA-ready product. Its getting there to some extent (as do all MySQL releases: 6-9 months from GA date) Feel free to comment on the blog post above cheers, -colin -- Colin Charles, Chief Evangelist MariaDB | t: +6-012-204-3201 | Skype: colincharles

3 6

[Maria-discuss] multi master and conflicts
by Roberto Spadim 26 Sep '13

26 Sep '13

Hi guys, New problems to solve here =) if anyone could help should be nice :) I have an old system that use only one server with aria/myisam tables (some temporary tables and some views too) I want to implement a multi master replication (near to a cluster...), but i should take care about replication conflicts.... There's some good pratices or books about implementing multi master without replication conflicts? Should I change it to galera cluster? Well maybe.. I don't know what to do with aria storage, galera works with innodb/xtradb/myisam, what about aria? i didn't tested yet I don't know what to do about commit phase with myisam too, since galera do the certificate at commits phase before commit, and myisam problably do a autocommit at each insert/update/delete, this will be a problem, or not? The idea is not use innodb or I should implement some tables or views to have a faster COUNT/MIN/MAX functions (myisam is optimized for it), and i should rewrite some codes to use BEGIN, COMMIT, and cancel if connection is lost Well physical problems... Servers will not be online all time, the network link isn't good, servers are ~50km far via a wifi link with some tree and birds and others problems (that's why i think async replication is ok, instead of galera 'sync' cluster) Any idea is well come, but should be nice something that myisam/aria could be used I asked some days ago about replication and galera and xtradb cluster, but i'm not sure what to do yet tks guys! ideas are wellcome -- Roberto Spadim

1 0

[Maria-discuss] MySQL 5.7 benchmark
by Colin Charles 24 Sep '13

24 Sep '13

We're featured, pitted against Percona Server and MySQL 5.7 (Dimitri kindly did this for MariaDB 5.5 & 10) http://dimitrik.free.fr/blog/archives/09-01-2013_09-30-2013.html#174 It is unclear what versions of the software he used, or if its the latest alphas we've pushed, but we need to look into this clearly cheers, -colin -- Colin Charles, Chief Evangelist MariaDB | t: +6-012-204-3201 | Skype: colincharles

2 1