- discuss - lists.mariadb.org

[Maria-discuss] Gentoo Ebuilds for MariaDB on GitHub
by Brian Evans 17 Mar '10

17 Mar '10

I have posted the build scripts for Gentoo onto GitHub. They can be found here: http://github.com/grknight/mariadb-gentoo Gentoo downstream uses git over bzr so I thought it was the best choice. Feel free to pull from it.

3 7

[Maria-discuss] problems with innodb
by Alexandre Almeida 11 Mar '10

11 Mar '10

Hi guys, I am building MariaDB from source and it doesn't come with innodb. I have tried the parameters: all and innobase. Is there anything else I can pass on command line to get innodb running at my MariaDB? Many thanks, Alex

3 4

[Maria-discuss] askmonty.org moving to a new server this Thursday (25 Feb)
by Daniel Bartholomew 25 Feb '10

25 Feb '10

All, I'm sending this to both Maria Developers and Maria Discuss to make sure it gets to everyone, sorry for any duplicates. Just a heads up for everyone: I will be moving the askmonty.org website from its current home to a new server this Thursday, 25 Feb. If all goes according to plan, the website will remain up during the move but will be read-only during the actual switch. askmonty.org is the only domain/website that will be impacted by this move, websites on any other domain (such as buildbot.askmonty.org) are not part of this move and will continue to function normally. I will send a notice out on Thursday when I start the process, and a final one once the move is complete and I've tested that things are working properly. Thanks! -- Daniel Bartholomew Monty Program - http://askmonty.org

3 4

[Maria-discuss] MariaDB 5.1.42 has been released
by Colin Charles 18 Feb '10

18 Feb '10

Dear MariaDB users, MariaDB 5.1.42, a new branch of the MySQL database which includes all major open source storage engines, myriad bug fixes, and many community patches, has been released. We are very proud to have made our first final release, and we encourage you to test it out and use it on your systems. For an overview of what's new in MariaDB 5.1.42, please see: http://askmonty.org/wiki/index.php/Manual:MariaDB_5.1.42_Release_Notes For information on installing MariaDB 5.1.42 on new servers or upgrading to MariaDB 5.1.42 from previous releases, please see: http://askmonty.org/wiki/index.php/Manual:Installation MariaDB is available in source and binary form for a variety of platforms and is available from the download pages at: http://askmonty.org/wiki/index.php/MariaDB:Download:MariaDB_5.1.42 It is also our pleasure to announce that we have a partnership with Webyog to offer their tools for trial and at a discounted rate if purchased within 30 days. Find out more at: http://askmonty.org/downloads/links/webyog http://askmonty.org/wiki/index.php/MariaDB:Download#Software_Partner_Downlo… We welcome and appreciate your feedback, bug reports, bug fixes, patches, and participation on our mailing list. Find out more at: http://askmonty.org/wiki/index.php/MariaDB#How_can_I_participate_in_the_dev… Enjoy! -- Colin Charles, http://bytebot.net/blog/ "First they ignore you, then they laugh at you, then they fight you, then you win." -- Mohandas Gandhi

3 4

[Maria-discuss] Josh Berkus on community
by Kurt von Finck 16 Feb '10

16 Feb '10

Nice set of points on bad community management raised by Josh Berkus. http://lwn.net/SubscriberLink/370157/31a2534da9d465d3/ Do you disagree with any? Are there any things you would add? Do you think our projects suffer from any of these problems, and what constructive criticism do you have? Also, is there stuff you'd like to see the Maria community do? I think these points are a good jumping-off point to make sure we do things right. -- ./k kurt von finck http://www.mneptok.com public key: keyserver.ubuntu.com key id: 5229D26A fingerprint: 127A A484 ADBF A5AD E7FB 8CD2 8913 18F4 5229 D26A Music is the space between the notes. - Debussy

5 4

[Maria-discuss] virtual columns
by Federico Razzoli 05 Feb '10

05 Feb '10

