Percona-Toolkit 之 pt-online-schema-change 总结
正文 pt online schema change ALTER tables without locking them. pt online schema change alters a table’s structure without blocking reads or writes. Spe ...
程序员文章站2023-11-16mysql主从同步-percona-toolkit工具的使用整理
在mysql工作中接触最多的就是mysql replication,mysql在复制方面还是会有一些常规问题,比如主库宕机或者从库宕机有可能会导致复制中断,通常需要进行人为修复,或者很多时候需要把一
程序员文章站2023-11-11Percona监控MySQL数据库,配置zabbix-agent和配置MySQL连接教程
配置zabbix-agent 安装percona插件 yum -y install https://www.percona.com/downloads/percona-re
程序员文章站2023-09-05Ubuntu下Zabbix结合percona监控mysql数据
按道理来说zabbix就自带的MySQL插件来监控mysql数据库,但是你会发现,自带的mysql监控项是很少的,根本满足不了公司的需求。由于它本身自带的模板太过简单了,所以需要做更详细的监控,而percona就提供了这个详细监控的模版以及脚本,解决了监控不全面的问题。percona插件是安装在za ...
程序员文章站2023-04-06Percona-Tookit工具包之pt-summary
占座 ...
程序员文章站2023-03-27Percona-Tookit工具包之pt-index-usage
占座 ...
程序员文章站2023-03-26Percona XtraBackup 备份还原篇
Percona XtraBackup 安装介绍篇已经对Percona XtraBackup的功能和安装做了比较详细的介绍,那么本篇我们直接进入主题,如何使用XtraBackup做备份、还原,下面主要介绍XtraBackup备份还原操作的细节和场景,疏漏之处难免存在,如有不足,敬请指出。本篇暂时不做原... ...
程序员文章站2022-12-25Percona-Tookit工具包之pt-kill
占座 ...
程序员文章站2022-12-25zabbix通过percona插件监控mysql的方法
1.安装php脚本运行环境 yum install -y php php-mysql 2.加载官方percona模板 [root@cat /]#
程序员文章站2022-12-09Percona-Tookit工具包之pt-slave-find
占座 ...
程序员文章站2022-11-30Percona-Toolkit 之 pt-archiver 总结
pt archiver Archive rows from a MySQL table into another table or a file. pt archiver nibbles records from a MySQL table. The and arguments use DSN sy ...
程序员文章站2022-11-27Percona-Toolkit 之 pt-table-sync 总结
pt table sync Synchronize MySQL table data efficiently. pt table sync synchronizes data efficiently between MySQL tables. pt table sync 是Percona Toolk ...
程序员文章站2022-11-26Percona-Tookit工具包之pt-query-digest
占座 ...
程序员文章站2022-10-27MySQL/MariaDB/Percona数据库升级脚本
mysql/mariadb/percona数据库升级脚本 mysql/mariadb/percona数据库升级脚本截取《oneinstack》中upgrade_db.sh
程序员文章站2022-10-08网络运营Percona-Tookit工具包之pt-heartbeat
占座 ...
程序员文章站2022-10-04Percona XtraBackup 8.0, 安装与测试
Percona XtraBackup 8.0 是Percona XtraBackup新推出了一个针对MySQL8.0的版本,主要是MySQL8.0在Redo 和 数据库字典方面有了新的改进。 XtraBackup 2.4 继续支持MySQL 5.6 和 5.7。 (1)移除了innobackupex ...
程序员文章站2022-09-14IT编程Percona-Tookit工具包之pt-show-grants
Preface User privileges regulation is pretty important in DBAs routine job.As we all know,it's the less the better to reduce risks when someone who ha ...
程序员文章站2022-08-13Percona-Tookit工具包之pt-pmp
Preface Sometimes we need to know the details of a program(porcess) when it is running even it's on the edge of crach.There's a lot of tools can be us ...
程序员文章站2022-08-13Percona-Tookit工具包之pt-find
Preface We used to use "find" command in linux or AIX when we need to get a certain file but cannot rember the precise name.We will execute "find /pat ...
程序员文章站2022-08-09Percona-Tookit工具包之pt-mysql-summary
Preface Sometimes we need to collect information of MySQL server as a report when we first time take over the system by someone else.Espcially there'r ...
程序员文章站2022-08-09