======================================================================================= SQLBENCH REPORT ======================================================================================= ENGINE: innodb MACHINE: orisndriz05 RUN ID: 1081 RUN DATE: 2012-01-18T20:58:13.888916 SERVER: drizzled VERSION: staging REVISION: 2494 COMMENT: 2494: Mark Atwood 2012-01-18 [merge] merge lp:~stewart/drizzle/fix-create-schema-for-catalogs
========================================================================================================================= TRENDING OVER LAST 5 runs Engine Test Time % Diff from Avg Diff Min Max Avg STD ========================================================================================================================= innodb alter_table_add 32.00 +0.62% 0.20 32.00 33.00 32.20 0.40 innodb alter_table_drop 23.00 +7.26% 1.80 23.00 26.00 24.80 0.98 innodb connect 3.00 -36.36% -0.80 2.00 3.00 2.20 0.40 innodb connect+select_1_row 3.00 -0.00% 0.00 3.00 3.00 3.00 0.00 innodb connect+select_simple 2.00 +28.57% 0.80 2.00 3.00 2.80 0.40 innodb count 17.00 -6.25% -1.00 13.00 18.00 16.00 2.10 innodb count_distinct 7.00 -0.00% 0.00 6.00 8.00 7.00 0.63 innodb count_distinct_2 16.00 -19.40% -2.60 12.00 16.00 13.40 1.50 innodb count_distinct_big 25.00 -9.65% -2.20 20.00 25.00 22.80 2.32 innodb count_distinct_group 15.00 -1.35% -0.20 14.00 15.00 14.80 0.40 innodb count_distinct_group_on_key 11.00 -12.24% -1.20 9.00 11.00 9.80 0.75 innodb count_distinct_group_on_key_parts 15.00 -5.63% -0.80 13.00 15.00 14.20 0.75 innodb count_distinct_key_prefix 4.00 +13.04% 0.60 4.00 5.00 4.60 0.49 innodb count_group_on_key_parts 12.00 -5.26% -0.60 11.00 12.00 11.40 0.49 innodb count_on_key 94.00 +2.08% 2.00 94.00 97.00 96.00 1.10 innodb create+drop 34.00 -0.59% -0.20 33.00 35.00 33.80 0.75 innodb create_index 3.00 -0.00% 0.00 3.00 3.00 3.00 0.00 innodb create_key+drop 30.00 +2.60% 0.80 30.00 32.00 30.80 0.75 innodb create_MANY_tables 24.00 -11.11% -2.40 20.00 24.00 21.60 1.36 innodb delete_all_many_keys 801.00 +5.03% 42.40 801.00 898.00 843.40 37.13 innodb delete_autocommit 4.00 -11.11% -0.40 3.00 4.00 3.60 0.49 innodb delete_big 1.00 -150.00% -0.60 0.00 1.00 0.40 0.49 innodb delete_big_many_keys 801.00 +4.96% 41.80 801.00 897.00 842.80 36.68 innodb delete_commit 2.00 -11.11% -0.20 1.00 2.00 1.80 0.40 innodb delete_key 3.00 -0.00% 0.00 3.00 3.00 3.00 0.00 innodb delete_range 8.00 -0.00% 0.00 8.00 8.00 8.00 0.00 innodb delete_rollback 2.00 -0.00% 0.00 2.00 2.00 2.00 0.00 innodb drop_index 3.00 +6.25% 0.20 3.00 4.00 3.20 0.40 innodb drop_table_when_MANY_tables 20.00 -5.26% -1.00 18.00 20.00 19.00 0.63 innodb insert 112.00 +1.23% 1.40 112.00 115.00 113.40 1.20 innodb insert_autocommit 3.00 +6.25% 0.20 3.00 4.00 3.20 0.40 innodb insert_commit 2.00 -11.11% -0.20 1.00 2.00 1.80 0.40 innodb insert_duplicates 21.00 -6.06% -1.20 19.00 21.00 19.80 0.75 innodb insert_key 283.00 -0.57% -1.60 278.00 283.00 281.40 2.06 innodb insert_many_fields 6.00 -11.11% -0.60 5.00 6.00 5.40 0.49 innodb insert_rollback 2.00 -0.00% 0.00 2.00 2.00 2.00 0.00 innodb insert_select_1_key 4.00 +16.67% 0.80 4.00 5.00 4.80 0.40 innodb insert_select_2_keys 7.00 -6.06% -0.40 6.00 7.00 6.60 0.49 innodb min_max 9.00 -9.76% -0.80 7.00 9.00 8.20 0.98 innodb min_max_on_key 24.00 +2.44% 0.60 24.00 25.00 24.60 0.49 innodb multiple_value_insert 5.00 +7.41% 0.40 5.00 6.00 5.40 0.49 innodb once_prepared_select 29.00 +0.68% 0.20 29.00 30.00 29.20 0.40 innodb order_by_big 13.00 +2.99% 0.40 13.00 14.00 13.40 0.49 innodb order_by_big_key 16.00 -9.59% -1.40 13.00 16.00 14.60 1.36 innodb order_by_big_key2 12.00 -0.00% 0.00 12.00 12.00 12.00 0.00 innodb order_by_big_key_desc 14.00 +4.11% 0.60 13.00 16.00 14.60 1.02 innodb order_by_big_key_diff 12.00 -0.00% 0.00 11.00 13.00 12.00 0.63 innodb order_by_big_key_prefix 12.00 +4.76% 0.60 12.00 13.00 12.60 0.49 innodb order_by_key2_diff 1.00 +28.57% 0.40 1.00 2.00 1.40 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 17.00 +15.00% 3.00 17.00 24.00 20.00 2.61 innodb outer_join_found 17.00 +11.46% 2.20 17.00 22.00 19.20 2.32 innodb outer_join_not_found 15.00 +11.76% 2.00 15.00 21.00 17.00 2.10 innodb outer_join_on_key 11.00 +14.06% 1.80 11.00 15.00 12.80 1.83 innodb prepared_select 37.00 +1.07% 0.40 37.00 38.00 37.40 0.49 innodb select_1_row 4.00 -17.65% -0.60 3.00 4.00 3.40 0.49 innodb select_1_row_cache 4.00 -5.26% -0.20 3.00 4.00 3.80 0.40 innodb select_2_rows 3.00 +21.05% 0.80 3.00 4.00 3.80 0.40 innodb select_big 14.00 -6.06% -0.80 12.00 14.00 13.20 0.98 innodb select_big_str 2.00 -42.86% -0.60 1.00 2.00 1.40 0.49 innodb select_cache 79.00 -21.91% -14.20 60.00 79.00 64.80 7.17 innodb select_cache2 88.00 -27.54% -19.00 62.00 88.00 69.00 9.63 innodb select_column+column 4.00 -5.26% -0.20 3.00 4.00 3.80 0.40 innodb select_diff_key 1.00 -150.00% -0.60 0.00 1.00 0.40 0.49 innodb select_distinct 4.00 +9.09% 0.40 4.00 5.00 4.40 0.49 innodb select_group 20.00 -5.26% -1.00 18.00 20.00 19.00 0.89 innodb select_group_when_MANY_tables 13.00 -8.33% -1.00 11.00 13.00 12.00 0.63 innodb select_join 1.00 -66.67% -0.40 0.00 1.00 0.60 0.49 innodb select_key 64.00 +0.62% 0.40 64.00 65.00 64.40 0.49 innodb select_key2 72.00 -0.56% -0.40 71.00 72.00 71.60 0.49 innodb select_key2_return_key 69.00 +0.29% 0.20 68.00 71.00 69.20 0.98 innodb select_key2_return_prim 70.00 -0.29% -0.20 69.00 70.00 69.80 0.40 innodb select_key_prefix 72.00 -0.84% -0.60 70.00 72.00 71.40 0.80 innodb select_key_prefix_join 5.00 -0.00% 0.00 5.00 5.00 5.00 0.00 innodb select_key_return_key 64.00 -0.00% 0.00 63.00 65.00 64.00 0.63 innodb select_many_fields 13.00 +1.52% 0.20 13.00 14.00 13.20 0.40 innodb select_range 44.00 -2.80% -1.20 41.00 45.00 42.80 1.47 innodb select_range_key2 10.00 -4.17% -0.40 9.00 10.00 9.60 0.49 innodb select_range_prefix 8.00 +11.11% 1.00 8.00 10.00 9.00 0.63 innodb select_simple 2.00 -0.00% 0.00 2.00 2.00 2.00 0.00 innodb select_simple_cache 2.00 -0.00% 0.00 2.00 2.00 2.00 0.00 innodb select_simple_join 1.00 -25.00% -0.20 0.00 1.00 0.80 0.40 innodb update_autocommit 3.00 +16.67% 0.60 3.00 4.00 3.60 0.49 innodb update_big 57.00 +2.73% 1.60 57.00 61.00 58.60 1.50 innodb update_commit 3.00 -36.36% -0.80 2.00 3.00 2.20 0.40 innodb update_of_key 22.00 -0.92% -0.20 21.00 23.00 21.80 0.75 innodb update_of_key_big 19.00 +2.06% 0.40 18.00 20.00 19.40 0.80 innodb update_of_primary_key_many_keys 1320.00 -2.12% -27.40 1260.00 1320.00 1292.60 23.46 innodb update_rollback 2.00 -0.00% 0.00 2.00 2.00 2.00 0.00 innodb update_with_key 120.00 -0.84% -1.00 118.00 120.00 119.00 0.89 innodb update_with_key_prefix 43.00 -0.00% 0.00 42.00 45.00 43.00 1.10 innodb wisc_benchmark 2.00 +23.08% 0.60 2.00 3.00 2.60 0.49 ========================================================================================================================= TRENDING OVER LAST 20 runs Engine Test Time % Diff from Avg Diff Min Max Avg STD ========================================================================================================================= innodb alter_table_add 32.00 -0.00% 0.00 30.00 33.00 32.00 0.71 innodb alter_table_drop 23.00 +7.26% 1.80 23.00 26.00 24.80 0.81 innodb connect 3.00 -42.86% -0.90 2.00 3.00 2.10 0.30 innodb connect+select_1_row 3.00 -5.26% -0.15 2.00 3.00 2.85 0.36 innodb connect+select_simple 2.00 +24.53% 0.65 2.00 3.00 2.65 0.48 innodb count 17.00 -6.58% -1.05 13.00 19.00 15.95 2.13 innodb count_distinct 7.00 -0.00% 0.00 6.00 8.00 7.00 0.77 innodb count_distinct_2 16.00 -16.36% -2.25 12.00 16.00 13.75 1.30 innodb count_distinct_big 25.00 -9.41% -2.15 20.00 26.00 22.85 2.17 innodb count_distinct_group 15.00 -1.35% -0.20 12.00 18.00 14.80 1.25 innodb count_distinct_group_on_key 11.00 -12.82% -1.25 8.00 12.00 9.75 1.04 innodb count_distinct_group_on_key_parts 15.00 -11.94% -1.60 11.00 15.00 13.40 1.28 innodb count_distinct_key_prefix 4.00 +20.00% 1.00 4.00 6.00 5.00 0.63 innodb count_group_on_key_parts 12.00 -9.59% -1.05 10.00 12.00 10.95 0.67 innodb count_on_key 94.00 +1.36% 1.30 91.00 104.00 95.30 3.15 innodb create+drop 34.00 -1.49% -0.50 32.00 35.00 33.50 0.81 innodb create_index 3.00 +3.23% 0.10 3.00 4.00 3.10 0.30 innodb create_key+drop 30.00 +5.51% 1.75 30.00 35.00 31.75 1.44 innodb create_MANY_tables 24.00 -12.15% -2.60 20.00 24.00 21.40 0.92 innodb delete_all_many_keys 801.00 +9.48% 83.85 749.00 1107.00 884.85 102.76 innodb delete_autocommit 4.00 -9.59% -0.35 3.00 4.00 3.65 0.48 innodb delete_big 1.00 -400.00% -0.80 0.00 1.00 0.20 0.40 innodb delete_big_many_keys 801.00 +9.43% 83.35 749.00 1106.00 884.35 102.52 innodb delete_commit 2.00 -5.26% -0.10 1.00 2.00 1.90 0.30 innodb delete_key 3.00 -3.45% -0.10 2.00 3.00 2.90 0.30 innodb delete_range 8.00 -1.91% -0.15 7.00 9.00 7.85 0.57 innodb delete_rollback 2.00 +4.76% 0.10 2.00 3.00 2.10 0.30 innodb drop_index 3.00 +1.64% 0.05 2.00 4.00 3.05 0.50 innodb drop_table 0.00 +100.00% 0.05 0.00 1.00 0.05 0.22 innodb drop_table_when_MANY_tables 20.00 -4.17% -0.80 18.00 21.00 19.20 0.81 innodb insert 112.00 +1.71% 1.95 112.00 116.00 113.95 1.12 innodb insert_autocommit 3.00 +9.09% 0.30 3.00 4.00 3.30 0.46 innodb insert_commit 2.00 -14.29% -0.25 1.00 2.00 1.75 0.43 innodb insert_duplicates 21.00 -6.87% -1.35 19.00 21.00 19.65 0.57 innodb insert_key 283.00 +1.27% 3.65 271.00 297.00 286.65 6.31 innodb insert_many_fields 6.00 -7.14% -0.40 5.00 6.00 5.60 0.49 innodb insert_rollback 2.00 -0.00% 0.00 2.00 2.00 2.00 0.00 innodb insert_select_1_key 4.00 +16.67% 0.80 3.00 6.00 4.80 0.68 innodb insert_select_2_keys 7.00 -9.38% -0.60 6.00 7.00 6.40 0.49 innodb min_max 9.00 -9.09% -0.75 7.00 9.00 8.25 0.94 innodb min_max_on_key 24.00 +3.42% 0.85 24.00 26.00 24.85 0.73 innodb multiple_value_insert 5.00 +11.50% 0.65 5.00 7.00 5.65 0.57 innodb once_prepared_select 29.00 +0.85% 0.25 29.00 30.00 29.25 0.43 innodb order_by_big 13.00 +6.14% 0.85 12.00 16.00 13.85 1.06 innodb order_by_big_key 16.00 -11.89% -1.70 12.00 16.00 14.30 1.42 innodb order_by_big_key2 12.00 +3.61% 0.45 11.00 14.00 12.45 0.86 innodb order_by_big_key_desc 14.00 +6.35% 0.95 13.00 16.00 14.95 0.97 innodb order_by_big_key_diff 12.00 +5.14% 0.65 11.00 14.00 12.65 0.91 innodb order_by_big_key_prefix 12.00 +7.34% 0.95 11.00 14.00 12.95 0.92 innodb order_by_key2_diff 1.00 +20.00% 0.25 1.00 2.00 1.25 0.43 innodb order_by_key_prefix 1.00 -17.65% -0.15 0.00 1.00 0.85 0.36 innodb order_by_range 1.00 -0.00% 0.00 1.00 1.00 1.00 0.00 innodb outer_join 17.00 +23.60% 5.25 17.00 26.00 22.25 2.86 innodb outer_join_found 17.00 +18.66% 3.90 17.00 24.00 20.90 2.47 innodb outer_join_not_found 15.00 +20.84% 3.95 15.00 22.00 18.95 2.64 innodb outer_join_on_key 11.00 +20.29% 2.80 11.00 16.00 13.80 1.69 innodb prepared_select 37.00 +0.80% 0.30 36.00 38.00 37.30 0.56 innodb select_1_row 4.00 -11.11% -0.40 3.00 4.00 3.60 0.49 innodb select_1_row_cache 4.00 -8.11% -0.30 3.00 4.00 3.70 0.46 innodb select_2_rows 3.00 +18.92% 0.70 3.00 4.00 3.70 0.46 innodb select_big 14.00 -7.69% -1.00 11.00 14.00 13.00 1.05 innodb select_big_str 2.00 -37.93% -0.55 1.00 2.00 1.45 0.50 innodb select_cache 79.00 -23.24% -14.90 54.00 79.00 64.10 5.34 innodb select_cache2 88.00 -32.43% -21.55 60.00 88.00 66.45 5.75 innodb select_column+column 4.00 -3.90% -0.15 3.00 4.00 3.85 0.36 innodb select_diff_key 1.00 -400.00% -0.80 0.00 1.00 0.20 0.40 innodb select_distinct 4.00 +13.98% 0.65 4.00 5.00 4.65 0.48 innodb select_group 20.00 -13.31% -2.35 15.00 20.00 17.65 1.49 innodb select_group_when_MANY_tables 13.00 -7.44% -0.90 11.00 14.00 12.10 0.70 innodb select_join 1.00 -33.33% -0.25 0.00 1.00 0.75 0.43 innodb select_key 64.00 +1.08% 0.70 63.00 67.00 64.70 0.90 innodb select_key2 72.00 -0.63% -0.45 70.00 74.00 71.55 0.92 innodb select_key2_return_key 69.00 -0.00% 0.00 68.00 71.00 69.00 0.95 innodb select_key2_return_prim 70.00 -0.36% -0.25 69.00 72.00 69.75 0.83 innodb select_key_prefix 72.00 -1.12% -0.80 70.00 73.00 71.20 0.87 innodb select_key_prefix_join 5.00 +11.50% 0.65 5.00 7.00 5.65 0.65 innodb select_key_return_key 64.00 -0.55% -0.35 63.00 66.00 63.65 0.79 innodb select_many_fields 13.00 +2.99% 0.40 13.00 17.00 13.40 0.92 innodb select_range 44.00 -3.04% -1.30 39.00 49.00 42.70 2.49 innodb select_range_key2 10.00 -4.17% -0.40 9.00 11.00 9.60 0.58 innodb select_range_prefix 8.00 +13.04% 1.20 8.00 10.00 9.20 0.60 innodb select_simple 2.00 +2.44% 0.05 2.00 3.00 2.05 0.22 innodb select_simple_cache 2.00 +6.98% 0.15 2.00 3.00 2.15 0.36 innodb select_simple_join 1.00 -42.86% -0.30 0.00 1.00 0.70 0.46 innodb update_autocommit 3.00 +10.45% 0.35 3.00 4.00 3.35 0.48 innodb update_big 57.00 +2.31% 1.35 57.00 61.00 58.35 1.42 innodb update_commit 3.00 -46.34% -0.95 2.00 3.00 2.05 0.22 innodb update_of_key 22.00 +1.79% 0.40 21.00 25.00 22.40 1.02 innodb update_of_key_big 19.00 -0.00% 0.00 17.00 21.00 19.00 0.95 innodb update_of_primary_key_many_keys 1320.00 -2.09% -27.05 1173.00 1452.00 1292.95 49.59 innodb update_rollback 2.00 +2.44% 0.05 2.00 3.00 2.05 0.22 innodb update_with_key 120.00 -0.29% -0.35 116.00 122.00 119.65 1.42 innodb update_with_key_prefix 43.00 -0.23% -0.10 40.00 46.00 42.90 1.41 innodb wisc_benchmark 2.00 +21.57% 0.55 2.00 3.00 2.55 0.50 ========================================================================================================================= TRENDING OVER ALL runs Engine Test Time % Diff from Avg Diff Min Max Avg STD ========================================================================================================================= innodb alter_table_add 32.00 -41.38% -9.37 11.00 61.00 22.63 10.12 innodb alter_table_drop 23.00 -19.69% -3.78 10.00 57.00 19.22 6.75 innodb connect 3.00 -42.70% -0.90 1.00 3.00 2.10 0.42 innodb connect+select_1_row 3.00 -9.69% -0.27 2.00 5.00 2.73 0.45 innodb connect+select_simple 2.00 +16.08% 0.38 1.00 3.00 2.38 0.49 innodb count 17.00 -7.78% -1.23 12.00 193.00 15.77 8.19 innodb count_distinct 7.00 -5.75% -0.38 5.00 50.00 6.62 2.13 innodb count_distinct_2 16.00 -20.57% -2.73 11.00 63.00 13.27 2.78 innodb count_distinct_big 25.00 -13.23% -2.92 5.00 67.00 22.08 2.91 innodb count_distinct_group 15.00 -12.43% -1.66 10.00 68.00 13.34 2.93 innodb count_distinct_group_on_key 11.00 -15.26% -1.46 7.00 69.00 9.54 2.82 innodb count_distinct_group_on_key_parts 15.00 -20.50% -2.55 9.00 72.00 12.45 2.97 innodb count_distinct_key_prefix 4.00 +22.39% 1.15 3.00 52.00 5.15 2.22 innodb count_group_on_key_parts 12.00 -18.38% -1.86 7.00 72.00 10.14 2.95 innodb count_on_key 94.00 -7.69% -6.71 68.00 107.00 87.29 7.58 innodb create+drop 34.00 -4.48% -1.46 18.00 75.00 32.54 11.00 innodb create_index 3.00 -2.90% -0.08 1.00 8.00 2.92 1.07 innodb create_key+drop 30.00 -4.65% -1.33 21.00 50.00 28.67 4.71 innodb create_MANY_tables 24.00 +25.34% 8.14 14.00 121.00 32.14 16.48 innodb create_table 0.00 +100.00% 0.10 0.00 3.00 0.10 0.34 innodb delete_all_many_keys 801.00 -56.79% -290.13 212.00 1888.00 510.87 358.24 innodb delete_autocommit 4.00 -15.37% -0.53 2.00 14.00 3.47 0.72 innodb delete_big 1.00 -224.52% -0.69 0.00 3.00 0.31 0.47 innodb delete_big_many_keys 801.00 -55.29% -285.19 212.00 2293.00 515.81 369.87 innodb delete_commit 2.00 -27.83% -0.44 1.00 5.00 1.56 0.52 innodb delete_key 3.00 +0.82% 0.02 2.00 35.00 3.02 1.39 innodb delete_range 8.00 +3.78% 0.31 5.00 23.00 8.31 3.00 innodb delete_rollback 2.00 -11.90% -0.21 1.00 12.00 1.79 0.86 innodb drop_index 3.00 -1.38% -0.04 1.00 9.00 2.96 1.24 innodb drop_table 0.00 +100.00% 0.04 0.00 2.00 0.04 0.22 innodb drop_table_when_MANY_tables 20.00 -2.76% -0.54 11.00 90.00 19.46 6.98 innodb insert 112.00 -4.06% -4.37 3.00 343.00 107.63 13.69 innodb insert_autocommit 3.00 +0.72% 0.02 2.00 99.00 3.02 3.07 innodb insert_commit 2.00 -38.38% -0.55 1.00 3.00 1.45 0.50 innodb insert_duplicates 21.00 -31.18% -4.99 11.00 21.00 16.01 2.80 innodb insert_key 283.00 +5.57% 16.70 142.00 700.00 299.70 98.69 innodb insert_many_fields 6.00 -6.62% -0.37 3.00 17.00 5.63 1.65 innodb insert_rollback 2.00 -16.50% -0.28 1.00 3.00 1.72 0.51 innodb insert_select_1_key 4.00 -2.94% -0.11 2.00 10.00 3.89 0.91 innodb insert_select_2_keys 7.00 -14.73% -0.90 4.00 16.00 6.10 1.95 innodb min_max 9.00 -14.64% -1.15 6.00 110.00 7.85 4.22 innodb min_max_on_key 24.00 -13.60% -2.87 14.00 37.00 21.13 3.20 innodb multiple_value_insert 5.00 +9.70% 0.54 2.00 50.00 5.54 3.98 innodb once_prepared_select 29.00 -16.47% -4.10 18.00 32.00 24.90 3.71 innodb order_by_big 13.00 +8.98% 1.28 12.00 31.00 14.28 1.47 innodb order_by_big_key 16.00 -19.21% -2.58 11.00 32.00 13.42 1.64 innodb order_by_big_key2 12.00 +2.37% 0.29 10.00 33.00 12.29 1.49 innodb order_by_big_key_desc 14.00 -2.10% -0.29 11.00 32.00 13.71 1.69 innodb order_by_big_key_diff 12.00 +2.66% 0.33 10.00 31.00 12.33 1.45 innodb order_by_big_key_prefix 12.00 +3.95% 0.49 10.00 32.00 12.49 1.49 innodb order_by_key2_diff 1.00 +28.52% 0.40 1.00 3.00 1.40 0.49 innodb order_by_key_prefix 1.00 -24.38% -0.20 0.00 2.00 0.80 0.40 innodb order_by_range 1.00 -18.51% -0.16 0.00 2.00 0.84 0.37 innodb outer_join 17.00 +13.83% 2.73 15.00 61.00 19.73 3.70 innodb outer_join_found 17.00 +10.94% 2.09 14.00 58.00 19.09 3.53 innodb outer_join_not_found 15.00 +10.93% 1.84 12.00 46.00 16.84 3.20 innodb outer_join_on_key 11.00 +16.06% 2.10 10.00 59.00 13.10 2.69 innodb prepared_select 37.00 -15.16% -4.87 22.00 40.00 32.13 4.62 innodb select_1_row 4.00 -35.39% -1.05 2.00 4.00 2.95 0.71 innodb select_1_row_cache 4.00 -42.94% -1.20 2.00 4.00 2.80 0.72 innodb select_2_rows 3.00 -0.40% -0.01 2.00 4.00 2.99 0.73 innodb select_big 14.00 -14.37% -1.76 0.00 31.00 12.24 1.50 innodb select_big_str 2.00 -67.47% -0.81 0.00 2.00 1.19 0.40 innodb select_cache 79.00 -31.01% -18.70 49.00 79.00 60.30 5.67 innodb select_cache2 88.00 -44.81% -27.23 49.00 88.00 60.77 6.35 innodb select_column+column 4.00 -31.25% -0.95 2.00 4.00 3.05 0.74 innodb select_diff_key 1.00 -348.66% -0.78 0.00 1.00 0.22 0.42 innodb select_distinct 4.00 +6.74% 0.29 3.00 8.00 4.29 0.55 innodb select_group 20.00 -22.19% -3.63 4.00 136.00 16.37 5.06 innodb select_group_when_MANY_tables 13.00 -32.39% -3.18 3.00 49.00 9.82 8.80 innodb select_join 1.00 -68.96% -0.41 0.00 1.00 0.59 0.49 innodb select_key 64.00 -17.75% -9.65 40.00 67.00 54.35 7.94 innodb select_key2 72.00 -17.91% -10.94 45.00 75.00 61.06 8.65 innodb select_key2_return_key 69.00 -18.12% -10.59 42.00 71.00 58.41 8.51 innodb select_key2_return_prim 70.00 -18.29% -10.83 42.00 72.00 59.17 8.63 innodb select_key_prefix 72.00 -19.26% -11.63 44.00 75.00 60.37 8.73 innodb select_key_prefix_join 5.00 -4.16% -0.20 3.00 10.00 4.80 0.66 innodb select_key_return_key 64.00 -19.93% -10.64 38.00 66.00 53.36 7.92 innodb select_many_fields 13.00 +11.60% 1.71 11.00 19.00 14.71 1.77 innodb select_range 44.00 +5.55% 2.59 38.00 76.00 46.59 4.06 innodb select_range_key2 10.00 -18.43% -1.56 6.00 11.00 8.44 1.09 innodb select_range_prefix 8.00 +0.46% 0.04 5.00 10.00 8.04 1.16 innodb select_simple 2.00 -17.23% -0.29 1.00 3.00 1.71 0.50 innodb select_simple_cache 2.00 -23.11% -0.38 1.00 3.00 1.62 0.51 innodb select_simple_join 1.00 -49.19% -0.33 0.00 3.00 0.67 0.48 innodb update_autocommit 3.00 +10.50% 0.35 2.00 16.00 3.35 0.96 innodb update_big 57.00 -9.45% -4.92 31.00 195.00 52.08 22.81 innodb update_commit 3.00 -85.15% -1.38 1.00 10.00 1.62 0.69 innodb update_of_key 22.00 +8.12% 1.94 18.00 100.00 23.94 5.77 innodb update_of_key_big 19.00 +30.34% 8.28 15.00 75.00 27.28 10.69 innodb update_of_primary_key_many_keys 1320.00 -5.46% -68.40 647.00 6065.00 1251.60 870.60 innodb update_rollback 2.00 -10.92% -0.20 1.00 31.00 1.80 1.76 innodb update_with_key 120.00 -7.81% -8.70 90.00 598.00 111.30 19.59 innodb update_with_key_prefix 43.00 -7.04% -2.83 33.00 202.00 40.17 6.49 innodb wisc_benchmark 2.00 +19.58% 0.49 2.00 5.00 2.49 0.52 ========================================================================================================================= FULL REVISION COMMENTARY: 2478.3.16: Stewart Smith 2012-01-18 fix up problem with constant schema identifiers for DATA_DICTIONARY and INFORMATION_SCHEMA that came up on certain compilers choosing orders for static constructor execution. 2478.3.15: Stewart Smith 2012-01-17 fix up table_identifier unit tests to deal with identifier::Table constructor now also requiring a Catalog identifier 2478.3.14: Stewart Smith 2012-01-17 [merge] merge trunk 2478.3.13: Stewart Smith 2012-01-05 fix initialization of message::schema to be from the Schema identifier, which includes the CATALOG name, so that we can create schemas in catalogs other than LOCAL 2478.3.12: Stewart Smith 2012-01-05 force a identifier::Schema to be constructed with a identifier::Catalog. This is close to the final 'big' part for CATALOG support. We also have to modify all around the server that creates identifier::Schema so it does so properly. Since a single Session cannot span schemas, we get off a wee bit easy :) The big limitation in this patch is that INFORMATION_SCHEMA and DATA_DICTIONARY only appear in the LOCAL catalog (and this really needs to be fixed before CATALOGs other than LOCAL are supported). 2478.3.11: Stewart Smith 2012-01-05 use the table identifier and catalog in the identifier in constructing the path in build_table_filename instead of the global drizzled::catalog::local_identifier(). Another step towards full CATALOG support 2478.3.10: Stewart Smith 2012-01-05 [merge] merge table_identifier unittest fix 2478.3.9: Stewart Smith 2012-01-05 TableShare use a TableIdentifier instead of db,table strings. 2478.3.8: Stewart Smith 2012-01-04 [merge] merge print_transaction_message filename/path bug fix (also hit in testing CATALOG) 2478.3.7: Stewart Smith 2012-01-04 [merge] merge off-by-one error message fix (was hitting this) 2478.3.6: Stewart Smith 2011-12-28 Schema identifier has a Catalog identifier. Use it instead of catalog::local_identifier() in most places in Schema identifier code 2478.3.5: Stewart Smith 2011-12-28 update innodb-system-table-view.result to include CATALOG in path to table 2478.3.4: Stewart Smith 2011-12-28 modify tableprototester to include local/ in the path for the test tables 2478.3.3: Stewart Smith 2011-12-28 modify transaction_log plugin to default to local/transaction.log to keep backwards compatibility with old drizzled (before chdir to local/ was removed) 2478.3.2: Stewart Smith 2011-12-28 no longer chdir into local CATALOG. Instead, generate paths everywhere (well... in identifiers) that include the path to the correct CATALOG. Currently that's just LOCAL, but we get closer. Also added is some backwards compatibility code in InnoDB for old data dictionary entries that didn't include CATALOG in catalog/db/table but just had db/table. The next step is to construct the table and schema identifiers with the current CATALOG. _______________________________________________ Mailing list: https://launchpad.net/~drizzle-benchmark Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-benchmark More help : https://help.launchpad.net/ListHelp
