![[PukiWiki]](image/pukiwiki.png "[PukiWiki]")
#author("2025-04-15T04:45:30+00:00","default:iseki","iseki") #author("2025-04-15T04:45:36+00:00","default:iseki","iseki") ** MySQL5 [#p2e315da] *** CentOS6/7 [#w10cbc9c] **** [[MySQL5.5>./MySQL5.5]] **** MySQL-5.6 [#f339cb0b] **** MySQL5.6 [#f339cb0b] yum -y install http://dev.mysql.com/get/mysql-community-release-el6-5.noarch.rpm yum -y install mysql mysql-devel mysql-server mysql-utilities mysql --version *** Setting [#haf396b3] - my.cnf [client] default-character-set = utf8mb4 [mysql] default-character-set = utf8mb4 [mysqld] #innodb_force_recovery = 0 # 0 -6 #datadir=/var/lib/mysql #socket=/var/lib/mysql/mysql.sock user=mysql # skip-external-locking #key_buffer_size = 16M key_buffer_size = 48M max_allowed_packet = 64M innodb_log_file_size=64M #table_open_cache = 64 sort_buffer_size = 512K net_buffer_length = 8K read_buffer_size = 256K read_rnd_buffer_size = 512K myisam_sort_buffer_size = 8M # tmp_table_size = 8M # # Disabling symbolic-links is recommended to prevent assorted security risks symbolic-links=0 # #slow query slow_query_log slow_query_log-file=/var/log/mysql/slow.log long_query_time=5 # max_connections=1024 table_open_cache=4096 # query_cache_size=48M query_cache_min_res_unit=2k # #log=/var/log/mysql/query.log #general_log_file=/var/log/mysql/query.log # #log-bin=mysql-bin #expire_logs_days=30 # log-error=/var/log/mysql/mysqld.log log-warnings=1 #default-character-set=utf8 #character-set-server=utf8 character-set-server = utf8mb4 skip-character-set-client-handshake innodb_large_prefix=on default-storage-engine=innodb #collation-server = utf8_general_ci collation-server = utf8mb4_unicode_ci # innodb_file_format = Barracuda innodb_file_per_table = 1 innodb_large_prefix [mysqld_safe] pid-file=/var/run/mysqld/mysqld.pid wait_timeout=604800 default-character-set=utf8 skip-character-set-client-handshake
