­ ­ ­ ­ ­ ­ ­ ­ ­ ­ ­ ­ ­ ­ ­ ­ ­ ­ [mysql] port = 3306 socket = /var/lib/mysql/mysql.sock [mysqld] disable-log-bin=1 default-authentication-plugin=mysql_native_password # Required Settings basedir = /usr/ bind_address = * datadir = /var/lib/mysql/ max_allowed_packet = 256M max_connect_errors = 1000000 port = 3306 skip_external_locking socket = /var/lib/mysql/mysql.sock tmpdir = /tmp user = mysql performance_schema = 0 sql_mode = "" # InnoDB Settings default_storage_engine = InnoDB innodb_buffer_pool_instances = 1 innodb_buffer_pool_size = 1G innodb_file_per_table = 1 innodb_flush_method = O_DIRECT innodb_log_buffer_size = 16M innodb_log_files_in_group = 2 innodb_stats_on_metadata = 0 #innodb_thread_concurrency = 15 innodb_read_io_threads = 4 innodb_write_io_threads = 4 # MyISAM Settings # query_cache_limit = 4M # query_cache_size = 128M # query_cache_type = 1 low_priority_updates = 1 concurrent_insert = 2 # Connection Settings max_connections = 500 # Buffer Settings join_buffer_size = 64M read_buffer_size = 32M read_rnd_buffer_size = 64M sort_buffer_size = 64M open_files_limit=40000 # Search Settings ft_min_word_len = 4 # Logging log_error = /var/lib/mysql/mysql_error.log long_query_time = 3 slow_query_log = 1 slow_query_log_file = /var/lib/mysql/mysql_slow.log mysqlx=0