I've read that MariaDB 5.2 will support virtual columns and I've read the virtual columns' specifications: http://forge.mysql.com/wiki/MySQL_virtual_columns_ref_manual I think there is a problem in that document. In CREATE TABLE and in ALTER TABLE commands you can create a virtual column. The syntax allows to specify that the column is STORED, if you wish. But it does not allow to specify that it's NOT STORED. This causes a little problem: one can not switch a STORED column to NOT STORED - one must to DROP and re-ADD the column. Also, I have a question: will virtual columns be able to use UDF's? Cheers, Federico

2 2

[Maria-discuss] FYI: askmonty.org/buildbot is moving to buildbot.askmonty.org/buildbot
by Daniel Bartholomew 04 Feb '10

04 Feb '10

All, This is an FYI for everyone that uses our buildbot web interface: Due to an upcoming server move I am in the process of moving our buildbot web interface from http://askmonty.org/buildbot to http://buildbot.askmonty.org/buildbot Both of the above currently work (and point at the same data), but as of Friday 5 Feb 2010 at approx 09:00 US Eastern time, http://askmonty.org/buildbot will turn into a redirect. The redirect will handle all of your old bookmarks (i.e. they should still work), but I thought I should at least let everyone know so that you aren't surprised by the move. I've already updated all of the links I could find on the askmonty.org wiki. And if you are wondering why I kept the /buildbot subdirectory in place on the new subdomain, well, it was easier and safer to keep it in place, so I did. If you connect directly to http://buildbot.askmonty.org you will automatically be redirected to the /buildbot subdir. Thanks! -- Daniel Bartholomew Monty Program - http://askmonty.org

1 0

[Maria-discuss] Replication and auto-increment
by Brian Evans 29 Jan '10

29 Jan '10

I was reading over the replication discussion on maria-developers I thought I'd share some thoughts that are not so technical as I do not understand the back end that well. Our system is currently a master-master WAN replication setup, each writing to a different DB with an offline process to do copies. Our databases extensively uses auto-increments on tables (more than necessary, but that's another story). Would future developments allow synchronous replication to occur on a single database when the WAN link has a single point of failure(SPoF)? How might an auto-increment system handle such a failure? This SPoF is our network link that can be a transient problem out of our control. Both sides may need to keep inserting data during this transient issue. This is usually not an issue 99% of the time, but it's better to prepare for downtime than trying to fix data errors in that 1%.

5 6

[Maria-discuss] MariaDB Twitter account
by Colin Charles 21 Dec '09

21 Dec '09

Hi! Does anyone know who runs the MariaDB twitter account? We'd like to get a hold of the login details, so that we can become more relevant on Twitter - i.e. start following people, answering questions, etc. If I don't get a response within 48 hours of this message, I'll contact Twitter to see if we can maybe get the account by them reassigning it to us. Cheers, -c -- Colin Charles, http://bytebot.net/blog/ "First they ignore you, then they laugh at you, then they fight you, then you win." -- Mohandas Gandhi

2 1

[Maria-discuss] Binding to network addresses
by Viljo Hakala 01 Dec '09

01 Dec '09

I am not sure whether this has been discussed. MySQL either binds to all network interfaces/addresses or to only single specified network address. Wouldn't this limitation be nice to have fixed in MariaDB, say I want to bind to 127.0.0.1 and a VIP network address, maybe management network address, but not to all network addresses on a server?

2 2

[Maria-discuss] Default Database Engine
by Richard Dunn 30 Nov '09

30 Nov '09

I have compiled and installed mariadb-5.1.39 on Mac OS X 10.6.2 and installed a 64-bit binary on CentOS 5. In both cases, MyISAM is still the default database engine. I would have expected it to be Maria. Did I miss something? Thanks, Richard

4 5

[Maria-discuss] [Kristian Nielsen] [Maria-developers] FOSDEM 2010
by Kristian Nielsen 11 Nov '09

11 Nov '09

It occured to me that this might be better to send to -discuss to get a wider audience. Sorry if you receive this twice. - Kristian.

1 0

