1
1
SHOW VARIABLES LIKE 'falcon_%';
3
3
falcon_checkpoint_schedule 7 * * * * *
4
5
falcon_consistent_read ON
6
7
falcon_debug_server OFF
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
59
62
SELECT @@GLOBAL.falcon_debug_mask;
60
63
@@GLOBAL.falcon_debug_mask
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
66
SET GLOBAL falcon_max_transaction_backlog = 10001;
67
SELECT @@GLOBAL.falcon_max_transaction_backlog;
68
@@GLOBAL.falcon_max_transaction_backlog
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
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
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
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 * * * * *
92
88
FALCON_CONSISTENT_READ ON
93
89
FALCON_DEBUG_MASK 4096
94
90
FALCON_DEBUG_SERVER OFF
95
91
FALCON_DEBUG_TRACE 0
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;