今天第一次用mysqlslap做数据库的测试,但是发现一个很奇怪的问题,我设置多并发的时候一直没有返回bench,但是打开数据库,确实是执行了。当我并发数设置为1的时候就能够返回bench了。。如下图,希望高人给我指点下,是否哪里出了什么错误。
解决方案 »
- 菜鸟求助,MYSQL不同进入方式显示的用户不一样
- count no execute query
- Mysql MyISAM数据库引擎发音
- 如何获取update的id
- 用什么语句可以获知数据库数据的更新?
- 急!!!!mysql查询问题!!!!
- 求助 谁能帮我写一个正则表达式过滤URL,使用MYSQL的正则表达式语法
- 巨简单的问题!!如何使用教本来建表?
- select * from tablename limit 10;如何让结果又大到小排序(类似order by desc)?在线等!!急!!
- Mysql UNION ALL
- 用MYSQL根据同一个字段的值取他所对应的值前3个对应的是value平均值
- [求救]BoneCP空闲连接被mysql断掉的问题
(C) 版权所有 1985-2003 Microsoft Corp.C:\Documents and Settings\Administrator.TOPANI-123>cd D:\Program Files\MySQL\MyS
QL Server 5.5\binC:\Documents and Settings\Administrator.TOPANI-123>d:D:\Program Files\MySQL\MySQL Server 5.5\bin>mysqlslap -uroot -p123456 --create-s
chema=testDB --concurrency=100 -q"select * from UserInfo"
Bench
Average number of seconds to run all queries: 19.531 seconds
Minimum number of seconds to run all queries: 19.531 seconds
Maximum number of seconds to run all queries: 19.531 seconds
Number of clients running queries: 100
Average number of queries per client: 1
D:\Program Files\MySQL\MySQL Server 5.5\bin>mysqlslap -uroot -p123456 --create-s
chema=testDB --number-of-queries=100 --concurrency=100 -q"select * from UserInfo
"
Bench
Average number of seconds to run all queries: 19.485 seconds
Minimum number of seconds to run all queries: 19.485 seconds
Maximum number of seconds to run all queries: 19.485 seconds
Number of clients running queries: 100
Average number of queries per client: 1
D:\Program Files\MySQL\MySQL Server 5.5\bin>mysqlslap -uroot -p123456 --create-s
chema=testDB --number-of-queries=200 --concurrency=200 -q"select * from UserInfo
"D:\Program Files\MySQL\MySQL Server 5.5\bin>mysqlslap -uroot -p123456 --create-s
chema=testDB --number-of-queries=600 --concurrency=300 -q"select * from UserInfo
"D:\Program Files\MySQL\MySQL Server 5.5\bin>mysqlslap -uroot -p123456 --create-s
chema=testDB --concurrency=300 -q"select * from UserInfo"D:\Program Files\MySQL\MySQL Server 5.5\bin>D:\Program Files\MySQL\MySQL Server 5.5\bin>看后面的几次都没有返回 bench 。能告诉我是什么问题吗?