MySQL設定

[mysqld]
default-character-set=utf8
innodb_data_file_path=ibdata:100M:autoextend
#  default-table-type=InnoDB
# err-log=/var/log/mysqld.log
set-variable = long_query_time=10

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 = 8
query_cache_size= 16M
# Try number of CPU's*2 for thread_concurrency
thread_concurrency = 8

#Don't allow new user creation by the user who has no write privileges to the mysql.user table.
safe-user-create

#Enable this option only if you would like to use InnoDB tables.
skip-innodb

[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

[mysql.server]
user=mysql
basedir=/var/lib

[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

とりあえず、ISAMしか使ってません。innodbを使おうとしたけどなんか遅かったし。

DBはjava経由のアクセスが前堤なのでUTF8にしてます。

http://www.wings.msn.to/contents/env/jsp/mysql_lin.html

http://www.nslabs.jp/mysql.rhtml