自宅サーバーに関する設定やTips置き場。

2008年11月9日日曜日

DB Server / MySQL

# cat /var/db/mysql/my.cnf


[client]
port = 3306
socket = /tmp/mysql.sock
sl-ca=/usr/local/etc/ssl/server.csr
ssl-cert=/usr/local/etc/ssl/server.crt
ssl-key=/usr/local/etc/ssl/server.key
default-character-set = utf8
[mysqld]
port = 3306
socket = /tmp/mysql.sock
skip-locking
key_buffer = 256M
max_allowed_packet = 1M
table_cache = 256
sort_buffer_size = 1M
read_buffer_size = 1M
read_rnd_buffer_size = 4M
myisam_sort_buffer_size = 64M
thread_cache_size = 8
query_cache_size= 16M
thread_concurrency = 8
ssl-ca=/usr/local/etc/ssl/server.csr
ssl-cert=/usr/local/etc/ssl/server.crt
ssl-key=/usr/local/etc/ssl/server.key
default-character-set = utf8
log-bin
expire_logs_days=7
server-id = 1
[mysqldump]
quick
max_allowed_packet = 16M
[mysql]
no-auto-rehash
default-character-set = utf8
[isamchk]
key_buffer = 128M
sort_buffer_size = 128M
read_buffer = 2M
write_buffer = 2M
[myisamchk]
key_buffer = 128M
sort_buffer_size = 128M
read_buffer = 2M
write_buffer = 2M
[mysqlhotcopy]
interactive-timeout

0 件のコメント:

マイブログ リスト

フォロワー

Blogger Syntax Highliter