時間:2015/6/28來源:IT貓撲網(wǎng)作者:網(wǎng)管聯(lián)盟我要評論(0)
mysql性能調整之my.cnf文件的配置方法:
[mysqld]
datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock skip-locking set-variable = key_buffer=16M set-variable = max_allowed_packet=1M set-variable = thread_stack=64K set-variable = record_buffer=1M set-variable = table_cache=1024 set-variable = sort_buffer=4M set-variable = net_buffer_length=8K set-variable = max_connect_errors=100 set-variable = max_connections=1024 server-id = 1 |
quick set-variable = max_allowed_packet=16M |
no-auto-rehash # Remove the next comment character if you are not familiar with SQL #safe-updates |
set-variable = key_buffer=20M set-variable = sort_buffer=20M |
set-variable = key_buffer=20M set-variable = sort_buffer=20M |
interactive-timeout |
user=mysql basedir=/var/lib |
err-log=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid |
關鍵詞標簽:配置,方法,文件,性能,
相關閱讀
熱門文章 10款MySQL數(shù)據(jù)庫客戶端圖形界面管理工具推薦MySQL常用維護管理工具Linux VPS/服務器上輕松導入、導出MySQL數(shù)據(jù)MySQL復制的概述、安裝、故障、技巧、工具
人氣排行 MySQL數(shù)據(jù)庫啟動失敗1067進程意外終止的解決辦法總結Mysql 1045錯誤解決辦法10款MySQL數(shù)據(jù)庫客戶端圖形界面管理工具推薦MySQL服務器進程CPU占用100%解決辦法MySQL導出導入命令的用例MySQL無法啟動、無法停止各種解決方法總結三種常用的MySQL建表語句Mysql清空表的實現(xiàn)方法