tag:blogger.com,1999:blog-5552895785228669482.post349405277344977052..comments2009-10-13T16:15:27.133+03:00Montyhttp://www.blogger.com/profile/06049512911785594864monty@askmonty.orgBlogger18125tag:blogger.com,1999:blog-5552895785228669482.post-31471264053920197022009-06-08T03:46:56.743+03:002009-06-08T03:46:56.743+03:00Can someone share when Maria with Rowlevel Locking will be ready for test? What version is included with Mysql 6.0, is that Maria 1.5 or Maria 2.0? <br /><br />Im very interested in testing row level locking with fulltext indexes. We have a huge problem with updates causing Select statements to bank up and eventually the database gets locked up. Id like to see if this is fixed.deeperShoppinghttp://www.blogger.com/profile/04015244443629027455noreply@blogger.comtag:blogger.com,1999:blog-5552895785228669482.post-3543047200571780812009-06-17T10:56:05.572+03:002009-06-17T10:56:05.572+03:00About which Maria release MysQL 6.0 contains and row level locking.<br /><br />MySQL 6.0 did include Maria 1.5, but as MySQL 6.0 is not going to be released, this isn&#39;t that relevant.<br /><br />MariaDB 5.1, is based on MySQL 5.1 and includes the Maria storage engine version 1.5. MariaDB 5.1 has higher concurrency than MyISAM for inserts but still holds table level locks for updates and deletes. This is scheduled to be fixed in MariaDB 5.4 which we are working on now. Our primary focus just now is on MariaDB, but we aim to have a better Maria storage engine out this year.<br /><br />You can follow our progress at <a href="http://askmonty.org/wiki/index.php/MariaDB" rel="nofollow">askmonty.org</a>.Montyhttp://www.blogger.com/profile/06049512911785594864noreply@blogger.comtag:blogger.com,1999:blog-5552895785228669482.post-18547814607123317522009-06-08T03:48:29.800+03:002009-06-08T03:48:29.800+03:00Does the mysql 6.0 download include Maria 1.5 or 2.0?<br /><br />I&#39;d like to test fulltext indexes and row level locking. We have a production database that requires fulltext indexes - and we get lockups when the system is busy and we update the main table.<br /><br />Does anyone know when we may be able to test out Maria 2.0?deeperShoppinghttp://www.blogger.com/profile/04015244443629027455noreply@blogger.comtag:blogger.com,1999:blog-5552895785228669482.post-49086334815001362642008-07-30T07:28:00.000+03:002008-07-30T07:28:00.000+03:00Correcting Stoner... 0/1 (in tests, 0/non-zero) are indeed false/true in C, predating Perl. The concept of 0/1 as false/true should already be very familiar to MySQL users, as those are the values of MySQL's TRUE/FALSE and logical expressions. PHP and other scripting languages often interpret empty/non-empty as false/true, as does bash - but the latter's stricter interpretation of 'empty' means that all of '0', ' ' and '1' are all regarded as true - not the reversal of sense you claim, but arguably counterintuitive.tobyhttp://www.blogger.com/profile/16041515498065869604noreply@blogger.comtag:blogger.com,1999:blog-5552895785228669482.post-20302876209357430482008-04-29T01:48:00.000+03:002008-04-29T01:48:00.000+03:00Nifty. I hear good things about this SE. I'll try playing around with it.C.J.http://www.blogger.com/profile/13555716613127948038noreply@blogger.comtag:blogger.com,1999:blog-5552895785228669482.post-67199662599791496302008-02-02T14:34:00.000+02:002008-02-02T14:34:00.000+02:00Instead of reinventing the wheel, why not help projects like PrimeBase XT ?<BR/><BR/>Or if the wheel has to be reinvented, why not work on something MySQL lacks, like a columnar engine?Frankhttp://www.blogger.com/profile/12817136642408990357noreply@blogger.comtag:blogger.com,1999:blog-5552895785228669482.post-25939978698016220742008-02-01T10:57:00.000+02:002008-02-01T10:57:00.000+02:00Hi!<BR/><BR/>Will here try to answer all comments so far:<BR/>(Sorry for the late answers, but I got a bit confused by where you could access the comments in the blogspot software and didn't notice these until now).<BR/><BR/>- Maria is of course licensed under GPL. You can now get the source and binaries http://forge.mysql.com/wiki/Maria_Preview<BR/><BR/>- The goal of the Maria development team is to make Maria to be the default transactional engine for MySQL by MySQL AB. The Falcon team has the same goal with Falcon engine. Let the best engine win :)<BR/><BR/> Seriously, both engines will have their own place and 'sweet spots' where they outperform each other and InnoDB. When both engines are stable we will start doing serious benchmarks to find out exactly where the sweet spots are.<BR/><BR/>- Regarding VAR=0|1, we will probably in the near future also allow the syntax VAR=TRUE | FALSE for cases like this.<BR/><BR/>- Faster View and materialised views are handled above the storage interface and thus not related to Maria. MERGE tables on the other hand has are very useful in environments where you want to easily manage many different collection of tables and is easiest handled by it's own engine.<BR/><BR/>- I don't plan to have more children. (And please don't hold it against me that I had said this once before :)Montyhttp://www.blogger.com/profile/06049512911785594864noreply@blogger.comtag:blogger.com,1999:blog-5552895785228669482.post-27460881466439065912008-01-29T06:38:00.000+02:002008-01-29T06:38:00.000+02:00are you planning on having another child, or is this the last mysql related project you will be doing?<BR/><BR/>seriously... I look forward to taking see the engine being put to hard work on our sites.Ianhttp://www.blogger.com/profile/14936725260777347334noreply@blogger.comtag:blogger.com,1999:blog-5552895785228669482.post-30938003558598195602008-01-29T00:49:00.000+02:002008-01-29T00:49:00.000+02:00How about concentrate on eliminating support for the MERGE table misfit and add real support for views, maybe materialized views...?<BR/>And give us your word that you're gonna quit supporting that "genius" engine called myisam and implement all the MySQL meta data dictionaries on this Maria engine. I'm soooooo sick of myisam.gigihttp://www.blogger.com/profile/06357593039726352596noreply@blogger.comtag:blogger.com,1999:blog-5552895785228669482.post-57528656494699594182008-01-29T10:43:00.000+02:002008-01-29T10:43:00.000+02:00The other Maria's cute! :)<BR/><BR/>And that's some big-ass house you have in the background!Laurence Khttp://www.blogger.com/profile/04686010645132877083noreply@blogger.comtag:blogger.com,1999:blog-5552895785228669482.post-57016501380794530582008-01-28T12:16:00.000+02:002008-01-28T12:16:00.000+02:00My questions:<BR/><BR/>How does Maria play with InnoDB, Falcon and MyISAM?<BR/><BR/>Is there a coordinated strategy about storage engines (at least for the ones by MySQL AB)?<BR/><BR/>Could you please shed some light?<BR/>Thanks and best regardspablojhttp://www.blogger.com/profile/03043517866113096024noreply@blogger.comtag:blogger.com,1999:blog-5552895785228669482.post-50906679415538389132008-01-30T04:46:00.000+02:002008-01-30T04:46:00.000+02:00"Maria is a new storage engine that Guilhem, Sanja, Sergei and I have been working on for the last 2 years."<BR/><BR/>Monty, this is fantastic news. I knew that you and your excellent team would produce something great, and now it is out! <BR/><BR/>LSLarryhttp://www.blogger.com/profile/04950902516895269927noreply@blogger.comtag:blogger.com,1999:blog-5552895785228669482.post-22454777472025673962008-02-01T06:55:00.000+02:002008-02-01T06:55:00.000+02:00Monty, good to see your blog..<BR/><BR/>Thanks<BR/>VenuVenuhttp://www.blogger.com/profile/13223028511934619666noreply@blogger.comtag:blogger.com,1999:blog-5552895785228669482.post-32082949208040262762008-01-28T05:03:00.000+02:002008-01-28T05:03:00.000+02:00Thanks for providing the details. This is a big help for me to evaluate whether I can use Maria when it is in a production release. Supporting one writer and many readers is all you need to use this on a slave.Mark Callaghanhttp://www.blogger.com/profile/09590445221922043181noreply@blogger.comtag:blogger.com,1999:blog-5552895785228669482.post-64506696223527259642008-01-29T15:15:00.000+02:002008-01-29T15:15:00.000+02:00Very exciting... unfortunately with my current employer i have been stuck in T-SQL for the last 2 years so my OpenSource passion has been quelled. I look forward to getting back in the MySQL mix.Fitzhttp://www.blogger.com/profile/03124539375033987504noreply@blogger.comtag:blogger.com,1999:blog-5552895785228669482.post-33286461254431343522008-01-30T10:58:00.000+02:002008-01-30T10:58:00.000+02:00What's the relation between Maria and Falcon?nomemoryspacehttp://nomemoryspace.wordpress.com/noreply@blogger.comtag:blogger.com,1999:blog-5552895785228669482.post-17644975382149884802008-01-28T17:02:00.000+02:002008-01-28T17:02:00.000+02:00Can we move away from the "VAR = 0|1" ? Not all DBAs are programmers and even those that are may have different expectations about 0 and 1. For example, Perl programmers treat 0 as false and 1 as true. C programmers may treat 0 as true and 1 as false (same for shell script.) And then there are those DBAs who have never written a line of code other than SQL.Stonerhttp://leapfrog.motd.org/noreply@blogger.comtag:blogger.com,1999:blog-5552895785228669482.post-76620161790043692222008-01-28T03:21:00.000+02:002008-01-28T03:21:00.000+02:00What license is Maria released under?<BR/><BR/>(I don't have BK and don't know how else to get the source files and check for myself!)Xaprbhttp://www.blogger.com/profile/01621441847303652718noreply@blogger.com