Created
April 6, 2009 02:45
-
-
Save arnaudsj/90618 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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