MySql Sample my.cnf File

November 27, 2006 / General Discussion

[client]port=3306socket=/var/lib/mysql/mysql.sock[mysqld]port=3306datadir=/var/lib/mysqlsocket=/var/lib/mysql/mysql.sockskip-lockingskip-innodbquery_cache_limit=1Mquery_cache_size=32Mquery_cache_type=1max_connections=500interactive_timeout=100wait_timeout=14400connect_timeout=10thread_cache_size=128key_buffer=150Mjoin_buffer=1Mmax_allowed_packet=16Mtable_cache=1500record_buffer=1Msort_buffer_size=1Mread_buffer_size=1Mread_rnd_buffer_size=768Kmax_connect_errors=10thread_concurrency=4myisam_sort_buffer_size=64Mlog-binserver-id=1[mysql.server]user=mysqlbasedir=/var/lib [safe_mysqld]err-log=/var/log/mysqld.logpid-file=/var/lib/mysql/********.pid [NOTE : here it should be server hostname]open_files_limit=8192 [mysqldump]quickmax_allowed_packet=16M [mysql]no-auto-rehash [isamchk]key_buffer=64Msort_buffer=64Mread_buffer=16Mwrite_buffer=16M [myisamchk]key_buffer=64Msort_buffer=64Mread_buffer=16Mwrite_buffer=16M [mysqlhotcopy]interactive-timeout