[mysqld] datadir = /var/lib/mysql socket = /var/lib/mysql/mysql.sock log_error = /var/log/mysqld.log symbolic-links = 0 performance-schema = ON local-infile = 0 sql_mode = NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION default-storage-engine = InnoDB external-locking = FALSE max_connections = 300 max_user_connections = 30 max_allowed_packet = 1G key_buffer_size = 512M table_open_cache = 50000 table_definition_cache = 50000 open_files_limit = 100000 tmp_table_size = 128M max_heap_table_size = 128M innodb_buffer_pool_size = 32G innodb_buffer_pool_instances = 16 innodb_log_file_size = 8G innodb_log_buffer_size = 256M innodb_file_per_table = 1 wait_timeout = 900 interactive_timeout = 900 [mysqld_safe] !includedir /etc/my.cnf.d