MySQL/MySQL5
をテンプレートにして作成
[
トップ
] [
タイトル一覧
|
ページ一覧
|
新規
|
検索
|
最終更新
|
ヘルプ
|
ログイン
]
開始行:
** MySQL5 [#p2e315da]
*** CentOS6/7 [#w10cbc9c]
**** [[MySQL5.5>./MySQL5.5]]
**** MySQL5.6 [#f339cb0b]
yum -y install http://dev.mysql.com/get/mysql-community-...
yum -y install mysql mysql-devel mysql-server mysql-util...
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 ass...
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
終了行:
** MySQL5 [#p2e315da]
*** CentOS6/7 [#w10cbc9c]
**** [[MySQL5.5>./MySQL5.5]]
**** MySQL5.6 [#f339cb0b]
yum -y install http://dev.mysql.com/get/mysql-community-...
yum -y install mysql mysql-devel mysql-server mysql-util...
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 ass...
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
ページ名:
![[PukiWiki]](image/pukiwiki.png "[PukiWiki]")
