mysql伺服器最佳化設定檔

標籤：

[mysqld]datadir=/var/lib/mysqlsocket=/var/lib/mysql/mysql.sockuser=mysql# Disabling symbolic-links is recommended to prevent assorted security riskssymbolic-links=0[mysqld_safe]log-error=/var/log/mysqld.logpid-file=/var/run/mysqld/mysqld.pidback_log=600max_connections=3000max_connect_errors=6000table_cache=614external-locking=FALSEmax_allowed_packet=32Msort_buffer_size=2Mjoin_buffer_size=2Mthread_cache_size=300thread_concurrency=8query_cache_size=64Mquery_cache_limit=4Mquery_cache_min_res_unit=2kthread_stack=192Ktransaction_isolation=READ-COMMITTEDtmp_table_size=256Mmax_heap_table_size=256Mlong_query_time=2expire_logs_days=7key_buffer_size=2048Mread_buffer_size=1Mread_rnd_buffer_size=16Mbulk_insert_buffer_size=64Minnodb_additional_mem_pool_size=16Minnodb_buffer_pool_size=2048Minnodb_data_file_path=ibdata1:1024M:autoextendinnodb_file_io_threads=4innodb_thread_concurrency=8innodb_flush_log_at_trx_commit=2innodb_log_file_size=128Minnodb_log_files_in_group=3innodb_max_dirty_pages_pct=90innodb_lock_wait_timeout=120innodb_file_per_table=0

View Code

 

mysql伺服器最佳化設定檔