Hi all,
Here are some test results obtained with sql-bench, and the fix that
allows insert test to run. I need to modify the compare-results script
to do several things such as automatically compare test result scripts
better to get some actual comparison info. Note: both RDBMSs used InnoDB
for this test.
this is a quad-core Intel(R) Xeon(TM) CPU 3.60GHz
But here's the raw stuff:
p...@orisndriz05:~/sql-bench$ time ./run-all-tests --server=mysql
--create-options="engine=innodb" --user=root --password=drizzle >
mysql-sql-bench.txt
real 136m31.437s
user 5m20.190s
sys 0m44.210s
Benchmark DBD suite: 2.15
Date of test: 2009-08-06 9:33:18
Running tests on: Linux 2.6.28-11-server x86_64
Arguments: --create-options=engine=innodb
Comments:
Limits from:
Server version: MySQL 5.0.75 0ubuntu10.2
Optimization: None
Hardware:
alter-table: Total time: 52 wallclock secs ( 0.04 usr 0.02 sys + 0.00
cusr 0.00 csys = 0.06 CPU)
ATIS: Total time: 6 wallclock secs ( 3.75 usr 0.26 sys + 0.00 cusr
0.00 csys = 4.01 CPU)
big-tables: Total time: 8 wallclock secs ( 2.40 usr 0.36 sys + 0.00
cusr 0.00 csys = 2.76 CPU)
connect: Total time: 18 wallclock secs ( 5.86 usr 2.07 sys + 0.00
cusr 0.00 csys = 7.93 CPU)
create: Total time: 128 wallclock secs ( 5.04 usr 1.33 sys + 0.00
cusr 0.00 csys = 6.37 CPU)
insert: Total time: 7857 wallclock secs (272.78 usr 35.69 sys + 0.00
cusr 0.00 csys = 308.47 CPU)
select: Total time: 93 wallclock secs (24.20 usr 2.45 sys + 0.00 cusr
0.00 csys = 26.65 CPU)
transactions: Total time: 16 wallclock secs ( 2.37 usr 1.19 sys + 0.00
cusr 0.00 csys = 3.56 CPU)
wisconsin: Total time: 11 wallclock secs ( 1.93 usr 0.62 sys + 0.00
cusr 0.00 csys = 2.55 CPU)
All 9 test executed successfully
Totals per operation:
Operation seconds usr sys cpu tests
alter_table_add 24.00 0.01 0.00 0.01 100
alter_table_drop 22.00 0.00 0.00 0.00 91
connect 1.00 0.83 0.14 0.97 2000
connect+select_1_row 2.00 0.85 0.19 1.04 2000
connect+select_simple 1.00 0.88 0.14 1.02 2000
count 16.00 0.00 0.01 0.01 100
count_distinct 0.00 0.10 0.05 0.15 1000
count_distinct_2 0.00 0.17 0.00 0.17 1000
count_distinct_big 5.00 2.88 0.02 2.90 120
count_distinct_group 0.00 0.42 0.00 0.42 1000
count_distinct_group_on_key 0.00 0.12 0.01 0.13 1000
count_distinct_group_on_key_parts 1.00 0.42 0.00 0.42 1000
count_distinct_key_prefix 1.00 0.07 0.02 0.09 1000
count_group_on_key_parts 0.00 0.52 0.01 0.53 1000
count_on_key 15.00 5.22 0.64 5.86 50100
create+drop 26.00 1.62 0.34 1.96 10000
create_MANY_tables 33.00 1.01 0.20 1.21 10000
create_index 3.00 0.00 0.00 0.00 8
create_key+drop 30.00 1.76 0.51 2.27 10000
create_table 0.00 0.01 0.00 0.01 31
delete_all_many_keys 2237.00 0.02 0.01 0.03 1
delete_autocommit 3.00 0.25 0.18 0.43 10000
delete_big 1.00 0.00 0.00 0.00 1
delete_big_many_keys 2236.00 0.02 0.01 0.03 128
delete_commit 1.00 0.20 0.14 0.34 10000
delete_key 4.00 0.21 0.10 0.31 10000
delete_range 14.00 0.00 0.00 0.00 12
delete_rollback 1.00 0.25 0.15 0.40 100
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 23.00 0.40 0.13 0.53 10000
insert 108.00 8.57 5.23 13.80 350768
insert_autocommit 3.00 0.33 0.07 0.40 10000
insert_commit 1.00 0.29 0.14 0.43 10000
insert_duplicates 13.00 2.59 1.25 3.84 100000
insert_key 1422.00 6.10 1.61 7.71 100000
insert_many_fields 4.00 0.17 0.04 0.21 2000
insert_rollback 1.00 0.28 0.14 0.42 100
insert_select_1_key 6.00 0.00 0.00 0.00 1
insert_select_2_keys 9.00 0.00 0.00 0.00 1
min_max 6.00 0.00 0.01 0.01 60
min_max_on_key 14.00 9.40 1.39 10.79 85000
multiple_value_insert 6.00 0.19 0.01 0.20 100000
once_prepared_select 25.00 4.96 1.26 6.22 100000
order_by_big 14.00 10.16 0.17 10.33 10
order_by_big_key 14.00 10.62 0.42 11.04 10
order_by_big_key2 11.00 9.09 0.24 9.33 10
order_by_big_key_desc 14.00 10.72 0.15 10.87 10
order_by_big_key_diff 12.00 9.88 0.20 10.08 10
order_by_big_key_prefix 14.00 9.75 0.17 9.92 10
order_by_key2_diff 1.00 0.85 0.00 0.85 500
order_by_key_prefix 1.00 0.44 0.01 0.45 500
order_by_range 1.00 0.49 0.03 0.52 500
outer_join 3.00 0.00 0.00 0.00 10
outer_join_found 3.00 0.00 0.00 0.00 10
outer_join_not_found 2.00 0.00 0.00 0.00 500
outer_join_on_key 1.00 0.00 0.00 0.00 10
prepared_select 34.00 12.04 1.46 13.50 100000
select_1_row 3.00 0.48 0.27 0.75 20000
select_1_row_cache 1.00 0.47 0.22 0.69 20000
select_2_rows 3.00 0.61 0.25 0.86 20000
select_big 12.00 9.36 0.16 9.52 80
select_big_str 1.00 0.34 0.11 0.45 2000
select_cache 1.00 1.07 0.12 1.19 10000
select_cache2 60.00 1.08 0.19 1.27 10000
select_column+column 3.00 0.43 0.28 0.71 20000
select_diff_key 0.00 0.04 0.00 0.04 500
select_distinct 0.00 0.66 0.01 0.67 800
select_group 2.00 0.61 0.07 0.68 2911
select_group_when_MANY_tables 16.00 0.25 0.15 0.40 10000
select_join 0.00 0.20 0.00 0.20 100
select_key 57.00 24.39 2.75 27.14 200000
select_key2 63.00 24.26 2.63 26.89 200000
select_key2_return_key 58.00 23.48 2.84 26.32 200000
select_key2_return_prim 58.00 24.15 2.71 26.86 200000
select_key_prefix 60.00 23.51 2.88 26.39 200000
select_key_prefix_join 2.00 1.59 0.02 1.61 100
select_key_return_key 57.00 24.89 2.82 27.71 200000
select_many_fields 3.00 2.23 0.32 2.55 2000
select_range 5.00 3.95 0.05 4.00 410
select_range_key2 3.00 2.12 0.22 2.34 25010
select_range_prefix 4.00 2.21 0.28 2.49 25010
select_simple 2.00 0.42 0.28 0.70 20000
select_simple_cache 1.00 0.55 0.19 0.74 20000
select_simple_join 0.00 0.31 0.01 0.32 500
update_autocommit 3.00 0.25 0.14 0.39 10000
update_big 75.00 0.00 0.00 0.00 10
update_commit 1.00 0.21 0.12 0.33 10000
update_of_key 63.00 1.38 0.76 2.14 50000
update_of_key_big 42.00 0.01 0.00 0.01 501
update_of_primary_key_many_keys 3200.00 0.01 0.00 0.01 256
update_rollback 2.00 0.31 0.11 0.42 100
update_with_key 94.00 7.58 4.48 12.06 300000
update_with_key_prefix 16.00 3.72 1.42 5.14 100000
wisc_benchmark 1.00 1.25 0.04 1.29 114
TOTALS 10418.00 313.54 43.90 357.44 2974250
Drizzle:
Benchmark DBD suite: 2.15
Date of test: 2009-08-05 8:58:01
Running tests on: Linux 2.6.28-11-server x86_64
Arguments:
Comments:
Limits from:
Server version: Drizzle 2009.08.1107
Optimization: None
Hardware:
alter-table: Total time: 48 wallclock secs ( 0.07 usr 0.04 sys + 0.00
cusr 0.00 csys = 0.11 CPU)
ATIS: Total time: 15 wallclock secs ( 4.58 usr 0.31 sys + 0.00 cusr
0.00 csys = 4.89 CPU)
big-tables: Total time: 21 wallclock secs ( 8.31 usr 0.23 sys + 0.00
cusr 0.00 csys = 8.54 CPU)
connect: Total time: 19 wallclock secs ( 5.94 usr 3.60 sys + 0.00
cusr 0.00 csys = 9.54 CPU)
create: Total time: 81 wallclock secs ( 5.02 usr 1.94 sys + 0.00 cusr
0.00 csys = 6.96 CPU)
insert: Total time: 3829 wallclock secs (270.16 usr 44.74 sys + 0.00
cusr 0.00 csys = 314.90 CPU)
select: Total time: 353 wallclock secs (30.94 usr 4.04 sys + 0.00
cusr 0.00 csys = 34.98 CPU)
transactions: Total time: 16 wallclock secs ( 2.48 usr 1.32 sys + 0.00
cusr 0.00 csys = 3.80 CPU)
wisconsin: Total time: 12 wallclock secs ( 2.75 usr 0.73 sys + 0.00
cusr 0.00 csys = 3.48 CPU)
All 9 test executed successfully
Totals per operation:
Operation seconds usr sys cpu tests
alter_table_add 23.00 0.03 0.02 0.05 100
alter_table_drop 20.00 0.01 0.01 0.02 91
connect 2.00 0.58 0.31 0.89 2000
connect+select_1_row 2.00 0.80 0.54 1.34 2000
connect+select_simple 2.00 1.25 0.62 1.87 2000
count 16.00 0.00 0.01 0.01 100
count_distinct 8.00 0.16 0.00 0.16 1000
count_distinct_2 15.00 0.32 0.04 0.36 1000
count_distinct_big 19.00 4.26 0.03 4.29 120
count_distinct_group 13.00 0.64 0.03 0.67 1000
count_distinct_group_on_key 9.00 0.20 0.01 0.21 1000
count_distinct_group_on_key_parts 13.00 0.89 0.12 1.01 1000
count_distinct_key_prefix 5.00 0.15 0.04 0.19 1000
count_group_on_key_parts 9.00 1.92 0.15 2.07 1000
count_on_key 78.00 6.25 1.10 7.35 50100
create+drop 19.00 1.56 0.56 2.12 10000
create_MANY_tables 15.00 0.95 0.38 1.33 10000
create_index 2.00 0.00 0.00 0.00 8
create_key+drop 23.00 1.73 0.61 2.34 10000
create_table 0.00 0.00 0.00 0.00 31
delete_all_many_keys 1043.00 0.00 0.00 0.00 1
delete_autocommit 3.00 0.26 0.08 0.34 10000
delete_big 0.00 0.00 0.00 0.00 1
delete_big_many_keys 1043.00 0.00 0.00 0.00 128
delete_commit 1.00 0.20 0.13 0.33 10000
delete_key 2.00 0.21 0.16 0.37 10000
delete_range 10.00 0.01 0.00 0.01 12
delete_rollback 2.00 0.16 0.16 0.32 100
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 16.00 0.46 0.17 0.63 10000
insert 91.00 8.34 6.28 14.62 350768
insert_autocommit 2.00 0.32 0.11 0.43 10000
insert_commit 1.00 0.33 0.12 0.45 10000
insert_duplicates 14.00 3.10 1.58 4.68 100000
insert_key 520.00 5.55 2.01 7.56 100000
insert_many_fields 4.00 0.15 0.03 0.18 2000
insert_rollback 2.00 0.31 0.16 0.47 100
insert_select_1_key 5.00 0.00 0.00 0.00 1
insert_select_2_keys 7.00 0.00 0.00 0.00 1
min_max 9.00 0.02 0.00 0.02 60
min_max_on_key 18.00 9.43 1.73 11.16 85000
multiple_value_insert 3.00 0.17 0.00 0.17 100000
once_prepared_select 21.00 4.92 3.01 7.93 100000
order_by_big 13.00 9.81 0.01 9.82 10
order_by_big_key 14.00 13.24 0.22 13.46 10
order_by_big_key2 11.00 9.97 0.07 10.04 10
order_by_big_key_desc 15.00 12.63 0.13 12.76 10
order_by_big_key_diff 11.00 10.08 0.12 10.20 10
order_by_big_key_prefix 12.00 10.62 0.04 10.66 10
order_by_key2_diff 1.00 0.80 0.01 0.81 500
order_by_key_prefix 1.00 0.38 0.01 0.39 500
order_by_range 1.00 0.52 0.02 0.54 500
outer_join 27.00 0.00 0.00 0.00 10
outer_join_found 27.00 0.01 0.00 0.01 10
outer_join_not_found 24.00 0.00 0.00 0.00 500
outer_join_on_key 15.00 0.00 0.00 0.00 10
prepared_select 27.00 11.57 3.01 14.58 100000
select_1_row 2.00 0.52 0.34 0.86 20000
select_1_row_cache 3.00 0.49 0.31 0.80 20000
select_2_rows 2.00 0.61 0.29 0.90 20000
select_big 12.00 10.31 0.19 10.50 80
select_big_str 1.00 0.46 0.11 0.57 2000
select_cache 68.00 1.32 0.37 1.69 10000
select_cache2 68.00 1.48 0.25 1.73 10000
select_column+column 2.00 0.38 0.42 0.80 20000
select_diff_key 0.00 0.05 0.01 0.06 500
select_distinct 4.00 0.67 0.00 0.67 800
select_group 15.00 0.69 0.01 0.70 2911
select_group_when_MANY_tables 8.00 0.32 0.22 0.54 10000
select_join 1.00 0.25 0.01 0.26 100
select_key 43.00 23.29 3.31 26.60 200000
select_key2 51.00 23.20 3.43 26.63 200000
select_key2_return_key 44.00 17.84 2.94 20.78 200000
select_key2_return_prim 44.00 18.89 3.11 22.00 200000
select_key_prefix 50.00 23.68 3.58 27.26 200000
select_key_prefix_join 4.00 2.33 0.03 2.36 100
select_key_return_key 49.00 24.51 3.59 28.10 200000
select_many_fields 17.00 8.16 0.20 8.36 2000
select_range 49.00 4.99 0.25 5.24 410
select_range_key2 7.00 2.78 0.14 2.92 25010
select_range_prefix 7.00 2.50 0.26 2.76 25010
select_simple 1.00 0.43 0.28 0.71 20000
select_simple_cache 2.00 0.40 0.38 0.78 20000
select_simple_join 1.00 0.32 0.02 0.34 500
update_autocommit 3.00 0.24 0.21 0.45 10000
update_big 53.00 0.00 0.00 0.00 10
update_commit 1.00 0.41 0.19 0.60 10000
update_of_key 31.00 1.80 0.84 2.64 50000
update_of_key_big 37.00 0.05 0.01 0.06 501
update_of_primary_key_many_keys 1294.00 0.00 0.00 0.00 256
update_rollback 1.00 0.25 0.16 0.41 100
update_with_key 95.00 7.87 5.50 13.37 300000
update_with_key_prefix 36.00 5.59 1.81 7.40 100000
wisc_benchmark 2.00 1.87 0.13 2.00 114
TOTALS 5420.00 324.22 56.85 381.07 2974250
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-discuss
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-discuss
More help : https://help.launchpad.net/ListHelp
