-
Notifications
You must be signed in to change notification settings - Fork 5
/
pathdbmysql.cnf
33 lines (30 loc) · 678 Bytes
/
pathdbmysql.cnf
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
32
[mysqld]
datadir=/data/pathdb/mysql
user=mysql
skip-name-resolve
symbolic-links=0
max_connections = 150
max_user_connections = 150
key_buffer = 36M
myisam_sort_buffer_size = 64M
join_buffer_size = 2M
read_buffer_size = 2M
sort_buffer_size = 3M
table_cache = 1024
thread_cache_size = 286
interactive_timeout = 25
wait_timeout = 1800
connect_timeout = 10
max_allowed_packet = 16M
max_connect_errors = 1000
query_cache_limit = 1M
query_cache_size = 0
query_cache_type = 0
tmp_table_size = 16M
innodb-flush-log-at-trx-commit=2
innodb_file_per_table=ON
innodb_buffer_pool_size = 4G
innodb_log_file_size=512M
innodb_stats_on_metadata=0
innodb_buffer_pool_instances=4
[mysqld_safe]