いつも使うmy.cnf

my.cnf

[client]
default-character-set=utf8

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
log-slow-queries=mysql_slow.log
long_query_time=1
log-queries-not-using-indexes
innodb_buffer_pool_size=512M
#innodb_log_file_size=128M
innodb_log_buffer_size=16M
innodb_additional_mem_pool_size=20M
sort_buffer_size=4M
read_rnd_buffer_size=2M
join_buffer_size=256K
read_buffer_size=1M
key_buffer_size=256M
myisam_sort_buffer_size=1M
default-character-set = utf8
skip-character-set-client-handshake
character-set-server = utf8
collation-server = utf8_general_ci
init-connect = SET NAMES utf8
sql-mode=TRADITIONAL


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