文档章节

Ubuntu用源方式安装MySQL的默认配置信息

FeanLau
 FeanLau
发布于 2018/02/10 18:19
字数 1128
阅读 20
收藏 0
mysql> show variables;
+----------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Variable_name                                            | Value                                                                                                                                                                                                                                                                                                                                                                                                            |
+----------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| auto_increment_increment                                 | 1                                                                                                                                                                                                                                                                                                                                                                                                                |
| auto_increment_offset                                    | 1                                                                                                                                                                                                                                                                                                                                                                                                                |
| autocommit                                               | ON                                                                                                                                                                                                                                                                                                                                                                                                               |
| automatic_sp_privileges                                  | ON                                                                                                                                                                                                                                                                                                                                                                                                               |
| avoid_temporal_upgrade                                   | OFF                                                                                                                                                                                                                                                                                                                                                                                                              |
| back_log                                                 | 80                                                                                                                                                                                                                                                                                                                                                                                                               |
| basedir                                                  | /usr/                                                                                                                                                                                                                                                                                                                                                                                                            |
| big_tables                                               | OFF                                                                                                                                                                                                                                                                                                                                                                                                              |
| bind_address                                             | 127.0.0.1                                                                                                                                                                                                                                                                                                                                                                                                        |
| binlog_cache_size                                        | 32768                                                                                                                                                                                                                                                                                                                                                                                                            |
| binlog_checksum                                          | CRC32                                                                                                                                                                                                                                                                                                                                                                                                            |
| binlog_direct_non_transactional_updates                  | OFF                                                                                                                                                                                                                                                                                                                                                                                                              |
| binlog_error_action                                      | ABORT_SERVER                                                                                                                                                                                                                                                                                                                                                                                                     |
| binlog_format                                            | ROW                                                                                                                                                                                                                                                                                                                                                                                                              |
| binlog_group_commit_sync_delay                           | 0                                                                                                                                                                                                                                                                                                                                                                                                                |
| binlog_group_commit_sync_no_delay_count                  | 0                                                                                                                                                                                                                                                                                                                                                                                                                |
| binlog_gtid_simple_recovery                              | ON                                                                                                                                                                                                                                                                                                                                                                                                               |
| binlog_max_flush_queue_time                              | 0                                                                                                                                                                                                                                                                                                                                                                                                                |
| binlog_order_commits                                     | ON                                                                                                                                                                                                                                                                                                                                                                                                               |
| binlog_row_image                                         | FULL                                                                                                                                                                                                                                                                                                                                                                                                             |
| binlog_rows_query_log_events                             | OFF                                                                                                                                                                                                                                                                                                                                                                                                              |
| binlog_stmt_cache_size                                   | 32768                                                                                                                                                                                                                                                                                                                                                                                                            |
| block_encryption_mode                                    | aes-128-ecb                                                                                                                                                                                                                                                                                                                                                                                                      |
| bulk_insert_buffer_size                                  | 8388608                                                                                                                                                                                                                                                                                                                                                                                                          |
| character_set_client                                     | utf8                                                                                                                                                                                                                                                                                                                                                                                                             |
| character_set_connection                                 | utf8                                                                                                                                                                                                                                                                                                                                                                                                             |
| character_set_database                                   | latin1                                                                                                                                                                                                                                                                                                                                                                                                           |
| character_set_filesystem                                 | binary                                                                                                                                                                                                                                                                                                                                                                                                           |
| character_set_results                                    | utf8                                                                                                                                                                                                                                                                                                                                                                                                             |
| character_set_server                                     | latin1                                                                                                                                                                                                                                                                                                                                                                                                           |
| character_set_system                                     | utf8                                                                                                                                                                                                                                                                                                                                                                                                             |
| character_sets_dir                                       | /usr/share/mysql/charsets/                                                                                                                                                                                                                                                                                                                                                                                       |
| check_proxy_users                                        | OFF                                                                                                                                                                                                                                                                                                                                                                                                              |
| collation_connection                                     | utf8_general_ci                                                                                                                                                                                                                                                                                                                                                                                                  |
| collation_database                                       | latin1_swedish_ci                                                                                                                                                                                                                                                                                                                                                                                                |
| collation_server                                         | latin1_swedish_ci                                                                                                                                                                                                                                                                                                                                                                                                |
| completion_type                                          | NO_CHAIN                                                                                                                                                                                                                                                                                                                                                                                                         |
| concurrent_insert                                        | AUTO                                                                                                                                                                                                                                                                                                                                                                                                             |
| connect_timeout                                          | 10                                                                                                                                                                                                                                                                                                                                                                                                               |
| core_file                                                | OFF                                                                                                                                                                                                                                                                                                                                                                                                              |
| datadir                                                  | /var/lib/mysql/                                                                                                                                                                                                                                                                                                                                                                                                  |
| date_format                                              | %Y-%m-%d                                                                                                                                                                                                                                                                                                                                                                                                         |
| datetime_format                                          | %Y-%m-%d %H:%i:%s                                                                                                                                                                                                                                                                                                                                                                                                |
| default_authentication_plugin                            | mysql_native_password                                                                                                                                                                                                                                                                                                                                                                                            |
| default_password_lifetime                                | 0                                                                                                                                                                                                                                                                                                                                                                                                                |
| default_storage_engine                                   | InnoDB                                                                                                                                                                                                                                                                                                                                                                                                           |
| default_tmp_storage_engine                               | InnoDB                                                                                                                                                                                                                                                                                                                                                                                                           |
| default_week_format                                      | 0                                                                                                                                                                                                                                                                                                                                                                                                                |
| delay_key_write                                          | ON                                                                                                                                                                                                                                                                                                                                                                                                               |
| delayed_insert_limit                                     | 100                                                                                                                                                                                                                                                                                                                                                                                                              |
| delayed_insert_timeout                                   | 300                                                                                                                                                                                                                                                                                                                                                                                                              |
| delayed_queue_size                                       | 1000                                                                                                                                                                                                                                                                                                                                                                                                             |
| disabled_storage_engines                                 |                                                                                                                                                                                                                                                                                                                                                                                                                  |
| disconnect_on_expired_password                           | ON                                                                                                                                                                                                                                                                                                                                                                                                               |
| div_precision_increment                                  | 4                                                                                                                                                                                                                                                                                                                                                                                                                |
| end_markers_in_json                                      | OFF                                                                                                                                                                                                                                                                                                                                                                                                              |
| enforce_gtid_consistency                                 | OFF                                                                                                                                                                                                                                                                                                                                                                                                              |
| eq_range_index_dive_limit                                | 200                                                                                                                                                                                                                                                                                                                                                                                                              |
| error_count                                              | 0                                                                                                                                                                                                                                                                                                                                                                                                                |
| event_scheduler                                          | OFF                                                                                                                                                                                                                                                                                                                                                                                                              |
| expire_logs_days                                         | 10                                                                                                                                                                                                                                                                                                                                                                                                               |
| explicit_defaults_for_timestamp                          | OFF                                                                                                                                                                                                                                                                                                                                                                                                              |
| external_user                                            |                                                                                                                                                                                                                                                                                                                                                                                                                  |
| flush                                                    | OFF                                                                                                                                                                                                                                                                                                                                                                                                              |
| flush_time                                               | 0                                                                                                                                                                                                                                                                                                                                                                                                                |
| foreign_key_checks                                       | ON                                                                                                                                                                                                                                                                                                                                                                                                               |
| ft_boolean_syntax                                        | + -><()~*:""&|                                                                                                                                                                                                                                                                                                                                                                                                   |
| ft_max_word_len                                          | 84                                                                                                                                                                                                                                                                                                                                                                                                               |
| ft_min_word_len                                          | 4                                                                                                                                                                                                                                                                                                                                                                                                                |
| ft_query_expansion_limit                                 | 20                                                                                                                                                                                                                                                                                                                                                                                                               |
| ft_stopword_file                                         | (built-in)                                                                                                                                                                                                                                                                                                                                                                                                       |
| general_log                                              | OFF                                                                                                                                                                                                                                                                                                                                                                                                              |
| general_log_file                                         | /var/lib/mysql/feanlau-VirtualBox.log                                                                                                                                                                                                                                                                                                                                                                            |
| group_concat_max_len                                     | 1024                                                                                                                                                                                                                                                                                                                                                                                                             |
| gtid_executed_compression_period                         | 1000                                                                                                                                                                                                                                                                                                                                                                                                             |
| gtid_mode                                                | OFF                                                                                                                                                                                                                                                                                                                                                                                                              |
| gtid_next                                                | AUTOMATIC                                                                                                                                                                                                                                                                                                                                                                                                        |
| gtid_owned                                               |                                                                                                                                                                                                                                                                                                                                                                                                                  |
| gtid_purged                                              |                                                                                                                                                                                                                                                                                                                                                                                                                  |
| have_compress                                            | YES                                                                                                                                                                                                                                                                                                                                                                                                              |
| have_crypt                                               | YES                                                                                                                                                                                                                                                                                                                                                                                                              |
| have_dynamic_loading                                     | YES                                                                                                                                                                                                                                                                                                                                                                                                              |
| have_geometry                                            | YES                                                                                                                                                                                                                                                                                                                                                                                                              |
| have_openssl                                             | DISABLED                                                                                                                                                                                                                                                                                                                                                                                                         |
| have_profiling                                           | YES                                                                                                                                                                                                                                                                                                                                                                                                              |
| have_query_cache                                         | YES                                                                                                                                                                                                                                                                                                                                                                                                              |
| have_rtree_keys                                          | YES                                                                                                                                                                                                                                                                                                                                                                                                              |
| have_ssl                                                 | DISABLED                                                                                                                                                                                                                                                                                                                                                                                                         |
| have_statement_timeout                                   | YES                                                                                                                                                                                                                                                                                                                                                                                                              |
| have_symlink                                             | YES                                                                                                                                                                                                                                                                                                                                                                                                              |
| host_cache_size                                          | 279                                                                                                                                                                                                                                                                                                                                                                                                              |
| hostname                                                 | feanlau-VirtualBox                                                                                                                                                                                                                                                                                                                                                                                               |
| identity                                                 | 0                                                                                                                                                                                                                                                                                                                                                                                                                |
| ignore_builtin_innodb                                    | OFF                                                                                                                                                                                                                                                                                                                                                                                                              |
| ignore_db_dirs                                           |                                                                                                                                                                                                                                                                                                                                                                                                                  |
| init_connect                                             |                                                                                                                                                                                                                                                                                                                                                                                                                  |
| init_file                                                |                                                                                                                                                                                                                                                                                                                                                                                                                  |
| init_slave                                               |                                                                                                                                                                                                                                                                                                                                                                                                                  |
| innodb_adaptive_flushing                                 | ON                                                                                                                                                                                                                                                                                                                                                                                                               |
| innodb_adaptive_flushing_lwm                             | 10                                                                                                                                                                                                                                                                                                                                                                                                               |
| innodb_adaptive_hash_index                               | ON                                                                                                                                                                                                                                                                                                                                                                                                               |
| innodb_adaptive_hash_index_parts                         | 8                                                                                                                                                                                                                                                                                                                                                                                                                |
| innodb_adaptive_max_sleep_delay                          | 150000                                                                                                                                                                                                                                                                                                                                                                                                           |
| innodb_api_bk_commit_interval                            | 5                                                                                                                                                                                                                                                                                                                                                                                                                |
| innodb_api_disable_rowlock                               | OFF                                                                                                                                                                                                                                                                                                                                                                                                              |
| innodb_api_enable_binlog                                 | OFF                                                                                                                                                                                                                                                                                                                                                                                                              |
| innodb_api_enable_mdl                                    | OFF                                                                                                                                                                                                                                                                                                                                                                                                              |
| innodb_api_trx_level                                     | 0                                                                                                                                                                                                                                                                                                                                                                                                                |
| innodb_autoextend_increment                              | 64                                                                                                                                                                                                                                                                                                                                                                                                               |
| innodb_autoinc_lock_mode                                 | 1                                                                                                                                                                                                                                                                                                                                                                                                                |
| innodb_buffer_pool_chunk_size                            | 134217728                                                                                                                                                                                                                                                                                                                                                                                                        |
| innodb_buffer_pool_dump_at_shutdown                      | ON                                                                                                                                                                                                                                                                                                                                                                                                               |
| innodb_buffer_pool_dump_now                              | OFF                                                                                                                                                                                                                                                                                                                                                                                                              |
| innodb_buffer_pool_dump_pct                              | 25                                                                                                                                                                                                                                                                                                                                                                                                               |
| innodb_buffer_pool_filename                              | ib_buffer_pool                                                                                                                                                                                                                                                                                                                                                                                                   |
| innodb_buffer_pool_instances                             | 1                                                                                                                                                                                                                                                                                                                                                                                                                |
| innodb_buffer_pool_load_abort                            | OFF                                                                                                                                                                                                                                                                                                                                                                                                              |
| innodb_buffer_pool_load_at_startup                       | ON                                                                                                                                                                                                                                                                                                                                                                                                               |
| innodb_buffer_pool_load_now                              | OFF                                                                                                                                                                                                                                                                                                                                                                                                              |
| innodb_buffer_pool_size                                  | 134217728                                                                                                                                                                                                                                                                                                                                                                                                        |
| innodb_change_buffer_max_size                            | 25                                                                                                                                                                                                                                                                                                                                                                                                               |
| innodb_change_buffering                                  | all                                                                                                                                                                                                                                                                                                                                                                                                              |
| innodb_checksum_algorithm                                | crc32                                                                                                                                                                                                                                                                                                                                                                                                            |
| innodb_checksums                                         | ON                                                                                                                                                                                                                                                                                                                                                                                                               |
| innodb_cmp_per_index_enabled                             | OFF                                                                                                                                                                                                                                                                                                                                                                                                              |
| innodb_commit_concurrency                                | 0                                                                                                                                                                                                                                                                                                                                                                                                                |
| innodb_compression_failure_threshold_pct                 | 5                                                                                                                                                                                                                                                                                                                                                                                                                |
| innodb_compression_level                                 | 6                                                                                                                                                                                                                                                                                                                                                                                                                |
| innodb_compression_pad_pct_max                           | 50                                                                                                                                                                                                                                                                                                                                                                                                               |
| innodb_concurrency_tickets                               | 5000                                                                                                                                                                                                                                                                                                                                                                                                             |
| innodb_data_file_path                                    | ibdata1:12M:autoextend                                                                                                                                                                                                                                                                                                                                                                                           |
| innodb_data_home_dir                                     |                                                                                                                                                                                                                                                                                                                                                                                                                  |
| innodb_deadlock_detect                                   | ON                                                                                                                                                                                                                                                                                                                                                                                                               |
| innodb_default_row_format                                | dynamic                                                                                                                                                                                                                                                                                                                                                                                                          |
| innodb_disable_sort_file_cache                           | OFF                                                                                                                                                                                                                                                                                                                                                                                                              |
| innodb_doublewrite                                       | ON                                                                                                                                                                                                                                                                                                                                                                                                               |
| innodb_fast_shutdown                                     | 1                                                                                                                                                                                                                                                                                                                                                                                                                |
| innodb_file_format                                       | Barracuda                                                                                                                                                                                                                                                                                                                                                                                                        |
| innodb_file_format_check                                 | ON                                                                                                                                                                                                                                                                                                                                                                                                               |
| innodb_file_format_max                                   | Barracuda                                                                                                                                                                                                                                                                                                                                                                                                        |
| innodb_file_per_table                                    | ON                                                                                                                                                                                                                                                                                                                                                                                                               |
| innodb_fill_factor                                       | 100                                                                                                                                                                                                                                                                                                                                                                                                              |
| innodb_flush_log_at_timeout                              | 1                                                                                                                                                                                                                                                                                                                                                                                                                |
| innodb_flush_log_at_trx_commit                           | 1                                                                                                                                                                                                                                                                                                                                                                                                                |
| innodb_flush_method                                      |                                                                                                                                                                                                                                                                                                                                                                                                                  |
| innodb_flush_neighbors                                   | 1                                                                                                                                                                                                                                                                                                                                                                                                                |
| innodb_flush_sync                                        | ON                                                                                                                                                                                                                                                                                                                                                                                                               |
| innodb_flushing_avg_loops                                | 30                                                                                                                                                                                                                                                                                                                                                                                                               |
| innodb_force_load_corrupted                              | OFF                                                                                                                                                                                                                                                                                                                                                                                                              |
| innodb_force_recovery                                    | 0                                                                                                                                                                                                                                                                                                                                                                                                                |
| innodb_ft_aux_table                                      |                                                                                                                                                                                                                                                                                                                                                                                                                  |
| innodb_ft_cache_size                                     | 8000000                                                                                                                                                                                                                                                                                                                                                                                                          |
| innodb_ft_enable_diag_print                              | OFF                                                                                                                                                                                                                                                                                                                                                                                                              |
| innodb_ft_enable_stopword                                | ON                                                                                                                                                                                                                                                                                                                                                                                                               |
| innodb_ft_max_token_size                                 | 84                                                                                                                                                                                                                                                                                                                                                                                                               |
| innodb_ft_min_token_size                                 | 3                                                                                                                                                                                                                                                                                                                                                                                                                |
| innodb_ft_num_word_optimize                              | 2000                                                                                                                                                                                                                                                                                                                                                                                                             |
| innodb_ft_result_cache_limit                             | 2000000000                                                                                                                                                                                                                                                                                                                                                                                                       |
| innodb_ft_server_stopword_table                          |                                                                                                                                                                                                                                                                                                                                                                                                                  |
| innodb_ft_sort_pll_degree                                | 2                                                                                                                                                                                                                                                                                                                                                                                                                |
| innodb_ft_total_cache_size                               | 640000000                                                                                                                                                                                                                                                                                                                                                                                                        |
| innodb_ft_user_stopword_table                            |                                                                                                                                                                                                                                                                                                                                                                                                                  |
| innodb_io_capacity                                       | 200                                                                                                                                                                                                                                                                                                                                                                                                              |
| innodb_io_capacity_max                                   | 2000                                                                                                                                                                                                                                                                                                                                                                                                             |
| innodb_large_prefix                                      | ON                                                                                                                                                                                                                                                                                                                                                                                                               |
| innodb_lock_wait_timeout                                 | 50                                                                                                                                                                                                                                                                                                                                                                                                               |
| innodb_locks_unsafe_for_binlog                           | OFF                                                                                                                                                                                                                                                                                                                                                                                                              |
| innodb_log_buffer_size                                   | 16777216                                                                                                                                                                                                                                                                                                                                                                                                         |
| innodb_log_checksums                                     | ON                                                                                                                                                                                                                                                                                                                                                                                                               |
| innodb_log_compressed_pages                              | ON                                                                                                                                                                                                                                                                                                                                                                                                               |
| innodb_log_file_size                                     | 50331648                                                                                                                                                                                                                                                                                                                                                                                                         |
| innodb_log_files_in_group                                | 2                                                                                                                                                                                                                                                                                                                                                                                                                |
| innodb_log_group_home_dir                                | ./                                                                                                                                                                                                                                                                                                                                                                                                               |
| innodb_log_write_ahead_size                              | 8192                                                                                                                                                                                                                                                                                                                                                                                                             |
| innodb_lru_scan_depth                                    | 1024                                                                                                                                                                                                                                                                                                                                                                                                             |
| innodb_max_dirty_pages_pct                               | 75.000000                                                                                                                                                                                                                                                                                                                                                                                                        |
| innodb_max_dirty_pages_pct_lwm                           | 0.000000                                                                                                                                                                                                                                                                                                                                                                                                         |
| innodb_max_purge_lag                                     | 0                                                                                                                                                                                                                                                                                                                                                                                                                |
| innodb_max_purge_lag_delay                               | 0                                                                                                                                                                                                                                                                                                                                                                                                                |
| innodb_max_undo_log_size                                 | 1073741824                                                                                                                                                                                                                                                                                                                                                                                                       |
| innodb_monitor_disable                                   |                                                                                                                                                                                                                                                                                                                                                                                                                  |
| innodb_monitor_enable                                    |                                                                                                                                                                                                                                                                                                                                                                                                                  |
| innodb_monitor_reset                                     |                                                                                                                                                                                                                                                                                                                                                                                                                  |
| innodb_monitor_reset_all                                 |                                                                                                                                                                                                                                                                                                                                                                                                                  |
| innodb_numa_interleave                                   | OFF                                                                                                                                                                                                                                                                                                                                                                                                              |
| innodb_old_blocks_pct                                    | 37                                                                                                                                                                                                                                                                                                                                                                                                               |
| innodb_old_blocks_time                                   | 1000                                                                                                                                                                                                                                                                                                                                                                                                             |
| innodb_online_alter_log_max_size                         | 134217728                                                                                                                                                                                                                                                                                                                                                                                                        |
| innodb_open_files                                        | 431                                                                                                                                                                                                                                                                                                                                                                                                              |
| innodb_optimize_fulltext_only                            | OFF                                                                                                                                                                                                                                                                                                                                                                                                              |
| innodb_page_cleaners                                     | 1                                                                                                                                                                                                                                                                                                                                                                                                                |
| innodb_page_size                                         | 16384                                                                                                                                                                                                                                                                                                                                                                                                            |
| innodb_print_all_deadlocks                               | OFF                                                                                                                                                                                                                                                                                                                                                                                                              |
| innodb_purge_batch_size                                  | 300                                                                                                                                                                                                                                                                                                                                                                                                              |
| innodb_purge_rseg_truncate_frequency                     | 128                                                                                                                                                                                                                                                                                                                                                                                                              |
| innodb_purge_threads                                     | 4                                                                                                                                                                                                                                                                                                                                                                                                                |
| innodb_random_read_ahead                                 | OFF                                                                                                                                                                                                                                                                                                                                                                                                              |
| innodb_read_ahead_threshold                              | 56                                                                                                                                                                                                                                                                                                                                                                                                               |
| innodb_read_io_threads                                   | 4                                                                                                                                                                                                                                                                                                                                                                                                                |
| innodb_read_only                                         | OFF                                                                                                                                                                                                                                                                                                                                                                                                              |
| innodb_replication_delay                                 | 0                                                                                                                                                                                                                                                                                                                                                                                                                |
| innodb_rollback_on_timeout                               | OFF                                                                                                                                                                                                                                                                                                                                                                                                              |
| innodb_rollback_segments                                 | 128                                                                                                                                                                                                                                                                                                                                                                                                              |
| innodb_sort_buffer_size                                  | 1048576                                                                                                                                                                                                                                                                                                                                                                                                          |
| innodb_spin_wait_delay                                   | 6                                                                                                                                                                                                                                                                                                                                                                                                                |
| innodb_stats_auto_recalc                                 | ON                                                                                                                                                                                                                                                                                                                                                                                                               |
| innodb_stats_include_delete_marked                       | OFF                                                                                                                                                                                                                                                                                                                                                                                                              |
| innodb_stats_method                                      | nulls_equal                                                                                                                                                                                                                                                                                                                                                                                                      |
| innodb_stats_on_metadata                                 | OFF                                                                                                                                                                                                                                                                                                                                                                                                              |
| innodb_stats_persistent                                  | ON                                                                                                                                                                                                                                                                                                                                                                                                               |
| innodb_stats_persistent_sample_pages                     | 20                                                                                                                                                                                                                                                                                                                                                                                                               |
| innodb_stats_sample_pages                                | 8                                                                                                                                                                                                                                                                                                                                                                                                                |
| innodb_stats_transient_sample_pages                      | 8                                                                                                                                                                                                                                                                                                                                                                                                                |
| innodb_status_output                                     | OFF                                                                                                                                                                                                                                                                                                                                                                                                              |
| innodb_status_output_locks                               | OFF                                                                                                                                                                                                                                                                                                                                                                                                              |
| innodb_strict_mode                                       | ON                                                                                                                                                                                                                                                                                                                                                                                                               |
| innodb_support_xa                                        | ON                                                                                                                                                                                                                                                                                                                                                                                                               |
| innodb_sync_array_size                                   | 1                                                                                                                                                                                                                                                                                                                                                                                                                |
| innodb_sync_spin_loops                                   | 30                                                                                                                                                                                                                                                                                                                                                                                                               |
| innodb_table_locks                                       | ON                                                                                                                                                                                                                                                                                                                                                                                                               |
| innodb_temp_data_file_path                               | ibtmp1:12M:autoextend                                                                                                                                                                                                                                                                                                                                                                                            |
| innodb_thread_concurrency                                | 0                                                                                                                                                                                                                                                                                                                                                                                                                |
| innodb_thread_sleep_delay                                | 10000                                                                                                                                                                                                                                                                                                                                                                                                            |
| innodb_tmpdir                                            |                                                                                                                                                                                                                                                                                                                                                                                                                  |
| innodb_undo_directory                                    | ./                                                                                                                                                                                                                                                                                                                                                                                                               |
| innodb_undo_log_truncate                                 | OFF                                                                                                                                                                                                                                                                                                                                                                                                              |
| innodb_undo_logs                                         | 128                                                                                                                                                                                                                                                                                                                                                                                                              |
| innodb_undo_tablespaces                                  | 0                                                                                                                                                                                                                                                                                                                                                                                                                |
| innodb_use_native_aio                                    | ON                                                                                                                                                                                                                                                                                                                                                                                                               |
| innodb_version                                           | 5.7.21                                                                                                                                                                                                                                                                                                                                                                                                           |
| innodb_write_io_threads                                  | 4                                                                                                                                                                                                                                                                                                                                                                                                                |
| insert_id                                                | 0                                                                                                                                                                                                                                                                                                                                                                                                                |
| interactive_timeout                                      | 28800                                                                                                                                                                                                                                                                                                                                                                                                            |
| internal_tmp_disk_storage_engine                         | InnoDB                                                                                                                                                                                                                                                                                                                                                                                                           |
| join_buffer_size                                         | 262144                                                                                                                                                                                                                                                                                                                                                                                                           |
| keep_files_on_create                                     | OFF                                                                                                                                                                                                                                                                                                                                                                                                              |
| key_buffer_size                                          | 16777216                                                                                                                                                                                                                                                                                                                                                                                                         |
| key_cache_age_threshold                                  | 300                                                                                                                                                                                                                                                                                                                                                                                                              |
| key_cache_block_size                                     | 1024                                                                                                                                                                                                                                                                                                                                                                                                             |
| key_cache_division_limit                                 | 100                                                                                                                                                                                                                                                                                                                                                                                                              |
| keyring_operations                                       | ON                                                                                                                                                                                                                                                                                                                                                                                                               |
| large_files_support                                      | ON                                                                                                                                                                                                                                                                                                                                                                                                               |
| large_page_size                                          | 0                                                                                                                                                                                                                                                                                                                                                                                                                |
| large_pages                                              | OFF                                                                                                                                                                                                                                                                                                                                                                                                              |
| last_insert_id                                           | 0                                                                                                                                                                                                                                                                                                                                                                                                                |
| lc_messages                                              | en_US                                                                                                                                                                                                                                                                                                                                                                                                            |
| lc_messages_dir                                          | /usr/share/mysql/                                                                                                                                                                                                                                                                                                                                                                                                |
| lc_time_names                                            | en_US                                                                                                                                                                                                                                                                                                                                                                                                            |
| license                                                  | GPL                                                                                                                                                                                                                                                                                                                                                                                                              |
| local_infile                                             | ON                                                                                                                                                                                                                                                                                                                                                                                                               |
| lock_wait_timeout                                        | 31536000                                                                                                                                                                                                                                                                                                                                                                                                         |
| locked_in_memory                                         | OFF                                                                                                                                                                                                                                                                                                                                                                                                              |
| log_bin                                                  | OFF                                                                                                                                                                                                                                                                                                                                                                                                              |
| log_bin_basename                                         |                                                                                                                                                                                                                                                                                                                                                                                                                  |
| log_bin_index                                            |                                                                                                                                                                                                                                                                                                                                                                                                                  |
| log_bin_trust_function_creators                          | OFF                                                                                                                                                                                                                                                                                                                                                                                                              |
| log_bin_use_v1_row_events                                | OFF                                                                                                                                                                                                                                                                                                                                                                                                              |
| log_builtin_as_identified_by_password                    | OFF                                                                                                                                                                                                                                                                                                                                                                                                              |
| log_error                                                | /var/log/mysql/error.log                                                                                                                                                                                                                                                                                                                                                                                         |
| log_error_verbosity                                      | 3                                                                                                                                                                                                                                                                                                                                                                                                                |
| log_output                                               | FILE                                                                                                                                                                                                                                                                                                                                                                                                             |
| log_queries_not_using_indexes                            | OFF                                                                                                                                                                                                                                                                                                                                                                                                              |
| log_slave_updates                                        | OFF                                                                                                                                                                                                                                                                                                                                                                                                              |
| log_slow_admin_statements                                | OFF                                                                                                                                                                                                                                                                                                                                                                                                              |
| log_slow_slave_statements                                | OFF                                                                                                                                                                                                                                                                                                                                                                                                              |
| log_statements_unsafe_for_binlog                         | ON                                                                                                                                                                                                                                                                                                                                                                                                               |
| log_syslog                                               | OFF                                                                                                                                                                                                                                                                                                                                                                                                              |
| log_syslog_facility                                      | daemon                                                                                                                                                                                                                                                                                                                                                                                                           |
| log_syslog_include_pid                                   | ON                                                                                                                                                                                                                                                                                                                                                                                                               |
| log_syslog_tag                                           |                                                                                                                                                                                                                                                                                                                                                                                                                  |
| log_throttle_queries_not_using_indexes                   | 0                                                                                                                                                                                                                                                                                                                                                                                                                |
| log_timestamps                                           | UTC                                                                                                                                                                                                                                                                                                                                                                                                              |
| log_warnings                                             | 2                                                                                                                                                                                                                                                                                                                                                                                                                |
| long_query_time                                          | 10.000000                                                                                                                                                                                                                                                                                                                                                                                                        |
| low_priority_updates                                     | OFF                                                                                                                                                                                                                                                                                                                                                                                                              |
| lower_case_file_system                                   | OFF                                                                                                                                                                                                                                                                                                                                                                                                              |
| lower_case_table_names                                   | 0                                                                                                                                                                                                                                                                                                                                                                                                                |
| master_info_repository                                   | FILE                                                                                                                                                                                                                                                                                                                                                                                                             |
| master_verify_checksum                                   | OFF                                                                                                                                                                                                                                                                                                                                                                                                              |
| max_allowed_packet                                       | 16777216                                                                                                                                                                                                                                                                                                                                                                                                         |
| max_binlog_cache_size                                    | 18446744073709547520                                                                                                                                                                                                                                                                                                                                                                                             |
| max_binlog_size                                          | 104857600                                                                                                                                                                                                                                                                                                                                                                                                        |
| max_binlog_stmt_cache_size                               | 18446744073709547520                                                                                                                                                                                                                                                                                                                                                                                             |
| max_connect_errors                                       | 100                                                                                                                                                                                                                                                                                                                                                                                                              |
| max_connections                                          | 151                                                                                                                                                                                                                                                                                                                                                                                                              |
| max_delayed_threads                                      | 20                                                                                                                                                                                                                                                                                                                                                                                                               |
| max_digest_length                                        | 1024                                                                                                                                                                                                                                                                                                                                                                                                             |
| max_error_count                                          | 64                                                                                                                                                                                                                                                                                                                                                                                                               |
| max_execution_time                                       | 0                                                                                                                                                                                                                                                                                                                                                                                                                |
| max_heap_table_size                                      | 16777216                                                                                                                                                                                                                                                                                                                                                                                                         |
| max_insert_delayed_threads                               | 20                                                                                                                                                                                                                                                                                                                                                                                                               |
| max_join_size                                            | 18446744073709551615                                                                                                                                                                                                                                                                                                                                                                                             |
| max_length_for_sort_data                                 | 1024                                                                                                                                                                                                                                                                                                                                                                                                             |
| max_points_in_geometry                                   | 65536                                                                                                                                                                                                                                                                                                                                                                                                            |
| max_prepared_stmt_count                                  | 16382                                                                                                                                                                                                                                                                                                                                                                                                            |
| max_relay_log_size                                       | 0                                                                                                                                                                                                                                                                                                                                                                                                                |
| max_seeks_for_key                                        | 18446744073709551615                                                                                                                                                                                                                                                                                                                                                                                             |
| max_sort_length                                          | 1024                                                                                                                                                                                                                                                                                                                                                                                                             |
| max_sp_recursion_depth                                   | 0                                                                                                                                                                                                                                                                                                                                                                                                                |
| max_tmp_tables                                           | 32                                                                                                                                                                                                                                                                                                                                                                                                               |
| max_user_connections                                     | 0                                                                                                                                                                                                                                                                                                                                                                                                                |
| max_write_lock_count                                     | 18446744073709551615                                                                                                                                                                                                                                                                                                                                                                                             |
| metadata_locks_cache_size                                | 1024                                                                                                                                                                                                                                                                                                                                                                                                             |
| metadata_locks_hash_instances                            | 8                                                                                                                                                                                                                                                                                                                                                                                                                |
| min_examined_row_limit                                   | 0                                                                                                                                                                                                                                                                                                                                                                                                                |
| multi_range_count                                        | 256                                                                                                                                                                                                                                                                                                                                                                                                              |
| myisam_data_pointer_size                                 | 6                                                                                                                                                                                                                                                                                                                                                                                                                |
| myisam_max_sort_file_size                                | 9223372036853727232                                                                                                                                                                                                                                                                                                                                                                                              |
| myisam_mmap_size                                         | 18446744073709551615                                                                                                                                                                                                                                                                                                                                                                                             |
| myisam_recover_options                                   | BACKUP                                                                                                                                                                                                                                                                                                                                                                                                           |
| myisam_repair_threads                                    | 1                                                                                                                                                                                                                                                                                                                                                                                                                |
| myisam_sort_buffer_size                                  | 8388608                                                                                                                                                                                                                                                                                                                                                                                                          |
| myisam_stats_method                                      | nulls_unequal                                                                                                                                                                                                                                                                                                                                                                                                    |
| myisam_use_mmap                                          | OFF                                                                                                                                                                                                                                                                                                                                                                                                              |
| mysql_native_password_proxy_users                        | OFF                                                                                                                                                                                                                                                                                                                                                                                                              |
| net_buffer_length                                        | 16384                                                                                                                                                                                                                                                                                                                                                                                                            |
| net_read_timeout                                         | 30                                                                                                                                                                                                                                                                                                                                                                                                               |
| net_retry_count                                          | 10                                                                                                                                                                                                                                                                                                                                                                                                               |
| net_write_timeout                                        | 60                                                                                                                                                                                                                                                                                                                                                                                                               |
| new                                                      | OFF                                                                                                                                                                                                                                                                                                                                                                                                              |
| ngram_token_size                                         | 2                                                                                                                                                                                                                                                                                                                                                                                                                |
| offline_mode                                             | OFF                                                                                                                                                                                                                                                                                                                                                                                                              |
| old                                                      | OFF                                                                                                                                                                                                                                                                                                                                                                                                              |
| old_alter_table                                          | OFF                                                                                                                                                                                                                                                                                                                                                                                                              |
| old_passwords                                            | 0                                                                                                                                                                                                                                                                                                                                                                                                                |
| open_files_limit                                         | 1024                                                                                                                                                                                                                                                                                                                                                                                                             |
| optimizer_prune_level                                    | 1                                                                                                                                                                                                                                                                                                                                                                                                                |
| optimizer_search_depth                                   | 62                                                                                                                                                                                                                                                                                                                                                                                                               |
| optimizer_switch                                         | index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,engine_condition_pushdown=on,index_condition_pushdown=on,mrr=on,mrr_cost_based=on,block_nested_loop=on,batched_key_access=off,materialization=on,semijoin=on,loosescan=on,firstmatch=on,duplicateweedout=on,subquery_materialization_cost_based=on,use_index_extensions=on,condition_fanout_filter=on,derived_merge=on |
| optimizer_trace                                          | enabled=off,one_line=off                                                                                                                                                                                                                                                                                                                                                                                         |
| optimizer_trace_features                                 | greedy_search=on,range_optimizer=on,dynamic_range=on,repeated_subselect=on                                                                                                                                                                                                                                                                                                                                       |
| optimizer_trace_limit                                    | 1                                                                                                                                                                                                                                                                                                                                                                                                                |
| optimizer_trace_max_mem_size                             | 16384                                                                                                                                                                                                                                                                                                                                                                                                            |
| optimizer_trace_offset                                   | -1                                                                                                                                                                                                                                                                                                                                                                                                               |
| parser_max_mem_size                                      | 18446744073709551615                                                                                                                                                                                                                                                                                                                                                                                             |
| performance_schema                                       | ON                                                                                                                                                                                                                                                                                                                                                                                                               |
| performance_schema_accounts_size                         | -1                                                                                                                                                                                                                                                                                                                                                                                                               |
| performance_schema_digests_size                          | 5000                                                                                                                                                                                                                                                                                                                                                                                                             |
| performance_schema_events_stages_history_long_size       | 1000                                                                                                                                                                                                                                                                                                                                                                                                             |
| performance_schema_events_stages_history_size            | 10                                                                                                                                                                                                                                                                                                                                                                                                               |
| performance_schema_events_statements_history_long_size   | 1000                                                                                                                                                                                                                                                                                                                                                                                                             |
| performance_schema_events_statements_history_size        | 10                                                                                                                                                                                                                                                                                                                                                                                                               |
| performance_schema_events_transactions_history_long_size | 1000                                                                                                                                                                                                                                                                                                                                                                                                             |
| performance_schema_events_transactions_history_size      | 10                                                                                                                                                                                                                                                                                                                                                                                                               |
| performance_schema_events_waits_history_long_size        | 1000                                                                                                                                                                                                                                                                                                                                                                                                             |
| performance_schema_events_waits_history_size             | 10                                                                                                                                                                                                                                                                                                                                                                                                               |
| performance_schema_hosts_size                            | -1                                                                                                                                                                                                                                                                                                                                                                                                               |
| performance_schema_max_cond_classes                      | 80                                                                                                                                                                                                                                                                                                                                                                                                               |
| performance_schema_max_cond_instances                    | -1                                                                                                                                                                                                                                                                                                                                                                                                               |
| performance_schema_max_digest_length                     | 1024                                                                                                                                                                                                                                                                                                                                                                                                             |
| performance_schema_max_file_classes                      | 80                                                                                                                                                                                                                                                                                                                                                                                                               |
| performance_schema_max_file_handles                      | 32768                                                                                                                                                                                                                                                                                                                                                                                                            |
| performance_schema_max_file_instances                    | -1                                                                                                                                                                                                                                                                                                                                                                                                               |
| performance_schema_max_index_stat                        | -1                                                                                                                                                                                                                                                                                                                                                                                                               |
| performance_schema_max_memory_classes                    | 320                                                                                                                                                                                                                                                                                                                                                                                                              |
| performance_schema_max_metadata_locks                    | -1                                                                                                                                                                                                                                                                                                                                                                                                               |
| performance_schema_max_mutex_classes                     | 210                                                                                                                                                                                                                                                                                                                                                                                                              |
| performance_schema_max_mutex_instances                   | -1                                                                                                                                                                                                                                                                                                                                                                                                               |
| performance_schema_max_prepared_statements_instances     | -1                                                                                                                                                                                                                                                                                                                                                                                                               |
| performance_schema_max_program_instances                 | -1                                                                                                                                                                                                                                                                                                                                                                                                               |
| performance_schema_max_rwlock_classes                    | 40                                                                                                                                                                                                                                                                                                                                                                                                               |
| performance_schema_max_rwlock_instances                  | -1                                                                                                                                                                                                                                                                                                                                                                                                               |
| performance_schema_max_socket_classes                    | 10                                                                                                                                                                                                                                                                                                                                                                                                               |
| performance_schema_max_socket_instances                  | -1                                                                                                                                                                                                                                                                                                                                                                                                               |
| performance_schema_max_sql_text_length                   | 1024                                                                                                                                                                                                                                                                                                                                                                                                             |
| performance_schema_max_stage_classes                     | 150                                                                                                                                                                                                                                                                                                                                                                                                              |
| performance_schema_max_statement_classes                 | 193                                                                                                                                                                                                                                                                                                                                                                                                              |
| performance_schema_max_statement_stack                   | 10                                                                                                                                                                                                                                                                                                                                                                                                               |
| performance_schema_max_table_handles                     | -1                                                                                                                                                                                                                                                                                                                                                                                                               |
| performance_schema_max_table_instances                   | -1                                                                                                                                                                                                                                                                                                                                                                                                               |
| performance_schema_max_table_lock_stat                   | -1                                                                                                                                                                                                                                                                                                                                                                                                               |
| performance_schema_max_thread_classes                    | 50                                                                                                                                                                                                                                                                                                                                                                                                               |
| performance_schema_max_thread_instances                  | -1                                                                                                                                                                                                                                                                                                                                                                                                               |
| performance_schema_session_connect_attrs_size            | 512                                                                                                                                                                                                                                                                                                                                                                                                              |
| performance_schema_setup_actors_size                     | -1                                                                                                                                                                                                                                                                                                                                                                                                               |
| performance_schema_setup_objects_size                    | -1                                                                                                                                                                                                                                                                                                                                                                                                               |
| performance_schema_users_size                            | -1                                                                                                                                                                                                                                                                                                                                                                                                               |
| pid_file                                                 | /var/run/mysqld/mysqld.pid                                                                                                                                                                                                                                                                                                                                                                                       |
| plugin_dir                                               | /usr/lib/mysql/plugin/                                                                                                                                                                                                                                                                                                                                                                                           |
| port                                                     | 3306                                                                                                                                                                                                                                                                                                                                                                                                             |
| preload_buffer_size                                      | 32768                                                                                                                                                                                                                                                                                                                                                                                                            |
| profiling                                                | OFF                                                                                                                                                                                                                                                                                                                                                                                                              |
| profiling_history_size                                   | 15                                                                                                                                                                                                                                                                                                                                                                                                               |
| protocol_version                                         | 10                                                                                                                                                                                                                                                                                                                                                                                                               |
| proxy_user                                               |                                                                                                                                                                                                                                                                                                                                                                                                                  |
| pseudo_slave_mode                                        | OFF                                                                                                                                                                                                                                                                                                                                                                                                              |
| pseudo_thread_id                                         | 5                                                                                                                                                                                                                                                                                                                                                                                                                |
| query_alloc_block_size                                   | 8192                                                                                                                                                                                                                                                                                                                                                                                                             |
| query_cache_limit                                        | 1048576                                                                                                                                                                                                                                                                                                                                                                                                          |
| query_cache_min_res_unit                                 | 4096                                                                                                                                                                                                                                                                                                                                                                                                             |
| query_cache_size                                         | 16777216                                                                                                                                                                                                                                                                                                                                                                                                         |
| query_cache_type                                         | OFF                                                                                                                                                                                                                                                                                                                                                                                                              |
| query_cache_wlock_invalidate                             | OFF                                                                                                                                                                                                                                                                                                                                                                                                              |
| query_prealloc_size                                      | 8192                                                                                                                                                                                                                                                                                                                                                                                                             |
| rand_seed1                                               | 0                                                                                                                                                                                                                                                                                                                                                                                                                |
| rand_seed2                                               | 0                                                                                                                                                                                                                                                                                                                                                                                                                |
| range_alloc_block_size                                   | 4096                                                                                                                                                                                                                                                                                                                                                                                                             |
| range_optimizer_max_mem_size                             | 8388608                                                                                                                                                                                                                                                                                                                                                                                                          |
| rbr_exec_mode                                            | STRICT                                                                                                                                                                                                                                                                                                                                                                                                           |
| read_buffer_size                                         | 131072                                                                                                                                                                                                                                                                                                                                                                                                           |
| read_only                                                | OFF                                                                                                                                                                                                                                                                                                                                                                                                              |
| read_rnd_buffer_size                                     | 262144                                                                                                                                                                                                                                                                                                                                                                                                           |
| relay_log                                                |                                                                                                                                                                                                                                                                                                                                                                                                                  |
| relay_log_basename                                       | /var/lib/mysql/feanlau-VirtualBox-relay-bin                                                                                                                                                                                                                                                                                                                                                                      |
| relay_log_index                                          | /var/lib/mysql/feanlau-VirtualBox-relay-bin.index                                                                                                                                                                                                                                                                                                                                                                |
| relay_log_info_file                                      | relay-log.info                                                                                                                                                                                                                                                                                                                                                                                                   |
| relay_log_info_repository                                | FILE                                                                                                                                                                                                                                                                                                                                                                                                             |
| relay_log_purge                                          | ON                                                                                                                                                                                                                                                                                                                                                                                                               |
| relay_log_recovery                                       | OFF                                                                                                                                                                                                                                                                                                                                                                                                              |
| relay_log_space_limit                                    | 0                                                                                                                                                                                                                                                                                                                                                                                                                |
| report_host                                              |                                                                                                                                                                                                                                                                                                                                                                                                                  |
| report_password                                          |                                                                                                                                                                                                                                                                                                                                                                                                                  |
| report_port                                              | 3306                                                                                                                                                                                                                                                                                                                                                                                                             |
| report_user                                              |                                                                                                                                                                                                                                                                                                                                                                                                                  |
| require_secure_transport                                 | OFF                                                                                                                                                                                                                                                                                                                                                                                                              |
| rpl_stop_slave_timeout                                   | 31536000                                                                                                                                                                                                                                                                                                                                                                                                         |
| secure_auth                                              | ON                                                                                                                                                                                                                                                                                                                                                                                                               |
| secure_file_priv                                         | /var/lib/mysql-files/                                                                                                                                                                                                                                                                                                                                                                                            |
| server_id                                                | 0                                                                                                                                                                                                                                                                                                                                                                                                                |
| server_id_bits                                           | 32                                                                                                                                                                                                                                                                                                                                                                                                               |
| server_uuid                                              | 19ce26be-0e4b-11e8-b5a6-080027c69c70                                                                                                                                                                                                                                                                                                                                                                             |
| session_track_gtids                                      | OFF                                                                                                                                                                                                                                                                                                                                                                                                              |
| session_track_schema                                     | ON                                                                                                                                                                                                                                                                                                                                                                                                               |
| session_track_state_change                               | OFF                                                                                                                                                                                                                                                                                                                                                                                                              |
| session_track_system_variables                           | time_zone,autocommit,character_set_client,character_set_results,character_set_connection                                                                                                                                                                                                                                                                                                                         |
| session_track_transaction_info                           | OFF                                                                                                                                                                                                                                                                                                                                                                                                              |
| sha256_password_proxy_users                              | OFF                                                                                                                                                                                                                                                                                                                                                                                                              |
| show_compatibility_56                                    | OFF                                                                                                                                                                                                                                                                                                                                                                                                              |
| show_old_temporals                                       | OFF                                                                                                                                                                                                                                                                                                                                                                                                              |
| skip_external_locking                                    | ON                                                                                                                                                                                                                                                                                                                                                                                                               |
| skip_name_resolve                                        | OFF                                                                                                                                                                                                                                                                                                                                                                                                              |
| skip_networking                                          | OFF                                                                                                                                                                                                                                                                                                                                                                                                              |
| skip_show_database                                       | OFF                                                                                                                                                                                                                                                                                                                                                                                                              |
| slave_allow_batching                                     | OFF                                                                                                                                                                                                                                                                                                                                                                                                              |
| slave_checkpoint_group                                   | 512                                                                                                                                                                                                                                                                                                                                                                                                              |
| slave_checkpoint_period                                  | 300                                                                                                                                                                                                                                                                                                                                                                                                              |
| slave_compressed_protocol                                | OFF                                                                                                                                                                                                                                                                                                                                                                                                              |
| slave_exec_mode                                          | STRICT                                                                                                                                                                                                                                                                                                                                                                                                           |
| slave_load_tmpdir                                        | /tmp                                                                                                                                                                                                                                                                                                                                                                                                             |
| slave_max_allowed_packet                                 | 1073741824                                                                                                                                                                                                                                                                                                                                                                                                       |
| slave_net_timeout                                        | 60                                                                                                                                                                                                                                                                                                                                                                                                               |
| slave_parallel_type                                      | DATABASE                                                                                                                                                                                                                                                                                                                                                                                                         |
| slave_parallel_workers                                   | 0                                                                                                                                                                                                                                                                                                                                                                                                                |
| slave_pending_jobs_size_max                              | 16777216                                                                                                                                                                                                                                                                                                                                                                                                         |
| slave_preserve_commit_order                              | OFF                                                                                                                                                                                                                                                                                                                                                                                                              |
| slave_rows_search_algorithms                             | TABLE_SCAN,INDEX_SCAN                                                                                                                                                                                                                                                                                                                                                                                            |
| slave_skip_errors                                        | OFF                                                                                                                                                                                                                                                                                                                                                                                                              |
| slave_sql_verify_checksum                                | ON                                                                                                                                                                                                                                                                                                                                                                                                               |
| slave_transaction_retries                                | 10                                                                                                                                                                                                                                                                                                                                                                                                               |
| slave_type_conversions                                   |                                                                                                                                                                                                                                                                                                                                                                                                                  |
| slow_launch_time                                         | 2                                                                                                                                                                                                                                                                                                                                                                                                                |
| slow_query_log                                           | OFF                                                                                                                                                                                                                                                                                                                                                                                                              |
| slow_query_log_file                                      | /var/lib/mysql/feanlau-VirtualBox-slow.log                                                                                                                                                                                                                                                                                                                                                                       |
| socket                                                   | /var/run/mysqld/mysqld.sock                                                                                                                                                                                                                                                                                                                                                                                      |
| sort_buffer_size                                         | 262144                                                                                                                                                                                                                                                                                                                                                                                                           |
| sql_auto_is_null                                         | OFF                                                                                                                                                                                                                                                                                                                                                                                                              |
| sql_big_selects                                          | ON                                                                                                                                                                                                                                                                                                                                                                                                               |
| sql_buffer_result                                        | OFF                                                                                                                                                                                                                                                                                                                                                                                                              |
| sql_log_bin                                              | ON                                                                                                                                                                                                                                                                                                                                                                                                               |
| sql_log_off                                              | OFF                                                                                                                                                                                                                                                                                                                                                                                                              |
| sql_mode                                                 | ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION                                                                                                                                                                                                                                                                        |
| sql_notes                                                | ON                                                                                                                                                                                                                                                                                                                                                                                                               |
| sql_quote_show_create                                    | ON                                                                                                                                                                                                                                                                                                                                                                                                               |
| sql_safe_updates                                         | OFF                                                                                                                                                                                                                                                                                                                                                                                                              |
| sql_select_limit                                         | 18446744073709551615                                                                                                                                                                                                                                                                                                                                                                                             |
| sql_slave_skip_counter                                   | 0                                                                                                                                                                                                                                                                                                                                                                                                                |
| sql_warnings                                             | OFF                                                                                                                                                                                                                                                                                                                                                                                                              |
| ssl_ca                                                   |                                                                                                                                                                                                                                                                                                                                                                                                                  |
| ssl_capath                                               |                                                                                                                                                                                                                                                                                                                                                                                                                  |
| ssl_cert                                                 |                                                                                                                                                                                                                                                                                                                                                                                                                  |
| ssl_cipher                                               |                                                                                                                                                                                                                                                                                                                                                                                                                  |
| ssl_crl                                                  |                                                                                                                                                                                                                                                                                                                                                                                                                  |
| ssl_crlpath                                              |                                                                                                                                                                                                                                                                                                                                                                                                                  |
| ssl_key                                                  |                                                                                                                                                                                                                                                                                                                                                                                                                  |
| stored_program_cache                                     | 256                                                                                                                                                                                                                                                                                                                                                                                                              |
| super_read_only                                          | OFF                                                                                                                                                                                                                                                                                                                                                                                                              |
| sync_binlog                                              | 1                                                                                                                                                                                                                                                                                                                                                                                                                |
| sync_frm                                                 | ON                                                                                                                                                                                                                                                                                                                                                                                                               |
| sync_master_info                                         | 10000                                                                                                                                                                                                                                                                                                                                                                                                            |
| sync_relay_log                                           | 10000                                                                                                                                                                                                                                                                                                                                                                                                            |
| sync_relay_log_info                                      | 10000                                                                                                                                                                                                                                                                                                                                                                                                            |
| system_time_zone                                         | CST                                                                                                                                                                                                                                                                                                                                                                                                              |
| table_definition_cache                                   | 615                                                                                                                                                                                                                                                                                                                                                                                                              |
| table_open_cache                                         | 431                                                                                                                                                                                                                                                                                                                                                                                                              |
| table_open_cache_instances                               | 16                                                                                                                                                                                                                                                                                                                                                                                                               |
| thread_cache_size                                        | 8                                                                                                                                                                                                                                                                                                                                                                                                                |
| thread_handling                                          | one-thread-per-connection                                                                                                                                                                                                                                                                                                                                                                                        |
| thread_stack                                             | 196608                                                                                                                                                                                                                                                                                                                                                                                                           |
| time_format                                              | %H:%i:%s                                                                                                                                                                                                                                                                                                                                                                                                         |
| time_zone                                                | SYSTEM                                                                                                                                                                                                                                                                                                                                                                                                           |
| timestamp                                                | 1518257757.127567                                                                                                                                                                                                                                                                                                                                                                                                |
| tls_version                                              | TLSv1,TLSv1.1                                                                                                                                                                                                                                                                                                                                                                                                    |
| tmp_table_size                                           | 16777216                                                                                                                                                                                                                                                                                                                                                                                                         |
| tmpdir                                                   | /tmp                                                                                                                                                                                                                                                                                                                                                                                                             |
| transaction_alloc_block_size                             | 8192                                                                                                                                                                                                                                                                                                                                                                                                             |
| transaction_allow_batching                               | OFF                                                                                                                                                                                                                                                                                                                                                                                                              |
| transaction_isolation                                    | REPEATABLE-READ                                                                                                                                                                                                                                                                                                                                                                                                  |
| transaction_prealloc_size                                | 4096                                                                                                                                                                                                                                                                                                                                                                                                             |
| transaction_read_only                                    | OFF                                                                                                                                                                                                                                                                                                                                                                                                              |
| transaction_write_set_extraction                         | OFF                                                                                                                                                                                                                                                                                                                                                                                                              |
| tx_isolation                                             | REPEATABLE-READ                                                                                                                                                                                                                                                                                                                                                                                                  |
| tx_read_only                                             | OFF                                                                                                                                                                                                                                                                                                                                                                                                              |
| unique_checks                                            | ON                                                                                                                                                                                                                                                                                                                                                                                                               |
| updatable_views_with_limit                               | YES                                                                                                                                                                                                                                                                                                                                                                                                              |
| version                                                  | 5.7.21-0ubuntu0.16.04.1                                                                                                                                                                                                                                                                                                                                                                                          |
| version_comment                                          | (Ubuntu)                                                                                                                                                                                                                                                                                                                                                                                                         |
| version_compile_machine                                  | x86_64                                                                                                                                                                                                                                                                                                                                                                                                           |
| version_compile_os                                       | Linux                                                                                                                                                                                                                                                                                                                                                                                                            |
| wait_timeout                                             | 28800                                                                                                                                                                                                                                                                                                                                                                                                            |
| warning_count                                            | 0                                                                                                                                                                                                                                                                                                                                                                                                                |
+----------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
510 rows in set (0.01 sec)

 

