- 论坛徽章:
- 0
|
mysql如何进行压力 性能测试？我看了几个相关的工具 但是结果证明不了什么的
Mysql自带的压力测试工具mysqlslap，通过模拟多个并发客户端访问mysql来执行测试，使用起来非常的简单。
参数说明: --concurrency，并发数 --number-of-queries，执行的SQL总数量
--iterations，迭代的实验次数（重复的次数） –auto-generate-sql，自动产生测试SQL
针对指定的数据库进行性能测试：
参数说明：--create-schema=test(数据库名称) --query= (指定SQL语句，可以定位到某个包含SQL的文件)
--number-of-queries 代表总共要运行多少次查询。
/usr/local/mysql/bin/mysqlslap –defaults-file=/etc/my.cnf –concurrency=25,50,100 –iterations=1 –create-shcema=”test” –query=”select title from sablog_articles where artcleid=”121” –number-of-queries=5000 –debug-info -uroot
这另外的一个测试：
Download：sql-bench.tar.gz
Tar –xzvf
cd sql-bench
[root@21server sql-bench]# perl run-all-tests --host='localhost' --server=MySQL --socket='/tmp/mysql.sock' --user='root' --password='254605sxz'
Benchmark DBD suite: 2.15
Date of test: 2009-08-10 11:16:38
Running tests on: Linux 2.6.18-53.el5xen i686
Arguments: --socket=/tmp/mysql.sock
Comments:
Limits from:
Server version: MySQL 5.1.32
Optimization: None
Hardware:
alter-table:
Total time: 27 wallclock secs ( 0.01 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.01 CPU)
ATIS:
Total time: 18 wallclock secs ( 2.59 usr 0.10 sys + 0.00 cusr 0.00 csys = 2.69 CPU)
big-tables: Total time: 11 wallclock secs ( 1.88 usr 0.68 sys + 0.00 cusr 0.00 csys = 2.56 CPU)
connect: Total time: 71 wallclock secs (13.20 usr 4.56 sys + 0.00 cusr 0.00 csys = 17.76 CPU)
create: ^[[ATotal time: 97 wallclock secs ( 1.71 usr 0.45 sys + 0.00 cusr 0.00 csys = 2.16 CPU)
insert: Total time: 1069 wallclock secs (139.65 usr 13.65 sys + 0.00 cusr 0.00 csys = 153.30 CPU)
select: Total time: 293 wallclock secs (15.87 usr 1.42 sys + 0.00 cusr 0.00 csys = 17.29 CPU)
transactions: Test skipped because the database doesn't support transactions
wisconsin: Total time: 6 wallclock secs ( 0.98 usr 0.10 sys + 0.00 cusr 0.00 csys = 1.08 CPU)
All 9 test executed successfully
Totals per operation:
Operation seconds usr sys cpu tests
alter_table_add 11.00 0.00 0.00 0.00 100
alter_table_drop 12.00 0.01 0.00 0.01 91
connect 5.00 1.68 0.25 1.93 10000
connect+select_1_row 5.00 1.56 0.28 1.84 10000
connect+select_simple 5.00 1.78 0.25 2.03 10000
count 7.00 0.00 0.00 0.00 100
count_distinct 7.00 0.39 0.06 0.45 1000
count_distinct_2 8.00 0.05 0.00 0.05 1000
count_distinct_big 14.00 3.50 0.03 3.53 120
count_distinct_group 6.00 0.01 0.00 0.01 1000
count_distinct_group_on_key 9.00 0.21 0.02 0.23 1000
count_distinct_group_on_key_parts 6.00 0.49 0.01 0.50 1000
count_distinct_key_prefix 6.00 0.33 0.03 0.36 1000
count_group_on_key_parts 9.00 0.37 0.02 0.39 1000
count_on_key 95.00 3.69 0.52 4.21 50100
create+drop 30.00 0.48 0.16 0.64 10000
create_MANY_tables 32.00 0.30 0.02 0.32 10000
create_index 2.00 0.00 0.00 0.00 8
create_key+drop 32.00 0.81 0.18 0.99 10000
create_table 0.00 0.00 0.00 0.00 31
delete_all_many_keys 177.00 0.00 0.00 0.00 1
delete_big 1.00 0.00 0.00 0.00 1
delete_big_many_keys 177.00 0.00 0.00 0.00 128
delete_key 1.00 0.00 0.01 0.01 10000
delete_range 6.00 0.00 0.00 0.00 12
drop_index 2.00 0.00 0.00 0.00 8
drop_table 0.00 0.00 0.00 0.00 28
drop_table_when_MANY_tables 1.00 0.02 0.02 0.04 10000
insert 43.00 2.59 1.44 4.03 350768
insert_duplicates 10.00 0.20 0.21 0.41 100000
insert_key 134.00 1.94 0.71 2.65 100000
insert_many_fields 3.00 0.01 0.00 0.01 2000
insert_select_1_key 2.00 0.00 0.00 0.00 1
insert_select_2_keys 3.00 0.00 0.00 0.00 1
min_max 5.00 0.00 0.00 0.00 60
min_max_on_key 12.00 1.74 0.37 2.11 85000
multiple_value_insert 1.00 0.18 0.02 0.20 100000
once_prepared_select 15.00 0.17 0.08 0.25 100000
order_by_big 15.00 11.79 0.27 12.06 10
order_by_big_key 14.00 11.78 0.19 11.97 10
order_by_big_key2 13.00 11.43 0.10 11.53 10
order_by_big_key_desc 14.00 11.76 0.33 12.09 10
order_by_big_key_diff 15.00 11.72 0.27 11.99 10
order_by_big_key_prefix 14.00 11.57 0.18 11.75 10
order_by_key2_diff 3.00 0.18 0.01 0.19 500
order_by_key_prefix 2.00 0.13 0.00 0.13 500
order_by_range 2.00 0.14 0.00 0.14 500
outer_join 37.00 0.00 0.00 0.00 10
outer_join_found 36.00 0.01 0.00 0.01 10
outer_join_not_found 17.00 0.00 0.00 0.00 500
outer_join_on_key 14.00 0.00 0.00 0.00 10
prepared_select 20.00 1.87 0.39 2.26 100000
select_1_row 10.00 1.90 0.94 2.84 100000
select_1_row_cache 10.00 1.94 1.12 3.06 100000
select_2_rows 9.00 1.17 0.44 1.61 100000
select_big 14.00 11.37 0.13 11.50 80
select_big_str 6.00 2.08 0.19 2.27 10000
select_cache 44.00 1.02 0.16 1.18 10000
select_cache2 45.00 1.26 0.20 1.46 10000
select_column+column 10.00 0.32 0.23 0.55 100000
select_diff_key 0.00 0.02 0.00 0.02 500
select_distinct 4.00 0.22 0.01 0.23 800
select_group 18.00 0.03 0.01 0.04 2911
select_group_when_MANY_tables 2.00 0.10 0.07 0.17 10000
select_join 2.00 0.00 0.00 0.00 100
select_key 41.00 13.63 2.05 15.68 200000
select_key2 41.00 10.14 1.27 11.41 200000
select_key2_return_key 33.00 5.16 0.81 5.97 200000
select_key2_return_prim 35.00 4.47 0.90 5.37 200000
select_key_prefix 40.00 4.31 0.84 5.15 200000
select_key_prefix_join 4.00 1.94 0.00 1.94 100
select_key_return_key 33.00 7.54 1.07 8.61 200000
select_many_fields 8.00 1.86 0.68 2.54 2000
select_range 49.00 3.15 0.06 3.21 410
select_range_key2 6.00 0.40 0.05 0.45 25010
select_range_prefix 7.00 0.56 0.04 0.60 25010
select_simple 6.00 0.02 0.03 0.05 100000
select_simple_cache 5.00 0.75 0.83 1.58 100000
select_simple_join 1.00 0.15 0.00 0.15 500
update_big 31.00 0.00 0.00 0.00 10
update_of_key 13.00 0.68 0.47 1.15 50000
update_of_key_big 12.00 0.00 0.00 0.00 501
update_of_primary_key_many_keys 39.00 0.01 0.00 0.01 256
update_with_key 41.00 2.77 1.71 4.48 300000
update_with_key_prefix 12.00 0.25 0.09 0.34 100000
wisc_benchmark 2.00 0.97 0.10 1.07 114
TOTALS 1743.00 175.08 20.93 196.01 3425950
[ 本帖最后由 liang3391 于 2009-8-20 17:33 编辑 ] |
|
免费注册
发表于 2009-08-20 17:32
发表于 2009-08-20 18:04