| MySQL FileSystems Benchmark | ||
|---|---|---|
| <<< Previous | ||
Benchmark DBD suite: 2.14 Date of test: 2003-08-14 15:45:36 Running tests on: Linux 2.4.20-4GB i686 Arguments: Comments: Limits from: Server version: MySQL 4.0.12 max log Optimization: None Hardware: alter-table: Total time: 8 wallclock secs ( 0.07 usr 0.01 sys + 0.00 cusr 0.00 csys = 0.08 CPU) ATIS: Total time: 26 wallclock secs (10.94 usr 1.08 sys + 0.00 cusr 0.00 csys = 12.02 CPU) big-tables: Total time: 18 wallclock secs ( 6.95 usr 2.18 sys + 0.00 cusr 0.00 csys = 9.13 CPU) connect: Total time: 107 wallclock secs (39.65 usr 9.13 sys + 0.00 cusr 0.00 csys = 48.78 CPU) create: Total time: 49 wallclock secs ( 4.43 usr 0.59 sys + 0.00 cusr 0.00 csys = 5.02 CPU) insert: Total time: 1305 wallclock secs (496.90 usr 44.66 sys + 0.00 cusr 0.00 csys = 541.56 CPU) select: Total time: 747 wallclock secs (59.23 usr 4.32 sys + 0.00 cusr 0.00 csys = 63.55 CPU) transactions: Test skipped because the database doesn't support transactions wisconsin: Total time: 9 wallclock secs ( 4.01 usr 0.36 sys + 0.00 cusr 0.00 csys = 4.37 CPU) All 9 test executed successfully Totals per operation: Operation seconds usr sys cpu tests alter_table_add 1.00 0.03 0.00 0.03 20 alter_table_drop 2.00 0.00 0.00 0.00 20 connect 5.00 3.52 0.37 3.89 10000 connect+select_1_row 7.00 4.06 0.44 4.50 10000 connect+select_simple 7.00 3.63 0.33 3.96 10000 count 24.00 0.05 0.00 0.05 100 count_distinct 18.00 0.23 0.01 0.24 1000 count_distinct_big 37.00 10.79 1.01 11.80 120 count_distinct_group 27.00 1.59 0.12 1.71 1000 count_distinct_group_on_key 24.00 0.29 0.04 0.33 1000 count_distinct_group_on_key_parts 26.00 2.81 0.04 2.85 1000 count_distinct_key_prefix 15.00 0.24 0.00 0.24 1000 count_group_on_key_parts 25.00 1.29 0.11 1.40 1000 count_on_key 253.00 10.16 0.63 10.79 50100 create+drop 12.00 1.32 0.16 1.48 10000 create_MANY_tables 14.00 0.91 0.10 1.01 10000 create_index 2.00 0.00 0.00 0.00 8 create_key+drop 14.00 1.60 0.13 1.73 10000 create_table 0.00 0.01 0.00 0.01 31 delete_all_many_keys 28.00 0.02 0.00 0.02 1 delete_big 0.00 0.00 0.00 0.00 1 delete_big_many_keys 28.00 0.02 0.00 0.02 128 delete_key 1.00 0.22 0.03 0.25 10000 delete_range 5.00 0.00 0.00 0.00 12 drop_index 2.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.28 0.08 0.36 10000 insert 49.00 7.87 2.02 9.89 350768 insert_duplicates 11.00 2.23 0.50 2.73 100000 insert_key 51.00 6.89 0.95 7.84 100000 insert_many_fields 5.00 0.29 0.03 0.32 2000 insert_select_1_key 3.00 0.00 0.00 0.00 1 insert_select_2_keys 4.00 0.00 0.00 0.00 1 min_max 13.00 0.01 0.00 0.01 60 min_max_on_key 102.00 14.99 0.78 15.77 85000 multiple_value_insert 3.00 0.39 0.01 0.40 100000 order_by_big 46.00 28.96 3.03 31.99 10 order_by_big_key 41.00 31.53 3.13 34.66 10 order_by_big_key2 37.00 29.12 3.00 32.12 10 order_by_big_key_desc 42.00 31.65 3.15 34.80 10 order_by_big_key_diff 43.00 29.04 3.09 32.13 10 order_by_big_key_prefix 39.00 28.87 3.17 32.04 10 order_by_key2_diff 4.00 2.50 0.24 2.74 500 order_by_key_prefix 2.00 1.21 0.17 1.38 500 order_by_range 3.00 1.52 0.12 1.64 500 outer_join 32.00 0.00 0.00 0.00 10 outer_join_found 29.00 0.00 0.00 0.00 10 outer_join_not_found 21.00 0.02 0.00 0.02 500 outer_join_on_key 23.00 0.00 0.00 0.00 10 select_1_row 12.00 3.24 1.09 4.33 100000 select_1_row_cache 11.00 3.10 1.23 4.33 100000 select_2_rows 13.00 3.31 1.35 4.66 100000 select_big 38.00 29.08 3.08 32.16 80 select_big_str 22.00 10.88 1.49 12.37 10000 select_cache 95.00 2.79 0.30 3.09 10000 select_cache2 96.00 3.01 0.26 3.27 10000 select_column+column 14.00 2.91 1.06 3.97 100000 select_diff_key 88.00 0.16 0.01 0.17 500 select_distinct 6.00 2.41 0.23 2.64 800 select_group 33.00 1.40 0.12 1.52 2911 select_group_when_MANY_tables 4.00 0.32 0.12 0.44 10000 select_join 1.00 0.64 0.08 0.72 100 select_key 65.00 38.89 2.83 41.72 200000 select_key2 69.00 38.73 2.64 41.37 200000 select_key2_return_key 65.00 37.56 1.73 39.29 200000 select_key2_return_prim 66.00 38.22 2.40 40.62 200000 select_key_prefix 68.00 38.31 2.69 41.00 200000 select_key_prefix_join 11.00 5.57 0.52 6.09 100 select_key_return_key 62.00 37.28 2.31 39.59 200000 select_many_fields 13.00 6.66 2.15 8.81 2000 select_range 75.00 13.16 1.02 14.18 410 select_range_key2 9.00 5.16 0.25 5.41 25010 select_range_prefix 11.00 4.66 0.34 5.00 25010 select_simple 8.00 2.41 0.92 3.33 100000 select_simple_cache 8.00 2.59 0.84 3.43 100000 select_simple_join 1.00 0.73 0.04 0.77 500 update_big 11.00 0.00 0.00 0.00 10 update_of_key 8.00 1.14 0.29 1.43 50000 update_of_key_big 9.00 0.01 0.00 0.01 501 update_of_primary_key_many_keys 20.00 0.04 0.01 0.05 256 update_with_key 33.00 5.76 2.01 7.77 300000 update_with_key_prefix 13.00 4.03 0.56 4.59 100000 wisc_benchmark 4.00 3.41 0.18 3.59 114 TOTALS 2247.00 607.73 61.14 668.87 3224799 |
Benchmark DBD suite: 2.14 Date of test: 2003-08-18 16:43:33 Running tests on: Linux 2.4.20-4GB i686 Arguments: Comments: Limits from: Server version: MySQL 4.0.12 max log Optimization: None Hardware: alter-table: Total time: 7 wallclock secs ( 0.05 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.05 CPU) ATIS: Total time: 27 wallclock secs (11.40 usr 1.01 sys + 0.00 cusr 0.00 csys = 12.41 CPU) big-tables: Total time: 19 wallclock secs ( 7.34 usr 1.95 sys + 0.00 cusr 0.00 csys = 9.29 CPU) connect: Total time: 108 wallclock secs (40.16 usr 10.40 sys + 0.00 cusr 0.00 csys = 50.56 CPU) create: Total time: 106 wallclock secs ( 4.93 usr 0.66 sys + 0.00 cusr 0.00 csys = 5.59 CPU) insert: Total time: 1288 wallclock secs (493.13 usr 44.75 sys + 0.00 cusr 0.00 csys = 537.88 CPU) select: Total time: 750 wallclock secs (56.95 usr 4.63 sys + 0.00 cusr 0.00 csys = 61.58 CPU) transactions: Test skipped because the database doesn't support transactions wisconsin: Total time: 10 wallclock secs ( 4.16 usr 0.27 sys + 0.00 cusr 0.00 csys = 4.43 CPU) All 9 test executed successfully Totals per operation: Operation seconds usr sys cpu tests alter_table_add 2.00 0.01 0.00 0.01 20 alter_table_drop 2.00 0.01 0.00 0.01 20 connect 5.00 3.57 0.28 3.85 10000 connect+select_1_row 8.00 4.17 0.58 4.75 10000 connect+select_simple 6.00 3.60 0.50 4.10 10000 count 23.00 0.04 0.01 0.05 100 count_distinct 18.00 0.27 0.02 0.29 1000 count_distinct_big 39.00 10.78 1.21 11.99 120 count_distinct_group 30.00 1.56 0.15 1.71 1000 count_distinct_group_on_key 23.00 0.31 0.01 0.32 1000 count_distinct_group_on_key_parts 31.00 1.45 0.14 1.59 1000 count_distinct_key_prefix 15.00 0.20 0.04 0.24 1000 count_group_on_key_parts 25.00 0.56 0.15 0.71 1000 count_on_key 254.00 10.36 0.61 10.97 50100 create+drop 12.00 1.07 0.20 1.27 10000 create_MANY_tables 38.00 1.42 0.08 1.50 10000 create_index 2.00 0.00 0.00 0.00 8 create_key+drop 12.00 1.53 0.22 1.75 10000 create_table 0.00 0.00 0.00 0.00 31 delete_all_many_keys 29.00 0.04 0.00 0.04 1 delete_big 0.00 0.00 0.00 0.00 1 delete_big_many_keys 29.00 0.04 0.00 0.04 128 delete_key 1.00 0.20 0.09 0.29 10000 delete_range 5.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 40.00 0.52 0.08 0.60 10000 insert 45.00 7.93 1.66 9.59 350768 insert_duplicates 11.00 1.94 0.61 2.55 100000 insert_key 50.00 6.32 0.85 7.17 100000 insert_many_fields 5.00 0.31 0.01 0.32 2000 insert_select_1_key 3.00 0.00 0.00 0.00 1 insert_select_2_keys 4.00 0.00 0.00 0.00 1 min_max 14.00 0.04 0.00 0.04 60 min_max_on_key 103.00 15.10 0.77 15.87 85000 multiple_value_insert 2.00 0.42 0.01 0.43 100000 order_by_big 47.00 28.94 3.07 32.01 10 order_by_big_key 41.00 31.43 3.27 34.70 10 order_by_big_key2 37.00 29.06 3.11 32.17 10 order_by_big_key_desc 42.00 31.86 2.97 34.83 10 order_by_big_key_diff 45.00 29.22 3.04 32.26 10 order_by_big_key_prefix 39.00 29.08 3.01 32.09 10 order_by_key2_diff 3.00 2.56 0.23 2.79 500 order_by_key_prefix 2.00 1.27 0.14 1.41 500 order_by_range 3.00 1.42 0.16 1.58 500 outer_join 33.00 0.00 0.00 0.00 10 outer_join_found 31.00 0.01 0.01 0.02 10 outer_join_not_found 22.00 0.00 0.00 0.00 500 outer_join_on_key 23.00 0.00 0.00 0.00 10 select_1_row 12.00 3.20 1.35 4.55 100000 select_1_row_cache 11.00 2.76 1.23 3.99 100000 select_2_rows 14.00 3.23 1.56 4.79 100000 select_big 38.00 29.02 3.19 32.21 80 select_big_str 22.00 10.99 1.67 12.66 10000 select_cache 92.00 2.66 0.18 2.84 10000 select_cache2 92.00 2.84 0.20 3.04 10000 select_column+column 14.00 2.91 1.25 4.16 100000 select_diff_key 88.00 0.25 0.01 0.26 500 select_distinct 7.00 2.41 0.18 2.59 800 select_group 32.00 1.49 0.18 1.67 2911 select_group_when_MANY_tables 4.00 0.39 0.08 0.47 10000 select_join 2.00 0.68 0.04 0.72 100 select_key 63.00 37.69 2.72 40.41 200000 select_key2 68.00 38.02 2.76 40.78 200000 select_key2_return_key 65.00 36.30 2.21 38.51 200000 select_key2_return_prim 66.00 38.31 2.44 40.75 200000 select_key_prefix 68.00 38.26 2.58 40.84 200000 select_key_prefix_join 10.00 5.67 0.48 6.15 100 select_key_return_key 62.00 36.60 2.23 38.83 200000 select_many_fields 14.00 7.02 1.94 8.96 2000 select_range 76.00 13.20 1.20 14.40 410 select_range_key2 11.00 4.93 0.39 5.32 25010 select_range_prefix 11.00 4.79 0.31 5.10 25010 select_simple 8.00 3.11 0.97 4.08 100000 select_simple_cache 8.00 2.62 1.00 3.62 100000 select_simple_join 1.00 0.78 0.06 0.84 500 update_big 13.00 0.00 0.00 0.00 10 update_of_key 8.00 1.32 0.25 1.57 50000 update_of_key_big 10.00 0.00 0.01 0.01 501 update_of_primary_key_many_keys 12.00 0.03 0.00 0.03 256 update_with_key 31.00 6.02 1.79 7.81 300000 update_with_key_prefix 12.00 4.12 0.62 4.74 100000 wisc_benchmark 5.00 3.44 0.19 3.63 114 TOTALS 2305.00 603.68 62.56 666.24 3224799 |
Benchmark DBD suite: 2.14 Date of test: 2003-08-14 16:27:50 Running tests on: Linux 2.4.20-4GB i686 Arguments: Comments: Limits from: Server version: MySQL 4.0.12 max log Optimization: None Hardware: alter-table: Total time: 14 wallclock secs ( 0.01 usr 0.01 sys + 0.00 cusr 0.00 csys = 0.02 CPU) ATIS: Total time: 28 wallclock secs (11.51 usr 0.89 sys + 0.00 cusr 0.00 csys = 12.40 CPU) big-tables: Total time: 18 wallclock secs ( 7.00 usr 2.10 sys + 0.00 cusr 0.00 csys = 9.10 CPU) connect: Total time: 106 wallclock secs (41.59 usr 9.56 sys + 0.00 cusr 0.00 csys = 51.15 CPU) create: Total time: 639 wallclock secs ( 4.78 usr 0.59 sys + 0.00 cusr 0.00 csys = 5.37 CPU) insert: Total time: 2406 wallclock secs (488.88 usr 43.89 sys + 0.00 cusr 0.00 csys = 532.77 CPU) select: Total time: 741 wallclock secs (57.59 usr 4.01 sys + 0.00 cusr 0.00 csys = 61.60 CPU) transactions: Test skipped because the database doesn't support transactions wisconsin: Total time: 9 wallclock secs ( 4.08 usr 0.35 sys + 0.00 cusr 0.00 csys = 4.43 CPU) All 9 test executed successfully Totals per operation: Operation seconds usr sys cpu tests alter_table_add 3.00 0.00 0.00 0.00 20 alter_table_drop 3.00 0.00 0.01 0.01 20 connect 5.00 3.64 0.31 3.95 10000 connect+select_1_row 8.00 4.42 0.51 4.93 10000 connect+select_simple 6.00 4.05 0.48 4.53 10000 count 23.00 0.07 0.00 0.07 100 count_distinct 18.00 0.25 0.03 0.28 1000 count_distinct_big 37.00 10.75 1.01 11.76 120 count_distinct_group 27.00 1.29 0.07 1.36 1000 count_distinct_group_on_key 23.00 0.44 0.02 0.46 1000 count_distinct_group_on_key_parts 27.00 1.56 0.11 1.67 1000 count_distinct_key_prefix 15.00 0.20 0.00 0.20 1000 count_group_on_key_parts 25.00 1.30 0.08 1.38 1000 count_on_key 253.00 9.71 0.63 10.34 50100 create+drop 184.00 1.52 0.10 1.62 10000 create_MANY_tables 181.00 1.25 0.08 1.33 10000 create_index 4.00 0.00 0.00 0.00 8 create_key+drop 184.00 1.31 0.22 1.53 10000 create_table 1.00 0.00 0.00 0.00 31 delete_all_many_keys 30.00 0.00 0.01 0.01 1 delete_big 0.00 0.00 0.00 0.00 1 delete_big_many_keys 29.00 0.00 0.01 0.01 128 delete_key 1.00 0.24 0.03 0.27 10000 delete_range 5.00 0.00 0.01 0.01 12 drop_index 3.00 0.00 0.00 0.00 8 drop_table 1.00 0.00 0.00 0.00 28 drop_table_when_MANY_tables 88.00 0.36 0.10 0.46 10000 insert 58.00 7.40 1.95 9.35 350768 insert_duplicates 9.00 2.21 0.53 2.74 100000 insert_key 1079.00 6.32 0.78 7.10 100000 insert_many_fields 5.00 0.29 0.01 0.30 2000 insert_select_1_key 3.00 0.00 0.00 0.00 1 insert_select_2_keys 4.00 0.00 0.00 0.00 1 min_max 14.00 0.04 0.01 0.05 60 min_max_on_key 103.00 14.63 0.85 15.48 85000 multiple_value_insert 3.00 0.40 0.01 0.41 100000 order_by_big 46.00 29.09 2.93 32.02 10 order_by_big_key 41.00 31.43 3.29 34.72 10 order_by_big_key2 37.00 29.01 3.05 32.06 10 order_by_big_key_desc 43.00 31.44 3.18 34.62 10 order_by_big_key_diff 44.00 29.04 3.24 32.28 10 order_by_big_key_prefix 38.00 29.04 3.00 32.04 10 order_by_key2_diff 3.00 2.53 0.18 2.71 500 order_by_key_prefix 2.00 1.35 0.11 1.46 500 order_by_range 3.00 1.57 0.17 1.74 500 outer_join 31.00 0.02 0.00 0.02 10 outer_join_found 29.00 0.01 0.00 0.01 10 outer_join_not_found 21.00 0.01 0.00 0.01 500 outer_join_on_key 24.00 0.00 0.00 0.00 10 select_1_row 12.00 3.18 1.19 4.37 100000 select_1_row_cache 11.00 2.89 1.15 4.04 100000 select_2_rows 14.00 3.37 1.37 4.74 100000 select_big 38.00 29.45 2.85 32.30 80 select_big_str 22.00 11.87 1.35 13.22 10000 select_cache 93.00 3.07 0.12 3.19 10000 select_cache2 93.00 3.06 0.16 3.22 10000 select_column+column 13.00 2.80 1.31 4.11 100000 select_diff_key 88.00 0.24 0.02 0.26 500 select_distinct 6.00 2.40 0.18 2.58 800 select_group 32.00 1.61 0.09 1.70 2911 select_group_when_MANY_tables 2.00 0.34 0.09 0.43 10000 select_join 1.00 0.69 0.03 0.72 100 select_key 62.00 37.05 2.53 39.58 200000 select_key2 67.00 37.93 2.57 40.50 200000 select_key2_return_key 64.00 36.15 2.07 38.22 200000 select_key2_return_prim 65.00 37.34 1.86 39.20 200000 select_key_prefix 68.00 38.43 2.63 41.06 200000 select_key_prefix_join 11.00 5.71 0.48 6.19 100 select_key_return_key 60.00 35.92 2.49 38.41 200000 select_many_fields 13.00 6.71 2.09 8.80 2000 select_range 73.00 13.19 1.06 14.25 410 select_range_key2 9.00 4.69 0.35 5.04 25010 select_range_prefix 11.00 4.64 0.27 4.91 25010 select_simple 8.00 2.80 1.04 3.84 100000 select_simple_cache 7.00 2.55 0.85 3.40 100000 select_simple_join 1.00 0.79 0.05 0.84 500 update_big 10.00 0.00 0.00 0.00 10 update_of_key 7.00 1.10 0.35 1.45 50000 update_of_key_big 10.00 0.00 0.00 0.00 501 update_of_primary_key_many_keys 101.00 0.00 0.00 0.00 256 update_with_key 29.00 5.36 1.57 6.93 300000 update_with_key_prefix 13.00 3.95 0.69 4.64 100000 wisc_benchmark 5.00 3.39 0.19 3.58 114 TOTALS 3943.00 600.86 60.16 661.02 3224799 |
Benchmark DBD suite: 2.14 Date of test: 2003-08-18 15:40:40 Running tests on: Linux 2.4.20-4GB i686 Arguments: Comments: Limits from: Server version: MySQL 4.0.12 max log Optimization: None Hardware: alter-table: Total time: 8 wallclock secs ( 0.05 usr 0.01 sys + 0.00 cusr 0.00 csys = 0.06 CPU) ATIS: Total time: 27 wallclock secs (11.31 usr 1.12 sys + 0.00 cusr 0.00 csys = 12.43 CPU) big-tables: Total time: 19 wallclock secs ( 7.37 usr 2.14 sys + 0.00 cusr 0.00 csys = 9.51 CPU) connect: Total time: 106 wallclock secs (42.63 usr 9.06 sys + 0.00 cusr 0.00 csys = 51.69 CPU) create: Total time: 134 wallclock secs ( 4.77 usr 0.45 sys + 0.00 cusr 0.00 csys = 5.22 CPU) insert: Total time: 1819 wallclock secs (504.13 usr 43.81 sys + 0.00 cusr 0.00 csys = 547.94 CPU) select: Total time: 745 wallclock secs (60.16 usr 4.38 sys + 0.00 cusr 0.00 csys = 64.54 CPU) transactions: Test skipped because the database doesn't support transactions wisconsin: Total time: 9 wallclock secs ( 4.19 usr 0.40 sys + 0.00 cusr 0.00 csys = 4.59 CPU) All 9 test executed successfully Totals per operation: Operation seconds usr sys cpu tests alter_table_add 2.00 0.00 0.01 0.01 20 alter_table_drop 2.00 0.01 0.00 0.01 20 connect 5.00 3.54 0.41 3.95 10000 connect+select_1_row 7.00 3.85 0.49 4.34 10000 connect+select_simple 6.00 4.37 0.43 4.80 10000 count 24.00 0.03 0.00 0.03 100 count_distinct 18.00 0.30 0.03 0.33 1000 count_distinct_big 37.00 10.76 1.04 11.80 120 count_distinct_group 27.00 1.99 0.11 2.10 1000 count_distinct_group_on_key 23.00 0.31 0.01 0.32 1000 count_distinct_group_on_key_parts 27.00 1.33 0.14 1.47 1000 count_distinct_key_prefix 15.00 0.26 0.02 0.28 1000 count_group_on_key_parts 25.00 1.37 0.11 1.48 1000 count_on_key 254.00 10.37 0.55 10.92 50100 create+drop 10.00 1.09 0.08 1.17 10000 create_MANY_tables 105.00 1.70 0.15 1.85 10000 create_index 2.00 0.01 0.00 0.01 8 create_key+drop 13.00 1.46 0.10 1.56 10000 create_table 0.00 0.01 0.00 0.01 31 delete_all_many_keys 131.00 0.01 0.01 0.02 1 delete_big 0.00 0.00 0.00 0.00 1 delete_big_many_keys 131.00 0.01 0.01 0.02 128 delete_key 1.00 0.31 0.07 0.38 10000 delete_range 8.00 0.00 0.00 0.00 12 drop_index 2.00 0.00 0.00 0.00 8 drop_table 0.00 0.00 0.00 0.00 28 drop_table_when_MANY_tables 3.00 0.18 0.04 0.22 10000 insert 46.00 7.67 1.72 9.39 350768 insert_duplicates 12.00 2.17 0.60 2.77 100000 insert_key 420.00 7.25 0.85 8.10 100000 insert_many_fields 5.00 0.27 0.05 0.32 2000 insert_select_1_key 3.00 0.00 0.00 0.00 1 insert_select_2_keys 4.00 0.00 0.00 0.00 1 min_max 13.00 0.03 0.00 0.03 60 min_max_on_key 104.00 16.16 0.89 17.05 85000 multiple_value_insert 2.00 0.40 0.01 0.41 100000 order_by_big 46.00 29.20 2.82 32.02 10 order_by_big_key 41.00 31.55 3.03 34.58 10 order_by_big_key2 37.00 28.94 3.01 31.95 10 order_by_big_key_desc 42.00 31.67 3.00 34.67 10 order_by_big_key_diff 43.00 29.06 2.95 32.01 10 order_by_big_key_prefix 39.00 28.93 2.97 31.90 10 order_by_key2_diff 3.00 2.49 0.24 2.73 500 order_by_key_prefix 2.00 1.33 0.12 1.45 500 order_by_range 3.00 1.46 0.11 1.57 500 outer_join 31.00 0.01 0.00 0.01 10 outer_join_found 28.00 0.00 0.00 0.00 10 outer_join_not_found 21.00 0.01 0.00 0.01 500 outer_join_on_key 23.00 0.01 0.00 0.01 10 select_1_row 12.00 3.46 1.17 4.63 100000 select_1_row_cache 11.00 2.99 0.96 3.95 100000 select_2_rows 14.00 3.86 1.28 5.14 100000 select_big 38.00 29.19 2.98 32.17 80 select_big_str 22.00 11.74 1.34 13.08 10000 select_cache 94.00 2.95 0.28 3.23 10000 select_cache2 94.00 3.29 0.16 3.45 10000 select_column+column 13.00 3.16 1.11 4.27 100000 select_diff_key 88.00 0.26 0.02 0.28 500 select_distinct 6.00 2.42 0.21 2.63 800 select_group 33.00 1.62 0.12 1.74 2911 select_group_when_MANY_tables 3.00 0.33 0.08 0.41 10000 select_join 2.00 0.65 0.09 0.74 100 select_key 66.00 40.03 2.54 42.57 200000 select_key2 70.00 39.18 2.64 41.82 200000 select_key2_return_key 66.00 39.58 2.01 41.59 200000 select_key2_return_prim 68.00 37.93 2.09 40.02 200000 select_key_prefix 70.00 40.00 2.89 42.89 200000 select_key_prefix_join 10.00 5.64 0.59 6.23 100 select_key_return_key 64.00 38.80 2.40 41.20 200000 select_many_fields 14.00 7.09 2.09 9.18 2000 select_range 73.00 13.45 1.06 14.51 410 select_range_key2 11.00 4.73 0.43 5.16 25010 select_range_prefix 11.00 4.81 0.35 5.16 25010 select_simple 8.00 3.08 0.98 4.06 100000 select_simple_cache 8.00 2.58 0.89 3.47 100000 select_simple_join 1.00 0.80 0.04 0.84 500 update_big 16.00 0.01 0.00 0.01 10 update_of_key 9.00 1.10 0.23 1.33 50000 update_of_key_big 13.00 0.01 0.00 0.01 501 update_of_primary_key_many_keys 55.00 0.03 0.00 0.03 256 update_with_key 33.00 5.84 2.10 7.94 300000 update_with_key_prefix 13.00 4.20 0.71 4.91 100000 wisc_benchmark 5.00 3.45 0.20 3.65 114 TOTALS 2960.00 620.14 60.22 680.36 3224799 |
This is the result file of the different benchmark tests.
The number in () after each tests shows how many SQL commands the particular
test did. As one test may have many different parameters this gives only
a rough picture of what was done. Check the source for more information :)
Keep in mind that one can't compare benchmarks run with different --cmp
options. The --cmp options sets the all limits according to the worst
limit for all server in the benchmark.
Numbers marked with '+' are estimated according to previous runs because
the query took longer than a given time-limit to finish. The estimation
shouldn't be far from the real result thought.
Numbers marked with '?' contains results that gave wrong result. This can only
be used as an indication of how long it took for the server to produce a wrong
result :)
Numbers marked with '*' are tests that was run a different number times
than the test in the first column. The reason for this is normally that the
marked test was run with different options that affects the number of tests
or that the test was from another version of the MySQL benchmarks.
Hope this will give you some idea how each db is performing at what thing ....
Hope you like it .... Luuk & Monty (1997)
The result logs which where found and the options:
1 mysql-EXT3 : MySQL 4.0.12 max log
2 mysql-JFS : MySQL 4.0.12 max log
3 mysql-ReiserFS : MySQL 4.0.12 max log
4 mysql-XFS : MySQL 4.0.12 max log
=====================================================================
Operation | 1| 2| 3| 4|
|mysql-E|mysql-J|mysql-R|mysql-X|
---------------------------------------------------------------------
Results per test in seconds: |
---------------------------------------------------------------------
ATIS | 27.00| 28.00| 26.00| 27.00|
alter-table | 8.00| 14.00| 8.00| 7.00|
big-tables | 19.00| 18.00| 18.00| 19.00|
connect | 106.00| 106.00| 107.00| 108.00|
create | 134.00| 639.00| 49.00| 106.00|
insert |1819.00|2406.00|1305.00|1288.00|
select | 745.00| 741.00| 747.00| 750.00|
wisconsin | 9.00| 9.00| 9.00| 10.00|
---------------------------------------------------------------------
The results per operation: |
---------------------------------------------------------------------
alter_table_add (20) | 2.00| 3.00| 1.00| 2.00|
alter_table_drop (20) | 2.00| 3.00| 2.00| 2.00|
connect (10000) | 5.00| 5.00| 5.00| 5.00|
connect+select_1_row (10000) | 7.00| 8.00| 7.00| 8.00|
connect+select_simple (10000) | 6.00| 6.00| 7.00| 6.00|
count (100) | 24.00| 23.00| 24.00| 23.00|
count_distinct (1000) | 18.00| 18.00| 18.00| 18.00|
count_distinct_big (120) | 37.00| 37.00| 37.00| 39.00|
count_distinct_group (1000) | 27.00| 27.00| 27.00| 30.00|
count_distinct_group_on_key (1000) | 23.00| 23.00| 24.00| 23.00|
count_distinct_group_on_key_parts (1| 27.00| 27.00| 26.00| 31.00|
count_distinct_key_prefix (1000) | 15.00| 15.00| 15.00| 15.00|
count_group_on_key_parts (1000) | 25.00| 25.00| 25.00| 25.00|
count_on_key (50100) | 254.00| 253.00| 253.00| 254.00|
create+drop (10000) | 10.00| 184.00| 12.00| 12.00|
create_MANY_tables (10000) | 105.00| 181.00| 14.00| 38.00|
create_index (8) | 2.00| 4.00| 2.00| 2.00|
create_key+drop (10000) | 13.00| 184.00| 14.00| 12.00|
create_table (31) | 0.00| 1.00| 0.00| 0.00|
delete_all_many_keys (1) | 131.00| 30.00| 28.00| 29.00|
delete_big (1) | 0.00| 0.00| 0.00| 0.00|
delete_big_many_keys (128) | 131.00| 29.00| 28.00| 29.00|
delete_key (10000) | 1.00| 1.00| 1.00| 1.00|
delete_range (12) | 8.00| 5.00| 5.00| 5.00|
drop_index (8) | 2.00| 3.00| 2.00| 1.00|
drop_table (28) | 0.00| 1.00| 0.00| 0.00|
drop_table_when_MANY_tables (10000) | 3.00| 88.00| 5.00| 40.00|
insert (350768) | 46.00| 58.00| 49.00| 45.00|
insert_duplicates (100000) | 12.00| 9.00| 11.00| 11.00|
insert_key (100000) | 420.00|1079.00| 51.00| 50.00|
insert_many_fields (2000) | 5.00| 5.00| 5.00| 5.00|
insert_select_1_key (1) | 3.00| 3.00| 3.00| 3.00|
insert_select_2_keys (1) | 4.00| 4.00| 4.00| 4.00|
min_max (60) | 13.00| 14.00| 13.00| 14.00|
min_max_on_key (85000) | 104.00| 103.00| 102.00| 103.00|
multiple_value_insert (100000) | 2.00| 3.00| 3.00| 2.00|
order_by_big (10) | 46.00| 46.00| 46.00| 47.00|
order_by_big_key (10) | 41.00| 41.00| 41.00| 41.00|
order_by_big_key2 (10) | 37.00| 37.00| 37.00| 37.00|
order_by_big_key_desc (10) | 42.00| 43.00| 42.00| 42.00|
order_by_big_key_diff (10) | 43.00| 44.00| 43.00| 45.00|
order_by_big_key_prefix (10) | 39.00| 38.00| 39.00| 39.00|
order_by_key2_diff (500) | 3.00| 3.00| 4.00| 3.00|
order_by_key_prefix (500) | 2.00| 2.00| 2.00| 2.00|
order_by_range (500) | 3.00| 3.00| 3.00| 3.00|
outer_join (10) | 31.00| 31.00| 32.00| 33.00|
outer_join_found (10) | 28.00| 29.00| 29.00| 31.00|
outer_join_not_found (500) | 21.00| 21.00| 21.00| 22.00|
outer_join_on_key (10) | 23.00| 24.00| 23.00| 23.00|
select_1_row (100000) | 12.00| 12.00| 12.00| 12.00|
select_1_row_cache (100000) | 11.00| 11.00| 11.00| 11.00|
select_2_rows (100000) | 14.00| 14.00| 13.00| 14.00|
select_big (80) | 38.00| 38.00| 38.00| 38.00|
select_big_str (10000) | 22.00| 22.00| 22.00| 22.00|
select_cache (10000) | 94.00| 93.00| 95.00| 92.00|
select_cache2 (10000) | 94.00| 93.00| 96.00| 92.00|
select_column+column (100000) | 13.00| 13.00| 14.00| 14.00|
select_diff_key (500) | 88.00| 88.00| 88.00| 88.00|
select_distinct (800) | 6.00| 6.00| 6.00| 7.00|
select_group (2911) | 33.00| 32.00| 33.00| 32.00|
select_group_when_MANY_tables (10000| 3.00| 2.00| 4.00| 4.00|
select_join (100) | 2.00| 1.00| 1.00| 2.00|
select_key (200000) | 66.00| 62.00| 65.00| 63.00|
select_key2 (200000) | 70.00| 67.00| 69.00| 68.00|
select_key2_return_key (200000) | 66.00| 64.00| 65.00| 65.00|
select_key2_return_prim (200000) | 68.00| 65.00| 66.00| 66.00|
select_key_prefix (200000) | 70.00| 68.00| 68.00| 68.00|
select_key_prefix_join (100) | 10.00| 11.00| 11.00| 10.00|
select_key_return_key (200000) | 64.00| 60.00| 62.00| 62.00|
select_many_fields (2000) | 14.00| 13.00| 13.00| 14.00|
select_range (410) | 73.00| 73.00| 75.00| 76.00|
select_range_key2 (25010) | 11.00| 9.00| 9.00| 11.00|
select_range_prefix (25010) | 11.00| 11.00| 11.00| 11.00|
select_simple (100000) | 8.00| 8.00| 8.00| 8.00|
select_simple_cache (100000) | 8.00| 7.00| 8.00| 8.00|
select_simple_join (500) | 1.00| 1.00| 1.00| 1.00|
update_big (10) | 16.00| 10.00| 11.00| 13.00|
update_of_key (50000) | 9.00| 7.00| 8.00| 8.00|
update_of_key_big (501) | 13.00| 10.00| 9.00| 10.00|
update_of_primary_key_many_keys (256| 55.00| 101.00| 20.00| 12.00|
update_with_key (300000) | 33.00| 29.00| 33.00| 31.00|
update_with_key_prefix (100000) | 13.00| 13.00| 13.00| 12.00|
wisc_benchmark (114) | 5.00| 5.00| 4.00| 5.00|
---------------------------------------------------------------------
TOTALS |2960.00|3943.00|2247.00|2305.00|
===================================================================== |
| <<< Previous | Home | |
| MySQL 3.23.55 |