© 著作权归作者所有

共有 人打赏支持
FeanLau
粉丝 3
博文 221
码字总数 117937
作品 0
浦东
程序员
私信 提问
Linux/CentOS安装MySQL(RPM安装、编译安装)

Linux/CentOS安装MySQL(RPM安装、编译安装) 目前最常用的MySQL安装方法也就是采用Yum安装RPM包,或者编译安装。这里将记录关于在CentOS上安装MySQL历史版本的方法。 RPM安装 这里使用CentO...

Eller
2018/12/25
0
0
Ubuntu安装nginx php5-fpm mysql (lnmp环境搭建)

配置环境说明: 系统:ubuntu 12.04 32位 内存:512M 硬盘:20G 一、安装nginx 1:ubuntu因为安全策略,一般是禁用了root用户,所以每次执行命令时一般需要加上sudo去操作。为了方面后面其他...

度外网络
2012/09/26
0
0
Linux MySQL安装教程

1 Ubuntu 16.04 sudo apt-get install mysql-server 一旦安装完成,MySQL服务器应该自动启动。您可以在终端提示符后运行以下命令来检查 MySQL 服务器是否正在运行: sudo netstat -tap | gr...

yuanlaijike
2017/12/09
0
0
lnmp+xdebug配置简单过程

ubuntu 12.04LTS环境: nginx 配置安装 安装依赖: libssl-dev libpcre3-dev 编译配置: wget http://nginx.org/download/nginx-1.5.4.tar.gz sudo ./configure --prefix=/usr/local/nginx --wi......

