=======================================================================================
SQLBENCH REPORT
=======================================================================================
ENGINE: innodb
MACHINE: orisndriz05
RUN ID: 614
RUN DATE: 2010-11-01T01:25:28.200965
SERVER: drizzled
VERSION: staging
REVISION: 1898
COMMENT: 1898: Brian Aker 2010-10-31 [merge] Merge of Brian + Stewart (all
slap).
=========================================================================================================================
TRENDING OVER LAST 5 runs
Engine Test Time % Diff from Avg Diff
Min Max Avg STD
=========================================================================================================================
innodb alter_table_add 32.00 -12.28% -3.50
17.00 38.00 28.50 7.70
innodb alter_table_drop 24.00 -10.34% -2.25
15.00 26.00 21.75 4.15
innodb connect 2.00 -0.00% 0.00
2.00 2.00 2.00 0.00
innodb connect+select_1_row 3.00 -20.00% -0.50
2.00 3.00 2.50 0.50
innodb connect+select_simple 3.00 -9.09% -0.25
2.00 3.00 2.75 0.43
innodb count 17.00 -19.30% -2.75
13.00 17.00 14.25 1.64
innodb count_distinct 7.00 -0.00% 0.00
6.00 8.00 7.00 0.71
innodb count_distinct_2 13.00 +1.89% 0.25
11.00 15.00 13.25 1.48
innodb count_distinct_big 24.00 -7.87% -1.75
20.00 24.00 22.25 1.79
innodb count_distinct_group 13.00 -0.00% 0.00
11.00 14.00 13.00 1.22
innodb count_distinct_group_on_key 8.00 +17.95% 1.75
8.00 11.00 9.75 1.30
innodb count_distinct_group_on_key_parts 13.00 -0.00% 0.00
12.00 14.00 13.00 0.71
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 -2.56% -0.25
8.00 11.00 9.75 1.09
innodb count_on_key 88.00 -1.15% -1.00
83.00 94.00 87.00 4.53
innodb create+drop 61.00 -23.23% -11.50
33.00 65.00 49.50 13.74
innodb create_index 3.00 -0.00% 0.00
2.00 4.00 3.00 0.71
innodb create_key+drop 35.00 -7.69% -2.50
27.00 40.00 32.50 5.32
innodb create_MANY_tables 77.00 -22.22% -14.00
44.00 86.00 63.00 18.77
innodb create_table 0.00 +100.00% 0.25
0.00 1.00 0.25 0.43
innodb delete_all_many_keys 1810.00 -74.96% -775.50
332.00 1810.00 1034.50 696.88
innodb delete_autocommit 5.00 -33.33% -1.25
3.00 5.00 3.75 0.83
innodb delete_big 0.00 +100.00% 0.50
0.00 1.00 0.50 0.50
innodb delete_big_many_keys 1810.00 -74.96% -775.50
332.00 1810.00 1034.50 696.88
innodb delete_commit 1.00 +33.33% 0.50
1.00 2.00 1.50 0.50
innodb delete_key 7.00 -47.37% -2.25
3.00 7.00 4.75 1.79
innodb delete_range 9.00 -20.00% -1.50
6.00 9.00 7.50 1.12
innodb delete_rollback 2.00 +11.11% 0.25
2.00 3.00 2.25 0.43
innodb drop_index 3.00 +25.00% 1.00
3.00 6.00 4.00 1.22
innodb drop_table 0.00 NULL 0.00
0.00 0.00 0.00 0.00
innodb drop_table_when_MANY_tables 27.00 -24.14% -5.25
14.00 27.00 21.75 5.54
innodb insert 140.00 -17.40% -20.75
100.00 140.00 119.25 18.81
innodb insert_autocommit 3.00 -20.00% -0.50
2.00 3.00 2.50 0.50
innodb insert_commit 2.00 -14.29% -0.25
1.00 2.00 1.75 0.43
innodb insert_duplicates 17.00 -13.33% -2.00
14.00 17.00 15.00 1.22
innodb insert_key 831.00 -57.76% -304.25
231.00 831.00 526.75 288.52
innodb insert_many_fields 10.00 -14.29% -1.25
7.00 10.00 8.75 1.09
innodb insert_rollback 1.00 +42.86% 0.75
1.00 2.00 1.75 0.43
innodb insert_select_1_key 4.00 +11.11% 0.50
4.00 6.00 4.50 0.87
innodb insert_select_2_keys 10.00 -29.03% -2.25
5.00 10.00 7.75 1.79
innodb min_max 8.00 -23.08% -1.50
6.00 8.00 6.50 0.87
innodb min_max_on_key 19.00 +1.30% 0.25
18.00 20.00 19.25 0.83
innodb multiple_value_insert 14.00 -33.33% -3.50
4.00 19.00 10.50 6.26
innodb once_prepared_select 23.00 +1.08% 0.25
23.00 24.00 23.25 0.43
innodb order_by_big 16.00 -8.47% -1.25
13.00 16.00 14.75 1.09
innodb order_by_big_key 12.00 +2.04% 0.25
12.00 13.00 12.25 0.43
innodb order_by_big_key2 11.00 +4.35% 0.50
11.00 13.00 11.50 0.87
innodb order_by_big_key_desc 12.00 +5.88% 0.75
12.00 14.00 12.75 0.83
innodb order_by_big_key_diff 12.00 +2.04% 0.25
11.00 13.00 12.25 0.83
innodb order_by_big_key_prefix 11.00 +4.35% 0.50
11.00 13.00 11.50 0.87
innodb order_by_key2_diff 2.00 -14.29% -0.25
1.00 2.00 1.75 0.43
innodb order_by_key_prefix 0.00 +100.00% 0.50
0.00 1.00 0.50 0.50
innodb order_by_range 1.00 -33.33% -0.25
0.00 1.00 0.75 0.43
innodb outer_join 23.00 -9.52% -2.00
18.00 23.00 21.00 1.87
innodb outer_join_found 21.00 -9.09% -1.75
15.00 21.00 19.25 2.49
innodb outer_join_not_found 19.00 -7.04% -1.25
14.00 19.00 17.75 2.17
innodb outer_join_on_key 15.00 -11.11% -1.50
12.00 15.00 13.50 1.12
innodb prepared_select 30.00 +3.23% 1.00
30.00 32.00 31.00 1.00
innodb select_1_row 2.00 +20.00% 0.50
2.00 3.00 2.50 0.50
innodb select_1_row_cache 3.00 -0.00% 0.00
3.00 3.00 3.00 0.00
innodb select_2_rows 3.00 -9.09% -0.25
2.00 3.00 2.75 0.43
innodb select_big 11.00 -2.33% -0.25
10.00 12.00 10.75 0.83
innodb select_big_str 1.00 -0.00% 0.00
1.00 1.00 1.00 0.00
innodb select_cache 65.00 -7.44% -4.50
57.00 65.00 60.50 2.87
innodb select_cache2 59.00 +9.58% 6.25
59.00 70.00 65.25 3.96
innodb select_column+column 2.00 +11.11% 0.25
2.00 3.00 2.25 0.43
innodb select_diff_key 0.00 +100.00% 0.25
0.00 1.00 0.25 0.43
innodb select_distinct 4.00 +11.11% 0.50
4.00 5.00 4.50 0.50
innodb select_group 17.00 -11.48% -1.75
13.00 17.00 15.25 1.79
innodb select_group_when_MANY_tables 6.00 -26.32% -1.25
4.00 6.00 4.75 0.83
innodb select_join 1.00 -33.33% -0.25
0.00 1.00 0.75 0.43
innodb select_key 51.00 -7.37% -3.50
44.00 51.00 47.50 2.69
innodb select_key2 62.00 -1.22% -0.75
59.00 62.00 61.25 1.30
innodb select_key2_return_key 57.00 +2.15% 1.25
57.00 59.00 58.25 0.83
innodb select_key2_return_prim 59.00 -1.29% -0.75
57.00 59.00 58.25 0.83
innodb select_key_prefix 60.00 +0.41% 0.25
60.00 61.00 60.25 0.43
innodb select_key_prefix_join 4.00 +11.11% 0.50
4.00 5.00 4.50 0.50
innodb select_key_return_key 48.00 -1.05% -0.50
44.00 52.00 47.50 2.96
innodb select_many_fields 12.00 +5.88% 0.75
12.00 13.00 12.75 0.43
innodb select_range 48.00 +0.52% 0.25
45.00 52.00 48.25 2.49
innodb select_range_key2 9.00 -5.88% -0.50
8.00 9.00 8.50 0.50
innodb select_range_prefix 8.00 +5.88% 0.50
8.00 9.00 8.50 0.50
innodb select_simple 1.00 +20.00% 0.25
1.00 2.00 1.25 0.43
innodb select_simple_cache 2.00 -0.00% 0.00
2.00 2.00 2.00 0.00
innodb select_simple_join 1.00 -100.00% -0.50
0.00 1.00 0.50 0.50
innodb TOTALS 9999.99 -49.13% -3294.50
3383.00 9999.99 6705.50 3294.55
innodb update_autocommit 5.00 -25.00% -1.00
3.00 5.00 4.00 0.71
innodb update_big 67.00 -17.54% -10.00
35.00 69.00 57.00 13.49
innodb update_commit 1.00 -0.00% 0.00
1.00 1.00 1.00 0.00
innodb update_of_key 51.00 -37.84% -14.00
24.00 51.00 37.00 12.55
innodb update_of_key_big 36.00 -26.32% -7.50
16.00 39.00 28.50 9.39
innodb update_of_primary_key_many_keys 4774.00 -74.89% -2044.25
888.00 4774.00 2729.75 1846.37
innodb update_rollback 2.00 -60.00% -0.75
1.00 2.00 1.25 0.43
innodb update_with_key 123.00 -7.66% -8.75
105.00 123.00 114.25 8.29
innodb update_with_key_prefix 45.00 -8.43% -3.50
37.00 46.00 41.50 4.03
innodb wisc_benchmark 2.00 -0.00% 0.00
2.00 2.00 2.00 0.00
=========================================================================================================================
TRENDING OVER LAST 20 runs
Engine Test Time % Diff from Avg Diff
Min Max Avg STD
=========================================================================================================================
innodb alter_table_add 32.00 -29.29% -7.25
17.00 38.00 24.75 6.82
innodb alter_table_drop 24.00 -22.68% -4.44
12.00 27.00 19.56 4.74
innodb connect 2.00 +15.79% 0.38
2.00 3.00 2.38 0.48
innodb connect+select_1_row 3.00 -4.35% -0.13
2.00 3.00 2.88 0.33
innodb connect+select_simple 3.00 -20.00% -0.50
2.00 3.00 2.50 0.50
innodb count 17.00 -19.30% -2.75
13.00 18.00 14.25 1.79
innodb count_distinct 7.00 -8.74% -0.56
5.00 8.00 6.44 0.86
innodb count_distinct_2 13.00 -6.67% -0.81
11.00 15.00 12.19 1.51
innodb count_distinct_big 24.00 -14.29% -3.00
20.00 24.00 21.00 1.62
innodb count_distinct_group 13.00 -6.67% -0.81
10.00 14.00 12.19 1.51
innodb count_distinct_group_on_key 8.00 +11.11% 1.00
8.00 11.00 9.00 1.06
innodb count_distinct_group_on_key_parts 13.00 -11.23% -1.31
10.00 14.00 11.69 1.53
innodb count_distinct_key_prefix 6.00 -23.08% -1.13
4.00 6.00 4.88 0.78
innodb count_group_on_key_parts 10.00 -3.90% -0.38
8.00 11.00 9.63 0.86
innodb count_on_key 88.00 -2.33% -2.00
80.00 94.00 86.00 3.79
innodb create+drop 61.00 -56.66% -22.06
25.00 65.00 38.94 10.08
innodb create_index 3.00 -9.09% -0.25
1.00 4.00 2.75 0.83
innodb create_key+drop 35.00 -17.65% -5.25
26.00 40.00 29.75 3.38
innodb create_MANY_tables 77.00 -35.98% -20.38
29.00 86.00 56.63 16.08
innodb create_table 0.00 +100.00% 0.13
0.00 1.00 0.13 0.33
innodb delete_all_many_keys 1810.00 -253.73% -1298.31
290.00 1810.00 511.69 462.11
innodb delete_autocommit 5.00 -45.45% -1.56
3.00 5.00 3.44 0.61
innodb delete_big 0.00 +100.00% 0.38
0.00 1.00 0.38 0.48
innodb delete_big_many_keys 1810.00 -253.73% -1298.31
290.00 1810.00 511.69 462.11
innodb delete_commit 1.00 +27.27% 0.38
1.00 2.00 1.38 0.48
innodb delete_key 7.00 -86.67% -3.25
3.00 7.00 3.75 1.15
innodb delete_range 9.00 -25.22% -1.81
5.00 11.00 7.19 1.42
innodb delete_rollback 2.00 -28.00% -0.44
1.00 3.00 1.56 0.61
innodb drop_index 3.00 -0.00% 0.00
2.00 6.00 3.00 1.06
innodb drop_table 0.00 +100.00% 0.06
0.00 1.00 0.06 0.24
innodb drop_table_when_MANY_tables 27.00 -26.69% -5.69
14.00 27.00 21.31 4.01
innodb insert 140.00 -31.53% -33.56
100.00 140.00 106.44 12.04
innodb insert_autocommit 3.00 -6.67% -0.19
2.00 3.00 2.81 0.39
innodb insert_commit 2.00 -45.45% -0.63
1.00 2.00 1.38 0.48
innodb insert_duplicates 17.00 -17.24% -2.50
14.00 17.00 14.50 0.79
innodb insert_key 831.00 -157.13% -507.81
184.00 831.00 323.19 188.78
innodb insert_many_fields 10.00 -31.15% -2.38
5.00 10.00 7.63 1.45
innodb insert_rollback 1.00 +33.33% 0.50
1.00 2.00 1.50 0.50
innodb insert_select_1_key 4.00 -1.59% -0.06
3.00 6.00 3.94 0.83
innodb insert_select_2_keys 10.00 -68.42% -4.06
4.00 10.00 5.94 1.64
innodb min_max 8.00 -18.52% -1.25
6.00 9.00 6.75 0.97
innodb min_max_on_key 19.00 -3.05% -0.56
16.00 20.00 18.44 1.17
innodb multiple_value_insert 14.00 -140.86% -8.19
3.00 19.00 5.81 4.23
innodb once_prepared_select 23.00 +1.87% 0.44
22.00 25.00 23.44 0.79
innodb order_by_big 16.00 -15.32% -2.13
12.00 16.00 13.88 1.32
innodb order_by_big_key 12.00 +3.03% 0.38
11.00 14.00 12.38 1.11
innodb order_by_big_key2 11.00 +3.83% 0.44
10.00 13.00 11.44 1.27
innodb order_by_big_key_desc 12.00 +5.42% 0.69
11.00 15.00 12.69 1.16
innodb order_by_big_key_diff 12.00 -3.78% -0.44
10.00 13.00 11.56 1.27
innodb order_by_big_key_prefix 11.00 +8.81% 1.06
11.00 14.00 12.06 1.03
innodb order_by_key2_diff 2.00 -33.33% -0.50
1.00 2.00 1.50 0.50
innodb order_by_key_prefix 0.00 +100.00% 0.81
0.00 1.00 0.81 0.39
innodb order_by_range 1.00 -33.33% -0.25
0.00 1.00 0.75 0.43
innodb outer_join 23.00 -17.57% -3.44
17.00 23.00 19.56 2.21
innodb outer_join_found 21.00 -13.13% -2.44
15.00 22.00 18.56 2.29
innodb outer_join_not_found 19.00 -16.03% -2.63
14.00 19.00 16.38 2.03
innodb outer_join_on_key 15.00 -12.68% -1.69
11.00 16.00 13.31 1.45
innodb prepared_select 30.00 +6.43% 2.06
30.00 33.00 32.06 0.97
innodb select_1_row 2.00 +21.95% 0.56
2.00 3.00 2.56 0.50
innodb select_1_row_cache 3.00 -9.09% -0.25
2.00 3.00 2.75 0.43
innodb select_2_rows 3.00 -9.09% -0.25
2.00 3.00 2.75 0.43
innodb select_big 11.00 +3.30% 0.38
10.00 14.00 11.38 1.17
innodb select_big_str 1.00 +11.11% 0.13
1.00 2.00 1.13 0.33
innodb select_cache 65.00 -13.79% -7.88
52.00 65.00 57.13 4.82
innodb select_cache2 59.00 +0.11% 0.06
51.00 70.00 59.06 5.94
innodb select_column+column 2.00 +21.95% 0.56
2.00 3.00 2.56 0.50
innodb select_diff_key 0.00 +100.00% 0.19
0.00 1.00 0.19 0.39
innodb select_distinct 4.00 +7.25% 0.31
4.00 5.00 4.31 0.46
innodb select_group 17.00 -7.94% -1.25
13.00 18.00 15.75 1.44
innodb select_group_when_MANY_tables 6.00 -21.52% -1.06
4.00 7.00 4.94 0.83
innodb select_join 1.00 -100.00% -0.50
0.00 1.00 0.50 0.50
innodb select_key 51.00 -3.42% -1.69
44.00 52.00 49.31 2.28
innodb select_key2 62.00 -2.27% -1.38
58.00 62.00 60.63 1.22
innodb select_key2_return_key 57.00 +2.36% 1.38
57.00 60.00 58.38 0.99
innodb select_key2_return_prim 59.00 -0.43% -0.25
56.00 62.00 58.75 1.48
innodb select_key_prefix 60.00 +0.62% 0.38
58.00 62.00 60.38 1.05
innodb select_key_prefix_join 4.00 +13.51% 0.63
4.00 5.00 4.63 0.48
innodb select_key_return_key 48.00 -1.99% -0.94
43.00 55.00 47.06 3.25
innodb select_many_fields 12.00 +5.88% 0.75
12.00 13.00 12.75 0.43
innodb select_range 48.00 -1.72% -0.81
44.00 52.00 47.19 2.70
innodb select_range_key2 9.00 -6.67% -0.56
7.00 9.00 8.44 0.70
innodb select_range_prefix 8.00 +4.48% 0.38
8.00 9.00 8.38 0.48
innodb select_simple 1.00 +30.43% 0.44
1.00 2.00 1.44 0.50
innodb select_simple_cache 2.00 -23.08% -0.38
1.00 2.00 1.63 0.48
innodb select_simple_join 1.00 -45.45% -0.31
0.00 3.00 0.69 0.77
innodb TOTALS 9999.99 -136.19% -5766.12
3076.00 9999.99 4233.87 2186.89
innodb update_autocommit 5.00 -50.94% -1.69
3.00 5.00 3.31 0.58
innodb update_big 67.00 -37.08% -18.13
35.00 69.00 48.88 11.01
innodb update_commit 1.00 +33.33% 0.50
1.00 2.00 1.50 0.50
innodb update_of_key 51.00 -86.73% -23.69
22.00 51.00 27.31 8.47
innodb update_of_key_big 36.00 -53.60% -12.56
16.00 39.00 23.44 6.00
innodb update_of_primary_key_many_keys 4774.00 -253.58% -3423.81
796.00 4774.00 1350.19 1221.24
innodb update_rollback 2.00 -28.00% -0.44
1.00 2.00 1.56 0.50
innodb update_with_key 123.00 -14.49% -15.56
100.00 123.00 107.44 6.24
innodb update_with_key_prefix 45.00 -17.46% -6.69
36.00 46.00 38.31 2.84
innodb wisc_benchmark 2.00 +15.79% 0.38
2.00 4.00 2.38 0.60
=========================================================================================================================
TRENDING OVER ALL runs
Engine Test Time % Diff from Avg Diff
Min Max Avg STD
=========================================================================================================================
innodb alter_table_add 32.00 -162.89% -19.83
11.00 14.00 12.17 0.87
innodb alter_table_drop 24.00 -110.27% -12.59
10.00 14.00 11.41 1.07
innodb connect 2.00 -18.37% -0.31
1.00 2.00 1.69 0.46
innodb connect+select_1_row 3.00 -27.94% -0.66
2.00 3.00 2.34 0.48
innodb connect+select_simple 3.00 -52.63% -1.03
1.00 2.00 1.97 0.18
innodb count 17.00 -13.33% -2.00
13.00 18.00 15.00 1.76
innodb count_distinct 7.00 -15.34% -0.93
5.00 8.00 6.07 0.83
innodb count_distinct_2 13.00 -7.10% -0.86
11.00 16.00 12.14 1.38
innodb count_distinct_big 24.00 -12.44% -2.66
18.00 25.00 21.34 1.97
innodb count_distinct_group 13.00 -2.72% -0.34
11.00 14.00 12.66 0.84
innodb count_distinct_group_on_key 8.00 +10.08% 0.90
8.00 11.00 8.90 1.12
innodb count_distinct_group_on_key_parts 13.00 -10.56% -1.24
10.00 15.00 11.76 1.36
innodb count_distinct_key_prefix 6.00 -27.01% -1.28
4.00 6.00 4.72 0.69
innodb count_group_on_key_parts 10.00 -22.88% -1.86
7.00 10.00 8.14 0.78
innodb count_on_key 88.00 -13.93% -10.76
73.00 83.00 77.24 2.25
innodb create+drop 61.00 -212.54% -41.48
19.00 21.00 19.52 0.56
innodb create_index 3.00 -58.18% -1.10
1.00 3.00 1.90 0.48
innodb create_key+drop 35.00 -55.20% -12.45
21.00 23.00 22.55 0.56
innodb create_MANY_tables 77.00 -351.11% -59.93
14.00 20.00 17.07 1.70
innodb create_table 0.00 +100.00% 0.07
0.00 1.00 0.07 0.25
innodb delete_all_many_keys 1810.00 -508.93% -1512.76
239.00 345.00 297.24 21.38
innodb delete_autocommit 5.00 -76.83% -2.17
2.00 3.00 2.83 0.38
innodb delete_big 0.00 +100.00% 0.28
0.00 1.00 0.28 0.45
innodb delete_big_many_keys 1810.00 -509.14% -1512.86
239.00 345.00 297.14 21.37
innodb delete_commit 1.00 +25.64% 0.34
1.00 2.00 1.34 0.48
innodb delete_key 7.00 -185.92% -4.55
2.00 3.00 2.45 0.50
innodb delete_range 9.00 -29.21% -2.03
6.00 8.00 6.97 0.56
innodb delete_rollback 2.00 -52.63% -0.69
1.00 2.00 1.31 0.46
innodb drop_index 3.00 -52.63% -1.03
1.00 3.00 1.97 0.32
innodb drop_table 0.00 NULL 0.00
0.00 0.00 0.00 0.00
innodb drop_table_when_MANY_tables 27.00 -100.26% -13.52
12.00 15.00 13.48 0.62
innodb insert 140.00 -54.37% -49.31
88.00 93.00 90.69 1.37
innodb insert_autocommit 3.00 -16.00% -0.41
2.00 3.00 2.59 0.49
innodb insert_commit 2.00 -81.25% -0.90
1.00 2.00 1.10 0.30
innodb insert_duplicates 17.00 -32.53% -4.17
12.00 14.00 12.83 0.53
innodb insert_key 831.00 -188.92% -543.38
189.00 345.00 287.62 32.94
innodb insert_many_fields 10.00 -145.76% -5.93
3.00 5.00 4.07 0.36
innodb insert_rollback 1.00 +29.27% 0.41
1.00 2.00 1.41 0.49
innodb insert_select_1_key 4.00 -17.17% -0.59
3.00 4.00 3.41 0.49
innodb insert_select_2_keys 10.00 -93.33% -4.83
4.00 6.00 5.17 0.59
innodb min_max 8.00 -4.50% -0.34
6.00 9.00 7.66 1.03
innodb min_max_on_key 19.00 -12.68% -2.14
14.00 20.00 16.86 1.28
innodb multiple_value_insert 14.00 -209.92% -9.48
3.00 5.00 4.52 0.56
innodb once_prepared_select 23.00 -9.70% -2.03
20.00 22.00 20.97 0.61
innodb order_by_big 16.00 -13.17% -1.86
12.00 15.00 14.14 0.94
innodb order_by_big_key 12.00 +3.33% 0.41
11.00 14.00 12.41 1.19
innodb order_by_big_key2 11.00 +4.20% 0.48
10.00 13.00 11.48 0.97
innodb order_by_big_key_desc 12.00 +6.95% 0.90
12.00 14.00 12.90 0.92
innodb order_by_big_key_diff 12.00 -3.57% -0.41
10.00 13.00 11.59 0.85
innodb order_by_big_key_prefix 11.00 +8.07% 0.97
11.00 13.00 11.97 0.85
innodb order_by_key2_diff 2.00 -70.59% -0.83
1.00 2.00 1.17 0.38
innodb order_by_key_prefix 0.00 +100.00% 0.62
0.00 1.00 0.62 0.49
innodb order_by_range 1.00 -38.10% -0.28
0.00 1.00 0.72 0.45
innodb outer_join 23.00 -32.60% -5.66
15.00 21.00 17.34 2.06
innodb outer_join_found 21.00 -24.54% -4.14
14.00 21.00 16.86 2.19
innodb outer_join_not_found 19.00 -26.67% -4.00
13.00 18.00 15.00 1.49
innodb outer_join_on_key 15.00 -25.36% -3.03
10.00 15.00 11.97 1.50
innodb prepared_select 30.00 -16.00% -4.14
22.00 29.00 25.86 2.10
innodb select_1_row 2.00 +18.31% 0.45
2.00 3.00 2.45 0.50
innodb select_1_row_cache 3.00 -45.00% -0.93
2.00 3.00 2.07 0.25
innodb select_2_rows 3.00 -35.94% -0.79
2.00 3.00 2.21 0.41
innodb select_big 11.00 +5.34% 0.62
10.00 13.00 11.62 1.00
innodb select_big_str 1.00 +9.60% 0.11
0.00 2.00 1.11 0.31
innodb select_cache 65.00 -12.87% -7.41
51.00 71.00 57.59 5.41
innodb select_cache2 59.00 -3.76% -2.14
51.00 68.00 56.86 4.88
innodb select_column+column 2.00 +24.68% 0.66
2.00 3.00 2.66 0.48
innodb select_diff_key 0.00 +100.00% 0.17
0.00 1.00 0.17 0.38
innodb select_distinct 4.00 -1.75% -0.07
3.00 5.00 3.93 0.36
innodb select_group 17.00 -11.79% -1.79
13.00 18.00 15.21 1.47
innodb select_group_when_MANY_tables 6.00 -50.00% -2.00
3.00 5.00 4.00 0.37
innodb select_join 1.00 -107.14% -0.52
0.00 1.00 0.48 0.50
innodb select_key 51.00 -14.56% -6.48
40.00 50.00 44.52 2.50
innodb select_key2 62.00 -25.82% -12.72
46.00 54.00 49.28 2.41
innodb select_key2_return_key 57.00 -21.45% -10.07
42.00 51.00 46.93 2.32
innodb select_key2_return_prim 59.00 -21.87% -10.59
43.00 55.00 48.41 2.92
innodb select_key_prefix 60.00 -18.13% -9.21
45.00 57.00 50.79 3.46
innodb select_key_prefix_join 4.00 +4.13% 0.17
4.00 5.00 4.17 0.38
innodb select_key_return_key 48.00 -10.13% -4.41
39.00 49.00 43.59 2.65
innodb select_many_fields 12.00 +27.04% 4.45
15.00 17.00 16.45 0.62
innodb select_range 48.00 +1.76% 0.86
47.00 57.00 48.86 1.66
innodb select_range_key2 9.00 -24.29% -1.76
6.00 8.00 7.24 0.57
innodb select_range_prefix 8.00 -14.29% -1.00
6.00 8.00 7.00 0.64
innodb select_simple 1.00 +30.95% 0.45
1.00 2.00 1.45 0.50
innodb select_simple_cache 2.00 -75.76% -0.86
1.00 2.00 1.14 0.34
innodb select_simple_join 1.00 -38.10% -0.28
0.00 1.00 0.72 0.45
innodb TOTALS 9999.99 -900.01% -9000.00
999.99 999.99 999.99 0.00
innodb update_autocommit 5.00 -79.01% -2.21
2.00 3.00 2.79 0.41
innodb update_big 67.00 -85.93% -30.97
31.00 40.00 36.03 2.48
innodb update_commit 1.00 +25.64% 0.34
1.00 2.00 1.34 0.48
innodb update_of_key 51.00 -164.58% -31.72
19.00 20.00 19.28 0.45
innodb update_of_key_big 36.00 -96.61% -17.69
16.00 20.00 18.31 1.18
innodb update_of_primary_key_many_keys 4774.00 -525.41% -4010.67
661.00 799.00 763.33 39.70
innodb update_rollback 2.00 -41.46% -0.59
1.00 2.00 1.41 0.49
innodb update_with_key 123.00 -34.05% -31.24
90.00 93.00 91.76 0.97
innodb update_with_key_prefix 45.00 -27.69% -9.76
34.00 36.00 35.24 0.57
innodb wisc_benchmark 2.00 +14.71% 0.34
2.00 3.00 2.34 0.48
=========================================================================================================================
FULL REVISION COMMENTARY:
1897.2.2: Brian Aker 2010-10-31 [merge] MErge in Stewart's work
1894.2.3: Stewart Smith 2010-11-01 also remove temp file
1894.2.2: Stewart Smith 2010-11-01 add test for drizzleslap output being
consumed by a drizzle command line client
1894.2.1: Stewart Smith 2010-11-01 for drizzleslap --only-print, display
which connection (an incrementing number, stored in the client context of the
drizzle obj) the query is going against.
1897.2.1: Brian Aker 2010-10-31 [merge] Merge in changes (updates to style)
for slap.
1897.1.4: Brian Aker 2010-10-31 Remove a dead const char.
1897.1.3: Brian Aker 2010-10-31 Updating with moving out wakeup to its own
file. Why not use barrier for
1897.1.2: Brian Aker 2010-10-31 Merge in modifications for slap (upgrade
the style).
1897.1.1: Brian Aker 2010-10-31 Small syntax updates to slap.
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-benchmark
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-benchmark
More help : https://help.launchpad.net/ListHelp
