Skip to content

Instantly share code, notes, and snippets.

@arnaudsj

arnaudsj/4GB Mysql bench

Created April 6, 2009 02:45
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save arnaudsj/90618 to your computer and use it in GitHub Desktop.
Save arnaudsj/90618 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
4GB Mysql bench
arnaudsj@andromeda ~/mysql-5.0.77/sql-bench
21:19:38 $ ./run-all-tests
Benchmark DBD suite: 2.15
Date of test: 2009-04-05 21:19:44
Running tests on: Linux 2.6.28-ARCH x86_64
Arguments:
Comments:
Limits from:
Server version: MySQL 5.0.77/
Optimization: None
Hardware:
alter-table: Total time: 13 wallclock secs ( 0.07 usr 0.02 sys + 0.00 cusr 0.00 csys = 0.09 CPU)
ATIS: Total time: 10 wallclock secs ( 3.75 usr 0.11 sys + 0.00 cusr 0.00 csys = 3.86 CPU)
big-tables: Total time: 8 wallclock secs ( 1.60 usr 0.21 sys + 0.00 cusr 0.00 csys = 1.81 CPU)
connect: Total time: 61 wallclock secs (21.99 usr 7.87 sys + 0.00 cusr 0.00 csys = 29.86 CPU)
create: Total time: 269 wallclock secs ( 4.08 usr 0.99 sys + 0.00 cusr 0.00 csys = 5.07 CPU)
insert: Total time: 499 wallclock secs (180.55 usr 17.24 sys + 0.00 cusr 0.00 csys = 197.79 CPU)
select: Total time: 172 wallclock secs (16.25 usr 1.25 sys + 0.00 cusr 0.00 csys = 17.50 CPU)
transactions: Test skipped because the database doesn't support transactions
wisconsin: Total time: 4 wallclock secs ( 1.38 usr 0.50 sys + 0.00 cusr 0.00 csys = 1.88 CPU)
All 9 test executed successfully
Totals per operation:
Operation seconds usr sys cpu tests
alter_table_add 8.00 0.03 0.00 0.03 100
alter_table_drop 3.00 0.00 0.01 0.01 91
connect 4.00 2.94 0.96 3.90 10000
connect+select_1_row 6.00 3.80 1.46 5.26 10000
connect+select_simple 7.00 3.23 1.11 4.34 10000
count 3.00 0.02 0.00 0.02 100
count_distinct 3.00 0.07 0.01 0.08 1000
count_distinct_2 6.00 0.08 0.02 0.10 1000
count_distinct_big 10.00 2.67 0.01 2.68 120
count_distinct_group 4.00 0.37 0.02 0.39 1000
count_distinct_group_on_key 5.00 0.11 0.00 0.11 1000
count_distinct_group_on_key_parts 4.00 0.37 0.03 0.40 1000
count_distinct_key_prefix 3.00 0.07 0.01 0.08 1000
count_group_on_key_parts 5.00 0.32 0.00 0.32 1000
count_on_key 50.00 3.10 0.41 3.51 50100
create+drop 89.00 1.31 0.34 1.65 10000
create_MANY_tables 85.00 0.95 0.19 1.14 10000
create_index 1.00 0.00 0.00 0.00 8
create_key+drop 91.00 1.42 0.32 1.74 10000
create_table 0.00 0.00 0.00 0.00 31
delete_all_many_keys 12.00 0.01 0.00 0.01 1
delete_big 0.00 0.00 0.00 0.00 1
delete_big_many_keys 12.00 0.01 0.00 0.01 128
delete_key 1.00 0.11 0.03 0.14 10000
delete_range 2.00 0.00 0.00 0.00 12
drop_index 1.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.13 0.04 0.17 10000
insert 28.00 4.80 1.83 6.63 350768
insert_duplicates 8.00 1.88 0.53 2.41 100000
insert_key 21.00 2.21 0.54 2.75 100000
insert_many_fields 3.00 0.08 0.01 0.09 2000
insert_select_1_key 2.00 0.00 0.00 0.00 1
insert_select_2_keys 1.00 0.00 0.00 0.00 1
min_max 3.00 0.00 0.00 0.00 60
min_max_on_key 11.00 5.38 0.59 5.97 85000
multiple_value_insert 1.00 0.14 0.01 0.15 100000
once_prepared_select 10.00 3.08 0.52 3.60 100000
order_by_big 11.00 8.40 0.13 8.53 10
order_by_big_key 11.00 9.22 0.14 9.36 10
order_by_big_key2 10.00 8.68 0.07 8.75 10
order_by_big_key_desc 11.00 8.99 0.13 9.12 10
order_by_big_key_diff 10.00 8.38 0.12 8.50 10
order_by_big_key_prefix 10.00 8.79 0.13 8.92 10
order_by_key2_diff 1.00 0.72 0.00 0.72 500
order_by_key_prefix 0.00 0.37 0.00 0.37 500
order_by_range 1.00 0.33 0.01 0.34 500
outer_join 10.00 0.00 0.00 0.00 10
outer_join_found 10.00 0.00 0.00 0.00 10
outer_join_not_found 7.00 0.00 0.00 0.00 500
outer_join_on_key 7.00 0.01 0.00 0.01 10
prepared_select 15.00 6.44 0.64 7.08 100000
select_1_row 8.00 1.91 0.65 2.56 100000
select_1_row_cache 6.00 1.53 0.67 2.20 100000
select_2_rows 8.00 1.62 0.61 2.23 100000
select_big 11.00 8.55 0.13 8.68 80
select_big_str 5.00 1.97 0.83 2.80 10000
select_cache 23.00 0.64 0.07 0.71 10000
select_cache2 22.00 0.60 0.05 0.65 10000
select_column+column 7.00 1.54 0.61 2.15 100000
select_diff_key 0.00 0.04 0.01 0.05 500
select_distinct 2.00 0.65 0.01 0.66 800
select_group 9.00 0.48 0.04 0.52 2911
select_group_when_MANY_tables 3.00 0.27 0.10 0.37 10000
select_join 0.00 0.22 0.00 0.22 100
select_key 39.00 18.07 2.10 20.17 200000
select_key2 29.00 13.43 1.46 14.89 200000
select_key2_return_key 27.00 12.79 1.40 14.19 200000
select_key2_return_prim 28.00 12.78 1.42 14.20 200000
select_key_prefix 40.00 15.65 1.71 17.36 200000
select_key_prefix_join 4.00 2.02 0.01 2.03 100
select_key_return_key 27.00 12.98 1.42 14.40 200000
select_many_fields 5.00 1.51 0.20 1.71 2000
select_range 37.00 3.11 0.09 3.20 410
select_range_key2 5.00 1.82 0.14 1.96 25010
select_range_prefix 5.00 1.41 0.11 1.52 25010
select_simple 5.00 1.93 0.59 2.52 100000
select_simple_cache 5.00 1.52 0.38 1.90 100000
select_simple_join 1.00 0.24 0.00 0.24 500
update_big 10.00 0.00 0.00 0.00 10
update_of_key 5.00 0.62 0.27 0.89 50000
update_of_key_big 5.00 0.01 0.00 0.01 501
update_of_primary_key_many_keys 5.00 0.01 0.01 0.02 256
update_with_key 22.00 3.81 1.56 5.37 300000
update_with_key_prefix 8.00 2.12 0.77 2.89 100000
wisc_benchmark 1.00 0.95 0.31 1.26 114
TOTALS 1035.00 225.82 28.10 253.92 3425950
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment