You are here

Home » Blogs » Shinguz's blog

MySQL out in the wild

Thu, 2011-06-30 14:29 — Shinguz

One of our partners recently asked me on what platforms do we usually see MySQL installed out there...

The last 5 years I gave the answer: Typically it is 80% Linux, 10% Windows, 5% Solaris and 5% all others. But this was only the picture of my limited view and I was not sure how objective this was.

This time I really wanted to know it and so I collected the information of about 570 MySQL installations of customers.

The following numbers came out:

Operating System

OScnt%
Mac OSX30.5%
FreeBSD50.9%
Windows6010.5%
Solaris Sparc30.5%
Solaris x8671.2%
Debian Linux11019.2%
Red Hat Linux19634.1%
other Linux17931.2%
SuSE Linux71.2%
AIX30.5%
Unknown10.2%
574100.0%
 Operating System

Operating System

Operating System
OScnt%
BSD81.4%
Windows6010.5%
Solaris101.7%
Linux49285.7%
AIX30.5%
Unknown10.2%
574100.0%

Platform

Platformcnt%
PowerPC40.7%
Sparc30.5%
Unknown71.2%
x8618331.9%
x86_6437765.7%
574100.0%
 Platform

Distribution

Distribution
Distributioncnt%
FreeBSD40.7%
Debian529.1%
Ubuntu498.5%
Red Hat20.3%
Source distribution10618.5%
SUSE MySQL RPM71.2%
Gentoo Linux91.6%
MySQL Classic (Commercial)10.2%
MySQL Cluster Server (Commercial)30.5%
MySQL Cluster Server (GPL)10.2%
MySQL Community (GPL)16528.7%
MySQL Enterprise Server (Commercial)284.9%
MySQL Enterprise Server (GPL)11319.7%
Percona Server (GPL)111.9%
MariaDB122.1%
Others111.9%
574100.0%

I would not say that those numbers are 100% correct for the whole market but the dimensions are quite right I would say...

Taxonomy upgrade extras: 
english
mysql
architecture
operating system
platform
distribution
installation

Comments

It's interesting to see that there are more production servers using Gentoo then Suse. Maybe Gentoo could/should have more attention from Mysql/Oracle? Just a thought ...
Sezacomment Thu, 2011-06-30 19:47

Possibly in the 4th graph the values are not too correct. I do not know for example where MySQL packages distributed with the SuSE distribution count and where MySQL Packages FOR the SuSE distribution count. Windows on the 4th graph is completely missing so they are counted in the MySQL% packages...
admincomment Thu, 2011-06-30 20:34

Oli, do you have stas for MySQL versions used? Would be interesting to see it here.
wladcomment Fri, 2011-07-01 00:13

Seufzg! I thought this question would pop up...! I try if I find some time to gather them...
admincomment Fri, 2011-07-01 06:55

Hi Wlad, Please find the numbers here:

MySQL Version

Version%
4.00.2%
4.12.7%
5.062.4%
5.129.6%
5.2 (MariaDB)1.7%
5.53.5%
100.0%
 MySQL Version

Please do NOT compare the numbers with the numbers above. They have a slightly different base but the result should not change significantly... PS: Roland: Better like this?
admincomment Mon, 2011-07-04 14:56

Great, thanks a lot! it is surprising to find out how old are the versions being used outside.
wladcomment Tue, 2011-07-05 03:01

Thanks for the post, interesting insights. Just one remark: recently I bumped into an article that argues why Pie charts are bad - esp. "fancy" 3D ones. When I started reading it, I didn't think I'd be convinced, but after seeing the examples in the article I changed my mind. When I was trying to read the Pie charts in this articles I had an immediate recollection - it's *really hard* to estimate the size of the Pie slices when they are oddly sized, in particular the smaller ones. It's a good thing that you still also print the actual figures, but in that case the Pie charts are redundant and distracting. If you have same time, please read http://www.perceptualedge.com/articles/08-21-07.pdf - it's really insightful IMO.
Roland.Boumancomment Fri, 2011-07-01 11:10

it would be very interesting to study the relationship and genesis about the major cms platforms like Joomla! and their databses (GPL, Open source or not); the trend on using a commercial or free database.
cypherinfocomment Mon, 2011-07-04 13:23

Hi cypherinfo, Indeed, that would be interesting... Unfortunately we do not have these numbers. CMS is nothing we have directly to do with and it seems like CMS do not typically have problems with their (MySQL) databases. What we see, when it is related to MySQL, most often Typo3 is used. But that is not the answer to your question. Sorry! Somebody who is a CMS specialist should take care of this question! Is somebody willing to set-up a poll for this? Oli
admincomment Mon, 2011-07-04 13:38

Michal Hrušecký did a Survey of the usage of different MySQL branches on OpenSuSE Linux. The results can be found in his article: MySQL survey results (Oct 17, 2011).
olicomment Wed, 2011-10-19 09:23