Home
News
Forum
Wiki
Blog
Contents
Gallery
Movies
Downloads
About NSL
[
List of Titles
|
List of Pages
|
New
|
Search
|
Recent changes
|
Help
]
MySQL/MySQL5
[
Front page
]
[ ]
Start:
** 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
End:
** 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
Page:
Site Search
Advanced Search
Login
Username:
Password:
Lost Password?
Register now!!
Sub Menu
New Arrivals
Books
Web Links
Site Map
e-Learning
TUIS Certificate
mini Calendar
May 2025
Su
Mo
Tu
We
Th
Fr
Sa
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
Today
Who's Online
77 user(s) are online (5 user(s) are browsing xpwiki)
Members: 0
Guests: 77
more...
Access Counter
Today :
Yesterday :
Total :
Powered by XOOPS Cube 2.1© 2001-2006
XOOPS Cube Project
Design by
XoopsDesign.com