发个kloxo的my.cnf优化--高手绕行

amo

[mysqld]
skip-locking
skip-bdb
skip-innodb
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1

# To allow mysqld to connect to a MySQL Cluster management daemon, uncomment
# these lines and adjust the connectstring as needed.
#ndbcluster
#ndb-connectstring="nodeid=4;host=localhost:1186"

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

[ndbd]
# If you are running a MySQL Cluster storage daemon (ndbd) on this machine,
# adjust its connection to the management daemon here.
# Note: ndbd init script requires this to include nodeid!
connect-string="nodeid=2;host=localhost:1186"

[ndb_mgm]
# connection string for MySQL Cluster management tool
connect-string="host=localhost:1186"

[ 本帖最后由 amo 于 2010-12-22 00:01 编辑 ]

cnweb

有自带优化的 呵呵

xspoco

lnmp路过

信仰

还发~skip-locking
skip-bdb
skip-innodb

咱就是因为多加了这个三行代码数据库就启动不了现在不优化了还是稳定的好~

walkman660

原帖由 信仰 于 2010-12-22 00:20 发表
还发~skip-locking
skip-bdb
skip-innodb

咱就是因为多加了这个三行代码数据库就启动不了现在不优化了还是稳定的好~

看你的mysql是那个版本了，最新的5.1.50稳定版会报错
应该使用
skip-external-locking
loose-skip-innodb
另外skip-bdb被废除了
注：以上仅限5.1.50稳定版或以上版本。之前的版本仍旧适用

卡恩

Poison

马甲

5.1以后  就不要 skip-bdb