mysqld server-id log-bin mysql-bin innodb_flush_log_at_ trx_commit syn

 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
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
[mysqld]
server-id = 1
log-bin = mysql-bin
innodb_flush_log_at_trx_commit=1
sync_binlog = 1
binlog-format = ROW
expire_logs_days = 30
max_binlog_size = 768M
binlog-do-db=salaryboard
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
#datadir = /var/lib/mysql
datadir = /mnt/volume_mysql_data/mysql
log-error = /var/log/mysql/error.log
# By default we only accept connections from localhost
bind-address = 0.0.0.0
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
innodb_buffer_pool_size = 64G
innodb_buffer_pool_instances=64
#innodb_log_buffer_size = 512M
#innodb_file_per_table = 1
innodb_open_files = 400
innodb_io_capacity = 2000
innodb_lock_wait_timeout = 180
innodb_read_io_threads = 64
innodb_thread_concurrency = 0
innodb_write_io_threads = 64
innodb_autoinc_lock_mode = 2
innodb_flush_method = O_DIRECT
max_connections = 1000
connect_timeout = 2
wait_timeout = 100
max_allowed_packet = 64M
thread_cache_size = 4096
sort_buffer_size = 1G
bulk_insert_buffer_size = 1G
tmp_table_size = 1G
max_heap_table_size = 1G
key_buffer_size = 128M
#open-files-limit = 2000
table_open_cache = 400
myisam_sort_buffer_size = 512M
concurrent_insert = 2
read_buffer_size = 8M
read_rnd_buffer_size = 4M
# Cache only tiny result sets, so we can fit more in the query cache.
query_cache_limit = 0
query_cache_size = 0
query_cache_type = 0