- 浏览: 395084 次
- 性别:
- 来自: 福州
文章分类
最新评论
-
生于菇乡:
GRANT CREATE ROUTINE,ALTER ROUT ...
mysql 存储过程权限相关 -
cocos:
[MYSQL] ERROR: cannot allocate ...
一次数据库升级过程 mysql5.0.78 到 5.1.57 -
cocos:
MySQL ERROR] Plugin 'InnoDB' in ...
一次数据库升级过程 mysql5.0.78 到 5.1.57 -
rjgcs123:
云集国内redis大佬的群正在招募各路redis朋友,不管你是 ...
redis 安装 配置解析 -
cocos:
mkfsmkfs -t 文件系统类型 /dev/设备名如要把/ ...
mount
C:\Program Files\MySQL\MySQL Server 5.1\scripts>mysqlslap --defaults-file="C:/Pr
ogram Files/MySQL/MySQL Server 5.1/my.ini" --concurrency=50 --iterations=1 --num
ber-int-cols=4 --auto-generate-sql --auto-generate-sql-load-type=update --engine
=myisam --number-of-queries=10000 -uroot -p8319999
update
Benchmark
Running for engine myisam
Average number of seconds to run all queries: 16.187 seconds
Minimum number of seconds to run all queries: 16.187 seconds
Maximum number of seconds to run all queries: 16.187 seconds
Number of clients running queries: 50
Average number of queries per client: 200
read
Benchmark
Running for engine myisam
Average number of seconds to run all queries: 5.703 seconds
Minimum number of seconds to run all queries: 5.703 seconds
Maximum number of seconds to run all queries: 5.703 seconds
Number of clients running queries: 50
Average number of queries per client: 200
write
Benchmark
Running for engine myisam
Average number of seconds to run all queries: 1.765 seconds
Minimum number of seconds to run all queries: 1.765 seconds
Maximum number of seconds to run all queries: 1.765 seconds
Number of clients running queries: 50
Average number of queries per client: 200
Benchmark
Running for engine myisam
Average number of seconds to run all queries: 7.968 seconds
Minimum number of seconds to run all queries: 7.968 seconds
Maximum number of seconds to run all queries: 7.968 seconds
Number of clients running queries: 50
Average number of queries per client: 1000
mixed:
Benchmark
Running for engine myisam
Average number of seconds to run all queries: 52.281 seconds
Minimum number of seconds to run all queries: 52.281 seconds
Maximum number of seconds to run all queries: 52.281 seconds
Number of clients running queries: 50
Average number of queries per client: 200
Benchmark
Running for engine myisam
Average number of seconds to run all queries: 51.985 seconds
Minimum number of seconds to run all queries: 51.985 seconds
Maximum number of seconds to run all queries: 51.985 seconds
Number of clients running queries: 50
Average number of queries per client: 200
C:\Program Files\MySQL\MySQL Server 5.1\scripts>mysqlslap --defaults-file="C:/Pr
ogram Files/MySQL/MySQL Server 5.1/my.ini" --concurrency=50 --iterations=1 --cre
ate-schema=edu_591up --query="select userid from ol_user where username='zbwangc
hao@163.com'" --number-of-queries=10000 -uroot -p8319999
Benchmark
Average number of seconds to run all queries: 3.813 seconds
Minimum number of seconds to run all queries: 3.813 seconds
Maximum number of seconds to run all queries: 3.813 seconds
Number of clients running queries: 50
Average number of queries per client: 200
C:\Program Files\MySQL\MySQL Server 5.1\scripts>mysqlslap --defaults-file="C:/Pr
ogram Files/MySQL/MySQL Server 5.1/my.ini" --concurrency=50 --iterations=10 --cr
eate-schema=edu_591up --query="select userid,username from ol_user where userid=
25091" --number-of-queries=10000 -uroot -p8319999
Benchmark
Average number of seconds to run all queries: 1.746 seconds
Minimum number of seconds to run all queries: 0.781 seconds
Maximum number of seconds to run all queries: 1.954 seconds
Number of clients running queries: 50
Average number of queries per client: 200
C:\Program Files\MySQL\MySQL Server 5.1\scripts>mysqlslap --defaults-file="C:/Pr
ogram Files/MySQL/MySQL Server 5.1/my.ini" --concurrency=50 --iterations=10 --cr
eate-schema=edu_591up --query="update ol_user set username='zbwangchao@163.com'
where userid=25091" --number-of-queries=10000 -uroot -p8319999
Benchmark
Average number of seconds to run all queries: 2.229 seconds
Minimum number of seconds to run all queries: 1.969 seconds
Maximum number of seconds to run all queries: 3.172 seconds
Number of clients running queries: 50
Average number of queries per client: 200
C:\Program Files\MySQL\MySQL Server 5.1\scripts>mysqlslap --defaults-file="C:/Pr
ogram Files/MySQL/MySQL Server 5.1/my.ini" --concurrency=50 --iterations=10 --cr
eate-schema=edu_591up --query="insert into ol_user(username,password)values('ton
gchao','dddddddddddddddd')" --number-of-queries=10000 -uroot -p8319999
Benchmark
Average number of seconds to run all queries: 8.992 seconds
Minimum number of seconds to run all queries: 8.078 seconds
Maximum number of seconds to run all queries: 9.750 seconds
Number of clients running queries: 50
Average number of queries per client: 200
C:\Program Files\MySQL\MySQL Server 5.1\scripts>mysqlslap --defaults-file="C:/Program Files/MySQL/MySQL Server 5.1/my.ini" --concurrency=50 --iterations=1 --create-schema=edu_591up --query="insert into ol_user(username,password)values('tongchao','dddddddddddddddd')" --number-of-queries=10000 -uroot -p8319999
Benchmark
Average number of seconds to run all queries: 2.000 seconds
Minimum number of seconds to run all queries: 2.000 seconds
Maximum number of seconds to run all queries: 2.000 seconds
Number of clients running queries: 50
Average number of queries per client: 200
(无索引)
mysqlslap --defaults-file="C:/Program Files/MySQL/MySQL Server 5.1/my.ini" --concurrency=50 --iterations=1 --create-schema=edu_591up --query="insert into ol_user(username,password)values('tongchao','dddddddddddddddd')" --number-of-queries=10000 -uroot -p8319999
mysqlslap --defaults-file="C:/Program Files/MySQL/MySQL Server 5.1/my.ini" --concurrency=50 --iterations=1 --create-schema=edu_591up --query="update ol_user set password='tongchaotongchao' where userid = 13" --number-of-queries=10000 -uroot -p8319999
mysqlslap --defaults-file="C:/Program Files/MySQL/MySQL Server 5.1/my.ini" --concurrency=50 --iterations=1 --create-schema=edu_591up --query="select * from ol_user where userid = 13" --number-of-queries=10000 -uroot -p8319999
*******************************************************************************************************************************
mysqlslap --defaults-file="D:/MySQL/MySql5.5/my.ini" --concurrency=50 --iterations=1 --create-schema=edu_591up --query="insert into ol_user(username,password)values('tongchao','dddddddddddddddd')" --number-of-queries=10000 -uroot
mysqlslap --defaults-file="D:/MySQL/MySql5.5/my.ini" --concurrency=50 --iterations=1 --create-schema=edu_591up --query="update ol_user set password='tongchaotongchao' where userid = 13" --number-of-queries=100000 -uroot
mysqlslap --defaults-file="D:/MySQL/MySql5.5/my.ini" --concurrency=50 --iterations=1 --create-schema=edu_591up --query="select * from ol_user where userid = 13" --number-of-queries=10000 -uroot
二、自动测试
mysqlslap --defaults-file="C:/Program Files/MySQL/MySQL Server 5.1/my.ini" --concurrency=50 --iterations=1 --number-int-cols=4 --auto-generate-sql --auto-generate-sql-load-type=update --engine=myisam,innodb --number-of-queries=10000 -uroot -p8319999
mysqlslap --defaults-file="D:/MySQL/MySql5.5/my.ini" --concurrency=50 --iterations=1 --number-int-cols=4 --auto-generate-sql --auto-generate-sql-load-type=update --engine=myisam,innodb --number-of-queries=10000 -uroot
mysqlslap --defaults-file="C:/Program Files/MySQL/mysql-5.1.54-win32/my.ini" --concurrency=50 --iterations=1 --number-int-cols=4 --auto-generate-sql --auto-generate-sql-load-type=update --engine=myisam,innodb --number-of-queries=10000 -uroot
结果:
5.1
update:
Benchmark
Running for engine myisam
Average number of seconds to run all queries: 17.547 seconds
Minimum number of seconds to run all queries: 17.547 seconds
Maximum number of seconds to run all queries: 17.547 seconds
Number of clients running queries: 50
Average number of queries per client: 200
Benchmark
Running for engine innodb
Average number of seconds to run all queries: 47.860 seconds
Minimum number of seconds to run all queries: 47.860 seconds
Maximum number of seconds to run all queries: 47.860 seconds
Number of clients running queries: 50
Average number of queries per client: 200
write:
Benchmark
Running for engine myisam
Average number of seconds to run all queries: 1.587 seconds
Minimum number of seconds to run all queries: 0.766 seconds
Maximum number of seconds to run all queries: 1.890 seconds
Number of clients running queries: 50
Average number of queries per client: 200
Benchmark
Running for engine innodb
Average number of seconds to run all queries: 1.868 seconds
Minimum number of seconds to run all queries: 1.812 seconds
Maximum number of seconds to run all queries: 2.094 seconds
Number of clients running queries: 50
Average number of queries per client: 200
mixed:
Benchmark
Running for engine myisam
Average number of seconds to run all queries: 52.453 seconds
Minimum number of seconds to run all queries: 52.453 seconds
Maximum number of seconds to run all queries: 52.453 seconds
Number of clients running queries: 50
Average number of queries per client: 200
Benchmark
Running for engine innodb
Average number of seconds to run all queries: 66.531 seconds
Minimum number of seconds to run all queries: 66.531 seconds
Maximum number of seconds to run all queries: 66.531 seconds
Number of clients running queries: 50
Average number of queries per client: 200
5.5
update:
Benchmark
Running for engine myisam
Average number of seconds to run all queries: 14.360 seconds
Minimum number of seconds to run all queries: 14.360 seconds
Maximum number of seconds to run all queries: 14.360 seconds
Number of clients running queries: 50
Average number of queries per client: 200
Benchmark
Running for engine innodb
Average number of seconds to run all queries: 43.843 seconds
Minimum number of seconds to run all queries: 43.843 seconds
Maximum number of seconds to run all queries: 43.843 seconds
Number of clients running queries: 50
Average number of queries per client: 200
write:
Benchmark
Running for engine myisam
Average number of seconds to run all queries: 1.526 seconds
Minimum number of seconds to run all queries: 0.703 seconds
Maximum number of seconds to run all queries: 1.766 seconds
Number of clients running queries: 50
Average number of queries per client: 200
Benchmark
Running for engine innodb
Average number of seconds to run all queries: 1.573 seconds
Minimum number of seconds to run all queries: 0.766 seconds
Maximum number of seconds to run all queries: 1.828 seconds
Number of clients running queries: 50
Average number of queries per client: 200
mixed:
Benchmark
Running for engine myisam
Average number of seconds to run all queries: 39.468 seconds
Minimum number of seconds to run all queries: 39.468 seconds
Maximum number of seconds to run all queries: 39.468 seconds
Number of clients running queries: 50
Average number of queries per client: 200
Benchmark
Running for engine innodb
Average number of seconds to run all queries: 50.468 seconds
Minimum number of seconds to run all queries: 50.468 seconds
Maximum number of seconds to run all queries: 50.468 seconds
Number of clients running queries: 50
Average number of queries per client: 200
C:\Documents and Settings\Administrator>mysqlslap --defaults-file="D:/MySQL/MySq
l5.5/my.ini" --concurrency=100 --iterations=5 --number-int-cols=4 --auto-generat
e-sql --auto-generate-sql-load-type=update --engine=innodb --number-of-queries=1
000 -uroot
Benchmark
Running for engine innodb
Average number of seconds to run all queries: 3.371 seconds
Minimum number of seconds to run all queries: 2.547 seconds
Maximum number of seconds to run all queries: 4.515 seconds
Number of clients running queries: 100
Average number of queries per client: 10
C:\Documents and Settings\Administrator>mysqlslap --defaults-file="C:/Program
les/MySQL/mysql-5.1.54-win32/my.ini" --concurrency=100 --iterations=5 --number
nt-cols=4 --auto-generate-sql --auto-generate-sql-load-type=update --engine=in
db --number-of-queries=1000 -uroot
Benchmark
Running for engine innodb
Average number of seconds to run all queries: 3.831 seconds
Minimum number of seconds to run all queries: 3.797 seconds
Maximum number of seconds to run all queries: 3.860 seconds
Number of clients running queries: 100
Average number of queries per client: 10
ogram Files/MySQL/MySQL Server 5.1/my.ini" --concurrency=50 --iterations=1 --num
ber-int-cols=4 --auto-generate-sql --auto-generate-sql-load-type=update --engine
=myisam --number-of-queries=10000 -uroot -p8319999
update
Benchmark
Running for engine myisam
Average number of seconds to run all queries: 16.187 seconds
Minimum number of seconds to run all queries: 16.187 seconds
Maximum number of seconds to run all queries: 16.187 seconds
Number of clients running queries: 50
Average number of queries per client: 200
read
Benchmark
Running for engine myisam
Average number of seconds to run all queries: 5.703 seconds
Minimum number of seconds to run all queries: 5.703 seconds
Maximum number of seconds to run all queries: 5.703 seconds
Number of clients running queries: 50
Average number of queries per client: 200
write
Benchmark
Running for engine myisam
Average number of seconds to run all queries: 1.765 seconds
Minimum number of seconds to run all queries: 1.765 seconds
Maximum number of seconds to run all queries: 1.765 seconds
Number of clients running queries: 50
Average number of queries per client: 200
Benchmark
Running for engine myisam
Average number of seconds to run all queries: 7.968 seconds
Minimum number of seconds to run all queries: 7.968 seconds
Maximum number of seconds to run all queries: 7.968 seconds
Number of clients running queries: 50
Average number of queries per client: 1000
mixed:
Benchmark
Running for engine myisam
Average number of seconds to run all queries: 52.281 seconds
Minimum number of seconds to run all queries: 52.281 seconds
Maximum number of seconds to run all queries: 52.281 seconds
Number of clients running queries: 50
Average number of queries per client: 200
Benchmark
Running for engine myisam
Average number of seconds to run all queries: 51.985 seconds
Minimum number of seconds to run all queries: 51.985 seconds
Maximum number of seconds to run all queries: 51.985 seconds
Number of clients running queries: 50
Average number of queries per client: 200
C:\Program Files\MySQL\MySQL Server 5.1\scripts>mysqlslap --defaults-file="C:/Pr
ogram Files/MySQL/MySQL Server 5.1/my.ini" --concurrency=50 --iterations=1 --cre
ate-schema=edu_591up --query="select userid from ol_user where username='zbwangc
hao@163.com'" --number-of-queries=10000 -uroot -p8319999
Benchmark
Average number of seconds to run all queries: 3.813 seconds
Minimum number of seconds to run all queries: 3.813 seconds
Maximum number of seconds to run all queries: 3.813 seconds
Number of clients running queries: 50
Average number of queries per client: 200
C:\Program Files\MySQL\MySQL Server 5.1\scripts>mysqlslap --defaults-file="C:/Pr
ogram Files/MySQL/MySQL Server 5.1/my.ini" --concurrency=50 --iterations=10 --cr
eate-schema=edu_591up --query="select userid,username from ol_user where userid=
25091" --number-of-queries=10000 -uroot -p8319999
Benchmark
Average number of seconds to run all queries: 1.746 seconds
Minimum number of seconds to run all queries: 0.781 seconds
Maximum number of seconds to run all queries: 1.954 seconds
Number of clients running queries: 50
Average number of queries per client: 200
C:\Program Files\MySQL\MySQL Server 5.1\scripts>mysqlslap --defaults-file="C:/Pr
ogram Files/MySQL/MySQL Server 5.1/my.ini" --concurrency=50 --iterations=10 --cr
eate-schema=edu_591up --query="update ol_user set username='zbwangchao@163.com'
where userid=25091" --number-of-queries=10000 -uroot -p8319999
Benchmark
Average number of seconds to run all queries: 2.229 seconds
Minimum number of seconds to run all queries: 1.969 seconds
Maximum number of seconds to run all queries: 3.172 seconds
Number of clients running queries: 50
Average number of queries per client: 200
C:\Program Files\MySQL\MySQL Server 5.1\scripts>mysqlslap --defaults-file="C:/Pr
ogram Files/MySQL/MySQL Server 5.1/my.ini" --concurrency=50 --iterations=10 --cr
eate-schema=edu_591up --query="insert into ol_user(username,password)values('ton
gchao','dddddddddddddddd')" --number-of-queries=10000 -uroot -p8319999
Benchmark
Average number of seconds to run all queries: 8.992 seconds
Minimum number of seconds to run all queries: 8.078 seconds
Maximum number of seconds to run all queries: 9.750 seconds
Number of clients running queries: 50
Average number of queries per client: 200
C:\Program Files\MySQL\MySQL Server 5.1\scripts>mysqlslap --defaults-file="C:/Program Files/MySQL/MySQL Server 5.1/my.ini" --concurrency=50 --iterations=1 --create-schema=edu_591up --query="insert into ol_user(username,password)values('tongchao','dddddddddddddddd')" --number-of-queries=10000 -uroot -p8319999
Benchmark
Average number of seconds to run all queries: 2.000 seconds
Minimum number of seconds to run all queries: 2.000 seconds
Maximum number of seconds to run all queries: 2.000 seconds
Number of clients running queries: 50
Average number of queries per client: 200
(无索引)
mysqlslap --defaults-file="C:/Program Files/MySQL/MySQL Server 5.1/my.ini" --concurrency=50 --iterations=1 --create-schema=edu_591up --query="insert into ol_user(username,password)values('tongchao','dddddddddddddddd')" --number-of-queries=10000 -uroot -p8319999
mysqlslap --defaults-file="C:/Program Files/MySQL/MySQL Server 5.1/my.ini" --concurrency=50 --iterations=1 --create-schema=edu_591up --query="update ol_user set password='tongchaotongchao' where userid = 13" --number-of-queries=10000 -uroot -p8319999
mysqlslap --defaults-file="C:/Program Files/MySQL/MySQL Server 5.1/my.ini" --concurrency=50 --iterations=1 --create-schema=edu_591up --query="select * from ol_user where userid = 13" --number-of-queries=10000 -uroot -p8319999
*******************************************************************************************************************************
mysqlslap --defaults-file="D:/MySQL/MySql5.5/my.ini" --concurrency=50 --iterations=1 --create-schema=edu_591up --query="insert into ol_user(username,password)values('tongchao','dddddddddddddddd')" --number-of-queries=10000 -uroot
mysqlslap --defaults-file="D:/MySQL/MySql5.5/my.ini" --concurrency=50 --iterations=1 --create-schema=edu_591up --query="update ol_user set password='tongchaotongchao' where userid = 13" --number-of-queries=100000 -uroot
mysqlslap --defaults-file="D:/MySQL/MySql5.5/my.ini" --concurrency=50 --iterations=1 --create-schema=edu_591up --query="select * from ol_user where userid = 13" --number-of-queries=10000 -uroot
二、自动测试
mysqlslap --defaults-file="C:/Program Files/MySQL/MySQL Server 5.1/my.ini" --concurrency=50 --iterations=1 --number-int-cols=4 --auto-generate-sql --auto-generate-sql-load-type=update --engine=myisam,innodb --number-of-queries=10000 -uroot -p8319999
mysqlslap --defaults-file="D:/MySQL/MySql5.5/my.ini" --concurrency=50 --iterations=1 --number-int-cols=4 --auto-generate-sql --auto-generate-sql-load-type=update --engine=myisam,innodb --number-of-queries=10000 -uroot
mysqlslap --defaults-file="C:/Program Files/MySQL/mysql-5.1.54-win32/my.ini" --concurrency=50 --iterations=1 --number-int-cols=4 --auto-generate-sql --auto-generate-sql-load-type=update --engine=myisam,innodb --number-of-queries=10000 -uroot
结果:
5.1
update:
Benchmark
Running for engine myisam
Average number of seconds to run all queries: 17.547 seconds
Minimum number of seconds to run all queries: 17.547 seconds
Maximum number of seconds to run all queries: 17.547 seconds
Number of clients running queries: 50
Average number of queries per client: 200
Benchmark
Running for engine innodb
Average number of seconds to run all queries: 47.860 seconds
Minimum number of seconds to run all queries: 47.860 seconds
Maximum number of seconds to run all queries: 47.860 seconds
Number of clients running queries: 50
Average number of queries per client: 200
write:
Benchmark
Running for engine myisam
Average number of seconds to run all queries: 1.587 seconds
Minimum number of seconds to run all queries: 0.766 seconds
Maximum number of seconds to run all queries: 1.890 seconds
Number of clients running queries: 50
Average number of queries per client: 200
Benchmark
Running for engine innodb
Average number of seconds to run all queries: 1.868 seconds
Minimum number of seconds to run all queries: 1.812 seconds
Maximum number of seconds to run all queries: 2.094 seconds
Number of clients running queries: 50
Average number of queries per client: 200
mixed:
Benchmark
Running for engine myisam
Average number of seconds to run all queries: 52.453 seconds
Minimum number of seconds to run all queries: 52.453 seconds
Maximum number of seconds to run all queries: 52.453 seconds
Number of clients running queries: 50
Average number of queries per client: 200
Benchmark
Running for engine innodb
Average number of seconds to run all queries: 66.531 seconds
Minimum number of seconds to run all queries: 66.531 seconds
Maximum number of seconds to run all queries: 66.531 seconds
Number of clients running queries: 50
Average number of queries per client: 200
5.5
update:
Benchmark
Running for engine myisam
Average number of seconds to run all queries: 14.360 seconds
Minimum number of seconds to run all queries: 14.360 seconds
Maximum number of seconds to run all queries: 14.360 seconds
Number of clients running queries: 50
Average number of queries per client: 200
Benchmark
Running for engine innodb
Average number of seconds to run all queries: 43.843 seconds
Minimum number of seconds to run all queries: 43.843 seconds
Maximum number of seconds to run all queries: 43.843 seconds
Number of clients running queries: 50
Average number of queries per client: 200
write:
Benchmark
Running for engine myisam
Average number of seconds to run all queries: 1.526 seconds
Minimum number of seconds to run all queries: 0.703 seconds
Maximum number of seconds to run all queries: 1.766 seconds
Number of clients running queries: 50
Average number of queries per client: 200
Benchmark
Running for engine innodb
Average number of seconds to run all queries: 1.573 seconds
Minimum number of seconds to run all queries: 0.766 seconds
Maximum number of seconds to run all queries: 1.828 seconds
Number of clients running queries: 50
Average number of queries per client: 200
mixed:
Benchmark
Running for engine myisam
Average number of seconds to run all queries: 39.468 seconds
Minimum number of seconds to run all queries: 39.468 seconds
Maximum number of seconds to run all queries: 39.468 seconds
Number of clients running queries: 50
Average number of queries per client: 200
Benchmark
Running for engine innodb
Average number of seconds to run all queries: 50.468 seconds
Minimum number of seconds to run all queries: 50.468 seconds
Maximum number of seconds to run all queries: 50.468 seconds
Number of clients running queries: 50
Average number of queries per client: 200
C:\Documents and Settings\Administrator>mysqlslap --defaults-file="D:/MySQL/MySq
l5.5/my.ini" --concurrency=100 --iterations=5 --number-int-cols=4 --auto-generat
e-sql --auto-generate-sql-load-type=update --engine=innodb --number-of-queries=1
000 -uroot
Benchmark
Running for engine innodb
Average number of seconds to run all queries: 3.371 seconds
Minimum number of seconds to run all queries: 2.547 seconds
Maximum number of seconds to run all queries: 4.515 seconds
Number of clients running queries: 100
Average number of queries per client: 10
C:\Documents and Settings\Administrator>mysqlslap --defaults-file="C:/Program
les/MySQL/mysql-5.1.54-win32/my.ini" --concurrency=100 --iterations=5 --number
nt-cols=4 --auto-generate-sql --auto-generate-sql-load-type=update --engine=in
db --number-of-queries=1000 -uroot
Benchmark
Running for engine innodb
Average number of seconds to run all queries: 3.831 seconds
Minimum number of seconds to run all queries: 3.797 seconds
Maximum number of seconds to run all queries: 3.860 seconds
Number of clients running queries: 100
Average number of queries per client: 10
发表评论
-
用SQL找出每种类型中时间最新的前N个数据组成的集合
2012-03-23 22:46 1503比如有文章表 Article(Id,Category ... -
mysql select 中的escape,转义
2011-10-17 16:57 2991SELECT * FROM tb1 WHERE varchar ... -
mysql 变量
2011-07-13 21:45 22141. 使用用户变量 可以清空MySQL 用 ... -
安装DBI组件。 Can't locate DBI.pm in @INC-mysql接口
2011-07-12 21:05 10668Can't locate DBI.pm in @INC ( ... -
mysql 排名
2011-07-08 11:21 1060SET @i=0; SELECT @i:=@i+1,user ... -
Linux下设置自动删除N天前备份
2011-07-06 21:00 1651find /data1/mysqldata/mysqlback ... -
修改数据库字符集
2011-07-05 13:08 1100ALTER DATABASE gongwuyuan_063 ... -
一个导数据的存储过程
2011-07-04 21:27 1256DELIMITER $$ USE `gongwuyu ... -
MySQL字符串函数:字符串截取
2011-07-04 20:08 1234MySQL 字符串截取函数:left(), right ... -
mysql 清理 binlog 二进制日志文件
2011-07-03 21:41 8710mysql> PURGE MASTER LOG ... -
xtrabackup
2011-07-03 21:21 18431. 下载 wget http://www.percona. ... -
MySQL的FLUSH句法
2011-07-03 19:14 2651MySQL的FLUSH句法(清除 ... -
mysql 存储过程权限相关
2011-06-30 01:43 72931.修改mysql 存储过程的definer 修改mysql. ... -
MySQL命令行的几个用法
2011-06-28 14:23 21171.使用\G按行垂直显示结果 如果一行很长,需要这行显示的话 ... -
MySQL命令行的几个用法
2011-06-28 14:17 1MySQL的客户端命令行工 ... -
mysql null
2011-06-20 20:22 1175mysql> select 0 is null, 0 ... -
External Locking skip-external-locking
2011-06-14 22:59 2093External locking is the use of ... -
innodb 日志文件异常引起innodb 启动失败
2011-06-14 22:13 15801innodb 日志文件异常引起innodb 启动失败 110 ... -
mysql innodb 引擎初始化错误
2011-06-14 22:06 3288错误日志: InnoDB: The InnoDB me ... -
mysql Incorrect integer value错误
2011-06-14 21:58 1691# Set the SQL mode to strict ...
相关推荐
mysqlslap
mysqlslap压力测试工具 mysqlslap压力测试工具
具体用法,请查看我博客https://blog.csdn.net/colcool/article/details/100841517
该工具是从mysql5.1.44版本中提取。
MySQL压力测试工具mysqlslap.pdf
mysqlslap使用总结电脑资料.doc
mysqlslap进行压力测试参考.pdf
MySQL压力测试工具mysqlslap资料.pdf
MySQL压力测试工具mysqlslap宣贯.pdf
一、Mysqlslap介绍 mysqlslap是MySQL5.1之后自带的benchmark基准测试工具,类似Apache Bench负载产生工具,生成schema,装载数据,执行benckmark和查询数据,语法简单,灵活,容易使用。该工具可以模拟多个客户端...
MySQL从5.1.4版开始带有一个压力测试工具mysqlslap,通过模拟多个并发客户端访问mysql来执行测试,使用起来非常的简单。通过mysqlslap –help可以获得可用的选项,这里列一些主要的参数,更详细的说明参考官方手册。...
mysqlslap是一个诊断程序,旨在模拟MySQL服务器的客户端负载并报告每个阶段的时间。它就像多个客户端正在访问服务器一样工作。 1、使用的语法: mysqlslap [options] –auto-generate-sql, -a :自动生成测试表和...
mysql自带的压力测试工具 forwindows
首选工具mysql自带的:mysqlslap –auto-generate-sql, -a 自动生成测试表和数据 –auto-generate-sql-load-type=type 测试语句的类型。取值包括:read,key,write,update和mixed(默认)。 –number-char-c
利用mysqlslap 、sysbench 、supersmack等工具来测试MYSQL集群性能,包含并发读写能力,大数据量下的读写能力,并发事务处理能力,稳定性,单线程性能等给出了测试用例。