======================================================================================= SQLBENCH REPORT ======================================================================================= ENGINE: innodb MACHINE: orisndriz05 RUN ID: 758 RUN DATE: 2010-12-22T11:27:36.096029 SERVER: drizzled VERSION: staging REVISION: 2019 COMMENT: 2019: Brian Aker 2010-12-22 Merge in change to allow for SQL Server style patterns.
========================================================================================================================= TRENDING OVER LAST 5 runs Engine Test Time % Diff from Avg Diff Min Max Avg STD ========================================================================================================================= innodb alter_table_add 18.00 +40.79% 12.40 18.00 41.00 30.40 8.26 innodb alter_table_drop 16.00 +34.96% 8.60 16.00 35.00 24.60 7.17 innodb connect 2.00 -0.00% 0.00 2.00 2.00 2.00 0.00 innodb connect+select_1_row 3.00 -0.00% 0.00 3.00 3.00 3.00 0.00 innodb connect+select_simple 3.00 -25.00% -0.60 2.00 3.00 2.40 0.49 innodb count 18.00 -7.14% -1.20 14.00 18.00 16.80 1.47 innodb count_distinct 7.00 -2.94% -0.20 6.00 7.00 6.80 0.40 innodb count_distinct_2 13.00 +8.45% 1.20 12.00 16.00 14.20 1.60 innodb count_distinct_big 23.00 +0.86% 0.20 21.00 24.00 23.20 1.17 innodb count_distinct_group 15.00 +1.32% 0.20 14.00 17.00 15.20 0.98 innodb count_distinct_group_on_key 11.00 -7.84% -0.80 9.00 11.00 10.20 0.75 innodb count_distinct_group_on_key_parts 15.00 -4.17% -0.60 14.00 15.00 14.40 0.49 innodb count_distinct_key_prefix 5.00 +3.85% 0.20 5.00 6.00 5.20 0.40 innodb count_group_on_key_parts 11.00 -1.85% -0.20 10.00 11.00 10.80 0.40 innodb count_on_key 94.00 +1.26% 1.20 91.00 100.00 95.20 3.06 innodb create+drop 33.00 +30.96% 14.80 33.00 62.00 47.80 12.22 innodb create_index 3.00 +25.00% 1.00 3.00 6.00 4.00 1.26 innodb create_key+drop 28.00 +10.26% 3.20 28.00 36.00 31.20 2.79 innodb create_MANY_tables 22.00 +42.11% 16.00 22.00 56.00 38.00 12.21 innodb create_table 0.00 +100.00% 0.20 0.00 1.00 0.20 0.40 innodb delete_all_many_keys 276.00 +62.12% 452.60 276.00 1357.00 728.60 509.29 innodb delete_autocommit 3.00 +6.25% 0.20 3.00 4.00 3.20 0.40 innodb delete_big 1.00 -150.00% -0.60 0.00 1.00 0.40 0.49 innodb delete_big_many_keys 276.00 +62.09% 452.00 276.00 1356.00 728.00 508.93 innodb delete_commit 2.00 -0.00% 0.00 2.00 2.00 2.00 0.00 innodb delete_key 3.00 +6.25% 0.20 2.00 5.00 3.20 1.17 innodb delete_range 8.00 +36.51% 4.60 8.00 19.00 12.60 4.03 innodb delete_rollback 2.00 -0.00% 0.00 2.00 2.00 2.00 0.00 innodb drop_index 2.00 +47.37% 1.80 2.00 7.00 3.80 1.83 innodb drop_table 0.00 +100.00% 0.20 0.00 1.00 0.20 0.40 innodb drop_table_when_MANY_tables 16.00 +32.20% 7.60 16.00 33.00 23.60 6.83 innodb insert 112.00 +3.11% 3.60 112.00 123.00 115.60 4.08 innodb insert_autocommit 3.00 +11.76% 0.40 3.00 4.00 3.40 0.49 innodb insert_commit 1.00 +37.50% 0.60 1.00 2.00 1.60 0.49 innodb insert_duplicates 19.00 -0.00% 0.00 18.00 20.00 19.00 0.63 innodb insert_key 181.00 +56.36% 233.80 181.00 706.00 414.80 228.53 innodb insert_many_fields 6.00 +16.67% 1.20 5.00 11.00 7.20 2.14 innodb insert_rollback 2.00 -0.00% 0.00 2.00 2.00 2.00 0.00 innodb insert_select_1_key 3.00 +21.05% 0.80 3.00 5.00 3.80 0.98 innodb insert_select_2_keys 6.00 +30.23% 2.60 6.00 11.00 8.60 1.85 innodb min_max 9.00 -9.76% -0.80 7.00 9.00 8.20 0.75 innodb min_max_on_key 24.00 +1.64% 0.40 24.00 25.00 24.40 0.49 innodb multiple_value_insert 3.00 +55.88% 3.80 3.00 12.00 6.80 4.26 innodb once_prepared_select 30.00 -1.35% -0.40 29.00 30.00 29.60 0.49 innodb order_by_big 16.00 -15.94% -2.20 12.00 16.00 13.80 1.47 innodb order_by_big_key 13.00 -4.84% -0.60 11.00 14.00 12.40 1.20 innodb order_by_big_key2 13.00 -16.07% -1.80 10.00 13.00 11.20 0.98 innodb order_by_big_key_desc 15.00 -13.64% -1.80 12.00 15.00 13.20 1.17 innodb order_by_big_key_diff 12.00 -5.26% -0.60 10.00 13.00 11.40 1.02 innodb order_by_big_key_prefix 14.00 -20.69% -2.40 11.00 14.00 11.60 1.20 innodb order_by_key2_diff 1.00 +37.50% 0.60 1.00 2.00 1.60 0.49 innodb order_by_key_prefix 1.00 -66.67% -0.40 0.00 1.00 0.60 0.49 innodb order_by_range 1.00 -0.00% 0.00 1.00 1.00 1.00 0.00 innodb outer_join 23.00 -6.48% -1.40 18.00 23.00 21.60 1.85 innodb outer_join_found 22.00 -5.77% -1.20 18.00 22.00 20.80 1.47 innodb outer_join_not_found 19.00 -0.00% 0.00 17.00 20.00 19.00 1.10 innodb outer_join_on_key 14.00 +1.41% 0.20 13.00 15.00 14.20 0.75 innodb prepared_select 38.00 -0.53% -0.20 37.00 39.00 37.80 0.75 innodb select_1_row 4.00 -17.65% -0.60 3.00 4.00 3.40 0.49 innodb select_1_row_cache 3.00 +16.67% 0.60 3.00 4.00 3.60 0.49 innodb select_2_rows 4.00 -0.00% 0.00 4.00 4.00 4.00 0.00 innodb select_big 11.00 +9.84% 1.20 11.00 13.00 12.20 0.98 innodb select_big_str 1.00 +28.57% 0.40 1.00 2.00 1.40 0.49 innodb select_cache 64.00 +0.93% 0.60 62.00 69.00 64.60 2.33 innodb select_cache2 64.00 +2.74% 1.80 62.00 70.00 65.80 2.71 innodb select_column+column 4.00 -11.11% -0.40 3.00 4.00 3.60 0.49 innodb select_distinct 5.00 -19.05% -0.80 4.00 5.00 4.20 0.40 innodb select_group 19.00 -13.10% -2.20 15.00 19.00 16.80 1.47 innodb select_group_when_MANY_tables 13.00 +50.76% 13.40 13.00 40.00 26.40 9.65 innodb select_join 0.00 +100.00% 0.80 0.00 1.00 0.80 0.40 innodb select_key 65.00 -0.62% -0.40 64.00 66.00 64.60 0.80 innodb select_key2 72.00 -0.00% 0.00 71.00 74.00 72.00 1.10 innodb select_key2_return_key 69.00 -0.58% -0.40 67.00 70.00 68.60 1.02 innodb select_key2_return_prim 70.00 -0.29% -0.20 68.00 72.00 69.80 1.33 innodb select_key_prefix 72.00 -0.56% -0.40 70.00 74.00 71.60 1.36 innodb select_key_prefix_join 5.00 -0.00% 0.00 5.00 5.00 5.00 0.00 innodb select_key_return_key 63.00 +0.32% 0.20 62.00 65.00 63.20 0.98 innodb select_many_fields 13.00 +7.14% 1.00 13.00 16.00 14.00 1.26 innodb select_range 42.00 -2.94% -1.20 39.00 43.00 40.80 1.47 innodb select_range_key2 10.00 -2.04% -0.20 9.00 10.00 9.80 0.40 innodb select_range_prefix 9.00 +2.17% 0.20 9.00 10.00 9.20 0.40 innodb select_simple 2.00 +23.08% 0.60 2.00 3.00 2.60 0.49 innodb select_simple_cache 2.00 -0.00% 0.00 2.00 2.00 2.00 0.00 innodb select_simple_join 1.00 -0.00% 0.00 1.00 1.00 1.00 0.00 innodb update_autocommit 4.00 -11.11% -0.40 3.00 4.00 3.60 0.49 innodb update_big 70.00 +28.72% 28.20 62.00 141.00 98.20 30.40 innodb update_commit 2.00 -0.00% 0.00 2.00 2.00 2.00 0.00 innodb update_of_key 21.00 +2.78% 0.60 21.00 24.00 21.60 1.20 innodb update_of_key_big 39.00 +8.88% 3.80 34.00 54.00 42.80 7.47 innodb update_of_primary_key_many_keys 666.00 +58.25% 929.40 666.00 2909.00 1595.40 1,042.32 innodb update_rollback 2.00 +9.09% 0.20 2.00 3.00 2.20 0.40 innodb update_with_key 118.00 +3.28% 4.00 113.00 134.00 122.00 7.29 innodb update_with_key_prefix 41.00 +4.65% 2.00 40.00 48.00 43.00 3.03 innodb wisc_benchmark 2.00 +28.57% 0.80 2.00 3.00 2.80 0.40 ========================================================================================================================= TRENDING OVER LAST 20 runs Engine Test Time % Diff from Avg Diff Min Max Avg STD ========================================================================================================================= innodb alter_table_add 18.00 +49.58% 17.70 17.00 49.00 35.70 8.13 innodb alter_table_drop 16.00 +42.24% 11.70 14.00 36.00 27.70 6.17 innodb connect 2.00 +9.09% 0.20 2.00 3.00 2.20 0.40 innodb connect+select_1_row 3.00 -9.09% -0.25 2.00 3.00 2.75 0.43 innodb connect+select_simple 3.00 -30.43% -0.70 2.00 3.00 2.30 0.46 innodb count 18.00 -12.15% -1.95 13.00 18.00 16.05 1.94 innodb count_distinct 7.00 -2.19% -0.15 5.00 8.00 6.85 0.91 innodb count_distinct_2 13.00 +6.81% 0.95 12.00 16.00 13.95 1.50 innodb count_distinct_big 23.00 -3.14% -0.70 19.00 24.00 22.30 1.68 innodb count_distinct_group 15.00 -3.81% -0.55 12.00 17.00 14.45 1.20 innodb count_distinct_group_on_key 11.00 -12.82% -1.25 8.00 12.00 9.75 1.22 innodb count_distinct_group_on_key_parts 15.00 -8.70% -1.20 12.00 15.00 13.80 0.93 innodb count_distinct_key_prefix 5.00 +4.76% 0.25 4.00 6.00 5.25 0.62 innodb count_group_on_key_parts 11.00 -0.46% -0.05 10.00 12.00 10.95 0.59 innodb count_on_key 94.00 -0.27% -0.25 88.00 100.00 93.75 3.36 innodb create+drop 33.00 +35.55% 18.20 33.00 72.00 51.20 12.17 innodb create_index 3.00 +31.03% 1.35 2.00 8.00 4.35 1.39 innodb create_key+drop 28.00 +17.65% 6.00 28.00 42.00 34.00 4.18 innodb create_MANY_tables 22.00 +48.84% 21.00 22.00 65.00 43.00 11.51 innodb create_table 0.00 +100.00% 0.30 0.00 3.00 0.30 0.71 innodb delete_all_many_keys 276.00 +69.67% 633.85 276.00 1486.00 909.85 495.43 innodb delete_autocommit 3.00 +25.93% 1.05 3.00 7.00 4.05 0.97 innodb delete_big 1.00 -66.67% -0.40 0.00 1.00 0.60 0.49 innodb delete_big_many_keys 276.00 +69.63% 632.75 276.00 1484.00 908.75 494.69 innodb delete_commit 2.00 -0.00% 0.00 1.00 3.00 2.00 0.45 innodb delete_key 3.00 +16.67% 0.60 2.00 5.00 3.60 0.97 innodb delete_range 8.00 +44.44% 6.40 8.00 23.00 14.40 4.27 innodb delete_rollback 2.00 +18.37% 0.45 2.00 3.00 2.45 0.50 innodb drop_index 2.00 +60.00% 3.00 2.00 7.00 5.00 1.34 innodb drop_table 0.00 +100.00% 0.10 0.00 1.00 0.10 0.30 innodb drop_table_when_MANY_tables 16.00 +42.96% 12.05 15.00 40.00 28.05 7.63 innodb insert 112.00 +5.08% 6.00 109.00 128.00 118.00 5.34 innodb insert_autocommit 3.00 +15.49% 0.55 3.00 4.00 3.55 0.50 innodb insert_commit 1.00 +33.33% 0.50 1.00 2.00 1.50 0.50 innodb insert_duplicates 19.00 +0.78% 0.15 18.00 20.00 19.15 0.57 innodb insert_key 181.00 +64.14% 323.75 181.00 787.00 504.75 220.15 innodb insert_many_fields 6.00 +17.81% 1.30 5.00 11.00 7.30 1.79 innodb insert_rollback 2.00 +2.44% 0.05 1.00 3.00 2.05 0.38 innodb insert_select_1_key 3.00 +25.00% 1.00 3.00 6.00 4.00 0.84 innodb insert_select_2_keys 6.00 +37.82% 3.65 6.00 14.00 9.65 2.20 innodb min_max 9.00 -12.50% -1.00 7.00 9.00 8.00 0.84 innodb min_max_on_key 24.00 +1.44% 0.35 24.00 25.00 24.35 0.48 innodb multiple_value_insert 3.00 +64.71% 5.50 3.00 14.00 8.50 3.96 innodb once_prepared_select 30.00 -1.52% -0.45 29.00 30.00 29.55 0.50 innodb order_by_big 16.00 -14.70% -2.05 12.00 16.00 13.95 1.24 innodb order_by_big_key 13.00 -2.36% -0.30 11.00 15.00 12.70 1.19 innodb order_by_big_key2 13.00 -12.07% -1.40 10.00 13.00 11.60 0.97 innodb order_by_big_key_desc 15.00 -13.64% -1.80 12.00 15.00 13.20 1.03 innodb order_by_big_key_diff 12.00 -3.90% -0.45 10.00 13.00 11.55 0.97 innodb order_by_big_key_prefix 14.00 -16.18% -1.95 11.00 14.00 12.05 1.12 innodb order_by_key2_diff 1.00 +35.48% 0.55 1.00 2.00 1.55 0.50 innodb order_by_key_prefix 1.00 -25.00% -0.20 0.00 1.00 0.80 0.40 innodb order_by_range 1.00 -5.26% -0.05 0.00 1.00 0.95 0.22 innodb outer_join 23.00 -4.55% -1.00 18.00 25.00 22.00 2.14 innodb outer_join_found 22.00 -4.27% -0.90 17.00 24.00 21.10 2.10 innodb outer_join_not_found 19.00 -0.80% -0.15 15.00 21.00 18.85 1.62 innodb outer_join_on_key 14.00 +5.41% 0.80 12.00 17.00 14.80 1.47 innodb prepared_select 38.00 -1.33% -0.50 37.00 39.00 37.50 0.59 innodb select_1_row 4.00 -5.26% -0.20 3.00 4.00 3.80 0.40 innodb select_1_row_cache 3.00 +15.49% 0.55 3.00 4.00 3.55 0.50 innodb select_2_rows 4.00 -8.11% -0.30 3.00 4.00 3.70 0.46 innodb select_big 11.00 +7.56% 0.90 10.00 14.00 11.90 1.09 innodb select_big_str 1.00 +25.93% 0.35 1.00 2.00 1.35 0.48 innodb select_cache 64.00 -1.67% -1.05 55.00 69.00 62.95 3.85 innodb select_cache2 64.00 -1.27% -0.80 54.00 73.00 63.20 4.66 innodb select_column+column 4.00 -5.26% -0.20 3.00 4.00 3.80 0.40 innodb select_distinct 5.00 -20.48% -0.85 4.00 5.00 4.15 0.36 innodb select_group 19.00 -11.76% -2.00 15.00 19.00 17.00 1.34 innodb select_group_when_MANY_tables 13.00 +56.01% 16.55 13.00 43.00 29.55 9.75 innodb select_join 0.00 +100.00% 0.85 0.00 1.00 0.85 0.36 innodb select_key 65.00 -1.01% -0.65 63.00 66.00 64.35 0.73 innodb select_key2 72.00 -0.84% -0.60 70.00 74.00 71.40 0.86 innodb select_key2_return_key 69.00 -1.17% -0.80 67.00 70.00 68.20 0.75 innodb select_key2_return_prim 70.00 -1.08% -0.75 68.00 72.00 69.25 0.99 innodb select_key_prefix 72.00 -1.19% -0.85 70.00 74.00 71.15 0.91 innodb select_key_prefix_join 5.00 -1.01% -0.05 4.00 5.00 4.95 0.22 innodb select_key_return_key 63.00 +0.08% 0.05 62.00 65.00 63.05 0.67 innodb select_many_fields 13.00 +7.47% 1.05 13.00 16.00 14.05 1.07 innodb select_range 42.00 +4.76% 2.10 39.00 52.00 44.10 3.58 innodb select_range_key2 10.00 -4.17% -0.40 9.00 10.00 9.60 0.49 innodb select_range_prefix 9.00 +2.17% 0.20 8.00 10.00 9.20 0.51 innodb select_simple 2.00 +11.11% 0.25 2.00 3.00 2.25 0.43 innodb select_simple_cache 2.00 +6.98% 0.15 2.00 3.00 2.15 0.36 innodb select_simple_join 1.00 -25.00% -0.20 0.00 1.00 0.80 0.40 innodb update_autocommit 4.00 -15.94% -0.55 3.00 4.00 3.45 0.50 innodb update_big 70.00 +38.27% 43.40 55.00 161.00 113.40 30.93 innodb update_commit 2.00 +2.44% 0.05 2.00 3.00 2.05 0.22 innodb update_of_key 21.00 +3.89% 0.85 20.00 24.00 21.85 0.96 innodb update_of_key_big 39.00 +12.06% 5.35 33.00 58.00 44.35 6.85 innodb update_of_primary_key_many_keys 666.00 +66.52% 1323.25 647.00 3180.00 1989.25 1,013.65 innodb update_rollback 2.00 +11.11% 0.25 2.00 3.00 2.25 0.43 innodb update_with_key 118.00 +4.49% 5.55 113.00 136.00 123.55 8.39 innodb update_with_key_prefix 41.00 +5.96% 2.60 40.00 49.00 43.60 2.97 innodb wisc_benchmark 2.00 +27.27% 0.75 2.00 5.00 2.75 0.83 ========================================================================================================================= TRENDING OVER ALL runs Engine Test Time % Diff from Avg Diff Min Max Avg STD ========================================================================================================================= innodb alter_table_add 18.00 +0.76% 0.14 11.00 61.00 18.14 9.00 innodb alter_table_drop 16.00 +4.94% 0.83 10.00 57.00 16.83 6.71 innodb connect 2.00 +2.26% 0.05 1.00 3.00 2.05 0.41 innodb connect+select_1_row 3.00 -13.26% -0.35 2.00 5.00 2.65 0.50 innodb connect+select_simple 3.00 -31.39% -0.72 1.00 3.00 2.28 0.46 innodb count 18.00 -14.52% -2.28 12.00 193.00 15.72 9.79 innodb count_distinct 7.00 -7.78% -0.51 5.00 50.00 6.49 2.50 innodb count_distinct_2 13.00 +0.22% 0.03 11.00 63.00 13.03 3.21 innodb count_distinct_big 23.00 -5.81% -1.26 5.00 67.00 21.74 3.21 innodb count_distinct_group 15.00 -17.65% -2.25 10.00 68.00 12.75 3.23 innodb count_distinct_group_on_key 11.00 -17.46% -1.64 7.00 69.00 9.36 3.29 innodb count_distinct_group_on_key_parts 15.00 -25.06% -3.01 9.00 72.00 11.99 3.32 innodb count_distinct_key_prefix 5.00 +1.14% 0.06 3.00 52.00 5.06 2.64 innodb count_group_on_key_parts 11.00 -13.46% -1.31 7.00 72.00 9.69 3.44 innodb count_on_key 94.00 -11.88% -9.98 68.00 203.00 84.02 7.95 innodb create+drop 33.00 -3.13% -1.00 18.00 81.00 32.00 12.97 innodb create_index 3.00 -9.21% -0.25 1.00 8.00 2.75 1.14 innodb create_key+drop 28.00 -1.79% -0.49 21.00 50.00 27.51 4.86 innodb create_MANY_tables 22.00 +39.23% 14.20 14.00 121.00 36.20 17.52 innodb create_table 0.00 +100.00% 0.11 0.00 3.00 0.11 0.37 innodb delete_all_many_keys 276.00 +33.67% 140.08 212.00 2293.00 416.08 390.69 innodb delete_autocommit 3.00 +10.76% 0.36 2.00 7.00 3.36 0.62 innodb delete_big 1.00 -323.93% -0.76 0.00 2.00 0.24 0.43 innodb delete_big_many_keys 276.00 +33.64% 139.92 212.00 2293.00 415.92 390.48 innodb delete_commit 2.00 -40.16% -0.57 1.00 3.00 1.43 0.51 innodb delete_key 3.00 +3.00% 0.09 2.00 35.00 3.09 1.64 innodb delete_range 8.00 +0.38% 0.03 5.00 23.00 8.03 3.30 innodb delete_rollback 2.00 -26.44% -0.42 1.00 4.00 1.58 0.58 innodb drop_index 2.00 +29.67% 0.84 1.00 9.00 2.84 1.36 innodb drop_table 0.00 +100.00% 0.04 0.00 2.00 0.04 0.22 innodb drop_table_when_MANY_tables 16.00 +17.55% 3.40 11.00 49.00 19.40 6.46 innodb insert 112.00 -6.92% -7.25 3.00 343.00 104.75 15.60 innodb insert_autocommit 3.00 -2.37% -0.07 2.00 99.00 2.93 3.69 innodb insert_commit 1.00 +22.01% 0.28 1.00 3.00 1.28 0.46 innodb insert_duplicates 19.00 -30.63% -4.46 11.00 21.00 14.54 2.11 innodb insert_key 181.00 +46.99% 160.47 142.00 959.00 341.47 169.70 innodb insert_many_fields 6.00 -9.09% -0.50 3.00 17.00 5.50 1.91 innodb insert_rollback 2.00 -26.91% -0.42 1.00 3.00 1.58 0.53 innodb insert_select_1_key 3.00 +19.80% 0.74 2.00 10.00 3.74 0.92 innodb insert_select_2_keys 6.00 -1.79% -0.11 4.00 16.00 5.89 2.14 innodb min_max 9.00 -15.26% -1.19 6.00 110.00 7.81 5.04 innodb min_max_on_key 24.00 -22.71% -4.44 14.00 37.00 19.56 2.62 innodb multiple_value_insert 3.00 +41.48% 2.13 2.00 50.00 5.13 4.63 innodb once_prepared_select 30.00 -30.65% -7.04 18.00 32.00 22.96 2.83 innodb order_by_big 16.00 -12.21% -1.74 12.00 31.00 14.26 1.60 innodb order_by_big_key 13.00 +0.33% 0.04 11.00 32.00 13.04 1.61 innodb order_by_big_key2 13.00 -8.23% -0.99 10.00 33.00 12.01 1.60 innodb order_by_big_key_desc 15.00 -14.42% -1.89 11.00 32.00 13.11 1.55 innodb order_by_big_key_diff 12.00 +0.28% 0.03 10.00 31.00 12.03 1.54 innodb order_by_big_key_prefix 14.00 -14.96% -1.82 10.00 32.00 12.18 1.62 innodb order_by_key2_diff 1.00 +28.79% 0.40 1.00 3.00 1.40 0.50 innodb order_by_key_prefix 1.00 -29.70% -0.23 0.00 2.00 0.77 0.43 innodb order_by_range 1.00 -24.77% -0.20 0.00 2.00 0.80 0.41 innodb outer_join 23.00 -22.99% -4.30 15.00 61.00 18.70 3.70 innodb outer_join_found 22.00 -20.99% -3.82 14.00 58.00 18.18 3.56 innodb outer_join_not_found 19.00 -19.78% -3.14 12.00 46.00 15.86 3.08 innodb outer_join_on_key 14.00 -12.33% -1.54 10.00 59.00 12.46 2.80 innodb prepared_select 38.00 -27.28% -8.14 22.00 40.00 29.86 3.81 innodb select_1_row 4.00 -50.19% -1.34 2.00 4.00 2.66 0.60 innodb select_1_row_cache 3.00 -20.21% -0.50 2.00 4.00 2.50 0.60 innodb select_2_rows 4.00 -49.54% -1.33 2.00 4.00 2.67 0.59 innodb select_big 11.00 +8.15% 0.98 0.00 31.00 11.98 1.59 innodb select_big_str 1.00 +11.01% 0.12 0.00 2.00 1.12 0.33 innodb select_cache 64.00 -6.13% -3.70 49.00 676.00 60.30 30.13 innodb select_cache2 64.00 -5.27% -3.20 49.00 677.00 60.80 31.79 innodb select_column+column 4.00 -47.31% -1.28 2.00 4.00 2.72 0.61 innodb select_diff_key 0.00 +100.00% 0.20 0.00 1.00 0.20 0.40 innodb select_distinct 5.00 -19.76% -0.83 3.00 8.00 4.17 0.54 innodb select_group 19.00 -18.23% -2.93 4.00 136.00 16.07 6.00 innodb select_group_when_MANY_tables 13.00 -63.15% -5.03 3.00 47.00 7.97 8.98 innodb select_join 0.00 +100.00% 0.56 0.00 1.00 0.56 0.50 innodb select_key 65.00 -29.96% -14.99 40.00 66.00 50.01 5.60 innodb select_key2 72.00 -27.21% -15.40 45.00 75.00 56.60 6.71 innodb select_key2_return_key 69.00 -27.97% -15.08 42.00 70.00 53.92 6.38 innodb select_key2_return_prim 70.00 -28.06% -15.34 42.00 72.00 54.66 6.57 innodb select_key_prefix 72.00 -29.13% -16.24 44.00 75.00 55.76 6.54 innodb select_key_prefix_join 5.00 -8.40% -0.39 3.00 10.00 4.61 0.66 innodb select_key_return_key 63.00 -28.43% -13.95 38.00 65.00 49.05 5.64 innodb select_many_fields 13.00 +15.49% 2.38 11.00 19.00 15.38 1.73 innodb select_range 42.00 +12.76% 6.14 39.00 76.00 48.14 3.53 innodb select_range_key2 10.00 -25.82% -2.05 6.00 10.00 7.95 0.90 innodb select_range_prefix 9.00 -20.12% -1.51 5.00 10.00 7.49 0.92 innodb select_simple 2.00 -28.62% -0.45 1.00 3.00 1.55 0.53 innodb select_simple_cache 2.00 -38.68% -0.56 1.00 3.00 1.44 0.51 innodb select_simple_join 1.00 -59.08% -0.37 0.00 3.00 0.63 0.49 innodb update_autocommit 4.00 -26.44% -0.84 2.00 5.00 3.16 0.49 innodb update_big 70.00 -49.89% -23.30 31.00 171.00 46.70 22.39 innodb update_commit 2.00 -39.60% -0.57 1.00 3.00 1.43 0.50 innodb update_of_key 21.00 +14.91% 3.68 18.00 100.00 24.68 6.80 innodb update_of_key_big 39.00 -55.96% -13.99 15.00 75.00 25.01 10.56 innodb update_of_primary_key_many_keys 666.00 +43.40% 510.58 647.00 6065.00 1176.58 1,069.05 innodb update_rollback 2.00 -31.12% -0.47 1.00 4.00 1.53 0.56 innodb update_with_key 118.00 -10.54% -11.25 90.00 598.00 106.75 22.06 innodb update_with_key_prefix 41.00 -6.48% -2.50 33.00 202.00 38.50 7.10 innodb wisc_benchmark 2.00 +18.22% 0.45 2.00 5.00 2.45 0.52 ========================================================================================================================= _______________________________________________ Mailing list: https://launchpad.net/~drizzle-benchmark Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-benchmark More help : https://help.launchpad.net/ListHelp
