=======================================================================================
SQLBENCH REPORT
=======================================================================================
ENGINE: innodb
MACHINE: orisndriz05
RUN ID: 756
RUN DATE: 2010-12-21T23:18:55.128660
SERVER: drizzled
VERSION: staging
REVISION: 2018
COMMENT: 2018: Brian Aker 2010-12-21 [merge] Merge in code for time type,
other cleanups.
=========================================================================================================================
TRENDING OVER LAST 5 runs
Engine Test Time % Diff from Avg Diff
Min Max Avg STD
=========================================================================================================================
innodb alter_table_add 24.00 +30.23% 10.40
24.00 41.00 34.40 5.92
innodb alter_table_drop 17.00 +38.85% 10.80
17.00 35.00 27.80 5.91
innodb connect 2.00 +9.09% 0.20
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 +9.09% 0.20
2.00 3.00 2.20 0.40
innodb count 17.00 -6.25% -1.00
14.00 18.00 16.00 1.67
innodb count_distinct 6.00 +16.67% 1.20
6.00 8.00 7.20 0.75
innodb count_distinct_2 12.00 +21.05% 3.20
12.00 16.00 15.20 1.60
innodb count_distinct_big 24.00 -6.19% -1.40
20.00 24.00 22.60 1.74
innodb count_distinct_group 14.00 +5.41% 0.80
14.00 16.00 14.80 0.75
innodb count_distinct_group_on_key 10.00 +5.66% 0.60
10.00 12.00 10.60 0.80
innodb count_distinct_group_on_key_parts 14.00 -2.94% -0.40
12.00 14.00 13.60 0.80
innodb count_distinct_key_prefix 5.00 +7.41% 0.40
5.00 6.00 5.40 0.49
innodb count_group_on_key_parts 11.00 +1.79% 0.20
11.00 12.00 11.20 0.40
innodb count_on_key 97.00 -1.25% -1.20
91.00 100.00 95.80 3.06
innodb create+drop 37.00 +29.12% 15.20
37.00 62.00 52.20 10.05
innodb create_index 3.00 +37.50% 1.80
3.00 6.00 4.80 1.17
innodb create_key+drop 29.00 +11.04% 3.60
29.00 36.00 32.60 2.33
innodb create_MANY_tables 27.00 +39.46% 17.60
27.00 56.00 44.60 9.71
innodb create_table 0.00 +100.00% 0.20
0.00 1.00 0.20 0.40
innodb delete_all_many_keys 281.00 +67.28% 577.80
281.00 1357.00 858.80 471.93
innodb delete_autocommit 4.00 -17.65% -0.60
3.00 4.00 3.40 0.49
innodb delete_big 0.00 +100.00% 0.20
0.00 1.00 0.20 0.40
innodb delete_big_many_keys 281.00 +67.25% 577.00
281.00 1356.00 858.00 471.41
innodb delete_commit 2.00 -0.00% 0.00
2.00 2.00 2.00 0.00
innodb delete_key 2.00 +44.44% 1.60
2.00 5.00 3.60 1.02
innodb delete_range 9.00 +38.36% 5.60
9.00 19.00 14.60 3.20
innodb delete_rollback 2.00 -0.00% 0.00
2.00 2.00 2.00 0.00
innodb drop_index 2.00 +61.54% 3.20
2.00 7.00 5.20 1.94
innodb drop_table 0.00 +100.00% 0.20
0.00 1.00 0.20 0.40
innodb drop_table_when_MANY_tables 17.00 +37.50% 10.20
17.00 33.00 27.20 5.46
innodb insert 113.00 +3.25% 3.80
112.00 123.00 116.80 4.02
innodb insert_autocommit 4.00 -11.11% -0.40
3.00 4.00 3.60 0.49
innodb insert_commit 1.00 +37.50% 0.60
1.00 2.00 1.60 0.49
innodb insert_duplicates 20.00 -3.09% -0.60
19.00 20.00 19.40 0.49
innodb insert_key 214.00 +57.03% 284.00
214.00 706.00 498.00 196.14
innodb insert_many_fields 5.00 +28.57% 2.00
5.00 9.00 7.00 1.41
innodb insert_rollback 2.00 +9.09% 0.20
2.00 3.00 2.20 0.40
innodb insert_select_1_key 3.00 +28.57% 1.20
3.00 5.00 4.20 0.75
innodb insert_select_2_keys 7.00 +23.91% 2.20
7.00 11.00 9.20 1.47
innodb min_max 8.00 -2.56% -0.20
7.00 9.00 7.80 0.75
innodb min_max_on_key 25.00 -2.46% -0.60
24.00 25.00 24.40 0.49
innodb multiple_value_insert 4.00 +54.55% 4.80
4.00 12.00 8.80 3.25
innodb once_prepared_select 29.00 +2.68% 0.80
29.00 30.00 29.80 0.40
innodb order_by_big 12.00 +11.76% 1.60
12.00 15.00 13.60 1.20
innodb order_by_big_key 14.00 -12.90% -1.60
11.00 14.00 12.40 1.36
innodb order_by_big_key2 10.00 +9.09% 1.00
10.00 12.00 11.00 0.63
innodb order_by_big_key_desc 14.00 -7.69% -1.00
12.00 14.00 13.00 0.89
innodb order_by_big_key_diff 11.00 +3.51% 0.40
10.00 13.00 11.40 1.36
innodb order_by_big_key_prefix 11.00 +5.17% 0.60
11.00 13.00 11.60 0.80
innodb order_by_key2_diff 2.00 -42.86% -0.60
1.00 2.00 1.40 0.49
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 -0.00% 0.00
1.00 1.00 1.00 0.00
innodb outer_join 22.00 -10.00% -2.00
18.00 23.00 20.00 2.10
innodb outer_join_found 21.00 -10.53% -2.00
17.00 21.00 19.00 1.67
innodb outer_join_not_found 19.00 -7.95% -1.40
15.00 20.00 17.60 1.74
innodb outer_join_on_key 14.00 -6.06% -0.80
12.00 15.00 13.20 1.17
innodb prepared_select 37.00 +1.07% 0.40
37.00 39.00 37.40 0.80
innodb select_1_row 3.00 +11.76% 0.40
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 4.00 -5.26% -0.20
3.00 4.00 3.80 0.40
innodb select_big 13.00 -8.33% -1.00
11.00 13.00 12.00 0.89
innodb select_big_str 2.00 -25.00% -0.40
1.00 2.00 1.60 0.49
innodb select_cache 62.00 +4.91% 3.20
62.00 69.00 65.20 3.19
innodb select_cache2 62.00 +8.55% 5.80
62.00 73.00 67.80 3.66
innodb select_column+column 3.00 +16.67% 0.60
3.00 4.00 3.60 0.49
innodb select_distinct 4.00 +4.76% 0.20
4.00 5.00 4.20 0.40
innodb select_group 16.00 +2.44% 0.40
15.00 18.00 16.40 1.02
innodb select_group_when_MANY_tables 20.00 +35.06% 10.80
20.00 40.00 30.80 7.25
innodb select_join 1.00 -0.00% 0.00
1.00 1.00 1.00 0.00
innodb select_key 64.00 +0.93% 0.60
64.00 66.00 64.60 0.80
innodb select_key2 71.00 +1.11% 0.80
71.00 74.00 71.80 1.17
innodb select_key2_return_key 68.00 +0.58% 0.40
67.00 70.00 68.40 1.02
innodb select_key2_return_prim 69.00 +0.86% 0.60
68.00 72.00 69.60 1.62
innodb select_key_prefix 71.00 +0.84% 0.60
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 62.00 +1.59% 1.00
62.00 65.00 63.00 1.10
innodb select_many_fields 16.00 -12.68% -1.80
13.00 16.00 14.20 1.47
innodb select_range 40.00 +2.91% 1.20
39.00 43.00 41.20 1.60
innodb select_range_key2 10.00 -4.17% -0.40
9.00 10.00 9.60 0.49
innodb select_range_prefix 9.00 +4.26% 0.40
9.00 10.00 9.40 0.49
innodb select_simple 3.00 -15.38% -0.40
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 -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 62.00 +45.42% 51.60
62.00 141.00 113.60 27.56
innodb update_commit 2.00 -0.00% 0.00
2.00 2.00 2.00 0.00
innodb update_of_key 21.00 +5.41% 1.20
21.00 24.00 22.20 1.17
innodb update_of_key_big 38.00 +17.39% 8.00
38.00 54.00 46.00 5.40
innodb update_of_primary_key_many_keys 677.00 +64.22% 1215.20
677.00 2909.00 1892.20 963.04
innodb update_rollback 2.00 +9.09% 0.20
2.00 3.00 2.20 0.40
innodb update_with_key 113.00 +9.74% 12.20
113.00 134.00 125.20 7.63
innodb update_with_key_prefix 40.00 +7.83% 3.40
40.00 48.00 43.40 2.80
innodb wisc_benchmark 3.00 -7.14% -0.20
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 24.00 +34.87% 12.85
17.00 49.00 36.85 7.52
innodb alter_table_drop 17.00 +40.87% 11.75
14.00 42.00 28.75 6.47
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 2.00 +13.04% 0.30
2.00 3.00 2.30 0.46
innodb count 17.00 -7.26% -1.15
13.00 18.00 15.85 1.93
innodb count_distinct 6.00 +11.11% 0.75
5.00 8.00 6.75 0.94
innodb count_distinct_2 12.00 +13.04% 1.80
11.00 16.00 13.80 1.63
innodb count_distinct_big 24.00 -8.11% -1.80
19.00 25.00 22.20 1.81
innodb count_distinct_group 14.00 +1.75% 0.25
12.00 16.00 14.25 1.04
innodb count_distinct_group_on_key 10.00 -3.63% -0.35
8.00 12.00 9.65 1.19
innodb count_distinct_group_on_key_parts 14.00 -4.09% -0.55
11.00 15.00 13.45 1.07
innodb count_distinct_key_prefix 5.00 +3.85% 0.20
4.00 6.00 5.20 0.68
innodb count_group_on_key_parts 11.00 -0.00% 0.00
10.00 12.00 11.00 0.63
innodb count_on_key 97.00 -4.08% -3.80
88.00 100.00 93.20 3.09
innodb create+drop 37.00 +29.86% 15.75
34.00 72.00 52.75 12.00
innodb create_index 3.00 +34.07% 1.55
2.00 8.00 4.55 1.36
innodb create_key+drop 29.00 +16.43% 5.70
28.00 43.00 34.70 4.43
innodb create_MANY_tables 27.00 +39.87% 17.90
25.00 65.00 44.90 11.30
innodb create_table 0.00 +100.00% 0.30
0.00 3.00 0.30 0.71
innodb delete_all_many_keys 281.00 +71.00% 687.90
279.00 1486.00 968.90 489.59
innodb delete_autocommit 4.00 +1.23% 0.05
3.00 7.00 4.05 0.97
innodb delete_big 0.00 +100.00% 0.60
0.00 2.00 0.60 0.58
innodb delete_big_many_keys 281.00 +70.97% 686.80
278.00 1484.00 967.80 488.86
innodb delete_commit 2.00 -0.00% 0.00
1.00 3.00 2.00 0.45
innodb delete_key 2.00 +45.21% 1.65
2.00 5.00 3.65 0.91
innodb delete_range 9.00 +39.60% 5.90
8.00 23.00 14.90 4.39
innodb delete_rollback 2.00 +21.57% 0.55
2.00 3.00 2.55 0.50
innodb drop_index 2.00 +61.54% 3.20
2.00 8.00 5.20 1.47
innodb drop_table 0.00 +100.00% 0.10
0.00 1.00 0.10 0.30
innodb drop_table_when_MANY_tables 17.00 +42.18% 12.40
15.00 44.00 29.40 7.91
innodb insert 113.00 +4.60% 5.45
109.00 128.00 118.45 5.50
innodb insert_autocommit 4.00 -12.68% -0.45
3.00 4.00 3.55 0.50
innodb insert_commit 1.00 +35.48% 0.55
1.00 2.00 1.55 0.50
innodb insert_duplicates 20.00 -3.90% -0.75
18.00 20.00 19.25 0.54
innodb insert_key 214.00 +60.06% 321.75
210.00 805.00 535.75 216.46
innodb insert_many_fields 5.00 +30.07% 2.15
5.00 11.00 7.15 1.59
innodb insert_rollback 2.00 +4.76% 0.10
1.00 3.00 2.10 0.44
innodb insert_select_1_key 3.00 +26.83% 1.10
3.00 6.00 4.10 0.77
innodb insert_select_2_keys 7.00 +30.35% 3.05
6.00 16.00 10.05 2.52
innodb min_max 8.00 -1.27% -0.10
7.00 9.00 7.90 0.83
innodb min_max_on_key 25.00 -2.67% -0.65
24.00 25.00 24.35 0.48
innodb multiple_value_insert 4.00 +56.28% 5.15
4.00 15.00 9.15 3.92
innodb once_prepared_select 29.00 +1.69% 0.50
29.00 30.00 29.50 0.50
innodb order_by_big 12.00 +13.04% 1.80
12.00 16.00 13.80 1.17
innodb order_by_big_key 14.00 -11.11% -1.40
11.00 15.00 12.60 1.20
innodb order_by_big_key2 10.00 +13.04% 1.50
10.00 13.00 11.50 0.92
innodb order_by_big_key_desc 14.00 -6.46% -0.85
12.00 15.00 13.15 0.91
innodb order_by_big_key_diff 11.00 +4.35% 0.50
10.00 13.00 11.50 0.97
innodb order_by_big_key_prefix 11.00 +7.95% 0.95
11.00 14.00 11.95 1.02
innodb order_by_key2_diff 2.00 -25.00% -0.40
1.00 2.00 1.60 0.49
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 22.00 +0.45% 0.10
18.00 25.00 22.10 2.19
innodb outer_join_found 21.00 +0.94% 0.20
17.00 24.00 21.20 2.18
innodb outer_join_not_found 19.00 -0.53% -0.10
15.00 22.00 18.90 1.76
innodb outer_join_on_key 14.00 +6.35% 0.95
12.00 17.00 14.95 1.53
innodb prepared_select 37.00 +1.20% 0.45
37.00 39.00 37.45 0.59
innodb select_1_row 3.00 +18.92% 0.70
3.00 4.00 3.70 0.46
innodb select_1_row_cache 4.00 -9.59% -0.35
3.00 4.00 3.65 0.48
innodb select_2_rows 4.00 -8.11% -0.30
3.00 4.00 3.70 0.46
innodb select_big 13.00 -10.17% -1.20
10.00 14.00 11.80 1.08
innodb select_big_str 2.00 -42.86% -0.60
1.00 2.00 1.40 0.49
innodb select_cache 62.00 +0.64% 0.40
55.00 69.00 62.40 4.13
innodb select_cache2 62.00 +1.59% 1.00
54.00 73.00 63.00 4.88
innodb select_column+column 3.00 +20.00% 0.75
3.00 4.00 3.75 0.43
innodb select_distinct 4.00 +2.44% 0.10
4.00 5.00 4.10 0.30
innodb select_group 16.00 +4.76% 0.80
15.00 19.00 16.80 1.33
innodb select_group_when_MANY_tables 20.00 +35.28% 10.90
14.00 44.00 30.90 9.62
innodb select_join 1.00 -11.11% -0.10
0.00 1.00 0.90 0.30
innodb select_key 64.00 +0.47% 0.30
63.00 66.00 64.30 0.78
innodb select_key2 71.00 +0.42% 0.30
70.00 74.00 71.30 0.84
innodb select_key2_return_key 68.00 +0.07% 0.05
67.00 70.00 68.05 0.74
innodb select_key2_return_prim 69.00 +0.29% 0.20
68.00 72.00 69.20 0.98
innodb select_key_prefix 71.00 +0.14% 0.10
70.00 74.00 71.10 0.89
innodb select_key_prefix_join 5.00 -1.01% -0.05
4.00 5.00 4.95 0.22
innodb select_key_return_key 62.00 +1.67% 1.05
62.00 65.00 63.05 0.67
innodb select_many_fields 16.00 -13.48% -1.90
13.00 16.00 14.10 1.14
innodb select_range 40.00 +10.81% 4.85
39.00 52.00 44.85 3.62
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 3.00 -33.33% -0.75
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 -33.33% -0.25
0.00 1.00 0.75 0.43
innodb update_autocommit 3.00 +14.29% 0.50
3.00 4.00 3.50 0.50
innodb update_big 62.00 +47.41% 55.90
55.00 171.00 117.90 32.18
innodb update_commit 2.00 -0.00% 0.00
1.00 3.00 2.00 0.32
innodb update_of_key 21.00 +4.76% 1.05
20.00 24.00 22.05 1.02
innodb update_of_key_big 38.00 +16.48% 7.50
33.00 58.00 45.50 6.95
innodb update_of_primary_key_many_keys 677.00 +67.97% 1436.40
647.00 3180.00 2113.40 999.19
innodb update_rollback 2.00 +11.11% 0.25
2.00 3.00 2.25 0.43
innodb update_with_key 113.00 +9.09% 11.30
113.00 136.00 124.30 8.72
innodb update_with_key_prefix 40.00 +9.09% 4.00
40.00 49.00 44.00 3.13
innodb wisc_benchmark 3.00 -7.14% -0.20
2.00 5.00 2.80 0.81
=========================================================================================================================
TRENDING OVER ALL runs
Engine Test Time % Diff from Avg Diff
Min Max Avg STD
=========================================================================================================================
innodb alter_table_add 24.00 -32.48% -5.88
11.00 61.00 18.12 8.99
innodb alter_table_drop 17.00 -1.09% -0.18
10.00 57.00 16.82 6.71
innodb connect 2.00 +2.27% 0.05
1.00 3.00 2.05 0.41
innodb connect+select_1_row 3.00 -13.30% -0.35
2.00 5.00 2.65 0.50
innodb connect+select_simple 2.00 +12.33% 0.28
1.00 3.00 2.28 0.46
innodb count 17.00 -8.20% -1.29
12.00 193.00 15.71 9.81
innodb count_distinct 6.00 +7.60% 0.49
5.00 50.00 6.49 2.51
innodb count_distinct_2 12.00 +7.89% 1.03
11.00 63.00 13.03 3.22
innodb count_distinct_big 24.00 -10.44% -2.27
5.00 67.00 21.73 3.22
innodb count_distinct_group 14.00 -9.89% -1.26
10.00 68.00 12.74 3.23
innodb count_distinct_group_on_key 10.00 -6.81% -0.64
7.00 69.00 9.36 3.30
innodb count_distinct_group_on_key_parts 14.00 -16.81% -2.01
9.00 72.00 11.99 3.32
innodb count_distinct_key_prefix 5.00 +1.15% 0.06
3.00 52.00 5.06 2.64
innodb count_group_on_key_parts 11.00 -13.49% -1.31
7.00 72.00 9.69 3.45
innodb count_on_key 97.00 -15.50% -13.02
68.00 203.00 83.98 7.93
innodb create+drop 37.00 -15.70% -5.02
18.00 81.00 31.98 12.97
innodb create_index 3.00 -9.23% -0.25
1.00 8.00 2.75 1.14
innodb create_key+drop 29.00 -5.45% -1.50
21.00 50.00 27.50 4.87
innodb create_MANY_tables 27.00 +25.45% 9.22
14.00 121.00 36.22 17.53
innodb create_table 0.00 +100.00% 0.11
0.00 3.00 0.11 0.38
innodb delete_all_many_keys 281.00 +32.51% 135.34
212.00 2293.00 416.34 391.25
innodb delete_autocommit 4.00 -18.95% -0.64
2.00 7.00 3.36 0.62
innodb delete_big 0.00 +100.00% 0.23
0.00 2.00 0.23 0.43
innodb delete_big_many_keys 281.00 +32.48% 135.18
212.00 2293.00 416.18 391.04
innodb delete_commit 2.00 -40.33% -0.57
1.00 3.00 1.43 0.51
innodb delete_key 2.00 +35.37% 1.09
2.00 35.00 3.09 1.64
innodb delete_range 9.00 -12.15% -0.98
5.00 23.00 8.02 3.30
innodb delete_rollback 2.00 -26.54% -0.42
1.00 4.00 1.58 0.58
innodb drop_index 2.00 +29.66% 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 17.00 +12.40% 2.41
11.00 49.00 19.41 6.46
innodb insert 113.00 -7.90% -8.27
3.00 343.00 104.73 15.62
innodb insert_autocommit 4.00 -36.50% -1.07
2.00 99.00 2.93 3.69
innodb insert_commit 1.00 +21.97% 0.28
1.00 3.00 1.28 0.46
innodb insert_duplicates 20.00 -37.61% -5.47
11.00 21.00 14.53 2.10
innodb insert_key 214.00 +37.39% 127.77
142.00 959.00 341.77 169.83
innodb insert_many_fields 5.00 +8.95% 0.49
3.00 17.00 5.49 1.90
innodb insert_rollback 2.00 -27.00% -0.43
1.00 3.00 1.57 0.53
innodb insert_select_1_key 3.00 +19.84% 0.74
2.00 10.00 3.74 0.92
innodb insert_select_2_keys 7.00 -18.85% -1.11
4.00 16.00 5.89 2.14
innodb min_max 8.00 -2.50% -0.19
6.00 110.00 7.81 5.05
innodb min_max_on_key 25.00 -27.91% -5.45
14.00 37.00 19.55 2.62
innodb multiple_value_insert 4.00 +22.06% 1.13
2.00 50.00 5.13 4.63
innodb once_prepared_select 29.00 -26.40% -6.06
18.00 32.00 22.94 2.81
innodb order_by_big 12.00 +15.84% 2.26
12.00 31.00 14.26 1.60
innodb order_by_big_key 14.00 -7.33% -0.96
11.00 32.00 13.04 1.62
innodb order_by_big_key2 10.00 +16.75% 2.01
10.00 33.00 12.01 1.60
innodb order_by_big_key_desc 14.00 -6.80% -0.89
11.00 32.00 13.11 1.55
innodb order_by_big_key_diff 11.00 +8.60% 1.03
10.00 31.00 12.03 1.55
innodb order_by_big_key_prefix 11.00 +9.67% 1.18
10.00 32.00 12.18 1.62
innodb order_by_key2_diff 2.00 -42.44% -0.60
1.00 3.00 1.40 0.50
innodb order_by_key_prefix 1.00 -29.57% -0.23
0.00 2.00 0.77 0.43
innodb order_by_range 1.00 -24.86% -0.20
0.00 2.00 0.80 0.41
innodb outer_join 22.00 -17.72% -3.31
15.00 61.00 18.69 3.69
innodb outer_join_found 21.00 -15.56% -2.83
14.00 58.00 18.17 3.56
innodb outer_join_not_found 19.00 -19.86% -3.15
12.00 46.00 15.85 3.08
innodb outer_join_on_key 14.00 -12.38% -1.54
10.00 59.00 12.46 2.80
innodb prepared_select 37.00 -24.02% -7.17
22.00 40.00 29.83 3.79
innodb select_1_row 3.00 -12.81% -0.34
2.00 4.00 2.66 0.60
innodb select_1_row_cache 4.00 -60.37% -1.51
2.00 4.00 2.49 0.60
innodb select_2_rows 4.00 -49.76% -1.33
2.00 4.00 2.67 0.59
innodb select_big 13.00 -8.56% -1.02
0.00 31.00 11.98 1.59
innodb select_big_str 2.00 -77.93% -0.88
0.00 2.00 1.12 0.33
innodb select_cache 62.00 -2.83% -1.71
49.00 676.00 60.29 30.17
innodb select_cache2 62.00 -2.00% -1.21
49.00 677.00 60.79 31.84
innodb select_column+column 3.00 -10.64% -0.29
2.00 4.00 2.71 0.61
innodb select_diff_key 0.00 +100.00% 0.20
0.00 1.00 0.20 0.40
innodb select_distinct 4.00 +4.17% 0.17
3.00 8.00 4.17 0.54
innodb select_group 16.00 +0.42% 0.07
4.00 136.00 16.07 6.01
innodb select_group_when_MANY_tables 20.00 -152.01% -12.06
3.00 47.00 7.94 8.97
innodb select_join 1.00 -78.76% -0.44
0.00 1.00 0.56 0.50
innodb select_key 64.00 -28.07% -14.03
40.00 66.00 49.97 5.55
innodb select_key2 71.00 -25.54% -14.45
45.00 75.00 56.55 6.67
innodb select_key2_return_key 68.00 -26.21% -14.12
42.00 70.00 53.88 6.34
innodb select_key2_return_prim 69.00 -26.33% -14.38
42.00 72.00 54.62 6.53
innodb select_key_prefix 71.00 -27.44% -15.29
44.00 75.00 55.71 6.50
innodb select_key_prefix_join 5.00 -8.42% -0.39
3.00 10.00 4.61 0.66
innodb select_key_return_key 62.00 -26.50% -12.99
38.00 65.00 49.01 5.60
innodb select_many_fields 16.00 -3.98% -0.61
11.00 19.00 15.39 1.73
innodb select_range 40.00 +16.95% 8.17
39.00 76.00 48.17 3.51
innodb select_range_key2 10.00 -25.92% -2.06
6.00 10.00 7.94 0.89
innodb select_range_prefix 9.00 -20.19% -1.51
5.00 10.00 7.49 0.91
innodb select_simple 3.00 -93.10% -1.45
1.00 3.00 1.55 0.53
innodb select_simple_cache 2.00 -38.83% -0.56
1.00 3.00 1.44 0.51
innodb select_simple_join 1.00 -59.35% -0.37
0.00 3.00 0.63 0.49
innodb update_autocommit 3.00 +5.14% 0.16
2.00 5.00 3.16 0.49
innodb update_big 62.00 -33.05% -15.40
31.00 171.00 46.60 22.33
innodb update_commit 2.00 -39.76% -0.57
1.00 3.00 1.43 0.50
innodb update_of_key 21.00 +14.95% 3.69
18.00 100.00 24.69 6.81
innodb update_of_key_big 38.00 -52.17% -13.03
15.00 75.00 24.97 10.56
innodb update_of_primary_key_many_keys 677.00 +42.54% 501.17
647.00 6065.00 1178.17 1,070.89
innodb update_rollback 2.00 -31.24% -0.48
1.00 4.00 1.52 0.56
innodb update_with_key 113.00 -5.89% -6.29
90.00 598.00 106.71 22.08
innodb update_with_key_prefix 40.00 -3.90% -1.50
33.00 202.00 38.50 7.11
innodb wisc_benchmark 3.00 -22.67% -0.55
2.00 5.00 2.45 0.52
=========================================================================================================================
FULL REVISION COMMENTARY:
2016.1.7: Brian Aker 2010-12-21 Remove MyISAM flip bit, and make sure that we
only pass in a good time_t to
2016.1.6: Brian Aker 2010-12-20 Additional cleanup for int32t time type
2016.1.5: Brian Aker 2010-12-20 Small cleanup on translating double to a time
2016.1.4: Brian Aker 2010-12-20 Fix tests where not cleaning them up after
running.
2016.1.3: Brian Aker 2010-12-20 Regression on session list.
2016.1.2: Brian Aker 2010-12-20 Fix for Solaris
2016.1.1: Brian Aker 2010-12-20 [merge] Update of the time code. Epoch is now
used for timestamp internall (this is
2015.1.2: Brian Aker 2010-12-20 Remove unsigned flag.
2015.1.1: Brian Aker 2010-12-20 [merge] Merge with trunk.
1999.4.12: Brian Aker 2010-12-20 Adds additional testing, and fixes CAST
again.
1999.4.11: Brian Aker 2010-12-19 Fix issues with some columns incorrectly
reporting NULL if they were of
1999.4.10: Brian Aker 2010-12-19 This fixes the bug where we were not
displaying the correct field type in
1999.4.9: Brian Aker 2010-12-18 Created EPOCH
1999.4.8: Brian Aker 2010-12-17 Adding in time type.
1999.4.7: Brian Aker 2010-12-17 Merge in first pass of TIME type (closer
to EPOCH time).
1999.4.6: Brian Aker 2010-12-17 Fix pack/unpack to go through common
functions.
1999.4.5: Brian Aker 2010-12-16 Get all of the endian stuff out of the
classes.
1999.4.4: Brian Aker 2010-12-16 First pass through on timestamp.
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-benchmark
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-benchmark
More help : https://help.launchpad.net/ListHelp
