如题,请给出示例,谢谢
解决方案 »
- 数据库设计问题
- MYsql 怎么约束列的取值范围
- 请教mysql存文件的问题
- Beware of big rollbacks of mass inserts的理解?
- 根据另外一张表新增数据的问题
- 高手来看看,下面MSSQL语句,怎么用MYSQL实现!
- mysql高手帮个忙!请给我有关mysql系统表一些资料
- 如何获得某ID前后5条记录的ID?
- 请教:Access数据库如何导入MySQL中?
- mysql替换中的正则表达式如何保留一部分内容
- 各位mysql达人,请教windows下编译mysql5.0.51b遇到找不到bison.exe问题!
- 求助:数据库连接成功,在执行update时出现错误:com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'id' at row 1
那个是官方的。
我以前简单做了一个
http://blog.chinaunix.net/u/29134/showart_443933.html
,而且到安装目录的bin目录下也找不到 mysqlslap.exe程序。有人了解吗??已经登录数据库成功!
use mysqlslap
然后建表news,classify输数据...
在命令行里输入:
C:\Program Files\MySQL\MySQL Server 5.5\bin>mysqlslap -u root –no-defaults -p -c
reate-schema=example --query="SELECT n.* FROM news n,classify c WHERE n.type=c.id AND c.type='2'" --iterations=1000
其中-u为username,-p为使用密码,query引号后的内容为执行的测试的sql,循环1000次
要求输入密码
Enter password: ****结果:
Bench
Average number of seconds to run all queries: 0.007 seconds
Minimum number of seconds to run all queries: 0.000 seconds
Maximum number of seconds to run all queries: 1.016 seconds
Number of clients running queries: 1
Average number of queries per client: 1
..
(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 。能告诉我是什么问题吗?