Hi Brian, Here is an example where several of the key tests went off the chart with sqlbench, specifically
delete_all_many_keys delete_big_many_keys insert_key update_of_primary_key_many_keys However when I looked into the results files for these tests, usr/sys/cpu times are minimal, so it feels like something else is going on here. Any ideas?? Operation seconds usr sys cpu tests delete_all_many_keys 348.00 0.01 0.01 0.02 1 delete_big_many_keys 348.00 0.01 0.01 0.02 128 insert_key 231.00 4.37 2.18 6.55 100000 update_of_primary_key_many_keys 888.00 0.02 0.01 0.03 256 On Sat, Oct 30, 2010 at 8:08 PM, orisndriz05 <[email protected]> wrote: > > ======================================================================================= > SQLBENCH REPORT > > ======================================================================================= > ENGINE: innodb > MACHINE: orisndriz05 > RUN ID: 610 > RUN DATE: 2010-10-30T17:53:25.719333 > SERVER: drizzled > VERSION: staging > REVISION: 1894 > COMMENT: 1894: Lee Bieber 2010-10-30 [merge] Merge Thomi - Changed the > vio_st structure (found in plugins/mysql_protocol/vio.h) to a proper C++ > class. > > > ========================================================================================================================= > TRENDING OVER LAST 5 runs > Engine Test Time % Diff from Avg Diff > Min Max Avg STD > > ========================================================================================================================= > innodb alter_table_add 36.00 -25.22% -7.25 > 20.00 36.00 28.75 6.53 > innodb alter_table_drop 29.00 -19.59% -4.75 > 17.00 29.00 24.25 4.55 > innodb connect 2.00 +11.11% 0.25 > 2.00 3.00 2.25 0.43 > innodb connect+select_1_row 2.00 +27.27% 0.75 > 2.00 3.00 2.75 0.43 > innodb connect+select_simple 3.00 -20.00% -0.50 > 2.00 3.00 2.50 0.50 > innodb count 13.00 -0.00% 0.00 > 13.00 13.00 13.00 0.00 > innodb count_distinct 7.00 -7.69% -0.50 > 5.00 8.00 6.50 1.12 > innodb count_distinct_2 14.00 -5.66% -0.75 > 11.00 15.00 13.25 1.48 > innodb count_distinct_big 21.00 -3.70% -0.75 > 20.00 21.00 20.25 0.43 > innodb count_distinct_group 13.00 -6.12% -0.75 > 11.00 14.00 12.25 1.30 > innodb count_distinct_group_on_key 10.00 -8.11% -0.75 > 8.00 10.00 9.25 0.83 > innodb count_distinct_group_on_key_parts 13.00 -10.64% -1.25 > 10.00 14.00 11.75 1.79 > innodb count_distinct_key_prefix 6.00 -14.29% -0.75 > 4.00 6.00 5.25 0.83 > innodb count_group_on_key_parts 10.00 -5.26% -0.50 > 8.00 10.00 9.50 0.87 > innodb count_on_key 84.00 +3.72% 3.25 > 83.00 92.00 87.25 3.83 > innodb create+drop 43.00 -17.81% -6.50 > 25.00 43.00 36.50 6.87 > innodb create_index 4.00 -14.29% -0.50 > 2.00 4.00 3.50 0.87 > innodb create_key+drop 26.00 +8.77% 2.50 > 26.00 31.00 28.50 1.80 > innodb create_MANY_tables 44.00 +15.38% 8.00 > 37.00 64.00 52.00 11.77 > innodb create_table 0.00 +100.00% 0.25 > 0.00 1.00 0.25 0.43 > innodb delete_all_many_keys 1235.00 -118.87% -670.75 > 337.00 1235.00 564.25 387.27 > innodb delete_autocommit 3.00 -0.00% 0.00 > 3.00 3.00 3.00 0.00 > innodb delete_big 0.00 +100.00% 0.25 > 0.00 1.00 0.25 0.43 > innodb delete_big_many_keys 1235.00 -118.87% -670.75 > 337.00 1235.00 564.25 387.27 > innodb delete_commit 1.00 +20.00% 0.25 > 1.00 2.00 1.25 0.43 > innodb delete_key 4.00 -14.29% -0.50 > 3.00 4.00 3.50 0.50 > innodb delete_range 9.00 -20.00% -1.50 > 7.00 9.00 7.50 0.87 > innodb delete_rollback 2.00 -33.33% -0.50 > 1.00 2.00 1.50 0.50 > innodb drop_index 4.00 -23.08% -0.75 > 3.00 4.00 3.25 0.43 > innodb drop_table 0.00 NULL 0.00 > 0.00 0.00 0.00 0.00 > innodb drop_table_when_MANY_tables 15.00 +28.57% 6.00 > 15.00 24.00 21.00 3.54 > innodb insert 104.00 -2.46% -2.50 > 100.00 104.00 101.50 1.50 > innodb insert_autocommit 3.00 -0.00% 0.00 > 3.00 3.00 3.00 0.00 > innodb insert_commit 1.00 +20.00% 0.25 > 1.00 2.00 1.25 0.43 > innodb insert_duplicates 14.00 +1.75% 0.25 > 14.00 15.00 14.25 0.43 > innodb insert_key 559.00 -68.12% -226.50 > 203.00 559.00 332.50 134.89 > innodb insert_many_fields 8.00 -6.67% -0.50 > 6.00 8.00 7.50 0.87 > innodb insert_rollback 2.00 -33.33% -0.50 > 1.00 2.00 1.50 0.50 > innodb insert_select_1_key 4.00 +5.88% 0.25 > 4.00 5.00 4.25 0.43 > innodb insert_select_2_keys 6.00 -9.09% -0.50 > 4.00 7.00 5.50 1.12 > innodb min_max 7.00 -3.70% -0.25 > 6.00 7.00 6.75 0.43 > innodb min_max_on_key 18.00 +1.37% 0.25 > 17.00 20.00 18.25 1.09 > innodb multiple_value_insert 15.00 -100.00% -7.50 > 4.00 15.00 7.50 4.39 > innodb once_prepared_select 22.00 +5.38% 1.25 > 22.00 24.00 23.25 0.83 > innodb order_by_big 15.00 -3.45% -0.50 > 13.00 15.00 14.50 0.87 > innodb order_by_big_key 12.00 +4.00% 0.50 > 11.00 14.00 12.50 1.12 > innodb order_by_big_key2 13.00 -6.12% -0.75 > 10.00 13.00 12.25 1.30 > innodb order_by_big_key_desc 14.00 -3.70% -0.50 > 12.00 15.00 13.50 1.12 > innodb order_by_big_key_diff 12.00 -0.00% 0.00 > 10.00 13.00 12.00 1.22 > innodb order_by_big_key_prefix 13.00 -4.00% -0.50 > 11.00 13.00 12.50 0.87 > 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 -33.33% -0.25 > 0.00 1.00 0.75 0.43 > innodb order_by_range 1.00 -0.00% 0.00 > 1.00 1.00 1.00 0.00 > innodb outer_join 21.00 -3.70% -0.75 > 17.00 23.00 20.25 2.17 > innodb outer_join_found 20.00 -5.26% -1.00 > 17.00 22.00 19.00 2.12 > innodb outer_join_not_found 19.00 -13.43% -2.25 > 14.00 19.00 16.75 2.28 > innodb outer_join_on_key 14.00 -1.82% -0.25 > 11.00 15.00 13.75 1.64 > innodb prepared_select 33.00 -0.76% -0.25 > 32.00 33.00 32.75 0.43 > innodb select_1_row 3.00 -9.09% -0.25 > 2.00 3.00 2.75 0.43 > innodb select_1_row_cache 2.00 +20.00% 0.50 > 2.00 3.00 2.50 0.50 > innodb select_2_rows 3.00 -0.00% 0.00 > 3.00 3.00 3.00 0.00 > innodb select_big 11.00 +6.38% 0.75 > 11.00 14.00 11.75 1.30 > innodb select_big_str 1.00 +20.00% 0.25 > 1.00 2.00 1.25 0.43 > innodb select_cache 62.00 -5.53% -3.25 > 52.00 64.00 58.75 4.66 > innodb select_cache2 66.00 -9.09% -5.50 > 55.00 66.00 60.50 4.61 > innodb select_column+column 3.00 -33.33% -0.75 > 2.00 3.00 2.25 0.43 > innodb select_diff_key 1.00 -300.00% -0.75 > 0.00 1.00 0.25 0.43 > innodb select_distinct 4.00 +5.88% 0.25 > 4.00 5.00 4.25 0.43 > innodb select_group 17.00 -3.03% -0.50 > 16.00 17.00 16.50 0.50 > innodb select_group_when_MANY_tables 5.00 -5.26% -0.25 > 4.00 5.00 4.75 0.43 > innodb select_join 1.00 -33.33% -0.25 > 0.00 1.00 0.75 0.43 > innodb select_key 50.00 -3.63% -1.75 > 47.00 50.00 48.25 1.30 > innodb select_key2 61.00 -1.24% -0.75 > 60.00 61.00 60.25 0.43 > innodb select_key2_return_key 58.00 -0.00% 0.00 > 57.00 59.00 58.00 0.71 > innodb select_key2_return_prim 57.00 +1.72% 1.00 > 57.00 60.00 58.00 1.22 > innodb select_key_prefix 61.00 -0.41% -0.25 > 60.00 61.00 60.75 0.43 > innodb select_key_prefix_join 4.00 +5.88% 0.25 > 4.00 5.00 4.25 0.43 > innodb select_key_return_key 47.00 +3.09% 1.50 > 47.00 50.00 48.50 1.12 > innodb select_many_fields 13.00 -1.96% -0.25 > 12.00 13.00 12.75 0.43 > innodb select_range 52.00 -5.58% -2.75 > 45.00 52.00 49.25 2.68 > innodb select_range_key2 8.00 +3.03% 0.25 > 8.00 9.00 8.25 0.43 > innodb select_range_prefix 8.00 +5.88% 0.50 > 8.00 9.00 8.50 0.50 > innodb select_simple 1.00 +33.33% 0.50 > 1.00 2.00 1.50 0.50 > innodb select_simple_cache 2.00 -33.33% -0.50 > 1.00 2.00 1.50 0.50 > innodb select_simple_join 1.00 -100.00% -0.50 > 0.00 1.00 0.50 0.50 > innodb TOTALS 8083.00 -75.66% -3481.50 > 3387.00 8083.00 4601.50 2010.32 > innodb update_autocommit 4.00 -14.29% -0.50 > 3.00 4.00 3.50 0.50 > innodb update_big 76.00 -31.60% -18.25 > 48.00 76.00 57.75 11.05 > innodb update_commit 1.00 +33.33% 0.50 > 1.00 2.00 1.50 0.50 > innodb update_of_key 26.00 -6.12% -1.50 > 22.00 26.00 24.50 1.50 > innodb update_of_key_big 32.00 -33.33% -8.00 > 17.00 32.00 24.00 5.34 > innodb update_of_primary_key_many_keys 3355.00 -122.81% -1849.25 > 871.00 3355.00 1505.75 1067.75 > innodb update_rollback 1.00 +33.33% 0.50 > 1.00 2.00 1.50 0.50 > innodb update_with_key 107.00 -2.15% -2.25 > 100.00 108.00 104.75 3.11 > innodb update_with_key_prefix 36.00 +2.04% 0.75 > 36.00 37.00 36.75 0.43 > innodb wisc_benchmark 3.00 -0.00% 0.00 > 2.00 4.00 3.00 0.71 > >
_______________________________________________ Mailing list: https://launchpad.net/~drizzle-benchmark Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-benchmark More help : https://help.launchpad.net/ListHelp