[Maria-discuss] Additional promise to the MCA
by Henrik Ingo 08 Oct '09

08 Oct '09

Hi all As Monty blogged some time ago http://monty-says.blogspot.com/2009/08/thoughts-about-dual-licensing-open.h… ...we want to add a promise to our MariaDB contributors signing the MCA, that we will not use their contributions to restrict other licensees ability to contribute to Open Source. This text has now been approved by a lawyer. The question is, is it understandable? ********************************** Additional promise to contributions under the Monty Program Contributor Agreement Monty Program Ab promises to each contributor assigning rights under the Monty Program Ab Contributor Agreement, that when licensing 'products' (software), that include a contribution, to other 3rd parties, the license will be either i) an Open Source license (www.opensource.org) or ii) another license, in which case: * the other license will NOT restrict the licensee from making his own modifications to the product, including adding other suitably licensed code or other 'materials' from other sources (such as code available under suitable Open Source licenses) * the license will NOT restrict the licensee from publishing his own code or other 'materials' including, but not limited to, under an Open Source license. As a special note, it is observed that the Monty Program Ab Contributor Agreement itself fulfills these requirements. Also note that this promise does not not extend as a requirement to 3rd parties so as to restrict their rights to license products containing contributions. ********************************** We are especially interested to get feedback on the understandability of the last paragraph. henrik -- email: henrik.ingo(a)avoinelama.fi tel: +358-40-5697354 www: www.avoinelama.fi/~hingo book: www.openlife.cc

5 17

Re: [Maria-discuss] Information for release notes
by Daniel Bartholomew 28 Sep '09

28 Sep '09

Also posting this message to maria-discuss for those that might be interested in the changelog, but are not subscribed to maria-developers. On Thu, 24 Sep 2009 15:19:19 +0200, Kristian Nielsen <knielsen(a)knielsen-hq.org> wrote: Kristian> Hi Daniel, Kristian> Kristian> Here is a rough changelog written from reading through bzr Kristian> history. Kristian> Kristian> I took a dump of every commit in MariaDB that is not in MySQL Kristian> 5.1.38, and wrote this summary of the changes. Kristian> Kristian> I don't have sufficient knowledge to parse through all of the Kristian> Maria changes from before MariaDB started. Instead I wrote a Kristian> generic entry for the Maria storage engine, and also added Kristian> entries for what is already written (by Monty I think) on Kristian> http://askmonty.org/wiki/index.php/MariaDB_versus_MySQL Kristian> Kristian> So this is probably the best shot we have at a complete list Kristian> of relevant differences between MySQL and MariaDB. Do let me Kristian> know if anyone finds anything missing or any errors. Kristian> Kristian> Daniel, I hope you can use this as the basis for the release Kristian> notes. This list helps a lot. Thanks! Using the contents of the list, I have created a Changelog page on the wiki: http://askmonty.org/wiki/index.php/Manual:MariaDB_5.1_Changelog I organized the page into two sections: Features, and Bug Fixes. I also added links to the pages in the manual which exist for the changelog entries refer to. Kristian> Maybe this list will also be useful for you to fill out the Kristian> Manual on the Wiki. I am thinking you could check that all Kristian> new features are documented, and add pages for those that are Kristian> not. If not trivial, you could just make a stub page and ask Kristian> on maria-developers@ for someone to fill them out? Stub pages for the manual are easy to create: 1. add a link to the new page to http://askmonty.org/wiki/index.php/Manual:Contents 2. click on the new link 3. enter the following text into the new page: {{stub}} 4. save the new stub page To get things going, I created the following new stub pages for the manual: http://askmonty.org/wiki/index.php/Manual:Mysql_client_--abort-source-on-er… http://askmonty.org/wiki/index.php/Manual:XtraDB_storage_engine http://askmonty.org/wiki/index.php/Manual:Character_Set_Conversion_performa… http://askmonty.org/wiki/index.php/Manual:CHECKSUM_TABLE_performance Other stubs may need to be created, but I don't know which of the remaining topics need documentation or not. For example, does the entry about MariaDB NOT supporting NDB need it's own Manual page or not? Any contributions to the above stubs are *very* welcome. Any contributions to any of the other refman pages are likewise welcome: http://askmonty.org/wiki/index.php/Manual:Contents Henrik> Could the list itself be a basis for a changelog document and Henrik> then we make release notes into a more human readable document? Henrik> I thought that was your intention yesterday on IRC? The changelog page is a good compliment to the release notes page. The changelog is brief and is presented as a series of bullet points. The release notes page is longer with items presented as paragraphs in a more readable way. Thanks. -- Daniel Bartholomew

