Home
News
Forum
Wiki
Blog
Contents
Gallery
Movies
Downloads
About NSL
If you want to see English page, please click "English" Button at Left.
[
タイトル一覧
|
ページ一覧
|
新規
|
単語検索
|
最終更新
|
ヘルプ
]
MySQL/MySQL5
をテンプレートにして作成
[
トップ
]
[ ]
開始行:
** MySQL5
*** CentOS6/7
**** Install (5.6)
yum -y install http://dev.mysql.com/get/mysql-community-...
yum -y install mysql mysql-devel mysql-server mysql-util...
mysql --version
#br
*** Setting
- 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
#br
終了行:
** MySQL5
*** CentOS6/7
**** Install (5.6)
yum -y install http://dev.mysql.com/get/mysql-community-...
yum -y install mysql mysql-devel mysql-server mysql-util...
mysql --version
#br
*** Setting
- 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
#br
ページ名:
サイト内 検索
高度な検索
ログイン
ユーザー名:
パスワード:
パスワード紛失
新規登録
サブ メニュー
新着情報
Books
リンク
サイトマップ
e-Learning
TUIS 認証局証明書
ミニカレンダー
2025年 5月
日
月
火
水
木
金
土
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
<今日>
オンライン状況
104 人のユーザが現在オンラインです。 (4 人のユーザが xpwiki を参照しています。)
登録ユーザ: 0
ゲスト: 104
もっと...
アクセスカウンタ
今日 :
昨日 :
総計 :
Powered by XOOPS Cube 2.1© 2001-2006
XOOPS Cube Project
Design by
XoopsDesign.com