Mysql : Show Status voir le réglages de Mysql

 

Ceci est un topic avancé. En tapant cette commande vous allez voir un peu les entrailles de Mysql. Nous allons voir ce qui est important dans ce tableau, il n’est pas question de tout vous expliquer, pour cela il y a la documentation officielle, mais nous allons plutôt voir comment régler les variables pour un fonctionnement optimal.

mysql> show global status;
+------------------------------------------+-------------+
| Variable_name                            | Value       |
+------------------------------------------+-------------+
| Aborted_clients                          | 0           |
| Aborted_connects                         | 2317        |
| Binlog_cache_disk_use                    | 0           |
| Binlog_cache_use                         | 0           |
| Binlog_stmt_cache_disk_use               | 0           |
| Binlog_stmt_cache_use                    | 0           |
| Bytes_received                           | 317330299   |
| Bytes_sent                               | 34571760173 |
| Com_admin_commands                       | 7           |
| Com_assign_to_keycache                   | 0           |
| Com_alter_db                             | 0           |
| Com_alter_db_upgrade                     | 0           |
| Com_alter_event                          | 0           |
| Com_alter_function                       | 0           |
| Com_alter_procedure                      | 0           |
| Com_alter_server                         | 0           |
| Com_alter_table                          | 1011        |
| Com_alter_tablespace                     | 0           |
| Com_analyze                              | 0           |
| Com_begin                                | 271         |
| Com_binlog                               | 0           |
| Com_call_procedure                       | 0           |
| Com_change_db                            | 48462       |
| Com_change_master                        | 0           |
| Com_check                                | 0           |
| Com_checksum                             | 0           |
| Com_commit                               | 271         |
| Com_create_db                            | 0           |
| Com_create_event                         | 0           |
| Com_create_function                      | 0           |
| Com_create_index                         | 1           |
| Com_create_procedure                     | 0           |
| Com_create_server                        | 0           |
| Com_create_table                         | 12471       |
| Com_create_trigger                       | 0           |
| Com_create_udf                           | 0           |
| Com_create_user                          | 0           |
| Com_create_view                          | 0           |
| Com_dealloc_sql                          | 0           |
| Com_delete                               | 18160       |
| Com_delete_multi                         | 0           |
| Com_do                                   | 0           |
| Com_drop_db                              | 0           |
| Com_drop_event                           | 0           |
| Com_drop_function                        | 0           |
| Com_drop_index                           | 0           |
| Com_drop_procedure                       | 0           |
| Com_drop_server                          | 0           |
| Com_drop_table                           | 12471       |
| Com_drop_trigger                         | 0           |
| Com_drop_user                            | 0           |
| Com_drop_view                            | 0           |
| Com_empty_query                          | 0           |
| Com_execute_sql                          | 0           |
| Com_flush                                | 5           |
| Com_grant                                | 0           |
| Com_ha_close                             | 0           |
| Com_ha_open                              | 0           |
| Com_ha_read                              | 0           |
| Com_help                                 | 0           |
| Com_insert                               | 218749      |
| Com_insert_select                        | 10535       |
| Com_install_plugin                       | 0           |
| Com_kill                                 | 0           |
| Com_load                                 | 0           |
| Com_lock_tables                          | 119         |
| Com_optimize                             | 0           |
| Com_preload_keys                         | 0           |
| Com_prepare_sql                          | 0           |
| Com_purge                                | 0           |
| Com_purge_before_date                    | 0           |
| Com_release_savepoint                    | 0           |
| Com_rename_table                         | 0           |
| Com_rename_user                          | 0           |
| Com_repair                               | 0           |
| Com_replace                              | 11          |
| Com_replace_select                       | 0           |
| Com_reset                                | 0           |
| Com_resignal                             | 0           |
| Com_revoke                               | 0           |
| Com_revoke_all                           | 0           |
| Com_rollback                             | 0           |
| Com_rollback_to_savepoint                | 0           |
| Com_savepoint                            | 0           |
| Com_select                               | 384720      |
| Com_set_option                           | 168209      |
| Com_signal                               | 0           |
| Com_show_authors                         | 0           |
| Com_show_binlog_events                   | 0           |
| Com_show_binlogs                         | 0           |
| Com_show_charsets                        | 0           |
| Com_show_collations                      | 0           |
| Com_show_contributors                    | 0           |
| Com_show_create_db                       | 0           |
| Com_show_create_event                    | 0           |
| Com_show_create_func                     | 0           |
| Com_show_create_proc                     | 0           |
| Com_show_create_table                    | 5686        |
| Com_show_create_trigger                  | 0           |
| Com_show_databases                       | 2           |
| Com_show_engine_logs                     | 0           |
| Com_show_engine_mutex                    | 0           |
| Com_show_engine_status                   | 0           |
| Com_show_events                          | 0           |
| Com_show_errors                          | 0           |
| Com_show_fields                          | 9891        |
| Com_show_function_status                 | 0           |
| Com_show_grants                          | 0           |
| Com_show_keys                            | 0           |
| Com_show_master_status                   | 0           |
| Com_show_open_tables                     | 0           |
| Com_show_plugins                         | 0           |
| Com_show_privileges                      | 0           |
| Com_show_procedure_status                | 0           |
| Com_show_processlist                     | 0           |
| Com_show_profile                         | 0           |
| Com_show_profiles                        | 0           |
| Com_show_relaylog_events                 | 0           |
| Com_show_slave_hosts                     | 0           |
| Com_show_slave_status                    | 0           |
| Com_show_status                          | 1           |
| Com_show_storage_engines                 | 0           |
| Com_show_table_status                    | 5686        |
| Com_show_tables                          | 169         |
| Com_show_triggers                        | 5686        |
| Com_show_variables                       | 373         |
| Com_show_warnings                        | 0           |
| Com_slave_start                          | 0           |
| Com_slave_stop                           | 0           |
| Com_stmt_close                           | 0           |
| Com_stmt_execute                         | 0           |
| Com_stmt_fetch                           | 0           |
| Com_stmt_prepare                         | 0           |
| Com_stmt_reprepare                       | 0           |
| Com_stmt_reset                           | 0           |
| Com_stmt_send_long_data                  | 0           |
| Com_truncate                             | 314         |
| Com_uninstall_plugin                     | 0           |
| Com_unlock_tables                        | 136         |
| Com_update                               | 38395       |
| Com_update_multi                         | 0           |
| Com_xa_commit                            | 0           |
| Com_xa_end                               | 0           |
| Com_xa_prepare                           | 0           |
| Com_xa_recover                           | 0           |
| Com_xa_rollback                          | 0           |
| Com_xa_start                             | 0           |
| Compression                              | OFF         |
| Connections                              | 111949      |
| Created_tmp_disk_tables                  | 21148       |
| Created_tmp_files                        | 24          |
| Created_tmp_tables                       | 38895       |
| Delayed_errors                           | 0           |
| Delayed_insert_threads                   | 0           |
| Delayed_writes                           | 0           |
| Flush_commands                           | 1           |
| Handler_commit                           | 169238      |
| Handler_delete                           | 9925        |
| Handler_discover                         | 0           |
| Handler_prepare                          | 0           |
| Handler_read_first                       | 24581       |
| Handler_read_key                         | 1519441     |
| Handler_read_last                        | 1184        |
| Handler_read_next                        | 3444617     |
| Handler_read_prev                        | 76079       |
| Handler_read_rnd                         | 48977532    |
| Handler_read_rnd_next                    | 3207292543  |
| Handler_rollback                         | 0           |
| Handler_savepoint                        | 0           |
| Handler_savepoint_rollback               | 0           |
| Handler_update                           | 120829      |
| Handler_write                            | 807199      |
| Innodb_buffer_pool_pages_data            | 5313        |
| Innodb_buffer_pool_bytes_data            | 87048192    |
| Innodb_buffer_pool_pages_dirty           | 0           |
| Innodb_buffer_pool_bytes_dirty           | 0           |
| Innodb_buffer_pool_pages_flushed         | 32202       |
| Innodb_buffer_pool_pages_free            | 2855        |
| Innodb_buffer_pool_pages_misc            | 23          |
| Innodb_buffer_pool_pages_total           | 8191        |
| Innodb_buffer_pool_read_ahead_rnd        | 0           |
| Innodb_buffer_pool_read_ahead            | 0           |
| Innodb_buffer_pool_read_ahead_evicted    | 0           |
| Innodb_buffer_pool_read_requests         | 2672987     |
| Innodb_buffer_pool_reads                 | 4937        |
| Innodb_buffer_pool_wait_free             | 0           |
| Innodb_buffer_pool_write_requests        | 931260      |
| Innodb_data_fsyncs                       | 160850      |
| Innodb_data_pending_fsyncs               | 0           |
| Innodb_data_pending_reads                | 0           |
| Innodb_data_pending_writes               | 0           |
| Innodb_data_read                         | 83120128    |
| Innodb_data_reads                        | 5692        |
| Innodb_data_writes                       | 189024      |
| Innodb_data_written                      | 1205576704  |
| Innodb_dblwr_pages_written               | 32202       |
| Innodb_dblwr_writes                      | 1928        |
| Innodb_have_atomic_builtins              | ON          |
| Innodb_log_waits                         | 0           |
| Innodb_log_write_requests                | 151151      |
| Innodb_log_writes                        | 152024      |
| Innodb_os_log_fsyncs                     | 153037      |
| Innodb_os_log_pending_fsyncs             | 0           |
| Innodb_os_log_pending_writes             | 0           |
| Innodb_os_log_written                    | 149860352   |
| Innodb_page_size                         | 16384       |
| Innodb_pages_created                     | 2517        |
| Innodb_pages_read                        | 4939        |
| Innodb_pages_written                     | 32202       |
| Innodb_row_lock_current_waits            | 0           |
| Innodb_row_lock_time                     | 0           |
| Innodb_row_lock_time_avg                 | 0           |
| Innodb_row_lock_time_max                 | 0           |
| Innodb_row_lock_waits                    | 0           |
| Innodb_rows_deleted                      | 2484        |
| Innodb_rows_inserted                     | 73896       |
| Innodb_rows_read                         | 2013849     |
| Innodb_rows_updated                      | 104201      |
| Innodb_truncated_status_writes           | 0           |
| Key_blocks_not_flushed                   | 0           |
| Key_blocks_unused                        | 306264      |
| Key_blocks_used                          | 17035       |
| Key_read_requests                        | 6045423     |
| Key_reads                                | 31732       |
| Key_write_requests                       | 301245      |
| Key_writes                               | 294060      |
| Last_query_cost                          | 0.000000    |
| Max_used_connections                     | 11          |
| Not_flushed_delayed_rows                 | 0           |
| Open_files                               | 786         |
| Open_streams                             | 0           |
| Open_table_definitions                   | 508         | 
| Open_tables                              | 512         |
| Opened_files                             | 160634      |<< on peut être limité
| Opened_table_definitions                 | 43297       |
| Opened_tables                            | 31209       |
| Performance_schema_cond_classes_lost     | 0           |
| Performance_schema_cond_instances_lost   | 0           |
| Performance_schema_file_classes_lost     | 0           |
| Performance_schema_file_handles_lost     | 0           |
| Performance_schema_file_instances_lost   | 0           |
| Performance_schema_locker_lost           | 0           |
| Performance_schema_mutex_classes_lost    | 0           |
| Performance_schema_mutex_instances_lost  | 0           |
| Performance_schema_rwlock_classes_lost   | 0           |
| Performance_schema_rwlock_instances_lost | 0           |
| Performance_schema_table_handles_lost    | 0           |
| Performance_schema_table_instances_lost  | 0           |
| Performance_schema_thread_classes_lost   | 0           |
| Performance_schema_thread_instances_lost | 0           |
| Prepared_stmt_count                      | 0           |
| Qcache_free_blocks                       | 2109        |
| Qcache_free_memory                       | 8953752     |
| Qcache_hits                              | 1129972     |
| Qcache_inserts                           | 296789      |
| Qcache_lowmem_prunes                     | 104980      |
| Qcache_not_cached                        | 86212       |
| Qcache_queries_in_cache                  | 8779        |
| Qcache_total_blocks                      | 20627       |
| Queries                                  | 2181421     |
| Questions                                | 2181413     |
| Rpl_status                               | AUTH_MASTER |
| Select_full_join                         | 480         |
| Select_full_range_join                   | 0           |
| Select_range                             | 10185       |
| Select_range_check                       | 0           |
| Select_scan                              | 86268       |
| Slave_heartbeat_period                   | 0.000       |
| Slave_open_temp_tables                   | 0           |
| Slave_received_heartbeats                | 0           |
| Slave_retried_transactions               | 0           |
| Slave_running                            | OFF         |
| Slow_launch_threads                      | 0           |
| Slow_queries                             | 1           |
| Sort_merge_passes                        | 8           |
| Sort_range                               | 20488       |
| Sort_rows                                | 49035868    |
| Sort_scan                                | 34820       |
| Ssl_accept_renegotiates                  | 0           |
| Ssl_accepts                              | 0           |
| Ssl_callback_cache_hits                  | 0           |
| Ssl_cipher                               |             |
| Ssl_cipher_list                          |             |
| Ssl_client_connects                      | 0           |
| Ssl_connect_renegotiates                 | 0           |
| Ssl_ctx_verify_depth                     | 0           |
| Ssl_ctx_verify_mode                      | 0           |
| Ssl_default_timeout                      | 0           |
| Ssl_finished_accepts                     | 0           |
| Ssl_finished_connects                    | 0           |
| Ssl_session_cache_hits                   | 0           |
| Ssl_session_cache_misses                 | 0           |
| Ssl_session_cache_mode                   | NONE        |
| Ssl_session_cache_overflows              | 0           |
| Ssl_session_cache_size                   | 0           |
| Ssl_session_cache_timeouts               | 0           |
| Ssl_sessions_reused                      | 0           |
| Ssl_used_session_cache_entries           | 0           |
| Ssl_verify_depth                         | 0           |
| Ssl_verify_mode                          | 0           |
| Ssl_version                              |             |
| Table_locks_immediate                    | 744686      |
| Table_locks_waited                       | 84          |
| Tc_log_max_pages_used                    | 0           |
| Tc_log_page_size                         | 0           |
| Tc_log_page_waits                        | 0           |
| Threads_cached                           | 7           |
| Threads_connected                        | 1           |
| Threads_created                          | 15          |
| Threads_running                          | 1           |
| Uptime                                   | 429307      |
| Uptime_since_flush_status                | 429307      |
+------------------------------------------+-------------+

 

 

 

