Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I have a small setup of MySQL Community Server version 5.6 running on KVM based VPS. 4 CPU cores are available and total memory is limited to 1GB. I use MyISAM tables mainly for Wordpress and few other personal projects.

Which server can best suit my requirements among MySQL Community Server(all 5.x versions), Percona and MariaDB? I am basically looking for better performance (mainly read) and resource utilization.

share|improve this question

closed as primarily opinion-based by ypercube, gbn, dezso, Michael - sqlbot, Mark Storey-Smith Jul 12 '13 at 12:01

Many good questions generate some degree of opinion based on expert experience, but answers to this question will tend to be almost entirely based on opinions, rather than facts, references, or specific expertise.If this question can be reworded to fit the rules in the help center, please edit the question.

1  
How big (in GB) is the total size of the databases that your instance is going to have? You could do tests to drain the last drop of efficiency by choosing the mysql flavour that plays better in your setup but raising the (low for today's standards) memory would be a safer bet for improving efficiency. –  ypercube Jul 12 '13 at 7:01
1  
Wih MyISAM you gain nothing using Percona because XtraDB is an InnoDB replacement. And @ypercube is correct. 1GB is pointless and I doubt you'll use 4 cores anyway –  gbn Jul 12 '13 at 7:33
    
@ypercube Database size is well within 1GB, it is comparatively smaller setup and memory is just sufficient at the moment. –  meharo Jul 12 '13 at 9:45
    
@gbn What about those extra performance optimizations in MariaDB 5.5 and 10? Won't that help much with smaller data size and less no. of CPU cores? –  meharo Jul 12 '13 at 9:48

1 Answer 1

I recently ran into this benchmark results:

https://blog.mariadb.org/benchmarking-mariadb-5-3-4/

The conclusion here was that MySQL-5.5 is the mos performing among others.

The tested editions here are :

  • MariaDB-5.3.4 – the Monty Program release candidate, both with XtraDB and the InnoDB plugin

  • Percona-Server 5.1.61 because it is based on the same XtraDB
    version as MariaDB-5.3

  • Percona-Server 5.5.20 – the current Percona flagship

  • MySQL-5.5.20 – the current Oracle flagship

Hope i helped

share|improve this answer
1  
Well, that benchmark was done on a real server (with unknown amount of memory) - so it may or rather may not correspond the OP's setup. –  dezso Jul 12 '13 at 8:50
    
The current Oracle flagship is 5.6 I think. And MariaDB has release (as GA, not RC) both 5.3 and 5.5 versions. –  ypercube Jul 12 '13 at 9:34
    
Helpful information @Audley-Christians. Appreciate if you can share information on latest releases because I also heard MySQL 5.6 is a better performer compared to 5.5 or older. –  meharo Jul 12 '13 at 9:53

Not the answer you're looking for? Browse other questions tagged or ask your own question.