MySQL5.7 global variables

estis2015/10/26 (月) 00:00 に投稿
mysql> show global 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/local/mysql                                                                                                                                                                                                                                                                                                                                                                                                 |
| big_tables                                               | OFF                                                                                                                                                                                                                                                                                                                                                                                                              |
| bind_address                                             | *                                                                                                                                                                                                                                                                                                                                                                                                                |
| 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                                     | latin1                                                                                                                                                                                                                                                                                                                                                                                                           |
| character_set_connection                                 | latin1                                                                                                                                                                                                                                                                                                                                                                                                           |
| character_set_database                                   | latin1                                                                                                                                                                                                                                                                                                                                                                                                           |
| character_set_filesystem                                 | binary                                                                                                                                                                                                                                                                                                                                                                                                           |
| character_set_results                                    | latin1                                                                                                                                                                                                                                                                                                                                                                                                           |
| character_set_server                                     | latin1                                                                                                                                                                                                                                                                                                                                                                                                           |
| character_set_system                                     | utf8                                                                                                                                                                                                                                                                                                                                                                                                             |
| character_sets_dir                                       | /usr/local/mysql/share/charsets/                                                                                                                                                                                                                                                                                                                                                                                 |
| check_proxy_users                                        | OFF                                                                                                                                                                                                                                                                                                                                                                                                              |
| collation_connection                                     | latin1_swedish_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                                                  | /usr/local/mysql/data/                                                                                                                                                                                                                                                                                                                                                                                           |
| date_format                                              | %Y-%m-%d                                                                                                                                                                                                                                                                                                                                                                                                         |
| datetime_format                                          | %Y-%m-%d %H:%i:%s                                                                                                                                                                                                                                                                                                                                                                                                |
| default_authentication_plugin                            | mysql_native_password                                                                                                                                                                                                                                                                                                                                                                                            |
| default_password_lifetime                                | 360                                                                                                                                                                                                                                                                                                                                                                                                              |
| 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                                                                                                                                                                                                                                                                                                                                                                                                              |
| event_scheduler                                          | OFF                                                                                                                                                                                                                                                                                                                                                                                                              |
| expire_logs_days                                         | 0                                                                                                                                                                                                                                                                                                                                                                                                                |
| explicit_defaults_for_timestamp                          | OFF                                                                                                                                                                                                                                                                                                                                                                                                              |
| flush                                                    | OFF                                                                                                                                                                                                                                                                                                                                                                                                              |
| flush_time                                               | 0                                                                                                                                                                                                                                                                                                                                                                                                                |
| foreign_key_checks                                       | ON                                                                                                                                                                                                                                                                                                                                                                                                               |
| ft_boolean_syntax                                        | + ->

Comments