请问my.cnf问题

SUNShineQQ

请问数据库数据目录下的my.cnf 和/etc/my.cnf有什么区别，都是干什么用的？

在freebsd下没有/etc/my.cnf文件，我要重定位数据库应该怎么办？应该注意哪些问题？？？

seacaptain

数据库目录里的my.cnf里的设置会覆盖/etc/my.cnf里的设置，优先级不同

yejr

[quote]原帖由 "seacaptain"]数据库目录里的my.cnf里的设置会覆盖/etc/my.cnf里的设置，优先级不同[/quote 发表：


/etc/my.cnf 是全局性的mysql设置
/data_dir/my.cnf是针对具体的某个数据库的特殊设置
~/.my.cnf是针对某个登陆用户的特殊设置

aloneflasher

楼上厉害,又学了一着

netocool

厉害
my.cnf里面各个选项有什么用呢?
# The following options will be passed to all MySQL clients
[client]
#password       = your_password
port            = 3306
socket          = /tmp/mysql.sock

# Here follows entries for some specific programs

# The MySQL server
[mysqld]
port            = 3306
socket          = /tmp/mysql.sock
skip-locking
set-variable    = key_buffer=16M
set-variable    = max_allowed_packet=1M
set-variable    = table_cache=64
set-variable    = sort_buffer=512K
set-variable    = net_buffer_length=8K
set-variable    = myisam_sort_buffer_size=8M
log-bin
server-id       = 1

# Point the following paths to different dedicated disks
#tmpdir         = /tmp/
#log-update     = /path-to-dedicated-directory/hostname

# Uncomment the following if you are using BDB tables
#set-variable   = bdb_cache_size=4M
#set-variable   = bdb_max_lock=10000

# Uncomment the following if you are using InnoDB tables
#innodb_data_home_dir = /usr/local/mysql/var/
#innodb_data_file_path = ibdata1:10M:autoextend
#innodb_log_group_home_dir = /usr/local/mysql/var/
#innodb_log_arch_dir = /usr/local/mysql/var/
# You can set .._buffer_pool_size up to 50 - 80 %
# of RAM but beware of setting memory usage too high
#set-variable = innodb_buffer_pool_size=16M
#set-variable = innodb_additional_mem_pool_size=2M
# Set .._log_file_size to 25 % of buffer pool size
#set-variable = innodb_log_file_size=5M
#set-variable = innodb_log_buffer_size=8M
#innodb_flush_log_at_trx_commit=1
#set-variable = innodb_lock_wait_timeout=50

[mysqldump]
quick
set-variable    = max_allowed_packet=16M

[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates

[isamchk]
set-variable    = key_buffer=20M
set-variable    = sort_buffer=20M
set-variable    = read_buffer=2M
set-variable    = write_buffer=2M

[myisamchk]
set-variable    = key_buffer=20M
set-variable    = sort_buffer=20M
set-variable    = read_buffer=2M
set-variable    = write_buffer=2M

[mysqlhotcopy]
interactive-timeout

send_linux

厉害
my.cnf里面各个选项有什么用呢?
# The following options will be passed to all MySQL clients
[c ...
netocool 发表于 2004-08-26 17:20

    现在都发现，这个东西有用啊

renxiao2003

都是一样的。只是根据启动程序的搜索顺序，先搜索到哪个就使用哪个啊。