Mysql qps 数据统计和分析 1.工作准备 1.1 mysql相关 配置准备 #打开查询日志Set global general_lo
1,数字辅助表//创建表create table test(id int unsigned not null primary key);delimiter //create procedure pnum(cnt int unsigned)begindeclare i int unsigned default 1;insert into num select i;wh
http://www.percona.com/redir/downloads/percona-toolkit/ 可下载pt软件包它需要依赖包,所以提前安装一下依赖包yum install perl perl-DBI perl-DBD-MySQL perl-IO-Socket-SSL perl-Time-HiRes -y解压tar -zxvf percona-toolkit-2.1.3.t
Copyright © 2005-2024 51CTO.COM 版权所有 京ICP证060544号