| 4 |
- |
1 |
[mysqld]
|
|
|
2 |
datadir=/var/lib/mysql
|
|
|
3 |
socket=/var/lib/mysql/mysql.sock
|
|
|
4 |
# Settings user and group are ignored when systemd is used (fedora >= 15).
|
|
|
5 |
# If you need to run mysqld under different user or group,
|
|
|
6 |
# customize your systemd unit file for mysqld according to the
|
|
|
7 |
# instructions in http://fedoraproject.org/wiki/Systemd
|
|
|
8 |
user=mysql
|
|
|
9 |
# Disabling symbolic-links is recommended to prevent assorted security risks
|
|
|
10 |
symbolic-links=0
|
|
|
11 |
key_buffer = 640M
|
|
|
12 |
table_cache = 1280
|
|
|
13 |
sort_buffer_size = 2M
|
|
|
14 |
myisam_sort_buffer_size = 8M
|
|
|
15 |
query_cache_size = 160M
|
|
|
16 |
thread_cache_size = 12
|
|
|
17 |
innodb_buffer_pool_size = 4G
|
|
|
18 |
join_buffer_size = 32k
|
|
|
19 |
|
|
|
20 |
# Semisynchronous Replication
|
|
|
21 |
# http://dev.mysql.com/doc/refman/5.5/en/replication-semisync.html
|
|
|
22 |
# uncomment next line on MASTER
|
|
|
23 |
;plugin-load=rpl_semi_sync_master=semisync_master.so
|
|
|
24 |
# uncomment next line on SLAVE
|
|
|
25 |
;plugin-load=rpl_semi_sync_slave=semisync_slave.so
|
|
|
26 |
|
|
|
27 |
# Others options for Semisynchronous Replication
|
|
|
28 |
;rpl_semi_sync_master_enabled=1
|
|
|
29 |
;rpl_semi_sync_master_timeout=10
|
|
|
30 |
;rpl_semi_sync_slave_enabled=1
|
|
|
31 |
|
|
|
32 |
# http://dev.mysql.com/doc/refman/5.5/en/performance-schema.html
|
|
|
33 |
;performance_schema
|
|
|
34 |
|
|
|
35 |
[mysqld_safe]
|
|
|
36 |
log-error=/var/log/mysqld.log
|
|
|
37 |
pid-file=/var/run/mysqld/mysqld.pid
|