blocks|key|1602165|text|Percona是大约7年前诞生的MySQL的一个分支。Percona的员工大多是前MySQL员工。他们非常关心InnoDB的性能，以至于将3万行代码注入到MySQL的版本中，以使这些增强成为可能。从MySQL+5.0开始，他们就一直在这样做，现在仍然如此。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1602166|MySQL+(eh+还是讨厌说出来)一直试图通过其InnoDB插件(自MySQL+5.1.38，现在完全原生于MySQL+5.5)来跟上Percona。|1602167|Percona曾经对MySQL版本做过积极的比较。在大多数情况下，在离开UNCONFIGURED的情况下，旧版本的MySQL优于更新的版本。您必须对MySQL进行调优以充分利用它。切换到Percona可能无法获得您正在寻找的增强功能。即使使用Percona，您也必须了解哪些性能增强是现成的，哪些设置是您需要配置的。|offset|length|1602168|其他我希望你觉得有帮助的帖子|1602169|是否有可能使MySQL使用多个核心？|unordered-list-item|1602170|如何正确地执行MySQL烘焙？|1602171|多核与MySQL性能|1602172|关于单线程和多线程数据库的性能|entityMap|0|LINK|mutability|MUTABLE|url|http://www.mysqlperformanceblog.com/2011/10/10/mysql-versions-shootout/|1|https://dba.stackexchange.com/questions/5666/possible-to-make-mysql-use-more-then-one-core/5670#5670|2|https://dba.stackexchange.com/questions/3375/how-do-i-properly-perform-a-mysql-bake-off/3376#3376|3|https://dba.stackexchange.com/questions/5926/multi-cores-and-mysql-performance/5968#5968|4|https://dba.stackexchange.com/questions/2918/about-single-threaded-versus-multithreaded-databases-performance/2948#2948^0|0|0|0|1X|0|0|0|0|I|1|0|0|F|2|0|0|A|3|0|0|F|4^^$0|@$1|2|3|4|5|6|7|17|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|18|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|19|8|@]|9|@$F|1A|G|1B|1|1C]]|A|$]]|$1|H|3|I|5|6|7|1D|8|@]|9|@]|A|$]]|$1|J|3|K|5|L|7|1E|8|@]|9|@$F|1F|G|1G|1|1H]]|A|$]]|$1|M|3|N|5|L|7|1I|8|@]|9|@$F|1J|G|1K|1|1L]]|A|$]]|$1|O|3|P|5|L|7|1M|8|@]|9|@$F|1N|G|1O|1|1P]]|A|$]]|$1|Q|3|R|5|L|7|1Q|8|@]|9|@$F|1R|G|1S|1|1T]]|A|$]]]|S|$T|$5|U|V|W|A|$X|Y]]|Z|$5|U|V|W|A|$X|10]]|11|$5|U|V|W|A|$X|12]]|13|$5|U|V|W|A|$X|14]]|15|$5|U|V|W|A|$X|16]]]]

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)

<a href="http://www.mysqlperformanceblog.com/2011/10/10/mysql-versions-shootout/" rel="noreferrer">Percona once did an aggressive comparison of MySQL versions. In most cases LEFT UNCONFIGURED, older versions of MySQL outperform newer versions</a>. 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

<ul>
<li><a href="https://dba.stackexchange.com/questions/5666/possible-to-make-mysql-use-more-then-one-core/5670#5670">Possible to make MySQL use more than one core?</a></li>
<li><a href="https://dba.stackexchange.com/questions/3375/how-do-i-properly-perform-a-mysql-bake-off/3376#3376">How do I properly perform a MySQL bake-off?</a></li>
<li><a href="https://dba.stackexchange.com/questions/5926/multi-cores-and-mysql-performance/5968#5968">Multi cores and MySQL Performance</a></li>
<li><a href="https://dba.stackexchange.com/questions/2918/about-single-threaded-versus-multithreaded-databases-performance/2948#2948">About single threaded versus multithreaded databases performance</a></li>
</ul>