Voir les variables de configuration de MySQL

mysql > show variables;
 Variable_name                                            | Value                                                                                                                                                                                                                                                                                                                                                                                                            |
+----------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| auto_generate_certs                                      | ON                                                                                                                                                                                                                                                                                                                                                                                                               |
| auto_increment_increment                                 | 1                                                                                                                                                                                                                                                                                                                                                                                                                |
| auto_increment_offset                                    | 1                                                                                                                                                                                                                                                                                                                                                                                                                |
| autocommit                                               | ON                                                                                                                                                                                                                                                                                                                                                                                                               |
| automatic_sp_privileges                                  | ON                                                                                                                                                                                                                                                                                                                                                                                                               |
| avoid_temporal_upgrade                                   | OFF                                                                                                                                                                                                                                                                                                                                                                                                              |
| back_log                                                 | 80                                                                                                                                                                                                                                                                                                                                                                                                               |
| basedir                                                  | /usr/local/Cellar/mysql@5.7/5.7.26/                                                                                                                                                                                                                                                                                                                                                                              |
| 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                                                                                                                                                                                                                                                                                                                                                                                                            |
| binlog_transaction_dependency_history_size               | 25000                                                                                                                                                                                                                                                                                                                                                                                                            |
| binlog_transaction_dependency_tracking                   | COMMIT_ORDER                                                                                                                                                                                                                                                                                                                                                                                                     |
| block_encryption_mode                                    | aes-128-ecb                                                                                                                                                                                                                                                                                                                                                                                                      |
| bulk_insert_buffer_size                                  | 8388608                                                                                                                                                                                                                                                                                                                                                                                                          |
| character_set_client                                     | utf8                                                                                                                                                                                                                                                                                                                                                                                                             |
| character_set_connection                                 | utf8                                                                                                                                                                                                                                                                                                                                                                                                             |
| character_set_database                                   | utf8                                                                                                                                                                                                                                                                                                                                                                                                             |
| character_set_filesystem                                 | binary                                                                                                                                                                                                                                                                                                                                                                                                           |
| character_set_results                                    | utf8                                                                                                                                                                                                                                                                                                                                                                                                             |
| character_set_server                                     | utf8                                                                                                                                                                                                                                                                                                                                                                                                             |
| character_set_system                                     | utf8                                                                                                                                                                                                                                                                                                                                                                                                             |
| character_sets_dir                                       | /usr/local/Cellar/mysql@5.7/5.7.26/share/mysql/charsets/                                                                                                                                                                                                                                                                                                                                                         |
| check_proxy_users                                        | OFF                                                                                                                                                                                                                                                                                                                                                                                                              |
| collation_connection                                     | utf8_general_ci                                                                                                                                                                                                                                                                                                                                                                                                  |
| collation_database                                       | utf8_general_ci                                                                                                                                                                                                                                                                                                                                                                                                  |
| collation_server                                         | utf8_general_ci                                                                                                                                                                                                                                                                                                                                                                                                  |
| completion_type                                          | NO_CHAIN                                                                                                                                                                                                                                                                                                                                                                                                         |
| concurrent_insert                                        | AUTO                                                                                                                                                                                                                                                                                                                                                                                                             |
| connect_timeout                                          | 10                                                                                                                                                                                                                                                                                                                                                                                                               |
| core_file                                                | OFF                                                                                                                                                                                                                                                                                                                                                                                                              |
| datadir                                                  | /usr/local/var/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                                         | 0                                                                                                                                                                                                                                                                                                                                                                                                                |
| 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                                              | ON                                                                                                                                                                                                                                                                                                                                                                                                               |
| general_log_file                                         | /Users/poste5hookipa/sites/logs/mysql.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                                             | YES                                                                                                                                                                                                                                                                                                                                                                                                              |
| have_profiling                                           | YES                                                                                                                                                                                                                                                                                                                                                                                                              |
| have_query_cache                                         | YES                                                                                                                                                                                                                                                                                                                                                                                                              |
| have_rtree_keys                                          | YES                                                                                                                                                                                                                                                                                                                                                                                                              |
| have_ssl                                                 | YES                                                                                                                                                                                                                                                                                                                                                                                                              |
| have_statement_timeout                                   | YES                                                                                                                                                                                                                                                                                                                                                                                                              |
| have_symlink                                             | YES                                                                                                                                                                                                                                                                                                                                                                                                              |
| host_cache_size                                          | 279                                                                                                                                                                                                                                                                                                                                                                                                              |
| hostname                                                 | iMac-de-Poste5.local                                                                                                                                                                                                                                                                                                                                                                                             |
| 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_old_blocks_pct                                    | 37                                                                                                                                                                                                                                                                                                                                                                                                               |
| innodb_old_blocks_time                                   | 1000                                                                                                                                                                                                                                                                                                                                                                                                             |
| innodb_online_alter_log_max_size                         | 134217728                                                                                                                                                                                                                                                                                                                                                                                                        |
| innodb_open_files                                        | 2000                                                                                                                                                                                                                                                                                                                                                                                                             |
| 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                                    | OFF                                                                                                                                                                                                                                                                                                                                                                                                              |
| innodb_version                                           | 5.7.26                                                                                                                                                                                                                                                                                                                                                                                                           |
| 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                                          | 8388608                                                                                                                                                                                                                                                                                                                                                                                                          |
| 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/local/Cellar/mysql@5.7/5.7.26/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                                                | ./iMac-de-Poste5.local.err                                                                                                                                                                                                                                                                                                                                                                                       |
| 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                                   | ON                                                                                                                                                                                                                                                                                                                                                                                                               |
| lower_case_table_names                                   | 2                                                                                                                                                                                                                                                                                                                                                                                                                |
| master_info_repository                                   | FILE                                                                                                                                                                                                                                                                                                                                                                                                             |
| master_verify_checksum                                   | OFF                                                                                                                                                                                                                                                                                                                                                                                                              |
| max_allowed_packet                                       | 4194304                                                                                                                                                                                                                                                                                                                                                                                                          |
| max_binlog_cache_size                                    | 18446744073709547520                                                                                                                                                                                                                                                                                                                                                                                             |
| max_binlog_size                                          | 1073741824                                                                                                                                                                                                                                                                                                                                                                                                       |
| 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                                   | OFF                                                                                                                                                                                                                                                                                                                                                                                                              |
| 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                                         | 5000                                                                                                                                                                                                                                                                                                                                                                                                             |
| 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                          | 10000                                                                                                                                                                                                                                                                                                                                                                                                            |
| performance_schema_events_stages_history_long_size       | 10000                                                                                                                                                                                                                                                                                                                                                                                                            |
| performance_schema_events_stages_history_size            | 10                                                                                                                                                                                                                                                                                                                                                                                                               |
| performance_schema_events_statements_history_long_size   | 10000                                                                                                                                                                                                                                                                                                                                                                                                            |
| performance_schema_events_statements_history_size        | 10                                                                                                                                                                                                                                                                                                                                                                                                               |
| performance_schema_events_transactions_history_long_size | 10000                                                                                                                                                                                                                                                                                                                                                                                                            |
| performance_schema_events_transactions_history_size      | 10                                                                                                                                                                                                                                                                                                                                                                                                               |
| performance_schema_events_waits_history_long_size        | 10000                                                                                                                                                                                                                                                                                                                                                                                                            |
| 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                    | 50                                                                                                                                                                                                                                                                                                                                                                                                               |
| 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                                                 | iMac-de-Poste5.local.pid                                                                                                                                                                                                                                                                                                                                                                                         |
| plugin_dir                                               | /usr/local/opt/mysql@5.7/lib/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                                         | 44                                                                                                                                                                                                                                                                                                                                                                                                               |
| query_alloc_block_size                                   | 8192                                                                                                                                                                                                                                                                                                                                                                                                             |
| query_cache_limit                                        | 1048576                                                                                                                                                                                                                                                                                                                                                                                                          |
| query_cache_min_res_unit                                 | 4096                                                                                                                                                                                                                                                                                                                                                                                                             |
| query_cache_size                                         | 1048576                                                                                                                                                                                                                                                                                                                                                                                                          |
| 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                                       | /usr/local/var/mysql/iMac-de-Poste5-relay-bin                                                                                                                                                                                                                                                                                                                                                                    |
| relay_log_index                                          | /usr/local/var/mysql/iMac-de-Poste5-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                                         | /private/var/lib/mysql-files/                                                                                                                                                                                                                                                                                                                                                                                    |
| server_id                                                | 0                                                                                                                                                                                                                                                                                                                                                                                                                |
| server_id_bits                                           | 32                                                                                                                                                                                                                                                                                                                                                                                                               |
| server_uuid                                              | 229573c4-aeb2-11e9-9f9e-7872d5d3a3b8                                                                                                                                                                                                                                                                                                                                                                             |
| 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_auto_generate_rsa_keys                   | ON                                                                                                                                                                                                                                                                                                                                                                                                               |
| sha256_password_private_key_path                         | private_key.pem                                                                                                                                                                                                                                                                                                                                                                                                  |
| sha256_password_proxy_users                              | OFF                                                                                                                                                                                                                                                                                                                                                                                                              |
| sha256_password_public_key_path                          | public_key.pem                                                                                                                                                                                                                                                                                                                                                                                                   |
| show_compatibility_56                                    | OFF                                                                                                                                                                                                                                                                                                                                                                                                              |
| show_create_table_verbosity                              | 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                                        | /var/folders/_m/1fwxv1810qz9dnmq6f39dqzr0000gn/T/                                                                                                                                                                                                                                                                                                                                                                |
| 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                                      | /usr/local/var/mysql/iMac-de-Poste5-slow.log                                                                                                                                                                                                                                                                                                                                                                     |
| socket                                                   | /tmp/mysql.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                                                   | ca.pem                                                                                                                                                                                                                                                                                                                                                                                                           |
| ssl_capath                                               |                                                                                                                                                                                                                                                                                                                                                                                                                  |
| ssl_cert                                                 | server-cert.pem                                                                                                                                                                                                                                                                                                                                                                                                  |
| ssl_cipher                                               |                                                                                                                                                                                                                                                                                                                                                                                                                  |
| ssl_crl                                                  |                                                                                                                                                                                                                                                                                                                                                                                                                  |
| ssl_crlpath                                              |                                                                                                                                                                                                                                                                                                                                                                                                                  |
| ssl_key                                                  | server-key.pem                                                                                                                                                                                                                                                                                                                                                                                                   |
| 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                                         | CEST                                                                                                                                                                                                                                                                                                                                                                                                             |
| table_definition_cache                                   | 1400                                                                                                                                                                                                                                                                                                                                                                                                             |
| table_open_cache                                         | 2000                                                                                                                                                                                                                                                                                                                                                                                                             |
| table_open_cache_instances                               | 16                                                                                                                                                                                                                                                                                                                                                                                                               |
| thread_cache_size                                        | 9                                                                                                                                                                                                                                                                                                                                                                                                                |
| thread_handling                                          | one-thread-per-connection                                                                                                                                                                                                                                                                                                                                                                                        |
| thread_stack                                             | 262144                                                                                                                                                                                                                                                                                                                                                                                                           |
| time_format                                              | %H:%i:%s                                                                                                                                                                                                                                                                                                                                                                                                         |
| time_zone                                                | SYSTEM                                                                                                                                                                                                                                                                                                                                                                                                           |
| timestamp                                                | 1564575641.188141                                                                                                                                                                                                                                                                                                                                                                                                |
| tls_version                                              | TLSv1,TLSv1.1,TLSv1.2                                                                                                                                                                                                                                                                                                                                                                                            |
| tmp_table_size                                           | 16777216                                                                                                                                                                                                                                                                                                                                                                                                         |
| tmpdir                                                   | /var/folders/_m/1fwxv1810qz9dnmq6f39dqzr0000gn/T/                                                                                                                                                                                                                                                                                                                                                                |
| 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.26-log                                                                                                                                                                                                                                                                                                                                                                                                       |
| version_comment                                          | Homebrew                                                                                                                                                                                                                                                                                                                                                                                                         |
| version_compile_machine                                  | x86_64                                                                                                                                                                                                                                                                                                                                                                                                           |
| version_compile_os                                       | osx10.14                                                                                                                                                                                                                                                                                                                                                                                                         |
| wait_timeout                                             | 28800                                                                                                                                                                                                                                                                                                                                                                                                            |
| warning_count                                            | 0   

Vous aimerez aussi...

Laisser un commentaire

Votre adresse de messagerie ne sera pas publiée. Les champs obligatoires sont indiqués avec *