Percona Server 5.7.21-20: 提升MySQL性能与稳定性

MYSQL

需积分: 9 139 浏览量更新于2024-07-19 收藏 1.25MB PDF 举报

身份认证购VIP最低享 7 折!

30元优惠券

"PERCONA Server是针对MySQL的一个增强版本，提供了更高的性能、可扩展性、灵活性和可靠性。此文档详细介绍了PERCONA Server 5.7.21-20版本的安装、性能提升、管理优化等多个方面，适用于希望优化数据库性能的企业或个人。" 在MySQL的世界中，PERCONA Server是一个备受推崇的开源解决方案，它为标准MySQL提供了一系列增强功能，以提高性能、可扩展性和管理效率。以下是对PERCONA Server关键知识点的详细说明： 1. **安装** (Installation): 文档的第二部分介绍了如何安装PERCONA Server，这通常包括下载、配置和启动数据库服务器的步骤，以及与标准MySQL相比可能需要额外考虑的特定设置。 2. **可扩展性改进** (Scalability Improvements): PERCONA Server在处理大数据量和高并发时表现出色，它允许用户在强大硬件上整合多个服务，从而延迟或避免分片，降低了硬件成本。 3. **性能提升** (Performance Improvements): 通过自我调优算法，PERCONA Server能够更有效地执行查询，使查询运行更快且更稳定。这包括对内存管理和查询优化器的优化，以及对高性能硬件的支持。 4. **灵活性改进** (Flexibility Improvements): 提供了更多定制选项和插件支持，使得数据库可以根据特定业务需求进行调整，例如对存储引擎的支持，如TokuDB和Percona MyRocks。 5. **可靠性改进** (Reliability Improvements): 通过增强的日志系统、备份和恢复工具，PERCONA Server提高了数据的安全性和可用性，确保更高的服务稳定性。 6. **管理改进** (Management Improvements): 提供了更强大的监控和管理工具，使得数据库的维护和调优工作变得更加简单，减少了管理员的工作负担。 7. **诊断改进** (Diagnostics Improvements): 改进了错误检测和故障排查能力，帮助用户无需猜测就能迅速定位问题并解决。 8. **TokuDB存储引擎** (TokuDB): 这是一种高性能、压缩的事务型存储引擎，适合需要大量插入和更新操作的场景，提供出色的行级锁定和崩溃恢复能力。 9. **Percona MyRocks** (Percona MyRocks): 是一个针对读密集型应用优化的存储引擎，结合了InnoDB的事务处理能力和RocksDB的高效磁盘存储，提供卓越的写入性能和低磁盘空间占用。 PERCONA Server的这些特性使其成为企业和开发者在MySQL基础上进行高性能数据库解决方案的首选，尤其是在处理大数据和高并发场景下，它的优势更为明显。通过使用PERCONA Server，用户可以节省时间、降低成本，同时提高系统的可靠性和整体性能。

资源详情

资源推荐

Percona Server Documentation, Release 5.7.21-20

Feature Ported Version

Improved Buffer Pool Scalability 5.7.10-1

Improved InnoDB I/O Scalability 5.7.10-1

Query Cache Enhancements 5.7.10-1

Improved NUMA support 5.7.10-1

Thread Pool 5.7.10-1

XtraDB Performance Improvements for I/O-Bound Highly-Concurrent Workloads 5.7.10-1

Suppress Warning Messages 5.7.10-1

Improved MEMORY Storage Engine 5.7.10-1

Restricting the number of binlog ﬁles 5.7.10-1

Extended SELECT INTO OUTFILE/DUMPFILE 5.7.10-1

Per-query variable statement 5.7.10-1

Extended mysqlbinlog 5.7.10-1

Slow Query Log Rotation and Expiration 5.7.10-1

CSV engine mode for standard-compliant quote and comma parsing 5.7.10-1

Support for PROXY protocol 5.7.10-1

Per-session server-id 5.7.10-1

Too Many Connections Warning 5.7.10-1

Handle Corrupted Tables 5.7.10-1

Percona Toolkit UDFs 5.7.10-1

Kill Idle Transactions 5.7.10-1

Enforcing Storage Engine 5.7.10-1

Utility user 5.7.10-1

Expanded Program Option Modiﬁers 5.7.10-1

