如题,请给出示例,谢谢
解决方案 »
- 如何在字符串型字段查询匹配数据,例如字段保存数据为“1,2,3,4”,如何查询此字段包含“2,4”的数据
- 奇葩的sql语句,搞死我了,求救~~~~
- mysql复制问题
- mysql 无法执行命令
- mysql求月平均数
- 关于MYSQL触发器的问题
- MYSQL在几次命令错误之后自动断开
- 什么是ISAM和MYISAM表
- to excel
- 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 。能告诉我是什么问题吗?