[mysqld] pid-file = /var/run/mysqld/mysqld.pid socket = /var/run/mysqld/mysqld.sock log-error = /var/log/mysql/error.log datadir = /home/mysql/ innodb_file_per_table default-authentication-plugin = mysql_native_password character_set_server = utf8mb4 collation_server = utf8mb4_general_ci init-connect = 'SET NAMES utf8mb4' ;slow_query_log = 1 ;slow_query_log_file = /var/log/mysql/slow.log ;long_query_time = 2 thread_cache_size = 32 table_open_cache = 2048 sort_buffer_size = 8M innodb = force ;innodb_buffer_pool_size = 1G innodb_buffer_pool_size = 512M innodb_log_file_size = 1GB innodb_stats_on_metadata = OFF innodb_buffer_pool_instances = 8 innodb_log_buffer_size = 10M innodb_flush_log_at_trx_commit = 2 innodb_thread_concurrency = 6 join_buffer_size = 8M tmp_table_size = 128M key_buffer_size = 128M max_allowed_packet = 64M max_heap_table_size = 128M read_rnd_buffer_size = 16M read_buffer_size = 2M bulk_insert_buffer_size = 64M max_connections = 512 myisam_sort_buffer_size = 128M explicit_defaults_for_timestamp = 1 open_files_limit = 65535 table_definition_cache = 1024 table_open_cache = 2048 log_bin_trust_function_creators = 1 disable_log_bin [mysqldump] set-gtid-purged=OFF [client] ssl-mode=DISABLED