Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- flashadmin@mx:~/sql-bench$ ./run-all-tests --user=root --pass=ujyxbt
- Benchmark DBD suite: 2.15
- Date of test: 2011-07-22 9:58:39
- Running tests on: Linux 2.6.32-5-xen-686 i686
- Arguments:
- Comments:
- Limits from:
- Server version: MySQL 5.1.49 3
- Optimization: None
- Hardware:
- alter-table: Total time: 23 wallclock secs ( 0.05 usr 0.08 sys + 0.00 cusr 0.00 csys = 0.13 CPU)
- ATIS: Total time: 7 wallclock secs ( 4.50 usr 0.74 sys + 0.00 cusr 0.00 csys = 5.24 CPU)
- big-tables: Total time: 7 wallclock secs ( 3.16 usr 0.82 sys + 0.00 cusr 0.00 csys = 3.98 CPU)
- connect: Total time: 197 wallclock secs (45.39 usr 34.22 sys + 0.00 cusr 0.00 csys = 79.61 CPU)
- create: Total time: 112 wallclock secs ( 5.72 usr 3.71 sys + 0.00 cusr 0.00 csys = 9.43 CPU)
- insert:
- Total time: 1437 wallclock secs (358.74 usr 139.80 sys + 0.00 cusr 0.00 csys = 498.54 CPU)
- select: Total time: 101 wallclock secs (30.53 usr 7.16 sys + 0.00 cusr 0.00 csys = 37.69 CPU)
- transactions: Test skipped because the database doesn't support transactions
- wisconsin: Total time: 11 wallclock secs ( 2.44 usr 1.65 sys + 0.00 cusr 0.00 csys = 4.09 CPU)
- All 9 test executed successfully
- Totals per operation:
- Operation seconds usr sys cpu tests
- alter_table_add 9.00 0.01 0.01 0.02 100
- alter_table_drop 10.00 0.01 0.01 0.02 91
- connect 11.00 5.36 1.70 7.06 10000
- connect+select_1_row 15.00 5.81 2.44 8.25 10000
- connect+select_simple 13.00 5.94 2.07 8.01 10000
- count 6.00 0.01 0.02 0.03 100
- count_distinct 1.00 0.17 0.04 0.21 1000
- count_distinct_2 0.00 0.16 0.05 0.21 1000
- count_distinct_big 4.00 3.46 0.06 3.52 120
- count_distinct_group 1.00 0.49 0.06 0.55 1000
- count_distinct_group_on_key 0.00 0.17 0.05 0.22 1000
- count_distinct_group_on_key_parts 1.00 0.50 0.05 0.55 1000
- count_distinct_key_prefix 0.00 0.17 0.03 0.20 1000
- count_group_on_key_parts 0.00 0.48 0.05 0.53 1000
- count_on_key 23.00 7.28 2.03 9.31 50100
- create+drop 33.00 1.68 1.08 2.76 10000
- create_MANY_tables 32.00 1.06 0.69 1.75 10000
- create_index 2.00 0.00 0.00 0.00 8
- create_key+drop 38.00 1.87 1.01 2.88 10000
- create_table 0.00 0.01 0.00 0.01 31
- delete_all_many_keys 52.00 0.01 0.00 0.01 1
- delete_big 0.00 0.00 0.00 0.00 1
- delete_big_many_keys 52.00 0.01 0.00 0.01 128
- delete_key 3.00 0.40 0.48 0.88 10000
- delete_range 6.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 4.00 0.49 0.41 0.90 10000
- insert 111.00 14.44 17.08 31.52 350768
- insert_duplicates 29.00 4.90 4.98 9.88 100000
- insert_key 118.00 6.58 5.93 12.51 100000
- insert_many_fields 3.00 0.23 0.11 0.34 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 3.00 0.01 0.00 0.01 60
- min_max_on_key 24.00 12.12 3.85 15.97 85000
- multiple_value_insert 2.00 0.22 0.02 0.24 100000
- once_prepared_select 48.00 8.16 5.36 13.52 100000
- order_by_big 14.00 9.91 0.33 10.24 10
- order_by_big_key 15.00 10.09 0.65 10.74 10
- order_by_big_key2 13.00 9.83 0.44 10.27 10
- order_by_big_key_desc 14.00 10.18 0.61 10.79 10
- order_by_big_key_diff 14.00 9.86 0.41 10.27 10
- order_by_big_key_prefix 13.00 9.79 0.48 10.27 10
- order_by_key2_diff 1.00 0.94 0.04 0.98 500
- order_by_key_prefix 2.00 0.53 0.02 0.55 500
- order_by_range 1.00 0.55 0.02 0.57 500
- outer_join 2.00 0.00 0.00 0.00 10
- outer_join_found 2.00 0.00 0.00 0.00 10
- outer_join_not_found 2.00 0.01 0.00 0.01 500
- outer_join_on_key 1.00 0.00 0.00 0.00 10
- prepared_select 58.00 15.99 5.94 21.93 100000
- select_1_row 31.00 4.74 4.66 9.40 100000
- select_1_row_cache 13.00 3.91 3.28 7.19 100000
- select_2_rows 34.00 4.91 4.87 9.78 100000
- select_big 13.00 9.69 0.60 10.29 80
- select_big_str 9.00 3.34 1.50 4.84 10000
- select_cache 2.00 1.37 0.41 1.78 10000
- select_cache2 51.00 1.74 0.63 2.37 10000
- select_column+column 36.00 4.75 4.91 9.66 100000
- select_diff_key 1.00 0.10 0.03 0.13 500
- select_distinct 1.00 0.79 0.04 0.83 800
- select_group 3.00 0.73 0.11 0.84 2911
- select_group_when_MANY_tables 5.00 0.62 0.52 1.14 10000
- select_join 0.00 0.23 0.00 0.23 100
- select_key 106.00 34.64 12.24 46.88 200000
- select_key2 112.00 35.32 11.90 47.22 200000
- select_key2_return_key 107.00 33.24 12.55 45.79 200000
- select_key2_return_prim 111.00 33.96 12.62 46.58 200000
- select_key_prefix 111.00 35.37 11.62 46.99 200000
- select_key_prefix_join 2.00 1.94 0.04 1.98 100
- select_key_return_key 104.00 34.65 11.59 46.24 200000
- select_many_fields 4.00 2.93 0.71 3.64 2000
- select_range 6.00 4.01 0.11 4.12 410
- select_range_key2 4.00 2.92 0.59 3.51 25010
- select_range_prefix 4.00 2.90 0.61 3.51 25010
- select_simple 18.00 3.25 4.56 7.81 100000
- select_simple_cache 17.00 3.38 4.23 7.61 100000
- select_simple_join 0.00 0.29 0.03 0.32 500
- update_big 14.00 0.01 0.00 0.01 10
- update_of_key 23.00 2.01 2.70 4.71 50000
- update_of_key_big 15.00 0.03 0.02 0.05 501
- update_of_primary_key_many_keys 32.00 0.01 0.02 0.03 256
- update_with_key 103.00 10.65 15.86 26.51 300000
- update_with_key_prefix 35.00 6.34 5.53 11.87 100000
- wisc_benchmark 2.00 1.17 0.14 1.31 114
- TOTALS 1941.00 445.83 187.84 633.67 3425950
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
