最新版的Percona Server有哪些優(yōu)點(diǎn)

這篇文章主要講解了“最新版的Percona Server有哪些優(yōu)點(diǎn)”，文中的講解內(nèi)容簡單清晰，易于學(xué)習(xí)與理解，下面請大家跟著小編的思路慢慢深入，一起來研究和學(xué)習(xí)“最新版的Percona Server有哪些優(yōu)點(diǎn)”吧！

Percona Server 5.5.44-37.3 發(fā)布，此版本基于 MySQL 5.5.44，包括其所有 bug 修復(fù)，是當(dāng)前 5.5 系列最新的穩(wěn)定版本。此版本現(xiàn)已提供下載，也提供在 Percona Software Repositories。

Bugs 修復(fù)

Symlinks to libmysqlclient libraries were missing on CentOS 6. Bug fixed #1408500.

RHEL/CentOS 6.6 OpenSSL package (1.0.1e-30.el6_6.9), containing a fix for CVE-2015-4000, changed the DH key sizes to a minimum of 768 bits. This caused an issue for MySQL as it uses 512 bit keys. Fixed by backporting an upstream 5.7 fix that increases the key size to 2048 bits. Bug fixed #1462856 (upstream #77275).

innochecksum would fail to check tablespaces in compressed format. The fix for this bug has been ported from Facebook MySQL 5.1 patch. Bug fixed #1100652 (upstream #66779).

Issuing SHOW BINLOG EVENTS with an invalid starting binlog position would cause a potentially misleading message in the server error log. Bug fixed #1409652 (upstream #75480).

While using max_slowlog_size, the slow query log was rotated every time slow query log was enabled, not really checking if the current slow log is indeed bigger than max_slowlog_size or not. Bug fixed #1416582.

If query_response_time_range_base variable was set as a command line option or in a configuration file, its value would not take effect until the first flush was made. Bug fixed #1453277 (Preston Bennes).

Prepared XA transactions with update undo logs were not properly recovered. Bug fixed #1468301.

Variable log_slow_sp_statements now supports skipping the logging of stored procedures into the slow log entirely with new OFF_NO_CALLS option. Bug fixed #1432846.

其他 bug 修復(fù)： #1380895 (upstream #72322)。更多改進(jìn)內(nèi)容請看發(fā)行說明。

Percona Server 5.6.25-73.0 發(fā)布，此版本現(xiàn)已提供在 Percona web site 和 Software Repositories。

此版本基于 MySQL 5.6.25，包括其所有 bug 修復(fù)，是當(dāng)前 5.6 系列最新的 GA 版本。

新特性

Percona Server 實(shí)現(xiàn)了對 PROXY 協(xié)議的支持。

Bugs 修復(fù)

Symlinks to libmysqlclient libraries were missing on CentOS 6. Bug fixed #1408500.

RHEL/CentOS 6.6 OpenSSL package (1.0.1e-30.el6_6.9), containing a fix for CVE-2015-4000, changed the DH key sizes to a minimum of 768 bits. This caused an issue for MySQL as it uses 512 bit keys. Fixed by backporting an upstream 5.7 fix that increases the key size to 2048 bits. Bug fixed #1462856 (upstream #77275).

Some compressed InnoDB data pages could be mistakenly considered corrupted, crashing the server. Bug fixed #1467760 (upstream #73689) Justin Tolmer.

innochecksum would fail to check tablespaces in compressed format. The fix for this bug has been ported from Facebook MySQL 5.6 patch. Bug fixed #1100652 (upstream #66779).

Using concurrent REPLACE, LOAD DATA REPLACE or INSERT ON DUPLICATE KEY UPDATE statements in the READ COMMITTED isolation level or with the innodb_locks_unsafe_for_binlog option enabled could lead to a unique-key constraint violation. Bug fixed #1308016 (upstream #76927).

Issuing SHOW BINLOG EVENTS with an invalid starting binlog position would cause a potentially misleading message in the server error log. Bug fixed #1409652 (upstream #75480).

While using max_slowlog_size, the slow query log was rotated every time slow query log was enabled, not really checking if the current slow log is indeed bigger than max_slowlog_size or not. Bug fixed #1416582.

Fixed possible server assertions when Backup Locks are used. Bug fixed #1432494.

If query_response_time_range_base variable was set as a command line option or in a configuration file, its value would not take effect until the first flush was made. Bug fixed #1453277 (Preston Bennes).

mysqld_safe script is now searching for libjemalloc.so.1 library, needed by TokuDB, in the basedir directory as well. Bug fixed #1462338.

Prepared XA transactions could cause a debug assertion failure during the shutdown. Bug fixed #1468326.

Variable log_slow_sp_statements now supports skipping the logging of stored procedures into the slow log entirely with new OFF_NO_CALLS option. Bug fixed #1432846.

TokuDB HotBackup library is now automatically loaded with mysqld_safe script. Bug fixed #1467443.

其他 bug 修復(fù) #1457113, #1380895, and #1413836。更多改進(jìn)內(nèi)容請看發(fā)行說明。

Percona 為 MySQL 數(shù)據(jù)庫服務(wù)器進(jìn)行了改進(jìn)，在功能和性能上較 MySQL 有著很顯著的提升。該版本提升了在高負(fù)載情況下的 InnoDB 的性能、為 DBA 提供一些非常有用的性能診斷工具；另外有更多的參數(shù)和命令來控制服務(wù)器行為。

Percona Server 只包含 MySQL 的服務(wù)器版，并沒有提供相應(yīng)對 MySQL 的 Connector 和 GUI 工具進(jìn)行改進(jìn)。

Percona Server 使用了一些 google-mysql-tools, Proven Scaling, Open Query 對 MySQL 進(jìn)行改造。

感謝各位的閱讀，以上就是“最新版的Percona Server有哪些優(yōu)點(diǎn)”的內(nèi)容了，經(jīng)過本文的學(xué)習(xí)后，相信大家對最新版的Percona Server有哪些優(yōu)點(diǎn)這一問題有了更深刻的體會(huì)，具體使用情況還需要大家實(shí)踐驗(yàn)證。這里是億速云，小編將為大家推送更多相關(guān)知識(shí)點(diǎn)的文章，歡迎關(guān)注！