MySQL Forums
Forum List  »  Performance

High memory used by MySQL
Posted by: Damian Kolany
Date: February 12, 2020 02:45AM

Hi everyone.
I faced an issue with increasing memory on my server becouse of my mysql.
He never stop eating my RAM :) and he need one day sometimes few days to eat all. That's why
i need to make restart from time to time otherwise OOM killer will do it for me ...

I read many topics about it, but still without success.
Please for any advice in this case, below more technical details.

Im using virtual machine with ubuntu 18.04 on board.
( it's production server )

RAM: 16GB
CPU: 16-core
SWAP: 4GB
vm.swappiness = 60

Distributor ID: Ubuntu
Description: Ubuntu 18.04.4 LTS
Release: 18.04
Codename: bionic

mysql Ver 14.14 Distrib 5.7.29, for Linux (x86_64) using EditLine wrapper

[client]
port=3306
socket=/var/run/mysqld/mysqld.sock

[mysqld_safe]
socket=/var/run/mysqld/mysqld.sock

[mysqld]
user=mysql
pid-file=/var/run/mysqld/mysqld.pid
socket=/var/run/mysqld/mysqld.sock
port=3306
basedir=/usr
datadir=/var/lib/mysql
tmpdir=/tmp
lc-messages-dir=/usr/share/mysql
log_error=/var/log/mysql/error.log
#general_log=on
#general_log_file=/var/log/mysql/query.log

symbolic-links=0

skip-external-locking
key_buffer_size = 100M
max_allowed_packet = 100M
open_files_limit = 5000
table_open_cache = 2048
table_definition_cache = 2048
sort_buffer_size = 512K
read_buffer_size = 512K
read_rnd_buffer_size = 4M
myisam_sort_buffer_size = 64M
thread_cache_size = 50
query_cache_size = 0
tmp_table_size = 128M
join_buffer_size = 512K
query_cache_type = 0
innodb_file_per_table = 1
innodb_log_files_in_group = 2
innodb_log_file_size = 650M
innodb_flush_log_at_trx_commit = 1
innodb_file_per_table = 1
innodb_buffer_pool_size = 6G
innodb_buffer_pool_instances = 2
innodb_lock_wait_timeout = 600
max_heap_table_size = 128M
max_connections=200
max_user_connections=200
wait_timeout=600
interactive_timeout=500
long_query_time= 5


sql_mode = STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION


!includedir /etc/mysql/conf.d/


free -m
total used free shared buff/cache available
Mem: 16038 14758 253 5 1027 954
Swap: 4095 1260 2835


top -b
top - 08:01:28 up 304 days, 18:45, 9 users, load average: 2.74, 1.29, 0.83
Tasks: 282 total, 2 running, 174 sleeping, 0 stopped, 4 zombie
%Cpu(s): 5.6 us, 0.4 sy, 0.0 ni, 92.9 id, 1.1 wa, 0.0 hi, 0.1 si, 0.0 st
KiB Mem : 16423680 total, 158976 free, 15008160 used, 1256544 buff/cache
KiB Swap: 4194300 total, 2808044 free, 1386256 used. 1083244 avail Mem

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
20323 mysql 20 0 20.553g 0.013t 5460 S 105.9 87.2 597:59.94 mysqld
23760 root 20 0 8792 2528 2288 R 94.1 0.0 0:29.23 zip
23874 root 20 0 44668 4060 3336 R 5.9 0.0 0:00.02 top
1 root 20 0 225680 5320 3252 S 0.0 0.0 317:39.18 systemd


show global status


Variable_name: Aborted_clients
Value: 2
Variable_name: Aborted_connects
Value: 0
Variable_name: Binlog_cache_disk_use
Value: 0
Variable_name: Binlog_cache_use
Value: 0
Variable_name: Binlog_stmt_cache_disk_use
Value: 0
Variable_name: Binlog_stmt_cache_use
Value: 0
Variable_name: Bytes_received
Value: 1310398842
Variable_name: Bytes_sent
Value: 61798110285
Variable_name: Com_admin_commands
Value: 3
Variable_name: Com_assign_to_keycache
Value: 0
Variable_name: Com_alter_db
Value: 0
Variable_name: Com_alter_db_upgrade
Value: 0
Variable_name: Com_alter_event
Value: 0
Variable_name: Com_alter_function
Value: 0
Variable_name: Com_alter_instance
Value: 0
Variable_name: Com_alter_procedure
Value: 0
Variable_name: Com_alter_server
Value: 0
Variable_name: Com_alter_table
Value: 0
Variable_name: Com_alter_tablespace
Value: 0
Variable_name: Com_alter_user
Value: 0
Variable_name: Com_analyze
Value: 0
Variable_name: Com_begin
Value: 166977
Variable_name: Com_binlog
Value: 0
Variable_name: Com_call_procedure
Value: 167342
Variable_name: Com_change_db
Value: 5519
Variable_name: Com_change_master
Value: 0
Variable_name: Com_change_repl_filter
Value: 0
Variable_name: Com_check
Value: 0
Variable_name: Com_checksum
Value: 0
Variable_name: Com_commit
Value: 166515
Variable_name: Com_create_db
Value: 0
Variable_name: Com_create_event
Value: 0
Variable_name: Com_create_function
Value: 0
Variable_name: Com_create_index
Value: 0
Variable_name: Com_create_procedure
Value: 0
Variable_name: Com_create_server
Value: 0
Variable_name: Com_create_table
Value: 0
Variable_name: Com_create_trigger
Value: 0
Variable_name: Com_create_udf
Value: 0
Variable_name: Com_create_user
Value: 0
Variable_name: Com_create_view
Value: 0
Variable_name: Com_dealloc_sql
Value: 0
Variable_name: Com_delete
Value: 4645
Variable_name: Com_delete_multi
Value: 0
Variable_name: Com_do
Value: 0
Variable_name: Com_drop_db
Value: 0
Variable_name: Com_drop_event
Value: 0
Variable_name: Com_drop_function
Value: 0
Variable_name: Com_drop_index
Value: 0
Variable_name: Com_drop_procedure
Value: 0
Variable_name: Com_drop_server
Value: 0
Variable_name: Com_drop_table
Value: 0
Variable_name: Com_drop_trigger
Value: 0
Variable_name: Com_drop_user
Value: 0
Variable_name: Com_drop_view
Value: 0
Variable_name: Com_empty_query
Value: 0
Variable_name: Com_execute_sql
Value: 2987
Variable_name: Com_explain_other
Value: 0
Variable_name: Com_flush
Value: 1
Variable_name: Com_get_diagnostics
Value: 0
Variable_name: Com_grant
Value: 0
Variable_name: Com_ha_close
Value: 0
Variable_name: Com_ha_open
Value: 0
Variable_name: Com_ha_read
Value: 0
Variable_name: Com_help
Value: 0
Variable_name: Com_insert
Value: 257874
Variable_name: Com_insert_select
Value: 8
Variable_name: Com_install_plugin
Value: 0
Variable_name: Com_kill
Value: 0
Variable_name: Com_load
Value: 0
Variable_name: Com_lock_tables
Value: 0
Variable_name: Com_optimize
Value: 0
Variable_name: Com_preload_keys
Value: 0
Variable_name: Com_prepare_sql
Value: 2987
Variable_name: Com_purge
Value: 0
Variable_name: Com_purge_before_date
Value: 0
Variable_name: Com_release_savepoint
Value: 31226
Variable_name: Com_rename_table
Value: 0
Variable_name: Com_rename_user
Value: 0
Variable_name: Com_repair
Value: 0
Variable_name: Com_replace
Value: 146
Variable_name: Com_replace_select
Value: 0
Variable_name: Com_reset
Value: 0
Variable_name: Com_resignal
Value: 0
Variable_name: Com_revoke
Value: 0
Variable_name: Com_revoke_all
Value: 0
Variable_name: Com_rollback
Value: 437
Variable_name: Com_rollback_to_savepoint
Value: 4325
Variable_name: Com_savepoint
Value: 31226
Variable_name: Com_select
Value: 3506163
Variable_name: Com_set_option
Value: 458041
Variable_name: Com_signal
Value: 0
Variable_name: Com_show_binlog_events
Value: 0
Variable_name: Com_show_binlogs
Value: 3
Variable_name: Com_show_charsets
Value: 0
Variable_name: Com_show_collations
Value: 0
Variable_name: Com_show_create_db
Value: 0
Variable_name: Com_show_create_event
Value: 0
Variable_name: Com_show_create_func
Value: 25
Variable_name: Com_show_create_proc
Value: 100
Variable_name: Com_show_create_table
Value: 8894
Variable_name: Com_show_create_trigger
Value: 50
Variable_name: Com_show_databases
Value: 5
Variable_name: Com_show_engine_logs
Value: 0
Variable_name: Com_show_engine_mutex
Value: 0
Variable_name: Com_show_engine_status
Value: 12
Variable_name: Com_show_events
Value: 0
Variable_name: Com_show_errors
Value: 0
Variable_name: Com_show_fields
Value: 33066
Variable_name: Com_show_function_code
Value: 0
Variable_name: Com_show_function_status
Value: 25
Variable_name: Com_show_grants
Value: 3
Variable_name: Com_show_keys
Value: 11932
Variable_name: Com_show_master_status
Value: 2
Variable_name: Com_show_open_tables
Value: 0
Variable_name: Com_show_plugins
Value: 0
Variable_name: Com_show_privileges
Value: 0
Variable_name: Com_show_procedure_code
Value: 0
Variable_name: Com_show_procedure_status
Value: 25
Variable_name: Com_show_processlist
Value: 1050
Variable_name: Com_show_profile
Value: 0
Variable_name: Com_show_profiles
Value: 0
Variable_name: Com_show_relaylog_events
Value: 0
Variable_name: Com_show_slave_hosts
Value: 2
Variable_name: Com_show_slave_status
Value: 4
Variable_name: Com_show_status
Value: 301
Variable_name: Com_show_storage_engines
Value: 2
Variable_name: Com_show_table_status
Value: 4341
Variable_name: Com_show_tables
Value: 829
Variable_name: Com_show_triggers
Value: 4325
Variable_name: Com_show_variables
Value: 858
Variable_name: Com_show_warnings
Value: 25
Variable_name: Com_show_create_user
Value: 0
Variable_name: Com_shutdown
Value: 0
Variable_name: Com_slave_start
Value: 0
Variable_name: Com_slave_stop
Value: 0
Variable_name: Com_group_replication_start
Value: 0
Variable_name: Com_group_replication_stop
Value: 0
Variable_name: Com_stmt_execute
Value: 2987
Variable_name: Com_stmt_close
Value: 1221
Variable_name: Com_stmt_fetch
Value: 0
Variable_name: Com_stmt_prepare
Value: 2987
Variable_name: Com_stmt_reset
Value: 0
Variable_name: Com_stmt_send_long_data
Value: 0
Variable_name: Com_truncate
Value: 3
Variable_name: Com_uninstall_plugin
Value: 0
Variable_name: Com_unlock_tables
Value: 25
Variable_name: Com_update
Value: 597461
Variable_name: Com_update_multi
Value: 83727
Variable_name: Com_xa_commit
Value: 0
Variable_name: Com_xa_end
Value: 0
Variable_name: Com_xa_prepare
Value: 0
Variable_name: Com_xa_recover
Value: 0
Variable_name: Com_xa_rollback
Value: 0
Variable_name: Com_xa_start
Value: 0
Variable_name: Com_stmt_reprepare
Value: 0
Variable_name: Connection_errors_accept
Value: 0
Variable_name: Connection_errors_internal
Value: 0
Variable_name: Connection_errors_max_connections
Value: 0
Variable_name: Connection_errors_peer_address
Value: 0
Variable_name: Connection_errors_select
Value: 0
Variable_name: Connection_errors_tcpwrap
Value: 0
Variable_name: Connections
Value: 271987
Variable_name: Created_tmp_disk_tables
Value: 125325
Variable_name: Created_tmp_files
Value: 108
Variable_name: Created_tmp_tables
Value: 486128
Variable_name: Delayed_errors
Value: 0
Variable_name: Delayed_insert_threads
Value: 0
Variable_name: Delayed_writes
Value: 0
Variable_name: Flush_commands
Value: 1
Variable_name: Handler_commit
Value: 4426378
Variable_name: Handler_delete
Value: 182234
Variable_name: Handler_discover
Value: 0
Variable_name: Handler_external_lock
Value: 15386713
Variable_name: Handler_mrr_init
Value: 0
Variable_name: Handler_prepare
Value: 0
Variable_name: Handler_read_first
Value: 719716
Variable_name: Handler_read_key
Value: 649198790
Variable_name: Handler_read_last
Value: 3034
Variable_name: Handler_read_next
Value: 21366654693
Variable_name: Handler_read_prev
Value: 126052275
Variable_name: Handler_read_rnd
Value: 8032178
Variable_name: Handler_read_rnd_next
Value: 7538416995
Variable_name: Handler_rollback
Value: 485
Variable_name: Handler_savepoint
Value: 31221
Variable_name: Handler_savepoint_rollback
Value: 4325
Variable_name: Handler_update
Value: 65675725
Variable_name: Handler_write
Value: 1102891284
Variable_name: Innodb_buffer_pool_dump_status
Value: Dumping of buffer pool not started
Variable_name: Innodb_buffer_pool_load_status
Value: Buffer pool(s) load completed at 200211 8:00:44
Variable_name: Innodb_buffer_pool_resize_status
Value:
Variable_name: Innodb_buffer_pool_pages_data
Value: 210262
Variable_name: Innodb_buffer_pool_bytes_data
Value: 3444932608
Variable_name: Innodb_buffer_pool_pages_dirty
Value: 78
Variable_name: Innodb_buffer_pool_bytes_dirty
Value: 1277952
Variable_name: Innodb_buffer_pool_pages_flushed
Value: 1174744
Variable_name: Innodb_buffer_pool_pages_free
Value: 158364
Variable_name: Innodb_buffer_pool_pages_misc
Value: 24542
Variable_name: Innodb_buffer_pool_pages_total
Value: 393168
Variable_name: Innodb_buffer_pool_read_ahead_rnd
Value: 0
Variable_name: Innodb_buffer_pool_read_ahead
Value: 36611
Variable_name: Innodb_buffer_pool_read_ahead_evicted
Value: 0
Variable_name: Innodb_buffer_pool_read_requests
Value: 71057360988
Variable_name: Innodb_buffer_pool_reads
Value: 160396
Variable_name: Innodb_buffer_pool_wait_free
Value: 0
Variable_name: Innodb_buffer_pool_write_requests
Value: 30337522
Variable_name: Innodb_data_fsyncs
Value: 712586
Variable_name: Innodb_data_pending_fsyncs
Value: 0
Variable_name: Innodb_data_pending_reads
Value: 0
Variable_name: Innodb_data_pending_writes
Value: 0
Variable_name: Innodb_data_read
Value: 3293336064
Variable_name: Innodb_data_reads
Value: 201544
Variable_name: Innodb_data_writes
Value: 1576713
Variable_name: Innodb_data_written
Value: 39084889600
Variable_name: Innodb_dblwr_pages_written
Value: 1134661
Variable_name: Innodb_dblwr_writes
Value: 133330
Variable_name: Innodb_log_waits
Value: 0
Variable_name: Innodb_log_write_requests
Value: 2045536
Variable_name: Innodb_log_writes
Value: 237798
Variable_name: Innodb_os_log_fsyncs
Value: 264212
Variable_name: Innodb_os_log_pending_fsyncs
Value: 0
Variable_name: Innodb_os_log_pending_writes
Value: 0
Variable_name: Innodb_os_log_written
Value: 1234708992
Variable_name: Innodb_page_size
Value: 16384
Variable_name: Innodb_pages_created
Value: 9883
Variable_name: Innodb_pages_read
Value: 201004
Variable_name: Innodb_pages_written
Value: 1174744
Variable_name: Innodb_row_lock_current_waits
Value: 0
Variable_name: Innodb_row_lock_time
Value: 3327766
Variable_name: Innodb_row_lock_time_avg
Value: 885
Variable_name: Innodb_row_lock_time_max
Value: 44920
Variable_name: Innodb_row_lock_waits
Value: 3758
Variable_name: Innodb_rows_deleted
Value: 434456
Variable_name: Innodb_rows_inserted
Value: 1630676
Variable_name: Innodb_rows_read
Value: 29245681636
Variable_name: Innodb_rows_updated
Value: 717909
Variable_name: Innodb_num_open_files
Value: 531
Variable_name: Innodb_truncated_status_writes
Value: 0
Variable_name: Innodb_available_undo_logs
Value: 128
Variable_name: Key_blocks_not_flushed
Value: 0
Variable_name: Key_blocks_unused
Value: 83278
Variable_name: Key_blocks_used
Value: 81
Variable_name: Key_read_requests
Value: 403871
Variable_name: Key_reads
Value: 1109
Variable_name: Key_write_requests
Value: 743
Variable_name: Key_writes
Value: 742
Variable_name: Locked_connects
Value: 0
Variable_name: Max_execution_time_exceeded
Value: 0
Variable_name: Max_execution_time_set
Value: 0
Variable_name: Max_execution_time_set_failed
Value: 0
Variable_name: Max_used_connections
Value: 64
Variable_name: Max_used_connections_time
Value: 2020-02-11 21:16:07
Variable_name: Not_flushed_delayed_rows
Value: 0
Variable_name: Ongoing_anonymous_transaction_count
Value: 0
Variable_name: Open_files
Value: 59
Variable_name: Open_streams
Value: 0
Variable_name: Open_table_definitions
Value: 1245
Variable_name: Open_tables
Value: 2048
Variable_name: Opened_files
Value: 3282
Variable_name: Opened_table_definitions
Value: 1248
Variable_name: Opened_tables
Value: 85784
Variable_name: Performance_schema_accounts_lost
Value: 0
Variable_name: Performance_schema_cond_classes_lost
Value: 0
Variable_name: Performance_schema_cond_instances_lost
Value: 0
Variable_name: Performance_schema_digest_lost
Value: 0
Variable_name: Performance_schema_file_classes_lost
Value: 0
Variable_name: Performance_schema_file_handles_lost
Value: 0
Variable_name: Performance_schema_file_instances_lost
Value: 0
Variable_name: Performance_schema_hosts_lost
Value: 0
Variable_name: Performance_schema_index_stat_lost
Value: 0
Variable_name: Performance_schema_locker_lost
Value: 0
Variable_name: Performance_schema_memory_classes_lost
Value: 0
Variable_name: Performance_schema_metadata_lock_lost
Value: 0
Variable_name: Performance_schema_mutex_classes_lost
Value: 0
Variable_name: Performance_schema_mutex_instances_lost
Value: 0
Variable_name: Performance_schema_nested_statement_lost
Value: 0
Variable_name: Performance_schema_prepared_statements_lost
Value: 0
Variable_name: Performance_schema_program_lost
Value: 0
Variable_name: Performance_schema_rwlock_classes_lost
Value: 0
Variable_name: Performance_schema_rwlock_instances_lost
Value: 0
Variable_name: Performance_schema_session_connect_attrs_lost
Value: 0
Variable_name: Performance_schema_socket_classes_lost
Value: 0
Variable_name: Performance_schema_socket_instances_lost
Value: 0
Variable_name: Performance_schema_stage_classes_lost
Value: 0
Variable_name: Performance_schema_statement_classes_lost
Value: 0
Variable_name: Performance_schema_table_handles_lost
Value: 0
Variable_name: Performance_schema_table_instances_lost
Value: 0
Variable_name: Performance_schema_table_lock_stat_lost
Value: 0
Variable_name: Performance_schema_thread_classes_lost
Value: 0
Variable_name: Performance_schema_thread_instances_lost
Value: 0
Variable_name: Performance_schema_users_lost
Value: 0
Variable_name: Prepared_stmt_count
Value: 0
Variable_name: Qcache_free_blocks
Value: 0
Variable_name: Qcache_free_memory
Value: 0
Variable_name: Qcache_hits
Value: 0
Variable_name: Qcache_inserts
Value: 0
Variable_name: Qcache_lowmem_prunes
Value: 0
Variable_name: Qcache_not_cached
Value: 0
Variable_name: Qcache_queries_in_cache
Value: 0
Variable_name: Qcache_total_blocks
Value: 0
Variable_name: Queries
Value: 5828848
Variable_name: Questions
Value: 5643578
Variable_name: Select_full_join
Value: 32679
Variable_name: Select_full_range_join
Value: 3886
Variable_name: Select_range
Value: 303870
Variable_name: Select_range_check
Value: 0
Variable_name: Select_scan
Value: 669187
Variable_name: Slave_open_temp_tables
Value: 0
Variable_name: Slow_launch_threads
Value: 0
Variable_name: Slow_queries
Value: 0
Variable_name: Sort_merge_passes
Value: 79
Variable_name: Sort_range
Value: 57581
Variable_name: Sort_rows
Value: 11093329
Variable_name: Sort_scan
Value: 251999
Variable_name: Ssl_accept_renegotiates
Value: 0
Variable_name: Ssl_accepts
Value: 0
Variable_name: Ssl_callback_cache_hits
Value: 0
Variable_name: Ssl_cipher
Value:
Variable_name: Ssl_cipher_list
Value:
Variable_name: Ssl_client_connects
Value: 0
Variable_name: Ssl_connect_renegotiates
Value: 0
Variable_name: Ssl_ctx_verify_depth
Value: 18446744073709551615
Variable_name: Ssl_ctx_verify_mode
Value: 5
Variable_name: Ssl_default_timeout
Value: 0
Variable_name: Ssl_finished_accepts
Value: 0
Variable_name: Ssl_finished_connects
Value: 0
Variable_name: Ssl_server_not_after
Value: Feb 8 08:00:26 2030 GMT
Variable_name: Ssl_server_not_before
Value: Feb 11 08:00:26 2020 GMT
Variable_name: Ssl_session_cache_hits
Value: 0
Variable_name: Ssl_session_cache_misses
Value: 0
Variable_name: Ssl_session_cache_mode
Value: SERVER
Variable_name: Ssl_session_cache_overflows
Value: 0
Variable_name: Ssl_session_cache_size
Value: 128
Variable_name: Ssl_session_cache_timeouts
Value: 0
Variable_name: Ssl_sessions_reused
Value: 0
Variable_name: Ssl_used_session_cache_entries
Value: 0
Variable_name: Ssl_verify_depth
Value: 0
Variable_name: Ssl_verify_mode
Value: 0
Variable_name: Ssl_version
Value:
Variable_name: Table_locks_immediate
Value: 283282
Variable_name: Table_locks_waited
Value: 264
Variable_name: Table_open_cache_hits
Value: 7704815
Variable_name: Table_open_cache_misses
Value: 85784
Variable_name: Table_open_cache_overflows
Value: 83727
Variable_name: Tc_log_max_pages_used
Value: 0
Variable_name: Tc_log_page_size
Value: 0
Variable_name: Tc_log_page_waits
Value: 0
Variable_name: Threads_cached
Value: 48
Variable_name: Threads_connected
Value: 2
Variable_name: Threads_created
Value: 64
Variable_name: Threads_running
Value: 2
Variable_name: Uptime
Value: 87645
Variable_name: Uptime_since_flush_status
Value: 87645


+--------+---------+---------+---------+
| engine | data | indexes | total |
+--------+---------+---------+---------+
| InnoDB | 2.99 GB | 1.84 GB | 4.82 GB |
| MyISAM | 0.12 GB | 0.04 GB | 0.16 GB |
| CSV | 0.00 GB | 0.00 GB | 0.00 GB |
| MEMORY | 0.00 GB | 0.00 GB | 0.00 GB |
| TOTALS | 3.10 GB | 1.88 GB | 4.98 GB |
+--------+---------+---------+---------+
5 rows in set (0.27 sec)


show variables

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

Options: ReplyQuote


Subject
Views
Written By
Posted
High memory used by MySQL
1217
February 12, 2020 02:45AM
821
February 12, 2020 11:41AM
655
February 13, 2020 09:24AM
676
February 13, 2020 11:49AM
658
February 14, 2020 09:05AM
569
February 14, 2020 11:06AM
646
March 02, 2020 04:12AM
546
March 02, 2020 04:17PM
440
March 02, 2020 08:35PM
506
March 02, 2020 08:36PM
594
March 03, 2020 06:12AM
499
March 03, 2020 11:51AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.