如题,请给出示例,谢谢
解决方案 »
- 问一个比较菜的问题,,MYSQL负载能支持多大的数据量?
- 印象中,sqlserver还是oracle中的同步/复制,其中有一种方式可以指定延迟时间,比如指定3秒从服务器为完成操作就认为同步/复制失败了。MySQL有类似
- JSP连接Mysqld的问题——连不上
- windows下mysql触发器问题--delete
- 乱码,struts+hibernate+mysql
- php+mysql连接的问题
- MySQL中怎样导入数据库?
- 急求怎么给mysql数据库里面添加日志
- 怎么查询出树形,不超过3层,200分
- 如何设计能容纳成千上万人注册的数据库,并且能很好的维护和拓展
- 各位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 。能告诉我是什么问题吗?