Commit | Line | Data |
---|---|---|
7163c128 TO |
1 | auto_increment_increment |
2 | auto_increment_offset | |
3 | autocommit | |
4 | automatic_sp_privileges | |
5 | back_log | |
6 | #|| basedir | /Applications/MAMP/Library/ | | |
7 | big_tables | |
8 | binlog_cache_size | |
9 | binlog_direct_non_transactional_updates | |
10 | binlog_format | |
11 | binlog_stmt_cache_size | |
12 | bulk_insert_buffer_size | |
13 | character_set_client | |
14 | character_set_connection | |
15 | character_set_database | |
16 | character_set_filesystem | |
17 | character_set_results | |
18 | character_set_server | |
19 | character_set_system | |
20 | #|| character_sets_dir | /Applications/MAMP/Library/share/charsets/ | | |
21 | collation_connection | |
22 | collation_database | |
23 | collation_server | |
24 | #|| completion_type | NO_CHAIN | | |
25 | concurrent_insert | |
26 | connect_timeout | |
27 | #|| datadir | /Users/foobar/.amp/ram_disk/mysql/ | | |
28 | date_format | |
29 | datetime_format | |
30 | default_storage_engine | |
31 | default_week_format | |
32 | delay_key_write | |
33 | delayed_insert_limit | |
34 | delayed_insert_timeout | |
35 | delayed_queue_size | |
36 | #|| div_precision_increment | 4 | | |
37 | #|| engine_condition_pushdown | ON | | |
38 | error_count | |
39 | #|| event_scheduler | OFF | | |
40 | #|| expire_logs_days | 0 | | |
41 | #|| external_user | | | |
42 | flush | |
43 | flush_time | |
44 | foreign_key_checks | |
45 | ft_boolean_syntax | |
46 | ft_max_word_len | |
47 | ft_min_word_len | |
48 | ft_query_expansion_limit | |
49 | #|| ft_stopword_file | (built-in) | | |
50 | #|| general_log | OFF | | |
51 | #|| general_log_file | /Users/foobar/.amp/ram_disk/mysql/whizbangz.log | | |
52 | group_concat_max_len | |
53 | have_compress | |
54 | have_crypt | |
55 | have_csv | |
56 | have_dynamic_loading | |
57 | have_geometry | |
58 | have_innodb | |
59 | have_ndbcluster | |
60 | have_openssl | |
61 | have_partitioning | |
62 | have_profiling | |
63 | have_query_cache | |
64 | have_rtree_keys | |
65 | have_ssl | |
66 | have_symlink | |
67 | #|| hostname | whizbangz.local | | |
68 | #|| identity | 0 | | |
69 | ignore_builtin_innodb | |
70 | #|| init_connect | | | |
71 | #|| init_file | | | |
72 | #|| init_slave | | | |
73 | innodb_adaptive_flushing | |
74 | innodb_adaptive_hash_index | |
75 | innodb_additional_mem_pool_size | |
76 | innodb_autoextend_increment | |
77 | innodb_autoinc_lock_mode | |
78 | innodb_buffer_pool_instances | |
79 | innodb_buffer_pool_size | |
80 | #|| innodb_change_buffering | all | | |
81 | #|| innodb_checksums | ON | | |
82 | innodb_commit_concurrency | |
83 | innodb_concurrency_tickets | |
84 | #|| innodb_data_file_path | ibdata1:10M:autoextend | | |
85 | #|| innodb_data_home_dir | | | |
86 | innodb_doublewrite | |
87 | innodb_fast_shutdown | |
88 | innodb_file_format | |
89 | innodb_file_format_check | |
90 | innodb_file_format_max | |
91 | innodb_file_per_table | |
92 | innodb_flush_log_at_trx_commit | |
93 | #|| innodb_flush_method | | | |
94 | #|| innodb_force_load_corrupted | OFF | | |
95 | #|| innodb_force_recovery | 0 | | |
96 | innodb_io_capacity | |
97 | #|| innodb_large_prefix | OFF | | |
98 | innodb_lock_wait_timeout | |
99 | #|| innodb_locks_unsafe_for_binlog | OFF | | |
100 | innodb_log_buffer_size | |
101 | innodb_log_file_size | |
102 | innodb_log_files_in_group | |
103 | #|| innodb_log_group_home_dir | ./ | | |
104 | #|| innodb_max_dirty_pages_pct | 75 | | |
105 | #|| innodb_max_purge_lag | 0 | | |
106 | #|| innodb_mirrored_log_groups | 1 | | |
107 | #|| innodb_old_blocks_pct | 37 | | |
108 | #|| innodb_old_blocks_time | 0 | | |
109 | innodb_open_files | |
110 | innodb_print_all_deadlocks | |
111 | #|| innodb_purge_batch_size | 20 | | |
112 | #|| innodb_purge_threads | 0 | | |
113 | #|| innodb_random_read_ahead | OFF | | |
114 | #|| innodb_read_ahead_threshold | 56 | | |
115 | #|| innodb_read_io_threads | 4 | | |
116 | innodb_replication_delay | |
117 | innodb_rollback_on_timeout | |
118 | innodb_rollback_segments | |
119 | innodb_spin_wait_delay | |
120 | innodb_stats_method | |
121 | #|| innodb_stats_on_metadata | ON | | |
122 | #|| innodb_stats_sample_pages | 8 | | |
123 | innodb_strict_mode | |
124 | innodb_support_xa | |
125 | innodb_sync_spin_loops | |
126 | innodb_table_locks | |
127 | innodb_thread_concurrency | |
128 | #|| innodb_thread_sleep_delay | 10000 | | |
129 | #|| innodb_use_native_aio | OFF | | |
130 | #|| innodb_use_sys_malloc | ON | | |
131 | innodb_version | |
132 | innodb_write_io_threads | |
133 | #|| insert_id | 0 | | |
134 | #|| interactive_timeout | 28800 | | |
135 | join_buffer_size | |
136 | #|| keep_files_on_create | OFF | | |
137 | key_buffer_size | |
138 | key_cache_age_threshold | |
139 | key_cache_block_size | |
140 | key_cache_division_limit | |
141 | large_files_support | |
142 | large_page_size | |
143 | large_pages | |
144 | #|| last_insert_id | 0 | | |
145 | lc_messages | |
146 | #|| lc_messages_dir | /Applications/MAMP/Library/share/ | | |
147 | lc_time_names | |
148 | #|| license | GPL | | |
149 | #|| local_infile | ON | | |
150 | lock_wait_timeout | |
151 | #|| locked_in_memory | OFF | | |
152 | #|| log | OFF | | |
153 | #|| log_bin | OFF | | |
154 | #|| log_bin_trust_function_creators | OFF | | |
155 | #|| log_error | | | |
156 | #|| log_output | FILE | | |
157 | #|| log_queries_not_using_indexes | OFF | | |
158 | #|| log_slave_updates | OFF | | |
159 | #|| log_slow_queries | OFF | | |
160 | #|| log_warnings | 1 | | |
161 | long_query_time | |
162 | #|| low_priority_updates | OFF | | |
163 | lower_case_file_system | |
164 | lower_case_table_names | |
165 | max_allowed_packet | |
166 | max_binlog_cache_size | |
167 | max_binlog_size | |
168 | max_binlog_stmt_cache_size | |
169 | max_connect_errors | |
170 | max_connections | |
171 | max_delayed_threads | |
172 | max_error_count | |
173 | max_heap_table_size | |
174 | max_insert_delayed_threads | |
175 | max_join_size | |
176 | max_length_for_sort_data | |
177 | max_long_data_size | |
178 | max_prepared_stmt_count | |
179 | max_relay_log_size | |
180 | max_seeks_for_key | |
181 | max_sort_length | |
182 | max_sp_recursion_depth | |
183 | max_tmp_tables | |
184 | max_user_connections | |
185 | max_write_lock_count | |
186 | metadata_locks_cache_size | |
187 | #|| min_examined_row_limit | 0 | | |
188 | #|| multi_range_count | 256 | | |
189 | #|| myisam_data_pointer_size | 6 | | |
190 | #|| myisam_max_sort_file_size | 9223372036853727232 | | |
191 | #|| myisam_mmap_size | 18446744073709551615 | | |
192 | #|| myisam_recover_options | OFF | | |
193 | #|| myisam_repair_threads | 1 | | |
194 | #|| myisam_sort_buffer_size | 8388608 | | |
195 | #|| myisam_stats_method | nulls_unequal | | |
196 | #|| myisam_use_mmap | OFF | | |
197 | net_buffer_length | |
198 | net_read_timeout | |
199 | net_retry_count | |
200 | net_write_timeout | |
201 | #|| new | OFF | | |
202 | #|| old | OFF | | |
203 | #|| old_alter_table | OFF | | |
204 | #|| old_passwords | OFF | | |
205 | #|| open_files_limit | 961 | | |
206 | optimizer_prune_level | |
207 | optimizer_search_depth | |
208 | #|| optimizer_switch | index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,engine_condition_pushdown=on | | |
209 | #|| performance_schema | OFF | | |
210 | #|| performance_schema_events_waits_history_long_size | 10000 | | |
211 | #|| performance_schema_events_waits_history_size | 10 | | |
212 | #|| performance_schema_max_cond_classes | 80 | | |
213 | #|| performance_schema_max_cond_instances | 1000 | | |
214 | #|| performance_schema_max_file_classes | 50 | | |
215 | #|| performance_schema_max_file_handles | 32768 | | |
216 | #|| performance_schema_max_file_instances | 10000 | | |
217 | #|| performance_schema_max_mutex_classes | 200 | | |
218 | #|| performance_schema_max_mutex_instances | 1000000 | | |
219 | #|| performance_schema_max_rwlock_classes | 30 | | |
220 | #|| performance_schema_max_rwlock_instances | 1000000 | | |
221 | #|| performance_schema_max_table_handles | 100000 | | |
222 | #|| performance_schema_max_table_instances | 50000 | | |
223 | #|| performance_schema_max_thread_classes | 50 | | |
224 | #|| performance_schema_max_thread_instances | 1000 | | |
225 | #|| pid_file | /Users/foobar/.amp/ram_disk/tmp/mysqld.pid | | |
226 | #|| plugin_dir | /Applications/MAMP/Library/lib/plugin/ | | |
227 | #|| port | 3307 | | |
228 | #|| preload_buffer_size | 32768 | | |
229 | profiling | |
230 | profiling_history_size | |
231 | protocol_version | |
232 | #|| proxy_user | | | |
233 | #|| pseudo_slave_mode | OFF | | |
234 | #|| pseudo_thread_id | 834 | | |
235 | query_alloc_block_size | |
236 | query_cache_limit | |
237 | query_cache_min_res_unit | |
238 | query_cache_size | |
239 | query_cache_type | |
240 | query_cache_wlock_invalidate | |
241 | query_prealloc_size | |
242 | #|| rand_seed1 | 0 | | |
243 | #|| rand_seed2 | 0 | | |
244 | #|| range_alloc_block_size | 4096 | | |
245 | read_buffer_size | |
246 | read_only | |
247 | read_rnd_buffer_size | |
248 | #|| relay_log | | | |
249 | #|| relay_log_index | | | |
250 | #|| relay_log_info_file | relay-log.info | | |
251 | #|| relay_log_purge | ON | | |
252 | #|| relay_log_recovery | OFF | | |
253 | #|| relay_log_space_limit | 0 | | |
254 | #|| report_host | | | |
255 | #|| report_password | | | |
256 | #|| report_port | 3307 | | |
257 | #|| report_user | | | |
258 | #|| rpl_recovery_rank | 0 | | |
259 | #|| secure_auth | OFF | | |
260 | #|| secure_file_priv | | | |
261 | #|| server_id | 0 | | |
262 | #|| skip_external_locking | ON | | |
263 | #|| skip_name_resolve | OFF | | |
264 | skip_networking | |
265 | #|| skip_show_database | OFF | | |
266 | #|| slave_compressed_protocol | OFF | | |
267 | #|| slave_exec_mode | STRICT | | |
268 | #|| slave_load_tmpdir | /Users/foobar/.amp/ram_disk/tmp | | |
269 | #|| slave_max_allowed_packet | 1073741824 | | |
270 | #|| slave_net_timeout | 3600 | | |
271 | #|| slave_skip_errors | OFF | | |
272 | #|| slave_transaction_retries | 10 | | |
273 | #|| slave_type_conversions | | | |
274 | #|| slow_launch_time | 2 | | |
275 | #|| slow_query_log | OFF | | |
276 | #|| slow_query_log_file | /Users/foobar/.amp/ram_disk/mysql/whizbangz-slow.log | | |
277 | #|| socket | /Users/foobar/.amp/ram_disk/tmp/mysqld.sock | | |
278 | #|| sort_buffer_size | 2097152 | | |
279 | sql_auto_is_null | |
280 | sql_big_selects | |
281 | sql_big_tables | |
282 | sql_log_bin | |
283 | sql_log_off | |
284 | sql_low_priority_updates | |
285 | sql_max_join_size | |
286 | sql_mode | |
287 | sql_notes | |
288 | sql_quote_show_create | |
289 | sql_safe_updates | |
290 | sql_select_limit | |
291 | sql_slave_skip_counter | |
292 | sql_warnings | |
293 | #|| ssl_ca | | | |
294 | #|| ssl_capath | | | |
295 | #|| ssl_cert | | | |
296 | #|| ssl_cipher | | | |
297 | #|| ssl_key | | | |
298 | storage_engine | |
299 | stored_program_cache | |
300 | #|| sync_binlog | 0 | | |
301 | #|| sync_frm | ON | | |
302 | #|| sync_master_info | 0 | | |
303 | #|| sync_relay_log | 0 | | |
304 | #|| sync_relay_log_info | 0 | | |
305 | system_time_zone | |
306 | table_definition_cache | |
307 | table_open_cache | |
308 | thread_cache_size | |
309 | thread_concurrency | |
310 | thread_handling | |
311 | thread_stack | |
312 | time_format | |
313 | time_zone | |
314 | timed_mutexes | |
315 | #|| timestamp | 1449353441 | | |
316 | tmp_table_size | |
317 | #|| tmpdir | /Users/foobar/.amp/ram_disk/tmp | | |
318 | transaction_alloc_block_size | |
319 | transaction_prealloc_size | |
320 | tx_isolation | |
321 | unique_checks | |
322 | updatable_views_with_limit | |
323 | version | |
324 | version_comment | |
325 | version_compile_machine | |
326 | version_compile_os | |
327 | wait_timeout | |
328 | warning_count |