[client] port = 3306 socket = /var/run/mysqld/mysqld.sock [mysqld_safe] socket = /var/run/mysqld/mysqld.sock nice = 0 [isamchk] key_buffer = 16M [mysql] no-auto-rehash [mysqldump] quick quote-names max_allowed_packet = 32M [mysqld] user = mysql pid-file = /var/run/mysqld/mysqld.pid socket = /var/run/mysqld/mysqld.sock port = 3306 basedir = /usr datadir = /srv/data/mysql tmpdir = /srv/temp lc_messages_dir = /usr/share/mysql lc_messages = en_US #skip_grant_tables = true skip-external-locking skip-name-resolve innodb_file_per_table = 1 wait_timeout = 300 interactive_timeout = 300 # * Fine Tuning max_connections = 100 connect_timeout = 10 wait_timeout = 600 max_allowed_packet = 32M thread_stack = 192K thread_cache_size = 16 thread_concurrency = 16 sort_buffer_size = 4M bulk_insert_buffer_size = 16M tmp_table_size = 4G max_heap_table_size = 4G join_buffer_size = 2G sort_buffer_size = 2G # * MyISAM myisam_recover = BACKUP key_buffer_size = 128M open-files-limit = 4096 table_open_cache = 500 myisam_sort_buffer_size = 512M concurrent_insert = 2 read_buffer_size = 2M read_rnd_buffer_size = 1M # * Query Cache Configuration query_cache_limit = 128K query_cache_size = 0 query_cache_type = OFF # * Logging and Replication #general_log_file = /var/log/mysql/mysql.log #general_log = 1 log_warnings = 2 #slow_query_log[={0|1}] slow_query_log_file = /srv/temp/mariadb-slow.log long_query_time = 10 #log_slow_rate_limit = 1000 log_slow_verbosity = query_plan #log-queries-not-using-indexes #log_slow_admin_statements server-id = 1093 report_host = sql-edi1400 #auto_increment_increment = 2 #auto_increment_offset = 1 log_bin = /srv/temp/mariadb-bin log_bin_index = /srv/temp/mariadb-bin.index # not fab for performance, but safer sync_binlog = 1 expire_logs_days = 5 max_binlog_size = 200M binlog_format = MIXED slave-compressed-protocol = 1 #sql_mode = NO_ENGINE_SUBSTITUTION,TRADITIONAL # * InnoDB default_storage_engine = InnoDB # you can't just change log file size, requires special procedure #innodb_log_file_size = 50M innodb_log_file_size = 256M innodb_buffer_pool_size = 7G innodb_log_buffer_size = 16M innodb_open_files = 400 innodb_io_capacity = 400 innodb_flush_method = O_DIRECT innodb_additional_mem_pool_size = 20M !includedir /etc/mysql/conf.d/