1: 2019-08-17 (土) 19:39:19 iseki  |
現: 2019-08-17 (土) 19:45:01 iseki |
| - | * MySQL5 [#p2e315da] | + | ** MySQL5 [#p2e315da] |
| - | ** CentOS6/7 [#w10cbc9c] | + | |
| - | *** Install (5.6) [#f339cb0b] | + | *** CentOS6/7 [#w10cbc9c] |
| | + | |
| | + | **** Install (5.6) [#f339cb0b] |
| | yum -y install http://dev.mysql.com/get/mysql-community-release-el6-5.noarch.rpm | | 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 | | yum -y install mysql mysql-devel mysql-server mysql-utilities |
| | mysql --version | | mysql --version |
| | + | #br |
| | + | |
| | + | *** 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 |
| | + | |
| | #br | | #br |
