SHOW VARIABLES;

'auto_generate_certs', 'ON'
'auto_increment_increment', '1'
'auto_increment_offset', '1'
'autocommit', 'ON'
'automatic_sp_privileges', 'ON'
'avoid_temporal_upgrade', 'OFF'
'back_log', '92'
'basedir', '/usr/'
'big_tables', 'OFF'
'bind_address', '*'
'binlog_cache_size', '32768'
'binlog_checksum', 'CRC32'
'binlog_direct_non_transactional_updates', 'OFF'
'binlog_error_action', 'ABORT_SERVER'
'binlog_format', 'ROW'
'binlog_group_commit_sync_delay', '0'
'binlog_group_commit_sync_no_delay_count', '0'
'binlog_gtid_simple_recovery', 'ON'
'binlog_max_flush_queue_time', '0'
'binlog_order_commits', 'ON'
'binlog_row_image', 'FULL'
'binlog_rows_query_log_events', 'OFF'
'binlog_stmt_cache_size', '32768'
'block_encryption_mode', 'aes-128-ecb'
'bulk_insert_buffer_size', '8388608'
'character_set_client', 'utf8'
'character_set_connection', 'utf8'
'character_set_database', 'latin1'
'character_set_filesystem', 'binary'
'character_set_results', 'utf8'
'character_set_server', 'latin1'
'character_set_system', 'utf8'
'character_sets_dir', '/usr/share/mysql/charsets/'
'check_proxy_users', 'OFF'
'collation_connection', 'utf8_general_ci'
'collation_database', 'latin1_swedish_ci'
'collation_server', 'latin1_swedish_ci'
'completion_type', 'NO_CHAIN'
'concurrent_insert', 'AUTO'
'connect_timeout', '10'
'core_file', 'OFF'
'csv_mode', ''
'datadir', '/var/lib/mysql/'
'date_format', '%Y-%m-%d'
'datetime_format', '%Y-%m-%d %H:%i:%s'
'default_authentication_plugin', 'mysql_native_password'
'default_password_lifetime', '0'
'default_storage_engine', 'InnoDB'
'default_tmp_storage_engine', 'InnoDB'
'default_week_format', '0'
'delay_key_write', 'ON'
'delayed_insert_limit', '100'
'delayed_insert_timeout', '300'
'delayed_queue_size', '1000'
'disabled_storage_engines', ''
'disconnect_on_expired_password', 'ON'
'div_precision_increment', '4'
'end_markers_in_json', 'OFF'
'enforce_gtid_consistency', 'OFF'
'enforce_storage_engine', ''
'eq_range_index_dive_limit', '200'
'error_count', '0'
'event_scheduler', 'OFF'
'expand_fast_index_creation', 'OFF'
'expire_logs_days', '1'
'explicit_defaults_for_timestamp', 'ON'
'external_user', ''
'extra_max_connections', '1'
'extra_port', '0'
'flush', 'OFF'
'flush_time', '0'
'foreign_key_checks', 'ON'
'ft_boolean_syntax', '+ -><()~*:\"\"&|'
'ft_max_word_len', '84'
'ft_min_word_len', '4'
'ft_query_expansion_limit', '20'
'ft_stopword_file', '(built-in)'
'general_log', 'OFF'
'general_log_file', '/var/lib/mysql/gpslive.log'
'group_concat_max_len', '1024'
'gtid_executed_compression_period', '1000'
'gtid_mode', 'OFF'
'gtid_next', 'AUTOMATIC'
'gtid_owned', ''
'gtid_purged', ''
'have_backup_locks', 'YES'
'have_backup_safe_binlog_info', 'YES'
'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_snapshot_cloning', 'YES'
'have_ssl', 'YES'
'have_statement_timeout', 'YES'
'have_symlink', 'DISABLED'
'host_cache_size', '342'
'hostname', 'gpslive.co.uk'
'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', '8'
'innodb_buffer_pool_load_abort', 'OFF'
'innodb_buffer_pool_load_at_startup', 'ON'
'innodb_buffer_pool_load_now', 'OFF'
'innodb_buffer_pool_size', '21474836480'
'innodb_change_buffer_max_size', '25'
'innodb_change_buffering', 'all'
'innodb_checksum_algorithm', 'crc32'
'innodb_checksums', 'ON'
'innodb_cleaner_lsn_age_factor', 'high_checkpoint'
'innodb_cmp_per_index_enabled', 'OFF'
'innodb_commit_concurrency', '0'
'innodb_compressed_columns_threshold', '96'
'innodb_compressed_columns_zip_level', '6'
'innodb_compression_failure_threshold_pct', '5'
'innodb_compression_level', '6'
'innodb_compression_pad_pct_max', '50'
'innodb_concurrency_tickets', '5000'
'innodb_corrupt_table_action', 'assert'
'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_empty_free_list_algorithm', 'backoff'
'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', '0'
'innodb_flush_method', 'O_DIRECT'
'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_kill_idle_transaction', '0'
'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', '33554432'
'innodb_log_files_in_group', '2'
'innodb_log_group_home_dir', './'
'innodb_log_write_ahead_size', '8192'
'innodb_lru_scan_depth', '1024'
'innodb_max_bitmap_file_size', '104857600'
'innodb_max_changed_pages', '1000000'
'innodb_max_dirty_pages_pct', '75.000000'
'innodb_max_dirty_pages_pct_lwm', '0.000000'
'innodb_max_purge_lag', '0'
'innodb_max_purge_lag_delay', '0'
'innodb_max_undo_log_size', '1073741824'
'innodb_monitor_disable', ''
'innodb_monitor_enable', ''
'innodb_monitor_reset', ''
'innodb_monitor_reset_all', ''
'innodb_numa_interleave', 'OFF'
'innodb_old_blocks_pct', '37'
'innodb_old_blocks_time', '1000'
'innodb_online_alter_log_max_size', '134217728'
'innodb_open_files', '400'
'innodb_optimize_fulltext_only', 'OFF'
'innodb_page_cleaners', '4'
'innodb_page_size', '16384'
'innodb_parallel_doublewrite_path', 'xb_doublewrite'
'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', '8'
'innodb_read_only', 'OFF'
'innodb_replication_delay', '0'
'innodb_rollback_on_timeout', 'OFF'
'innodb_rollback_segments', '128'
'innodb_show_locks_held', '10'
'innodb_show_verbose_locks', '0'
'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_track_changed_pages', 'OFF'
'innodb_undo_directory', './'
'innodb_undo_log_truncate', 'OFF'
'innodb_undo_logs', '128'
'innodb_undo_tablespaces', '0'
'innodb_use_global_flush_log_at_trx_commit', 'ON'
'innodb_use_native_aio', 'ON'
'innodb_version', '5.7.19-17'
'innodb_write_io_threads', '8'
'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'
'kill_idle_transaction', '0'
'large_files_support', 'ON'
'large_page_size', '0'
'large_pages', 'OFF'
'last_insert_id', '0'
'lc_messages', 'en_US'
'lc_messages_dir', '/usr/share/mysql/'
'lc_time_names', 'en_US'
'license', 'GPL'
'local_infile', 'ON'
'lock_wait_timeout', '31536000'
'locked_in_memory', 'OFF'
'log_bin', 'ON'
'log_bin_basename', '/var/log/mysql/mysql-bin'
'log_bin_index', '/var/log/mysql/mysql-bin.index'
'log_bin_trust_function_creators', 'OFF'
'log_bin_use_v1_row_events', 'OFF'
'log_builtin_as_identified_by_password', 'OFF'
'log_error', '/var/log/mysql/error.log'
'log_error_verbosity', '3'
'log_output', 'FILE'
'log_queries_not_using_indexes', 'OFF'
'log_slave_updates', 'OFF'
'log_slow_admin_statements', 'OFF'
'log_slow_filter', ''
'log_slow_rate_limit', '1'
'log_slow_rate_type', 'session'
'log_slow_slave_statements', 'OFF'
'log_slow_sp_statements', 'ON'
'log_slow_verbosity', ''
'log_statements_unsafe_for_binlog', 'ON'
'log_syslog', 'OFF'
'log_syslog_facility', 'daemon'
'log_syslog_include_pid', 'ON'
'log_syslog_tag', ''
'log_throttle_queries_not_using_indexes', '0'
'log_timestamps', 'UTC'
'log_warnings', '2'
'long_query_time', '10.000000'
'low_priority_updates', 'OFF'
'lower_case_file_system', 'OFF'
'lower_case_table_names', '0'
'master_info_repository', 'FILE'
'master_verify_checksum', 'OFF'
'max_allowed_packet', '4194304'
'max_binlog_cache_size', '18446744073709547520'
'max_binlog_files', '0'
'max_binlog_size', '1073741824'
'max_binlog_stmt_cache_size', '18446744073709547520'
'max_connect_errors', '100'
'max_connections', '214'
'max_delayed_threads', '20'
'max_digest_length', '1024'
'max_error_count', '64'
'max_execution_time', '0'
'max_heap_table_size', '536870912'
'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_slowlog_files', '0'
'max_slowlog_size', '0'
'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', '1024'
'optimizer_prune_level', '1'
'optimizer_search_depth', '62'
'optimizer_switch', 'index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,engine_condition_pushdown=on,index_condition_pushdown=on,mrr=on,mrr_cost_based=on,block_nested_loop=on,batched_key_access=off,materialization=on,semijoin=on,loosescan=on,firstmatch=on,duplicateweedout=on,subquery_materialization_cost_based=on,use_index_extensions=on,condition_fanout_filter=on,derived_merge=on'
'optimizer_trace', 'enabled=off,one_line=off'
'optimizer_trace_features', 'greedy_search=on,range_optimizer=on,dynamic_range=on,repeated_subselect=on'
'optimizer_trace_limit', '1'
'optimizer_trace_max_mem_size', '16384'
'optimizer_trace_offset', '-1'
'parser_max_mem_size', '18446744073709551615'
'performance_schema', 'ON'
'performance_schema_accounts_size', '-1'
'performance_schema_digests_size', '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', '400'
'performance_schema_max_metadata_locks', '-1'
'performance_schema_max_mutex_classes', '250'
'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', '203'
'performance_schema_max_statement_stack', '10'
'performance_schema_max_table_handles', '-1'
'performance_schema_max_table_instances', '-1'
'performance_schema_max_table_lock_stat', '-1'
'performance_schema_max_thread_classes', '50'
'performance_schema_max_thread_instances', '-1'
'performance_schema_session_connect_attrs_size', '512'
'performance_schema_setup_actors_size', '-1'
'performance_schema_setup_objects_size', '-1'
'performance_schema_users_size', '-1'
'pid_file', '/var/run/mysqld/mysqld.pid'
'plugin_dir', '/usr/lib/mysql/plugin/'
'port', '3306'
'preload_buffer_size', '32768'
'profiling', 'OFF'
'profiling_history_size', '15'
'protocol_version', '10'
'proxy_protocol_networks', ''
'proxy_user', ''
'pseudo_server_id', '0'
'pseudo_slave_mode', 'OFF'
'pseudo_thread_id', '170468203'
'query_alloc_block_size', '8192'
'query_cache_limit', '10485760'
'query_cache_min_res_unit', '4096'
'query_cache_size', '0'
'query_cache_strip_comments', 'OFF'
'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', '/var/log/mysql/mysql-relay-bin.log'
'relay_log_basename', '/var/log/mysql/mysql-relay-bin'
'relay_log_index', '/var/log/mysql/mysql-relay-bin.index'
'relay_log_info_file', 'relay-log.info'
'relay_log_info_repository', 'FILE'
'relay_log_purge', 'ON'
'relay_log_recovery', 'OFF'
'relay_log_space_limit', '0'
'report_host', ''
'report_password', ''
'report_port', '3306'
'report_user', ''
'require_secure_transport', 'OFF'
'rpl_stop_slave_timeout', '31536000'
'secure_auth', 'ON'
'secure_file_priv', '/var/lib/mysql-files/'
'server_id', '2'
'server_id_bits', '32'
'server_uuid', '5ccd4550-b58e-11e7-a68b-901b0ea3c2b9'
'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_old_temporals', 'OFF'
'skip_external_locking', 'ON'
'skip_name_resolve', 'OFF'
'skip_networking', 'OFF'
'skip_show_database', 'OFF'
'slave_allow_batching', 'OFF'
'slave_checkpoint_group', '512'
'slave_checkpoint_period', '300'
'slave_compressed_protocol', 'OFF'
'slave_exec_mode', 'STRICT'
'slave_load_tmpdir', '/tmp'
'slave_max_allowed_packet', '1073741824'
'slave_net_timeout', '60'
'slave_parallel_type', 'DATABASE'
'slave_parallel_workers', '0'
'slave_pending_jobs_size_max', '16777216'
'slave_preserve_commit_order', 'OFF'
'slave_rows_search_algorithms', 'TABLE_SCAN,INDEX_SCAN'
'slave_skip_errors', 'OFF'
'slave_sql_verify_checksum', 'ON'
'slave_transaction_retries', '10'
'slave_type_conversions', ''
'slow_launch_time', '2'
'slow_query_log', 'OFF'
'slow_query_log_always_write_time', '10.000000'
'slow_query_log_file', '/var/lib/mysql/gpslive-slow.log'
'slow_query_log_use_global_control', ''
'socket', '/var/run/mysqld/mysqld.sock'
'sort_buffer_size', '262144'
'sql_auto_is_null', 'OFF'
'sql_big_selects', 'ON'
'sql_buffer_result', 'OFF'
'sql_log_bin', 'ON'
'sql_log_off', 'OFF'
'sql_mode', 'STRICT_ALL_TABLES,NO_ENGINE_SUBSTITUTION'
'sql_notes', 'ON'
'sql_quote_show_create', 'ON'
'sql_safe_updates', 'ON'
'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', 'UTC'
'table_definition_cache', '16384'
'table_open_cache', '400'
'table_open_cache_instances', '16'
'thread_cache_size', '50'
'thread_handling', 'one-thread-per-connection'
'thread_pool_high_prio_mode', 'transactions'
'thread_pool_high_prio_tickets', '4294967295'
'thread_pool_idle_timeout', '60'
'thread_pool_max_threads', '100000'
'thread_pool_oversubscribe', '3'
'thread_pool_size', '8'
'thread_pool_stall_limit', '500'
'thread_stack', '262144'
'thread_statistics', 'OFF'
'time_format', '%H:%i:%s'
'time_zone', 'SYSTEM'
'timestamp', '1515167077.267011'
'tls_version', 'TLSv1,TLSv1.1,TLSv1.2'
'tmp_table_size', '536870912'
'tmpdir', '/tmp'
'transaction_alloc_block_size', '8192'
'transaction_allow_batching', 'OFF'
'transaction_prealloc_size', '4096'
'transaction_write_set_extraction', 'OFF'
'tx_isolation', 'REPEATABLE-READ'
'tx_read_only', 'OFF'
'unique_checks', 'ON'
'updatable_views_with_limit', 'YES'
'userstat', 'OFF'
'version', '5.7.19-17-log'
'version_comment', 'Percona Server (GPL), Release \'17\', Revision \'e19a6b7b73f\''
'version_compile_machine', 'x86_64'
'version_compile_os', 'debian-linux-gnu'
'wait_timeout', '28800'
'warning_count', '0'