Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- [mysqld]
- local-infile = 1
- datadir=/var/lib/mysql
- socket=/var/lib/mysql/mysql.sock
- back_log = 200
- interactive_timeout = 7200
- wait_timeout = 7200
- net_read_timeout = 120
- net_write_timeout = 300
- sort_buffer_size = 2M
- read_buffer_size = 8M
- read_rnd_buffer_size = 16M
- join_buffer_size = 8M
- tmp_table_size = 128M
- max_heap_table_size = 128M
- query_cache_type = 1
- query_cache_size = 96M
- query_cache_limit = 2M
- max_connections = 70
- thread_cache_size= 32
- open_files_limit = 65535
- table_definition_cache = 4000
- table_open_cache = 15000
- max_allowed_packet = 32M
- key_buffer_size = 512M # up from 256#
- innodb_thread_concurrency = 0 #up from 8#
- innodb_lock_wait_timeout = 7200
- innodb_flush_method = O_DIRECT
- innodb_file_per_table = 1
- innodb_buffer_pool_size = 26G
- [mysqld_safe]
- log-error=/var/log/mariadb/mariadb.log
- pid-file=/var/run/mariadb/mariadb.pid
- !includedir /etc/my.cnf.d
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement