[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
自宅サーバーに関する設定やTips置き場。
2008年11月9日日曜日
DB Server / MySQL
# cat /var/db/mysql/my.cnf
登録:
コメントの投稿 (Atom)
ブログ アーカイブ
-
▼
2008
(23)
-
▼
11月
(23)
- FTP Server / proftpd.conf (SSL/TLS + MySQL)
- DNS Server / .zone
- DNS Server / rndc.conf
- DNS Server / named.conf
- Proxy Server / squid.conf
- Proxy Server / hosts
- Proxy Server / resolv.conf
- Proxy Server / rc.conf
- Server / OpenSSH
- Firewall Server / PF
- Server / rc.conf
- Server / resolv.conf
- Server / hosts
- Server / make.conf
- DB Server / MySQL
- Server / pkgtools.conf
- Ftp Server / ProFTPD
- Mail Server / dovecot-sql.conf
- Mail Server / dovecot.conf
- Mail Server / main.cf
- Mail Server / master.cf
- Web Server / httpd.conf
- コメント行を削除
-
▼
11月
(23)
0 件のコメント:
コメントを投稿