[mysqld] ## File Location datadir = /var/lib/mysql pid_file = /var/run/mysqld/mysqld.pid log_error = /var/log/mysqld.log slow_query_log_file = /var/log/slow.log socket = /var/lib/mysql/mysql.sock ## Basic Setup user = mysql explicit_defaults_for_timestamp = true ## InnoDB default-storage-engine = InnoDB innodb_file_per_table = ON innodb_buffer_pool_size = 6G innodb_log_buffer_size = 8M innodb_log_file_size = 1G innodb_log_files_in_group = 2 # Slow SQL Check slow_query_log = 0 log_output = FILE long_query_time = 30 log_queries_not_using_indexes = 0