Sample my.cnf

manager Tue, 04/21/2009 - 16:21

Here are the contents of my my.cnf:

# more /etc/my.cnf
[mysqld]
datadir=/mysql/data
socket=/var/lib/mysql/mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
bind-address =  10.52.1.117
ft_min_word_len=3
# Tuning parameters
tmp_table_size=64M
max_heap_table_size=64M
table_cache=512
set-variable=max_connections=300
wait_timeout=7800
query_cache_size = 8388608
thread_cache_size = 4
join_buffer_size = 128K

[myisamchk]
ft_min_word_len=3
rd_len=3
    
[mysql.server]
user=mysql
basedir=/var/lib

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

Subject

MySQL