Pencarian

Rss Posts

 

 

 

MariaDB 5.3.4 benchmarks

Feb 19, 2012

MariaDB 5.3 has reached the release candidate milestone, and the 5.3 version promises a lot of new features and optimization (i.e in optimizer http://kb.askmonty.org/en/what-is-mariadb-53#query-optimizer). No surprise I wanted to check how all improvements affect general performance.
So I why don’t we run old good sysbench benchmark.

For the benchmark I took:

HP ProLiant DL380 G6 box
sysbench multitables oltp rw workload, 16 tables, 500mil rows each, total datasize about 30GB
working threads from 1 to 256
Versions: MariaDB 5.3.4, MySQL 5.5.20
Data is stored on RAID10 HDD partition
Like in all my recent benchmarks, I make throughput measurements each 10 sec, so we can see the stability of the throughout

The raw results, configuration and scripts are available on our Benchmarks Launchpad
The graphical results:
Throughput (more is better)

Threads MariaDB 5.3.4 MySQL 5.5.20 Ratio
1 252 271 0.9298893
2 412 588 0.7006803
4 801 1097 0.7301732
8 1709 2205 0.7750567
16 3197 4076 0.7843474
32 3303 4166 0.7928469
64 3336 4150 0.8038554
128 3800 4170 0.9112710
256 3710 4131 0.8980876

I was surprised to see that MariaDB shows 20-30% worse throughput.
It seems many changes resulted to performance hit in general. I wonder whether MariaDB team runs performance regression benchmarks, and if they do, why do we see such performance decline.
Follow @VadimTk

Basisdata, F/OSS, Sindikasi     Comments Off

MariaDB: the new MySQL? Interview with Michael Monty Widenius.

Sep 29, 2011

?I want to ensure that the MySQL code base (under the name of MariaDB) will survive as open source, in spite of what Oracle may do.? — Michael ?Monty? Widenius. Michael ?Monty? Widenius is the main author of the original version of the open-source MySQL database and a founding member of the MySQL AB company. [...]

Basisdata, F/OSS, Sindikasi     Comments Off

Proposal for MariaDB trademark policy

Dec 21, 2010

Within Monty Program Ab we have during this year had a lot of discussions about how to go forward with the MariaDB trademark. It’s been clear that everyone wants to have something that is substantially freer than the MySQL trademark to ensure the survival of MariaDB whatever happens to Monty Program Ab.We wanted to make something that should work well, both for open source and commercial usage (and yes, I know that in some cases these are one and the same), which is not very common with many other trademark policies. My belief is that by having a very liberal trademark policy we will create a bigger ecosystem around MariaDB which will help all of us.Now we have had a couple of internal drafts (with heavy input from our community advocates) and we have released our first public draft.Please give us feedback about this either on my blog or the knowledge base so that we can take your thoughts into account for our final version!

Aplikasi, Basisdata, F/OSS, Sindikasi     Comments Off

Using MariaDB as a column store and Virtual Columns for indexing

Oct 28, 2010

This is a followup to my previous post about Virtual Columns. In this post I will do a more in-depth test on using virtual columns in a use case where MariaDB is used as a document store.
Document oriented DB basics
Relational databases store data in 2-dimensional tables, rows and columns. Document oriented databases do not store Word documents or novels, rather the “documents” are essentially serialized PHP arrays, Java-objects, etc. The most popular document format today is JSON. JSON “documents” have exactly the same syntax as a JavaScript array, originally JavaScript programmers would just eval(“data = ” + jsondocument); to get the data into a variable (unserialize). For more information about JSON and how a JSON database would work, see the Wikipedia article and for instance the MongoDB manual.
Another format that has been used for document stores is XML documents, and many programming languages can serialize objects into XML.
read more

Sindikasi     0 Comments

MariaDB 5.1.49 for Mac OS X

Aug 27, 2010


Stuttgart: a rainy day, waiting for Iftar. Good time for good news!
During my vacation I read about a request for a MariaDB package for Mac OS X? and did some research. Back from vacation I have an alpha version of MariaDB package for Mac OS X for? our community to test.
Caution: this is the first installer I ever wrote on a Mac, so use it on a test system only!
I would like you to test the installer and provide us with feedback.
Known issues in the MariaDB installer:

The Preferences Pane app for starting/stopping the server instance is missing
The installer for setting up MariaDB as a Startup Item is missing.

Side node: while digging into the Mac installer I found two
bugs in the MySQL Mac OS X installer.

http://bugs.mysql.com/bug.php?id=56279

Mac installer does not work as documented

http://bugs.mysql.com/bug.php?id=56280

Mac installer’s postflight script does not work all the time

You can grab the package from here:

http://lisas.de/~hakan/file/mariadb-5.1.49-osx10.6-x86.pkg

Basisdata, F/OSS, Sindikasi     Comments Off

MariaDB is Thinking about Fixing MySQL Replication and You Can Help

Jan 29, 2010

In case you have not noticed, MariaDB is joining the list of projects thinking about how to improve MySQL replication.nbsp;nbsp; The discussion thread starts here on the maria-developers mailing list. This discussion was jointly started by Monty Program, Codership, and Continuent (my employer) in an effort to push the state of the art beyond features offered by the current MySQL replication.nbsp; Now that things are starting to die down with the Oracle acquisition, we can get back to the job of making the MySQL code base substantially better.nbsp; The first step in that effort is to get a discussion going to develop our understanding of the replication problems we think are most important and outline a strategy to solve them.nbsp; Speaking as a developer on Tungsten, my current preference would to be to improve the existing MySQL replication.nbsp; I suspect this would also be the preference of most current MySQL users.nbsp; However, there are also more radical approaches on the table, for example from our friends at Codership, who are developing an innovative form of multi-master replication based on group communications and transaction certification.nbsp; That’s a good thing, as we want a range of contrasting ideas that take full advantage of the creativity in the community on the topic of replication. If you have interest in improving MySQL replication please join the MariaDB project and contribute your thoughts.nbsp; It should be an interesting conversation.

Basisdata, Sindikasi     0 Comments