Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- [mysqld]
- bind-address=0.0.0.0
- datadir=/var/lib/mysql
- socket=/var/run/mysqld/mysql.sock
- tmpdir=/mnt/tmpfs
- max_heap_table_size=1280M
- tmp_table_size=1280M
- max_allowed_packet=128M
- thread_stack=512K
- max-connect-errors=10000
- max_connections=300
- default-storage-engine=innodb
- symbolic-links=1
- transaction-isolation=READ-COMMITTED
- slow_query_log = ON
- long_query_time=5
- slow_query_log_file = /var/log/mariadb10.2/mysql-slow.log
- #######################################
- innodb_file_per_table=1
- innodb_log_file_size = 5G
- innodb_log_buffer_size = 4M
- innodb_flush_log_at_trx_commit=2
- innodb_flush_method=O_DIRECT
- innodb_io_capacity = 3000
- innodb_io_capacity_max = 6000
- innodb_strict_mode=OFF
- #######################################
- interactive_timeout=60
- wait_timeout=20
- connect_timeout=20
- #######################################
- ###GLOBAL
- table_cache = 4096
- table_definition_cache = 4096
- table_cache=512
- thread_cache_size=128
- table_open_cache=4000
- query_cache_size = 128M
- query_cache_type=1
- query_cache_limit=4M
- innodb_buffer_pool_size=35G
- key_buffer_size=2G
- #######################################
- myisam_sort_buffer_size=128M
- innodb_buffer_pool_instances = 37
- join_buffer_size=128M
- read_buffer_size = 4M
- sort_buffer_size = 4M
- read_rnd_buffer_size = 4M
- #######################################
- [mysqld_safe]
- log-error=/var/log/mysqld.log
- [mysqld]
- collation-server=utf8_general_ci
- init-connect='SET NAMES utf8'
- character-set-server=utf8
- [client]
- default-character-set=utf8
- socket=/var/run/mysqld/mysql.sock
- [mysql]
- default-character-set=utf8
Advertisement
Add Comment
Please, Sign In to add comment
