MySQL Forums
Forum List  »  NDB clusters

A puzzle of useing SQL_BENCH
Posted by: power wang
Date: June 06, 2005 03:54AM

I have trouble now,can anybody help me?
I use sql bench to do the test Suite.I got the info:

Benchmark DBD suite: 2.15
Date of test: 2005-06-06 13:23:50
Running tests on: Linux 2.6.5-1.358 i686
Arguments: --tcpip --threads=50
Comments:
Limits from:
Server version: MySQL 4.1.12 max
Optimization: None
Hardware:

alter-table: Total time: 42 wallclock secs ( 0.10 usr 0.04 sys + 0.00 cusr 0.00 csys = 0.14 CPU)
ATIS: Total time: 38 wallclock secs (13.57 usr 5.49 sys + 0.00 cusr 0.00 csys = 19.06 CPU)
big-tables: Total time: 37 wallclock secs (11.85 usr 12.37 sys + 0.00 cusr 0.00 csys = 24.22 CPU)
connect: Total time: 4 wallclock secs ( 0.81 usr 0.55 sys + 0.00 cusr 0.00 csys = 1.36 CPU)
create: Total time: 611 wallclock secs ( 6.32 usr 2.66 sys + 0.00 cusr 0.00 csys = 8.98 CPU)
insert: Total time: 2332 wallclock secs (893.87 usr 276.74 sys + 0.00 cusr 0.00 csys = 1170.61 CPU)
select: Total time: 666 wallclock secs (77.57 usr 24.61 sys + 0.00 cusr 0.00 csys = 102.18 CPU)
transactions: Test skipped because the database doesn't support transactions
wisconsin: Total time: 15 wallclock secs ( 4.07 usr 2.08 sys + 0.00 cusr 0.00 csys = 6.15 CPU)

All 9 test executed successfully

