パラメータ内容†これだけは最低限記述しておいて、あとからサーバーごとに調整しようっていう値。 # cd /etc/ # cp -p my.cnf mysql.org # vim my.cnf [mysqld] skip-character-set-client-handshake character-set-server=utf8 collation-server = utf8_general_ci init-connect = SET NAMES utf8 # common max_connections = 1000 interactive_timeout = 3600 lock_wait_timeout = 3600 wait_timeout = 3600 # MyISAM key_buffer_size=8M thread_cache_size=16 query_cache_limit=5M query_cache_min_res_unit=4k query_cache_size=8M query_cache_type=1 sort_buffer_size=8M read_buffer_size=8M join_buffer_size=8M read_rnd_buffer_size=8M # InnoDB innodb_buffer_pool_size=1024M innodb_additional_mem_pool_size=16M innodb_log_file_size=512M innodb_log_buffer_size=16M innodb_file_per_table = 1 [client] default-character-set=utf8 |