1 auto_increment_increment
4 automatic_sp_privileges
6 #|| basedir | /Applications/MAMP/Library/ |
9 binlog_direct_non_transactional_updates
11 binlog_stmt_cache_size
12 bulk_insert_buffer_size
14 character_set_connection
15 character_set_database
16 character_set_filesystem
20 #|| character_sets_dir | /Applications/MAMP/Library/share/charsets/ |
24 #|| completion_type | NO_CHAIN |
27 #|| datadir | /Users/foobar/.amp/ram_disk/mysql/ |
30 default_storage_engine
34 delayed_insert_timeout
36 #|| div_precision_increment | 4 |
37 #|| engine_condition_pushdown | ON |
39 #|| event_scheduler | OFF |
40 #|| expire_logs_days | 0 |
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 |
67 #|| hostname | whizbangz.local |
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 | |
89 innodb_file_format_check
90 innodb_file_format_max
92 innodb_flush_log_at_trx_commit
93 #|| innodb_flush_method | |
94 #|| innodb_force_load_corrupted | OFF |
95 #|| innodb_force_recovery | 0 |
97 #|| innodb_large_prefix | OFF |
98 innodb_lock_wait_timeout
99 #|| innodb_locks_unsafe_for_binlog | OFF |
100 innodb_log_buffer_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 |
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
121 #|| innodb_stats_on_metadata | ON |
122 #|| innodb_stats_sample_pages | 8 |
125 innodb_sync_spin_loops
127 innodb_thread_concurrency
128 #|| innodb_thread_sleep_delay | 10000 |
129 #|| innodb_use_native_aio | OFF |
130 #|| innodb_use_sys_malloc | ON |
132 innodb_write_io_threads
134 #|| interactive_timeout | 28800 |
136 #|| keep_files_on_create | OFF |
138 key_cache_age_threshold
140 key_cache_division_limit
144 #|| last_insert_id | 0 |
146 #|| lc_messages_dir | /Applications/MAMP/Library/share/ |
149 #|| local_infile | ON |
151 #|| locked_in_memory | OFF |
154 #|| log_bin_trust_function_creators | OFF |
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 |
162 #|| low_priority_updates | OFF |
163 lower_case_file_system
164 lower_case_table_names
166 max_binlog_cache_size
168 max_binlog_stmt_cache_size
174 max_insert_delayed_threads
176 max_length_for_sort_data
178 max_prepared_stmt_count
182 max_sp_recursion_depth
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 |
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/ |
228 #|| preload_buffer_size | 32768 |
230 profiling_history_size
233 #|| pseudo_slave_mode | OFF |
234 #|| pseudo_thread_id | 834 |
235 query_alloc_block_size
237 query_cache_min_res_unit
240 query_cache_wlock_invalidate
244 #|| range_alloc_block_size | 4096 |
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 |
255 #|| report_password | |
256 #|| report_port | 3307 |
258 #|| rpl_recovery_rank | 0 |
259 #|| secure_auth | OFF |
260 #|| secure_file_priv | |
262 #|| skip_external_locking | ON |
263 #|| skip_name_resolve | OFF |
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 |
284 sql_low_priority_updates
288 sql_quote_show_create
291 sql_slave_skip_counter
300 #|| sync_binlog | 0 |
302 #|| sync_master_info | 0 |
303 #|| sync_relay_log | 0 |
304 #|| sync_relay_log_info | 0 |
306 table_definition_cache
315 #|| timestamp | 1449353441 |
317 #|| tmpdir | /Users/foobar/.amp/ram_disk/tmp |
318 transaction_alloc_block_size
319 transaction_prealloc_size
322 updatable_views_with_limit
325 version_compile_machine