lilclimate
2013/02/20
0
1
企业级监控 Zabbix 的安装与使用

Zabbix 是一个基于WEB界面的提供分布式系统监视以及网络监视功能的企业级的开源解决方案。目前Git@OSC的服务器均使用Zabbix进行集群监控,写这篇博客也是为了记录安装使用过程中的一些总结。...

Zoker
2015/04/30
0
10

没有更多内容

加载失败,请刷新页面

加载更多

JS数组去重的几种常见方法

一、简单的去重方法 // 最简单数组去重法/** 新建一新数组,遍历传入数组,值不在新数组就push进该新数组中* IE8以下不支持数组的indexOf方法* */function uniq(array){ var ...

Jack088
9分钟前
0
0
kafka 集群监控

一、监控kafka工具有很多,但是对于运维人员来说kafka Manager 就可以了 二、下载kafkaManager 编译安装 地址https://github.com/yahoo/kafka-manager 三、下下来的是源码 需要在开始安装官方...

雁南飞丶
10分钟前
0
0
php开发环境搭建

一、wamp环境搭建 安装apache 安装mysql 解压php 在httpd.conf中配置apache,让apache支持php #加载php作为apache的一个模块 LoadModule php5_module "d:/server/php/php5apache2_4.dll" 5. ......

lujc
12分钟前
0
0
java+testng接口测试

最近写了三个接口,很不想写了,觉得好麻烦呀,用postman比这个简洁多了,为什么要写代码呀,为都要学习代码呀呀,我现在还没觉得手写代码比用工具工作上优势体现在哪里了~~知道的告诉我下...

EvanDev
21分钟前
0
0
反向代理(内网穿透)工具Ngrok安装

ngrok是一个反向代理工具,1.x版本源码开源;可以自己搭建一个服务来使用,将本地的web或tcp服务通过公共端口和外部建立一个安全通道,这样就可以通过外网直接访问本地对应的服务,在进行微信...

zerokb-小浪
28分钟前
0
0

没有更多内容

加载失败,请刷新页面

加载更多

返回顶部
顶部