[server] datadir=/data/mysql socket=/data/mysql/mysql.sock # this is only for the mysqld standalone daemon [mysqld] innodb_flush_log_at_trx_commit = 1 innodb_buffer_pool_size = 10G innodb_log_file_size = 2G expire_logs_days = 10 max_connections = 300 tmp_table_size=256M max_heap_table_size=256M performance_schema=ON