最近对MySql的性能要求越来越高了,所以也需要做相关的压力仿真测试。
super-smack测试mysql性能
一.使用Red Hat Enterprise Linux Server release 5.4,x86_64位系统
一.使用Red Hat Enterprise Linux Server release 5.4,x86_64位系统
二.环境安装
三.使用super-smack
Error running query select count(*) from http_auth:Table 'test.http_auth' doesn't exist
Creating table 'http_auth'
Populating data file '/var/smack-data/words.dat' with shell command 'gen-data -n 90000 -f -12s%n,%-25s,%n,%d'
sh: /var/smack-data/words.dat: No such file or directory
super-smack: Error generating data file errno = 2, error is No such file or directory
Creating table 'http_auth'
Populating data file '/var/smack-data/words.dat' with shell command 'gen-data -n 90000 -f -12s%n,%-25s,%n,%d'
sh: /var/smack-data/words.dat: No such file or directory
super-smack: Error generating data file errno = 2, error is No such file or directory
Table 'http_auth' does not meet condtions, will be dropped
Creating table 'http_auth'
Loading data from file '/var/smack-data/http_auth.dat' into table 'http_auth'
Table http_auth is now ready for the test
Query Barrel Report for client smacker1
connect: max=5ms min=1ms avg= 2ms from 10 clients
Query_type
num_queries
max_time
min_time
q_per_s
select_index
20000
0
0
14947.59
Creating table 'http_auth'
Loading data from file '/var/smack-data/http_auth.dat' into table 'http_auth'
Table http_auth is now ready for the test
Query Barrel Report for client smacker1
connect: max=5ms
Query_type
select_index
Query Barrel Report for client smacker1
connect: max=35ms min=0ms avg= 14ms from 10 clients
Query_type
num_queries
max_time
min_time
q_per_s
select_index
20000
0
0
14760.01
connect: max=35ms
Query_type
select_index