Slashdot is powered by your submissions, so send in your scoop


Forgot your password?
DEAL: For $25 - Add A Second Phone Number To Your Smartphone for life! Use promo code SLASHDOT25. Also, Slashdot's Facebook page has a chat bot now. Message it for stories and more. Check out the new SourceForge HTML5 internet speed test! ×

MariaDB vs. MySQL: A Performance Comparison 112

Nerval's Lobster writes "MariaDB is a fork of the MySQL source code, split off in the wake of concerns over what Oracle would do with MySQL licensing. In addition to its role as a 'drop-in replacement' for MySQL, MariaDB also includes some new features that (some claim) make it better than MySQL. Jeff Cogswell compares MySQL and MariaDB and suggests (in his opinion) that there's 'more than enough reason to ditch MySQL and switch over to MariaDB and stay there.' Why? While he breaks down MariaDB's new features and thinks many of them aren't that fantastic, and while MariaDB's performance isn't that much better than that of MySQL ('MariaDB's performance appears a bit better on multi-core machines, but I strongly suspect that one could tweak MySQL to match'), the questions over Oracle and MySQL licensing give him pause. 'MariaDB shows every indication that it will be around for quite awhile, while you can't really say the same of Oracle's MySQL,' he writes. 'Free-and-open MySQL competes with Oracle's proprietary and extremely competitive tools. That alone is grounds for concern — will Oracle do something to impede MySQL's development?'"

Comment Re:XFS for huge mailqueues, otherwise EXT3 or EXT4 (Score 3, Interesting) 210

From memory (I've been out of that business for 6 months) CPanel stores mail as maildirs. If you have gazillions of small files (that's a lot of email) then XFS handles it a lot better than ext3 - I've never benchmarked XFS against ext4. Back in the day, it also dealt with quotas more efficiently than ext2/3, but I really doubt that is a problem nowadays.

If you aren't handling gazillions of files, I'd be tempted to stick to ext3 or ext4 - just because it's more common and well known, not because it is necessarily the most efficient. When your server goes down, you'll quickly find advice on how to restore ext3 filesystems because gazillions of people have done it before. You will find less info about xfs (although it may be higher quality), just because it isn't as common.

XFS is probably better for large maildirs, but ext3 in recent kernels has much better performance on large directories starting in the late 2.6 kernels. It doesn't provide for infinite # of files per directory, but it doesn't take a huge hit listing e.g. 4k files in a directory anymore.

Comment Re:is it shipping to customers ? (Score 1) 394

The comment would be purely theoretical problem.

Unless it can be seen in the binary, RTS will tell anyone involved: 'No, you cannot see our source. You've made a serious public accusation. Do you own your house? Any other assets? What was your net worth prior to today?'

If I understand your comment, you're stating that, if I may paraphrase, "of course they're not going to say they infringe. anyone would say that and since they only ship a binary they can keep the source to themselves while threatening legal action".

Again, if I understood you correctly, then you're also expressing that in your view they are guilty until proven innocent. I'm commenting since that's not the case. If I write some code and then release it under the GPL, then as Nick says in his comments, it is any other user who is responsible for abiding by the GPL. I, however, can chose to release my code in any form I chose under any other license I chose subsequently unless/until I assign the rights to another party (this is what the FSF asks for when you work on their projects - this prevents software that they advocate from being dual-licensed and allows them to unambiguously pursue infringement).

Comment Re:Ever heard of CompuServe? (Score 3, Informative) 469

True, that. In '92 compuserve was established, but its greatest value for geeks was that they had a usenet feed and a mail gateway (which was probably a uucp connection to uunet/alternet, but mail flowed!), and so you could communicate with the rest of the world. It's still sad that they kept denying that this was their future until they couldn't stop hemorrhaging users.

Comment Re:Defaults still insane? (Score 2) 209

My point is that those "bunch of tiny servers" vastly outnumber the "real enterprise applications".

Shouldn't your hosting provider be doing this for you, or shouldn't you be doing this on install? This thread has been going on and on over a handful of config options. So you need configuration management. The apache config is flexible enough and unlike sendmail completely readable and comprehensible.

Comment Re:ZFS v31+ at last? (Score 1) 224

> I don't see that Oracle has anything to lose here by staying open with that component, filesystems benefit a lot from widespread use and lots of testing, but, well, it is Oracle.

I believe netapp still believes, somehow, that zfs is wafl, and that they should be paid damages for distribution of their IP.

I know that Daniel Philips has claimed at conferences way back when that he has seen prior art on WAFLs patents, but he still stopped working on Tux2 instead of fighting it. I don't know if Larry and the big O have a patent portfolio that can shut up netapp.

Comment Re:Nothing to see here (Score 0) 224

ZFS has been riddled with bugs in practice. Production crashes, re-silvering that fails constantly, magic voodoo incantations to get all pools up and running (I don't mean commands, I mean "well, sometimes the third time we reboot it works"). Uggh. Now that bugs aren't being fixed in opensolaris, I don't know how paying customers can convince solaris support to patch bugs. I used to point out that we wouldn't be paying for a patch that someone had integrated into opensolaris a year prior. I am so happy I don't touch this any more.

Comment Re:Zones (Score 1, Insightful) 224

They're OK... until you try to manage different (commercial) applications on them. When app 1 requires a kernel patch, well there's no real virtualization there - the zones still run the same kernel, so when app 2 requires a different, incompatible patch, you get the throw up your hands and become the IT that says "no".

These are old issues, but trying to sell zones as the end-all be-all, or as even much more interesting than a BSD jail, is bogus.

Let's get to real issues that this doesn't change: patch management is a nightmare on solaris. 11 hasn't changed this. The OS is waaaay overpriced vs. the competition, and very unsophisticated processes monitoring via smf (I honestly think they should have cut their losses and just used runit - most of the benefits, none of the academically-inspired and simply stupid limitations in compiling the graph at boot time vs run time vs build time.... ugh).

Comment Re:Don't mix the vendor networking gear? (Score 1) 54

Sorry, but no. I've been in the industry for over 10 years, and it's rare to experience these types of problems. Consumer-grade equipment is notorious for this type of thing, but it's much less common with a major vendor with a reputation to protect. Single vendor rarely means best of breed.

It may be rare, but when you're in a conf. call with Juniper and Cisco and F5 because you're finding that multicast is dropping packets, you can be pretty sure that the one that fixes it is the one who has a proposal to replace all of the others' equipment with their own.

Comment Re: The Spec (Score 1) 194

This is a soft-sell way to get nosql databases into traditional IT situations, where familiarity with SQL will let current support and DBAs say "oh, it's like SQL, but it doesn't have joins. I can do that".

I always did like the sqlite docs, specifically the diagrams of the state machine for each statement.

Comment And you download it from where? (Score 2) 181

Firefox has always had the most frustrating UI for their info pages. They'll send you to pages and pages of info, but there's never a standard sidebar to actually download the available versions. The page this article links to has a link to the mobile beta of 4, which is exactly not the platform I'm browsing from. Fail.

Slashdot Top Deals

The price one pays for pursuing any profession, or calling, is an intimate knowledge of its ugly side. -- James Baldwin