# # This group is read both by the client and the server # use it for options that affect everything # [client-server] # # include *.cnf from the config directory # !includedir /etc/my.cnf.d [mysqld] log-error=/var/lib/mysql/peridot.daxa.net.err performance-schema=0 skip-external-locking max_allowed_packet=268435456 # Connection limits max_connections = 1000 max_user_connections = 50 wait_timeout = 300 interactive_timeout = 300 # Threading open_files_limit = 39000 # InnoDB Settings innodb_buffer_pool_size = 64G innodb_log_file_size = 1G innodb_log_buffer_size = 256M innodb_flush_log_at_trx_commit = 2 innodb_thread_concurrency = 16 innodb_file_per_table = 1 innodb_open_files = 65535 innodb_io_capacity = 1000 unix_socket=OFF sql-mode="" init_connect='SET SESSION sql_mode=""'