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
| OS |
cnt |
% |
| Mac OSX |
3 |
0.5% |
| FreeBSD |
5 |
0.9% |
| Windows |
60 |
10.5% |
| Solaris Sparc |
3 |
0.5% |
| Solaris x86 |
7 |
1.2% |
| Debian Linux |
110 |
19.2% |
| Red Hat Linux |
196 |
34.1% |
| other Linux |
179 |
31.2% |
| SuSE Linux |
7 |
1.2% |
| AIX |
3 |
0.5% |
| Unknown |
1 |
0.2% |
|
574 |
100.0% |
|
 |
Operating System
 |
| OS |
cnt |
% |
| BSD |
8 |
1.4% |
| Windows |
60 |
10.5% |
| Solaris |
10 |
1.7% |
| Linux |
492 |
85.7% |
| AIX |
3 |
0.5% |
| Unknown |
1 |
0.2% |
|
574 |
100.0% |
|
Platform
| Platform |
cnt |
% |
| PowerPC |
4 |
0.7% |
| Sparc |
3 |
0.5% |
| Unknown |
7 |
1.2% |
| x86 |
183 |
31.9% |
| x86_64 |
377 |
65.7% |
|
574 |
100.0% |
|
 |
Distribution
 |
| Distribution |
cnt |
% |
| FreeBSD |
4 |
0.7% |
| Debian |
52 |
9.1% |
| Ubuntu |
49 |
8.5% |
| Red Hat |
2 |
0.3% |
| Source distribution |
106 |
18.5% |
| SUSE MySQL RPM |
7 |
1.2% |
| Gentoo Linux |
9 |
1.6% |
| MySQL Classic (Commercial) |
1 |
0.2% |
| MySQL Cluster Server (Commercial) |
3 |
0.5% |
| MySQL Cluster Server (GPL) |
1 |
0.2% |
| MySQL Community (GPL) |
165 |
28.7% |
| MySQL Enterprise Server (Commercial) |
28 |
4.9% |
| MySQL Enterprise Server (GPL) |
113 |
19.7% |
| Percona Server (GPL) |
11 |
1.9% |
| MariaDB |
12 |
2.1% |
| Others |
11 |
1.9% |
|
574 |
100.0% |
|
I would not say that those numbers are 100% correct for the whole market but the dimensions are quite right I would say...
English
Deutsch
Michal did a similar Survey for OpenSuSE
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).
CMS Platforms And Databases
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.
CMS Platforms And Databases
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
Pie charts
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.
MySQL versions?
Oli, do you have stas for MySQL versions used? Would be interesting to see it here.
MySQL versions used
Hi Wlad,
Please find the numbers here:
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?
Great, thanks a lot! it is
Great, thanks a lot!
it is surprising to find out how old are the versions being used outside.
MySQL versions used
Seufzg!
I thought this question would pop up...! I try if I find some time to gather them...
It's interesting to see that
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 ...
SuSE vs. Gentoo
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...