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.

What is Percona?

How does it differ from MySQL?

When should we consider switching (or upgrading) from stock MySQL to Percona?

To add some specifics in our situation we almost exclusively use InnoDB (which I understand Percona has done a lot of optimizing for) with extensive foreign key constraints and a few stored procedures.

What we are finding at present is that MySQL is poorly optimizing our queries and so any query that goes above 3-4 joins we have to build explicitly with STRAIGHT joins to improve performance.

share|improve this question
    
Just a clarification - Percona is a MySQL consulting/development company. Percona Server is one of many products made by the company Percona. –  Aaron Brown Mar 27 '12 at 20:09

2 Answers 2

up vote 9 down vote accepted

Percona Server is a fork of MySQL that came into being about 7 years ago. The Percona employees are mostly former MySQL people. They care about InnoDB performance so much that they inject 30,000 lines of code into its version of MySQL to make those enhancements possible. They have been doing this since MySQL 5.0 and are still at it today.

MySQL (eh Oracle [still hate saying it]) has been trying to keep up with it Percona via its InnoDB plugin (since MySQL 5.1.38, now fully native in MySQL 5.5)

Percona once did an aggressive comparison of MySQL versions. In most cases LEFT UNCONFIGURED, older versions of MySQL outperform newer versions. You must tune MySQL to get the most of it. Switching to Percona may not get enhancements you are looking for. Even with Percona, you must find out what performance enhancements come out-of-the-box and what is settings you need to configure otherwise.

Other posts I hope you find helpful

share|improve this answer
1  
Perhaps you can add MariaDB as another option. The recent 5.3 release has a lot of performance improvements (of the optimizer). –  ypercube Mar 27 '12 at 1:00
    
@ypercube I guess someone should sponsor a bake-off every business quarter to see how MySQL, Percona Server, and MariaDB stack up against each other and against prior releases (dba.stackexchange.com/a/3376/877.) –  RolandoMySQLDBA Mar 27 '12 at 1:17

As well as RolandoMySQLDBA's answer, my observation is that Percona offers features that

  • come only with "paid for" stock mySQL
  • make it more that a "grown up" RDBMS

Examples:

Assuming like for like performance, the extra kit from Percona makes MySQL far more viable

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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