1
+-----------------------------------------+-------------------------------------------------------------------------------------+
2
| Variable_name | Value |
3
+-----------------------------------------+-------------------------------------------------------------------------------------+
4
| auto_increment_increment | 1 |
5
| auto_increment_offset | 1 |
6
| automatic_sp_privileges | ON |
8
| basedir | /home/daniel/mysql_binaries/mysql-5.0.82-linux-x86_64-glibc23/ |
9
| binlog_cache_size | 32768 |
10
| bulk_insert_buffer_size | 8388608 |
11
| character_set_client | latin1 |
12
| character_set_connection | latin1 |
13
| character_set_database | latin1 |
14
| character_set_filesystem | binary |
15
| character_set_results | latin1 |
16
| character_set_server | latin1 |
17
| character_set_system | utf8 |
18
| character_sets_dir | /home/daniel/mysql_binaries/mysql-5.0.82-linux-x86_64-glibc23/share/mysql/charsets/ |
19
| collation_connection | latin1_swedish_ci |
20
| collation_database | latin1_swedish_ci |
21
| collation_server | latin1_swedish_ci |
22
| completion_type | 0 |
23
| concurrent_insert | 1 |
24
| connect_timeout | 10 |
25
| datadir | /tmp/12345/data/ |
26
| date_format | %Y-%m-%d |
27
| datetime_format | %Y-%m-%d %H:%i:%s |
28
| default_week_format | 0 |
29
| delay_key_write | ON |
30
| delayed_insert_limit | 100 |
31
| delayed_insert_timeout | 300 |
32
| delayed_queue_size | 1000 |
33
| div_precision_increment | 4 |
34
| keep_files_on_create | OFF |
35
| engine_condition_pushdown | OFF |
36
| expire_logs_days | 0 |
39
| ft_boolean_syntax | + -><()~*:""&| |
40
| ft_max_word_len | 84 |
41
| ft_min_word_len | 4 |
42
| ft_query_expansion_limit | 20 |
43
| ft_stopword_file | (built-in) |
44
| group_concat_max_len | 1024 |
45
| have_archive | YES |
47
| have_blackhole_engine | YES |
48
| have_compress | YES |
49
| have_community_features | YES |
50
| have_profiling | YES |
53
| have_dynamic_loading | YES |
54
| have_example_engine | NO |
55
| have_federated_engine | YES |
56
| have_geometry | YES |
59
| have_merge_engine | YES |
60
| have_ndbcluster | DISABLED |
61
| have_openssl | DISABLED |
62
| have_ssl | DISABLED |
63
| have_query_cache | YES |
65
| have_rtree_keys | YES |
66
| have_symlink | YES |
71
| innodb_additional_mem_pool_size | 1048576 |
72
| innodb_autoextend_increment | 8 |
73
| innodb_buffer_pool_awe_mem_mb | 0 |
74
| innodb_buffer_pool_size | 16777216 |
75
| innodb_checksums | ON |
76
| innodb_commit_concurrency | 0 |
77
| innodb_concurrency_tickets | 500 |
78
| innodb_data_file_path | ibdata1:10M:autoextend |
79
| innodb_data_home_dir | /tmp/12345/data |
80
| innodb_adaptive_hash_index | ON |
81
| innodb_doublewrite | ON |
82
| innodb_fast_shutdown | 1 |
83
| innodb_file_io_threads | 4 |
84
| innodb_file_per_table | OFF |
85
| innodb_flush_log_at_trx_commit | 1 |
86
| innodb_flush_method | |
87
| innodb_force_recovery | 0 |
88
| innodb_lock_wait_timeout | 50 |
89
| innodb_locks_unsafe_for_binlog | OFF |
90
| innodb_log_arch_dir | |
91
| innodb_log_archive | OFF |
92
| innodb_log_buffer_size | 1048576 |
93
| innodb_log_file_size | 5242880 |
94
| innodb_log_files_in_group | 2 |
95
| innodb_log_group_home_dir | /tmp/12345/data |
96
| innodb_max_dirty_pages_pct | 90 |
97
| innodb_max_purge_lag | 0 |
98
| innodb_mirrored_log_groups | 1 |
99
| innodb_open_files | 300 |
100
| innodb_rollback_on_timeout | OFF |
101
| innodb_support_xa | ON |
102
| innodb_sync_spin_loops | 20 |
103
| innodb_table_locks | ON |
104
| innodb_thread_concurrency | 8 |
105
| innodb_thread_sleep_delay | 10000 |
106
| innodb_use_legacy_cardinality_algorithm | ON |
107
| interactive_timeout | 28800 |
108
| join_buffer_size | 131072 |
109
| key_buffer_size | 16777216 |
110
| key_cache_age_threshold | 300 |
111
| key_cache_block_size | 1024 |
112
| key_cache_division_limit | 100 |
113
| language | /home/daniel/mysql_binaries/mysql-5.0.82-linux-x86_64-glibc23/share/mysql/english/ |
114
| large_files_support | ON |
115
| large_page_size | 0 |
116
| large_pages | OFF |
117
| lc_time_names | en_US |
119
| local_infile | ON |
120
| locked_in_memory | OFF |
123
| log_bin_trust_function_creators | OFF |
125
| log_queries_not_using_indexes | OFF |
126
| log_slave_updates | ON |
127
| log_slow_queries | OFF |
129
| long_query_time | 10 |
130
| low_priority_updates | OFF |
131
| lower_case_file_system | OFF |
132
| lower_case_table_names | 0 |
133
| max_allowed_packet | 1048576 |
134
| max_binlog_cache_size | 18446744073709547520 |
135
| max_binlog_size | 1073741824 |
136
| max_connect_errors | 10 |
137
| max_connections | 100 |
138
| max_delayed_threads | 20 |
139
| max_error_count | 64 |
140
| max_heap_table_size | 16777216 |
141
| max_insert_delayed_threads | 20 |
142
| max_join_size | 18446744073709551615 |
143
| max_length_for_sort_data | 1024 |
144
| max_prepared_stmt_count | 16382 |
145
| max_relay_log_size | 0 |
146
| max_seeks_for_key | 18446744073709551615 |
147
| max_sort_length | 1024 |
148
| max_sp_recursion_depth | 0 |
149
| max_tmp_tables | 32 |
150
| max_user_connections | 0 |
151
| max_write_lock_count | 18446744073709551615 |
152
| multi_range_count | 256 |
153
| myisam_data_pointer_size | 6 |
154
| myisam_max_sort_file_size | 9223372036853727232 |
155
| myisam_recover_options | OFF |
156
| myisam_repair_threads | 1 |
157
| myisam_sort_buffer_size | 8388608 |
158
| myisam_stats_method | nulls_unequal |
159
| ndb_autoincrement_prefetch_sz | 1 |
160
| ndb_force_send | ON |
161
| ndb_use_exact_count | ON |
162
| ndb_use_transactions | ON |
163
| ndb_cache_check_time | 0 |
164
| ndb_connectstring | |
165
| net_buffer_length | 16384 |
166
| net_read_timeout | 30 |
167
| net_retry_count | 10 |
168
| net_write_timeout | 60 |
170
| old_passwords | OFF |
171
| open_files_limit | 1024 |
172
| optimizer_prune_level | 1 |
173
| optimizer_search_depth | 62 |
174
| pid_file | /tmp/12345/data/mysql_sandbox12345.pid |
177
| preload_buffer_size | 32768 |
179
| profiling_history_size | 15 |
180
| protocol_version | 10 |
181
| query_alloc_block_size | 8192 |
182
| query_cache_limit | 1048576 |
183
| query_cache_min_res_unit | 4096 |
184
| query_cache_size | 0 |
185
| query_cache_type | ON |
186
| query_cache_wlock_invalidate | OFF |
187
| query_prealloc_size | 8192 |
188
| range_alloc_block_size | 4096 |
189
| read_buffer_size | 131072 |
191
| read_rnd_buffer_size | 262144 |
192
| relay_log | mysql-relay-bin |
193
| relay_log_index | |
194
| relay_log_info_file | relay-log.info |
195
| relay_log_purge | ON |
196
| relay_log_space_limit | 0 |
197
| rpl_recovery_rank | 0 |
198
| secure_auth | OFF |
199
| secure_file_priv | |
200
| server_id | 12345 |
201
| skip_external_locking | ON |
202
| skip_networking | OFF |
203
| skip_show_database | OFF |
204
| slave_compressed_protocol | OFF |
205
| slave_load_tmpdir | /tmp/ |
206
| slave_net_timeout | 3600 |
207
| slave_skip_errors | OFF |
208
| slave_transaction_retries | 10 |
209
| slow_launch_time | 2 |
210
| socket | /tmp/12345/mysql_sandbox12345.sock |
211
| sort_buffer_size | 2097144 |
212
| sql_big_selects | ON |
215
| sql_warnings | OFF |
221
| storage_engine | MyISAM |
224
| system_time_zone | MDT |
226
| table_lock_wait_timeout | 50 |
227
| table_type | MyISAM |
228
| thread_cache_size | 0 |
229
| thread_stack | 262144 |
230
| time_format | %H:%i:%s |
231
| time_zone | SYSTEM |
232
| timed_mutexes | OFF |
233
| tmp_table_size | 33554432 |
235
| transaction_alloc_block_size | 8192 |
236
| transaction_prealloc_size | 4096 |
237
| tx_isolation | REPEATABLE-READ |
238
| updatable_views_with_limit | YES |
239
| version | 5.0.82-log |
240
| version_comment | MySQL Community Server (GPL) |
241
| version_compile_machine | x86_64 |
242
| version_compile_os | unknown-linux-gnu |
243
| wait_timeout | 28800 |
244
+-----------------------------------------+-------------------------------------------------------------------------------------+
added
removed
t/lib/samples/show-variables/vars003.txt