Totals per operation:
Operation seconds usr sys cpu tests
alter_table_add 18.00 0.02 0.01 0.03 100
alter_table_drop 18.00 0.02 0.00 0.02 91
connect 1.00 0.10 0.04 0.14 100
connect+select_1_row 0.00 0.11 0.04 0.15 100
connect+select_simple 0.00 0.12 0.04 0.16 100
count 17.00 0.04 0.01 0.05 100
count_distinct 20.00 0.41 0.08 0.49 1000
count_distinct_2 26.00 0.40 0.11 0.51 1000
count_distinct_big 37.00 11.44 4.94 16.38 120
count_distinct_group 20.00 1.56 0.53 2.09 1000
count_distinct_group_on_key 26.00 0.46 0.13 0.59 1000
count_distinct_group_on_key_parts 20.00 1.56 0.51 2.07 1000
count_distinct_key_prefix 14.00 0.33 0.10 0.43 1000
count_group_on_key_parts 25.00 1.47 0.54 2.01 1000
count_on_key 234.00 16.74 4.14 20.88 50100
create+drop 200.00 1.95 0.71 2.66 10000
create_MANY_tables 200.00 1.39 0.44 1.83 10000
create_index 3.00 0.00 0.00 0.00 8
create_key+drop 200.00 2.07 0.79 2.86 10000
create_table 1.00 0.01 0.01 0.02 31
delete_all_many_keys 39.00 0.02 0.01 0.03 1
delete_big 1.00 0.00 0.00 0.00 1
delete_big_many_keys 39.00 0.02 0.01 0.03 128
delete_key 3.00 0.26 0.18 0.44 10000
delete_range 7.00 0.00 0.00 0.00 12
drop_index 3.00 0.00 0.00 0.00 8
drop_table 0.00 0.00 0.00 0.00 28
drop_table_when_MANY_tables 5.00 0.44 0.31 0.75 10000
insert 108.00 13.33 9.83 23.16 350768
insert_duplicates 28.00 4.32 2.87 7.19 100000
insert_key 87.00 7.16 3.12 10.28 100000
insert_many_fields 7.00 0.38 0.15 0.53 2000
insert_select_1_key 4.00 0.00 0.00 0.00 1
insert_select_2_keys 4.00 0.00 0.00 0.00 1
min_max 12.00 0.03 0.01 0.04 60
min_max_on_key 53.00 28.05 7.25 35.30 85000
multiple_value_insert 3.00 0.51 0.04 0.55 100000
once_prepared_select 49.00 12.90 7.59 20.49 100000
order_by_big 66.00 44.20 15.16 59.36 10
order_by_big_key 61.00 45.11 16.03 61.14 10
order_by_big_key2 59.00 44.11 15.16 59.27 10
order_by_big_key_desc 61.00 45.18 15.97 61.15 10
order_by_big_key_diff 64.00 43.92 15.26 59.18 10
order_by_big_key_prefix 60.00 44.16 15.32 59.48 10
order_by_key2_diff 7.00 3.87 1.24 5.11 500
order_by_key_prefix 4.00 2.07 0.64 2.71 500
order_by_range 4.00 1.97 0.66 2.63 500
outer_join 44.00 0.01 0.00 0.01 10
outer_join_found 42.00 0.00 0.00 0.00 10
outer_join_not_found 26.00 0.01 0.00 0.01 500
outer_join_on_key 26.00 0.00 0.00 0.00 10
prepared_select 73.00 33.44 9.38 42.82 100000
select_1_row 1.00 0.06 0.05 0.11 1000
select_1_row_cache 0.00 0.06 0.05 0.11 1000
select_2_rows 0.00 0.06 0.08 0.14 1000
select_big 59.00 44.03 15.34 59.37 80
select_big_str 0.00 0.11 0.06 0.17 100
select_cache 58.00 3.29 0.83 4.12 10000
select_cache2 59.00 3.37 0.88 4.25 10000
select_column+column 1.00 0.06 0.07 0.13 1000
select_diff_key 69.00 0.24 0.04 0.28 500
select_distinct 11.00 2.61 1.04 3.65 800
select_group 30.00 1.87 0.58 2.45 2911
select_group_when_MANY_tables 6.00 0.47 0.41 0.88 10000
select_join 2.00 0.77 0.34 1.11 100
select_key 149.00 76.24 19.78 96.02 200000
select_key2 154.00 76.22 18.71 94.93 200000
select_key2_return_key 139.00 71.15 15.50 86.65 200000
select_key2_return_prim 147.00 73.45 17.23 90.68 200000
select_key_prefix 155.00 75.68 20.30 95.98 200000
select_key_prefix_join 10.00 6.72 2.85 9.57 100
select_key_return_key 141.00 72.86 16.75 89.61 200000
select_many_fields 30.00 11.47 12.22 23.69 2000
select_range 119.00 12.76 5.39 18.15 410
select_range_key2 20.00 7.83 2.06 9.89 25010
select_range_prefix 20.00 8.07 2.03 10.10 25010
select_simple 1.00 0.06 0.05 0.11 1000
select_simple_cache 0.00 0.06 0.07 0.13 1000
select_simple_join 2.00 1.00 0.38 1.38 500
update_big 26.00 0.00 0.00 0.00 10
update_of_key 20.00 1.74 1.42 3.16 50000
update_of_key_big 14.00 0.02 0.02 0.04 501
update_of_primary_key_many_keys 19.00 0.01 0.00 0.01 256
update_with_key 94.00 10.44 9.49 19.93 300000
update_with_key_prefix 37.00 8.22 4.03 12.25 100000
wisc_benchmark 4.00 2.73 1.08 3.81 114
TOTALS 3726.00 989.40 318.49 1307.89 2792350

Could anybody explain it for me,thanks.

Such as "15 wallclock secs ( 4.07 usr 2.08 sys + 0.00 cusr 0.00 csys = 6.15 CPU)" means what?
Another, i want to get the performance of mysql cluster,any tools who can provide?

Options: ReplyQuote


Subject
Views
Written By
Posted
A puzzle of useing SQL_BENCH
2690
June 06, 2005 03:54AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.