blocks|key|2742337|text|和RolandoMySQLDBA的回答一样，我的观察是Percona提供了以下特性|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|2742338|只带“付费”股票mySQL|unordered-list-item|2742339|使它更像一个“成熟的”RDBMS|2742340|示例：|2742341|Percona+XtraDB集群的作用更像定理下的适当HA解|2742342|在线备份|2742343|更多的旋钮、杠杆和监控|2742344|假设类似于类似的性能，来自Percona的额外工具包使MySQL更加可行。|entityMap|0|LINK|mutability|MUTABLE|url|https://dba.stackexchange.com/a/15601/52550|1|http://www.percona.com/doc/percona-xtradb-cluster/intro.html|2|http://www.percona.com/software/percona-xtradb/|3|http://www.percona.com/software/percona-server/feature-comparison/^0|1|I|0|0|0|0|0|L|9|1|0|0|4|2|0|0|B|3|0^^$0|@$1|2|3|4|5|6|7|15|8|@]|9|@$A|16|B|17|1|18]]|C|$]]|$1|D|3|E|5|F|7|19|8|@]|9|@]|C|$]]|$1|G|3|H|5|F|7|1A|8|@]|9|@]|C|$]]|$1|I|3|J|5|6|7|1B|8|@]|9|@]|C|$]]|$1|K|3|L|5|F|7|1C|8|@]|9|@$A|1D|B|1E|1|1F]]|C|$]]|$1|M|3|N|5|F|7|1G|8|@]|9|@$A|1H|B|1I|1|1J]]|C|$]]|$1|O|3|P|5|F|7|1K|8|@]|9|@$A|1L|B|1M|1|1N]]|C|$]]|$1|Q|3|R|5|6|7|1O|8|@]|9|@]|C|$]]]|S|$T|$5|U|V|W|C|$X|Y]]|Z|$5|U|V|W|C|$X|10]]|11|$5|U|V|W|C|$X|12]]|13|$5|U|V|W|C|$X|14]]]]

As well as <a href="https://dba.stackexchange.com/a/15601/52550">RolandoMySQLDBA's answer</a>, my observation is that Percona offers features that

<ul>
<li>come only with "paid for" stock mySQL</li>
<li>make it more that a "grown up" RDBMS </li>
</ul>

Examples:

<ul>
<li>Percona XtraDB Cluster acts more like a <a href="http://www.percona.com/doc/percona-xtradb-cluster/intro.html" rel="nofollow noreferrer">proper HA solution as per the CAP theorem</a></li>
<li><a href="http://www.percona.com/software/percona-xtradb/" rel="nofollow noreferrer">Online backups</a></li>
<li><a href="http://www.percona.com/software/percona-server/feature-comparison/" rel="nofollow noreferrer">More knobs and levers and monitoring</a></li>
</ul>

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

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.

Percona vs MySQL

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

教程

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云智能顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云AI代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

功能1上新10个字符

功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符。

功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符。

功能5描述100个字符功能5描述100个字符功能5描述100个字符功能5描述100个字符功能5描述100个字符功能5描述100个字符

功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符

功能4上新

文章&问答评论现已支持表情

全新交互，全新视觉，新增快捷键、悬浮工具栏、高亮块等功能并同时优化现有功能，全面提升创作效率和体验

社区富文本编辑器全新改版！诚邀体验～ 

精选全网热门MCP server，让你的AI更好用 🚀

💥开发者 MCP广场重磅上线！

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

聚焦“写作效率、视觉美观与运行性能”三方面进行全面升级，为您提供更高效、稳定的创作环境

社区富文本&Markdown编辑器全新改版上线，欢迎大家体验!

诚挚邀请您参与本次调研，分享您的真实使用感受与建议。您的反馈至关重要，感谢您的支持与参与！

社区新版编辑器体验调研

什么是Percona？它与MySQL有什么不同？我们什么时候应该考虑从库存MySQL转换(或升级)到Percona？为了在我们的情况下添加一些细节，我们几乎完全使用了InnoDB (我知道Percona已经为它做了很多优化)，具有广泛的外键约束和一些存储过程。我们目前发现，MySQL对我们的查询进行了很差的优化，因此，任何高于3-4连接的查询，我们都必须使用直接联接显式构建，以提高性能。

问Percona对MySQL
EN

回答 2

Database Administration用户

Database Administration用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问Percona对MySQLEN

回答 2

Database Administration用户

Database Administration用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问Percona对MySQL
EN