my.cnf/my.ini ファイル

MySQL

メモリ1GBのMySQLのサンプル

[mysqld]
datadir=/var/lib/mysql
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
default-character-set=utf8
init-connect=SET NAMES utf8
max_allowed_packet=100M
max_connections=300
#log_slow_queries
#long_query_time = 1
innodb_buffer_pool_size=512M
innodb_log_file_size=128M
#log-bin
query_cache_limit=8M
query_cache_size=64M
set-variable = key_buffer=256M
set-variable = table_cache=128
set-variable = sort_buffer=32M


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

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

[client] 
default-character-set=utf8

[mysql]
default-character-set=utf8