[mysqld]datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock user=mysql#innodb settings innodb_log_file_size=100M innodb_additional_mem_pool_size=20M innodb_flush_log_at_trx_commit=2 innodb_lock_wait_timeout=1800 innodb_buffer_pool_size=20G#other vars net_read_timeout=120skip-locking skip-name-resolve table_cache=2048thread_cache_size=16 back_log=100max_connect_errors=10000 open-files-limit=20000interactive_timeout=3600wait_timeout=1800max_connections=200key_buffer_size=1Gconnect_timeout=120#skip-name-resolve max_allowed_packet=16Mtmp_table_size=64Mmax_heap_table_size=64Mquery_cache_size=256Msort_buffer_size=1Mread_buffer_size=1Mread_rnd_buffer_size=8Mjoin_buffer_size=3Mold_passwords=1Đối với vps Centos