3 3

[Maria-discuss] License for MariaDB 5.1 Reference Manual
by Daniel Bartholomew 23 Sep '09

23 Sep '09

All, What license should we use for the MariaDB 5.1 Reference Manual? Some of the suggestions I've seen on IRC include: FDL : http://www.gnu.org/copyleft/fdl.html CreativeCommons : http://creativecommons.org My personal preference is to use the Creative Commons BY-SA license: http://creativecommons.org/licenses/by-sa/3.0/ This is the license used by Wikipedia and the share-alike part of the license ensures that the content remains open. It's a common license and is well understood and liked by a lot of people. Henrik mentioned the problem of attribution with CC licenses, but I don't think this is an issue with the mediawiki software we're using because of the edit histories and edit summaries, both of which fulfill this requirement. For example, the history page for the PBXT entry in the manual attributes me and Paul McCullagh for our contributions to the article: http://askmonty.org/wiki/index.php?title=Manual:PBXT_storage_engine&action=… I don't have much experience with the FDL, so if someone has reasons why we should use it, please share. Thanks. -- Daniel Bartholomew

3 2

[Maria-discuss] MariaDB 5.1 Reference Manual Introduction
by Daniel Bartholomew 22 Sep '09

22 Sep '09

All, The MariaDB 5.1 Reference Manual is progressing, but it needs an introduction. If you haven't taken a look at it yet, here is the TOC for the manual: http://askmonty.org/wiki/index.php/Manual:Contents At this stage we do not have a full or complete manual. Eventually we will have one, but creating it will take time. The purpose of the MariaDB 5.1 Reference Manual is to just document the differences between MariaDB 5.1 and MySQL 5.1 with the understanding that users can refer to the MySQL 5.1 manual for anything not covered in the MariaDB 5.1 manual. I'm currently working on an outline for the introduction page. One thing I think the intro should have is a version of the above paragraph to set expectations (we don't want users to think that we think our manual is complete). Beyond that, what other things should the introduction include? Also, if anyone knows of anything else which should be added to the manual, please let me know (or jump in and add it). Thanks. -- Daniel Bartholomew

1 0

Re: [Maria-discuss] [Maria-developers] MariaDB and the SCA
by Paul McCullagh 04 Sep '09

04 Sep '09

Hi Arjen, (Also posted to Maria-Discuss, so postings to Maria-Developers can be dropped on follow-up). On Sep 3, 2009, at 1:21 PM, Arjen Lentz wrote: > Hi Henrik, Kristian, > > On 03/09/2009, at 9:05 PM, Henrik Ingo wrote: >> On Thu, Sep 3, 2009 at 12:51 PM, Kristian >> Nielsen<knielsen(a)knielsen-hq.org> wrote: >>> Kristian Nielsen <knielsen(a)knielsen-hq.org> writes: >>> >>>> Davi Arnaut <Davi.Arnaut(a)Sun.COM> writes: >>>> >>>>> I've been monitoring the maria-developers list and there are some >>>>> patches that we would like to gradually incorporate into our >>>>> branches. For a practical example, i would like to merge into 5.1 >>>>> parts of this (http://tinyurl.com/q2ulgt) patch by Kristian. >>> >>>> Negotiations between Monty Program and Sun have started some time >>>> ago on a >>>> deal which would cover how Sun will get the rights it needs (ie. >>>> SCA) to >>>> include the MariaDB code into the MySQL code, and how Monty >>>> Program will >>>> receive compensation for giving these rights. As I understand it, >>>> these >>>> negotiations are however still in the early phase. >>> >>> Apparently, this is moving nowhere :-(. >>> >>> Davi, I'm sorry there has been no progress on this. We discussed >>> this again in >>> MariaDB, and would like to get things working better for now. >>> >>> What Monty suggested was that it would work for Sun if we submit >>> specific >>> patches under a BSD-new license. >>> >>> I realise that the http://tinyurl.com/q2ulgt patch request is now >>> so old that >>> it may be of no interest to you any longer. But if you have a >>> request for this >>> or other patches, please send them. All developers at Monty >>> Program have the >>> ability to submit their work to Sun at their own discretion, so we >>> should be >>> able to make this work on a low-overhead technician-to-technician >>> level. >> >> Thanks for picking this up. I just wanted to confirm this is true and >> we are happy to cooperate. > > > It's how it works with Drizzle. > However, I've blogged and otherwise written and spoken about this > before, it does not make me particularly happy. > > Here's the layout: > - the GPL parts of the code are owned by Sun. > - BSD can be incorporated non-OSS derivatives. > > And the consequenec of this is that Sun is able to perpetuate the > dual licensing model - a model which perhaps worked once upon a type > and did well, but which is definitely outdated, and only abused by > greedy salespeople. As far as I know, with the advent of the BSD licensed libdrizzle (https://launchpad.net/libdrizzle ), which also runs with MySQL (and I assume MariaDB), the dual licensing model is now irrelevant. My reading of the GPL license (http://www.gnu.org/copyleft/gpl.html) is that only programs that link GPL components become part of the greater work. From the GPL section "1. Source Code.": "For example, Corresponding Source includes interface definition files associated with source files for the work, and the source code for shared libraries and dynamically linked subprograms that the work is specifically designed to require, such as by intimate data communication or control flow between those subprograms and other parts of the work." So linked sub-programs are included. But: "However, it does not include the work's System Libraries, or general- purpose tools or generally available free programs which are used unmodified in performing those activities but which are not part of the work." So an unmodified free program like mysqld (the MySQL daemon), are not part of the work. This means that a programming linking libdrizzle, and then accessing mysqld over a communications _channel_ (like TCP, socket, pipe, etc), does not need to be GPL. > By agreeing to this arrangement, contributors ensure that Sun is > able to continue that. > Do you want that? > > "yes" might be a valid choice, on the basis that it might be more > important to get the changes upstream. > But I think the question needs to be asked explicitly. Hence. -- Paul McCullagh PrimeBase Technologies www.primebase.org www.blobstreaming.org pbxt.blogspot.com

4 7

Re: [Maria-discuss] [Maria-developers] MariaDB and the SCA
by Henrik Ingo 03 Sep '09

03 Sep '09

Hi Giuseppe I'm cross-posting to maria-discuss since this is now a non-technical discussion. Please remove maria-developers when replying. On Thu, Sep 3, 2009 at 3:01 PM, Giuseppe Maxia<g.maxia(a)gmail.com> wrote: > Why it's perfectly OK that MariaDB gets MySQL bugfixes for free and > instead it's a rip off if MySQL gets MariaDB bug fixes? Of course, all of the MariaDB source code is available as GPL, just like for MySQL. Sun is not prohibited from using it under the GPL, just like we are using MySQL code. > MariaDB requires the same kind of legal grants that Sun asks, and the > FAQ even states "The MCA is based on Sun's Contributor Agreement. We > think it is one of the best contributor agreements around! " > http://askmonty.org/wiki/index.php/MCA_FAQ We've made some adjustments, but yes, apparently it is one of the best contributor agreements around, the community seems to think. That's why we use it. > So, where is the catch? If Sun asks for the SCA, it's "greedy > salesmen". If MariaDB asks the same thing, it's "protecting the > community". Actually, it is very important that MariaDB copyrights are pooled to one owner, we could get into trouble if we didn't do that. (I won't give the details, so as not to give any ideas.) Same is true for XtraDB, where we have advised Percona to pool the copryights from any non-Percona contributors. It's not like we (MP) want to own everything, but somebody has to do it. Personally my first motivation in favor of pooling copyrights was however entirely benevolent towards MySQL and its users. By having the copyrights pooled in one place (rather than just going all GPL), we are able to assign the code back to Sun (if we so agree), and I'd really like to do that so that all MySQL users, also the commercial licensees would benefit from the MariaDB work. henrik -- email: henrik.ingo(a)avoinelama.fi tel: +358-40-5697354 www: www.avoinelama.fi/~hingo book: www.openlife.cc

3 2

[Maria-discuss] Compile failure on OS
by Sergey Petrunya 24 Aug '09

24 Aug '09

Hi! We're getting a compile error when trying to compile PBXT+Maria on ppc MacOS X: http://askmonty.org/buildbot/builders/macosx-g5-dbg/builds/12/steps/compile… looking at the bottom there, one sees: if ccache gcc -DHAVE_CONFIG_H -I. -I. -I../../../include -I../../../include -I../../../include -I../../../regex -I../../../storage/innobase/include -I../../../sql -I. -g -Wimplicit -Wreturn-type -Wswitch -Wtrigraphs -Wcomment -W -Wchar-subscripts -Wformat -Wparentheses -Wsign-compare -Wwrite-strings -Wunused-function -Wunused-label -Wunused-value -Wunused-variable -Wreorder -Wctor-dtor-privacy -Wnon-virtual-dtor -felide-constructors -fno-exceptions -fno-rtti -DUNIV_MUST_NOT_INLINE -DEXTRA_DEBUG -DFORCE_INIT_OF_VARS -DSAFEMALLOC -DPEDANTIC_SAFEMALLOC -O0 -g3 -gdwarf-2 -fno-implicit-templates -fno-exceptions -fno-rtti -D_P1003_1B_VISIBLE -DSIGNAL_WITH_VIO_CLOSE -DSIGNALS_DONT_BREAK_READ -DIGNORE_SIGHUP_SIGQUIT -DDONT_DECLARE_CXA_PURE_VIRTUAL -MT libpbxt_a-datalog_xt.o -MD -MP -MF ".deps/libpbxt_a-datalog_xt.Tpo" -c -o libpbxt_a-datalog_xt.o `test -f 'datalog_xt.cc' || echo './'`datalog_xt.cc; \ then mv -f ".deps/libpbxt_a-datalog_xt.Tpo" ".deps/libpbxt_a-datalog_xt.Po"; else rm -f ".deps/libpbxt_a-datalog_xt.Tpo"; exit 1; fi lock_xt.h: In function 'void xt_atomic_inc2(volatile u_int16_t*)': lock_xt.h:194: error: '__sync_fetch_and_add' was not declared in this scope lock_xt.h: In function 'void xt_atomic_dec2(volatile u_int16_t*)': lock_xt.h:209: error: '__sync_fetch_and_sub' was not declared in this scope lock_xt.h: At global scope: lock_xt.h:584: warning: 'struct XTRowLockList' only defines private constructors and has no friends lock_xt.h:640: warning: 'struct XTRowLocks' only defines private constructors and has no friends Is PBXT expected to work on MacOS X G5? BR Sergey -- Sergey Petrunia, Software Developer Monty Program AB, http://askmonty.org Blog: http://s.petrunia.net/blog

3 2

Re: [Maria-discuss] Compile failure on OS
by Hakan Kuecuekyilmaz 21 Aug '09

21 Aug '09

See also, Compile fails on Mac OS X PPC https://bugs.launchpad.net/bugs/415475 Best regards, Hakan Am 21.08.2009 um 15:58 schrieb Sergey Petrunya <psergey(a)askmonty.org>: > Hi! > > We're getting a compile error when trying to compile PBXT+Maria on > ppc MacOS X: > > http://askmonty.org/buildbot/builders/macosx-g5-dbg/builds/12/steps/compile… > > looking at the bottom there, one sees: > > if ccache gcc -DHAVE_CONFIG_H -I. -I. -I../../../include -I../../../ > include > -I../../../include -I../../../regex -I../../../storage/innobase/ > include > -I../../../sql -I. -g -Wimplicit -Wreturn-type -Wswitch - > Wtrigraphs > -Wcomment -W -Wchar-subscripts -Wformat -Wparentheses -Wsign-compare > -Wwrite-strings -Wunused-function -Wunused-label -Wunused-value > -Wunused-variable -Wreorder -Wctor-dtor-privacy -Wnon-virtual-dtor > -felide-constructors -fno-exceptions -fno-rtti -DUNIV_MUST_NOT_INLINE > -DEXTRA_DEBUG -DFORCE_INIT_OF_VARS -DSAFEMALLOC - > DPEDANTIC_SAFEMALLOC -O0 > -g3 -gdwarf-2 -fno-implicit-templates -fno-exceptions -fno-rtti > -D_P1003_1B_VISIBLE -DSIGNAL_WITH_VIO_CLOSE -DSIGNALS_DONT_BREAK_READ > -DIGNORE_SIGHUP_SIGQUIT -DDONT_DECLARE_CXA_PURE_VIRTUAL -MT > libpbxt_a-datalog_xt.o -MD -MP -MF ".deps/libpbxt_a-datalog_xt.Tpo" - > c -o > libpbxt_a-datalog_xt.o `test -f 'datalog_xt.cc' || echo > './'`datalog_xt.cc; \ > then mv -f ".deps/libpbxt_a-datalog_xt.Tpo" > ".deps/libpbxt_a-datalog_xt.Po"; else rm -f > ".deps/libpbxt_a-datalog_xt.Tpo"; exit 1; fi > lock_xt.h: In function 'void xt_atomic_inc2(volatile u_int16_t*)': > lock_xt.h:194: error: '__sync_fetch_and_add' was not declared in > this scope > lock_xt.h: In function 'void xt_atomic_dec2(volatile u_int16_t*)': > lock_xt.h:209: error: '__sync_fetch_and_sub' was not declared in > this scope > lock_xt.h: At global scope: > lock_xt.h:584: warning: 'struct XTRowLockList' only defines private > constructors and has no friends > lock_xt.h:640: warning: 'struct XTRowLocks' only defines private > constructors and has no friends > > Is PBXT expected to work on MacOS X G5? > > BR > Sergey > -- > Sergey Petrunia, Software Developer > Monty Program AB, http://askmonty.org > Blog: http://s.petrunia.net/blog > > _______________________________________________ > 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] why does UNION ALL use a temp table?
by MARK CALLAGHAN 03 Aug '09

03 Aug '09

Why does UNION ALL use a temp table? Many users are surprised by this. It would be faster to return rows from each branch of a UNION ALL query directly to the network. -- Mark Callaghan mdcallag(a)gmail.com

3 6

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

27 Jul '09

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] Launchpad RO mode
by Kurt von Finck 22 Jul '09

22 Jul '09

FYI ... > Launchpad will be in read-only mode for an hour on Wednesday, 22nd > July while we roll out new code. > > Going read-only: 22.00 UTC, Wednesday 22 July 2009 > Expected back to normal: 23.00 UTC, Wednesday 22 July 2009 > > There will be a couple of minutes around 22.00 UTC during which > Launchpad is unavailable while we switch into read-only mode, and then > another couple of minutes again when we switch back to read-write. > > Note that’s “UTC”. Actual time in your time zone may be different, > and remember Britain is in BST right now, which is 1 hour later than > UTC. > > Watch this list for details of the new release later this week. > > Best, > -Karl Fogel -- ./k kurt von finck http://www.mneptok.com public key: keyserver.ubuntu.com key id: 5229D26A fingerprint: 127A A484 ADBF A5AD E7FB 8CD2 8913 18F4 5229 D26A Music is the space between the notes. - Debussy

1 0