~jlukas79/+junk/mysql-server

« back to all changes in this revision

Viewing changes to mysql-test/suite/falcon/r/falcon_options.result

manual merge 6.0-main --> 6.0-bka-review

Show diffs side-by-side

added added

removed removed

Lines of Context:
1
1
SHOW VARIABLES LIKE 'falcon_%';
2
2
Variable_name   Value
3
3
falcon_checkpoint_schedule      7 * * * * *
 
4
falcon_checksums        ON
4
5
falcon_consistent_read  ON
5
6
falcon_debug_mask       0
6
7
falcon_debug_server     OFF
7
8
falcon_debug_trace      0
8
9
falcon_direct_io        1
9
10
falcon_gopher_threads   5
10
 
falcon_index_chill_threshold    4
 
11
falcon_index_chill_threshold    4194304
11
12
falcon_initial_allocation       0
12
13
falcon_io_threads       2
13
14
falcon_large_blob_threshold     160000
14
15
falcon_lock_wait_timeout        50
15
 
falcon_max_transaction_backlog  150
16
16
falcon_page_cache_size  4194304
17
17
falcon_page_size        4096
18
 
falcon_record_chill_threshold   5
 
18
falcon_record_chill_threshold   5242880
19
19
falcon_record_memory_max        262144000
20
20
falcon_record_scavenge_floor    50
21
21
falcon_record_scavenge_threshold        67
23
23
falcon_serial_log_block_size    0
24
24
falcon_serial_log_buffers       20
25
25
falcon_serial_log_dir   
 
26
falcon_serial_log_file_size     10485760
26
27
falcon_serial_log_priority      1
27
28
falcon_support_xa       OFF
28
29
falcon_use_deferred_index_hash  OFF
 
30
falcon_use_sectorcache  OFF
 
31
falcon_use_supernodes   ON
29
32
SELECT @@GLOBAL.falcon_debug_server;
30
33
@@GLOBAL.falcon_debug_server
31
34
0
59
62
SELECT @@GLOBAL.falcon_debug_mask;
60
63
@@GLOBAL.falcon_debug_mask
61
64
4096
62
 
SELECT @@GLOBAL.falcon_max_transaction_backlog INTO @previous_falcon_max_transaction_backlog;
63
 
SELECT @@GLOBAL.falcon_max_transaction_backlog;
64
 
@@GLOBAL.falcon_max_transaction_backlog
65
 
150
66
 
SET GLOBAL falcon_max_transaction_backlog = 10001;
67
 
SELECT @@GLOBAL.falcon_max_transaction_backlog;
68
 
@@GLOBAL.falcon_max_transaction_backlog
69
 
10001
70
65
SELECT @@GLOBAL.falcon_record_memory_max INTO @previous_falcon_record_memory_max;
71
66
SELECT @@GLOBAL.falcon_record_memory_max;
72
67
@@GLOBAL.falcon_record_memory_max
76
71
@@GLOBAL.falcon_record_memory_max
77
72
536870912
78
73
SELECT @@GLOBAL.falcon_index_chill_threshold INTO @previous_falcon_index_chill_threshold;
79
 
SET GLOBAL falcon_index_chill_threshold = 1024;
 
74
SET GLOBAL falcon_index_chill_threshold = 1073741824;
80
75
SELECT @@GLOBAL.falcon_index_chill_threshold;
81
76
@@GLOBAL.falcon_index_chill_threshold
82
 
1024
 
77
1073741824
83
78
SELECT @@GLOBAL.falcon_record_chill_threshold INTO @previous_falcon_record_chill_threshold;
84
 
SET GLOBAL falcon_record_chill_threshold = 1024;
 
79
SET GLOBAL falcon_record_chill_threshold = 1073741824;
85
80
SELECT @@GLOBAL.falcon_record_chill_threshold;
86
81
@@GLOBAL.falcon_record_chill_threshold
87
 
1024
 
82
1073741824
88
83
SELECT * FROM INFORMATION_SCHEMA.global_variables
89
84
WHERE variable_name LIKE 'falcon%';
90
85
VARIABLE_NAME   VARIABLE_VALUE
91
86
FALCON_CHECKPOINT_SCHEDULE      7 * * * * *
 
87
FALCON_CHECKSUMS        ON
92
88
FALCON_CONSISTENT_READ  ON
93
89
FALCON_DEBUG_MASK       4096
94
90
FALCON_DEBUG_SERVER     OFF
95
91
FALCON_DEBUG_TRACE      0
96
92
FALCON_DIRECT_IO        1
97
93
FALCON_GOPHER_THREADS   5
98
 
FALCON_INDEX_CHILL_THRESHOLD    1024
 
94
FALCON_INDEX_CHILL_THRESHOLD    1073741824
99
95
FALCON_INITIAL_ALLOCATION       0
100
96
FALCON_IO_THREADS       2
101
97
FALCON_LARGE_BLOB_THRESHOLD     160000
102
98
FALCON_LOCK_WAIT_TIMEOUT        50
103
 
FALCON_MAX_TRANSACTION_BACKLOG  10001
104
99
FALCON_PAGE_CACHE_SIZE  4194304
105
100
FALCON_PAGE_SIZE        4096
106
 
FALCON_RECORD_CHILL_THRESHOLD   1024
 
101
FALCON_RECORD_CHILL_THRESHOLD   1073741824
107
102
FALCON_RECORD_MEMORY_MAX        536870912
108
103
FALCON_RECORD_SCAVENGE_FLOOR    50
109
104
FALCON_RECORD_SCAVENGE_THRESHOLD        67
111
106
FALCON_SERIAL_LOG_BLOCK_SIZE    0
112
107
FALCON_SERIAL_LOG_BUFFERS       20
113
108
FALCON_SERIAL_LOG_DIR   
 
109
FALCON_SERIAL_LOG_FILE_SIZE     10485760
114
110
FALCON_SERIAL_LOG_PRIORITY      1
115
111
FALCON_SUPPORT_XA       OFF
116
112
FALCON_USE_DEFERRED_INDEX_HASH  OFF
 
113
FALCON_USE_SECTORCACHE  OFF
 
114
FALCON_USE_SUPERNODES   ON
117
115
SET GLOBAL falcon_debug_mask = @previous_falcon_debug_mask;
118
 
SET GLOBAL falcon_max_transaction_backlog =  @previous_falcon_max_transaction_backlog;
119
116
SET GLOBAL falcon_record_memory_max =  @previous_falcon_record_memory_max;
120
117
SET GLOBAL falcon_index_chill_threshold = @previous_falcon_index_chill_threshold;
121
118
SET GLOBAL falcon_record_chill_threshold = @previous_falcon_record_chill_threshold;