XtraDB changed page tracking 5.7.10-1

PAM Authentication Plugin 5.7.10-1

Expanded Fast Index Creation 5.7.10-1

Backup Locks 5.7.10-1

Audit Log Plugin 5.7.10-1

Start transaction with consistent snapshot 5.7.10-1

Extended SHOW GRANTS 5.7.10-1

User Statistics 5.7.10-1

Slow Query Log 5.7.10-1

Extended Show Engine InnoDB Status 5.7.10-1

Show Storage Engines 5.7.10-1

Process List 5.7.10-1

Misc. INFORMATION_SCHEMA Tables 5.7.10-1

Thread Based Proﬁling 5.7.10-1

Metrics for scalability measurement 5.7.10-1

Response Time Distribution 5.7.10-1

4.6. Features ported from Percona Server 5.6 to Percona Server 5.7 14

Percona Server Documentation, Release 5.7.21-20

Percona apt Testing repository

Percona offers pre-release builds from the testing repository. To enable it add the just uncomment the testing repos-

itory lines in the Percona repository deﬁnition in your repository ﬁle (default /etc/apt/sources.list.d/

percona-release.list). It should looks like this (in this example VERSION is the name of your distribution):

# Testing & pre-release packages

deb http://repo.percona.com/apt VERSION testing

deb-src http://repo.percona.com/apt VERSION testing

Apt-Pinning the packages

In some cases you might need to “pin” the selected packages to avoid the upgrades from the distribution repositories.

You’ll need to make a new ﬁle /etc/apt/preferences.d/00percona.pref and add the following lines in

it:

Package:

Pin: release o=Percona Development Team

Pin-Priority: 1001

For more information about the pinning you can check the ofﬁcial debian wiki.

Installing Percona Server using downloaded deb packages

Download the packages of the desired series for your architecture from the download page. The easiest way is to

download bundle which contains all the packages. Following example will download Percona Server 5.7.10-3

release packages for Debian 8.0:

$ wget https://www.percona.com/downloads/Percona-Server-5.7/Percona-Server-5.

˓→7.10-3/binary/debian/jessie/x86_64/Percona-Server-5.7.10-3-r63dafaf-jessie-

˓→x86_64-bundle.tar

You should then unpack the bundle to get the packages:

$ tar xvf Percona-Server-5.7.10-3-r63dafaf-jessie-x86_64-bundle.tar

After you unpack the bundle you should see the following packages:

$ ls

.deb

libperconaserverclient20-dev_5.7.10-3-1.jessie_amd64.deb

libperconaserverclient20_5.7.10-3-1.jessie_amd64.deb

percona-server-5.7-dbg_5.7.10-3-1.jessie_amd64.deb

percona-server-client-5.7_5.7.10-3-1.jessie_amd64.deb

percona-server-common-5.7_5.7.10-3-1.jessie_amd64.deb

percona-server-server-5.7_5.7.10-3-1.jessie_amd64.deb

percona-server-source-5.7_5.7.10-3-1.jessie_amd64.deb

percona-server-test-5.7_5.7.10-3-1.jessie_amd64.deb

percona-server-tokudb-5.7_5.7.10-3-1.jessie_amd64.deb

Now you can install Percona Server by running:

$ sudo dpkg -i

.deb

5.1. Installing Percona Server from Repositories 18

剩余415页未读，继续阅读

Austindatabases

粉丝: 2389
资源: 8

Percona Server 5.7.21-20: 提升MySQL性能与稳定性

PerconaServerforMySql-5.7.29-32.pdf

percona server

mysql percona server 官方手册

percona mysql用的多吗

Ubuntu下载 mysql percona 5.7.44-48

试图安装 mysql-community-client-8.0.31-1.el7.x86_64 和 percona-server-client

Percona Server

rocky安装percona

mysql8.0.34安装percona

percona xtrabackup mysqlbackup

Percona 是什么

percona mysql 5.7重置root密码

yum install https://repo.percona.com/yum/percona-release-latest.noarch.rpm

yum安装percona

Ubuntu 20.04.6 LTS 安装percona-xtrabackup

mysql好用的版本

mysqll arm64下载

docker Percona

centos7如何下载percona2.4版本

percona mysql 5.7 在windows环境下怎么debug？

最新资源