mysql
8 posts in total
About orzdba
OrzDBA Perl脚本，用于对Linux主机和MySQL相关指标进行实时监控。 Usage 1234567# system loadorzdba -sysorzdba -lazy -rt -S /var/lib/mysql/mysql.sock# mysql serverorzdba -mysql -S /var/lib/mysql/mysql.sock# innodborzdba -inno...
About InnoTop
InnoTop A realtime terminal-based top-like monitor for MySQL. Compile 12345678910111213141516171819# BuildRequiresyum install -y makeyum install -y perl-ExtUtils-MakeMakeryum install -y perl-Test-Simp...
pt-archiver不会迁移max(id)那条数据的问题
To be is to be perceived. 现象描述 pt-archiver迁移数据时，发现原表中总会留有一条数据，即max(id)那条数据，修正方案如下。 pt-archiver源码 1234567891011if ( $o->get('safe-auto-increment') && $sel_stmt->{i...
关于 Percona Toolkit
About Percona Toolkit “Percona Toolkit allows our large, transaction-based customers to make regular schema changes as their business evolves without interrupting their 24X7 operations.” – Hany Fahim...
关于 MySQL 的锁和 InnoDB Locking
About lock in MySQL and InnoDB locking I reside in the present. 实验环境 MySQL 5.7.21 on docker[1] 主要内容 MySQL Lock InnoDB Lock Deadlock MySQL中四种类型的锁 Table, 表锁 Row, 行锁 Page, 页锁 Matedata, 元数据锁 其中，p...
CentOS 7 下安装 MySQL 5.7 的三种方案
MySQL是时下最流行的开源关系型数据库之一，下面来简要介绍三种安装MySQL Database的方案。 方案一：连接Yum仓库安装MySQL 方案二：安装MySQL的Linux二进制包 方案三：编译MySQL源码进行安装 实验环境 CentOS 7.4 Linux 3.10.0-693.17.1.el7.x86_64 MySQL Community Server 5.7.21 方案一：连...