Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- [mysqld]
- datadir=C:/Program Files/MariaDB 10.4/data
- port=3306
- character-set-server=utf8
- innodb-page-size=32768
- innodb_buffer_pool_size=32G
- innodb_log_file_size=16G
- innodb_log_buffer_size=64M
- innodb_flush_log_at_trx_commit=1
- innodb_io_capacity=1000
- thread_cache_size=256
- max_connections=10000
- sync_binlog=1
- max_allowed_packet=2G
- innodb_log_files_in_group = 3
- innodb_buffer_pool_instances=24
- key_buffer_size=384M
- read_buffer_size=2M
- read_rnd_buffer_size=8M
- query_cache_size=32M
- net_read_timeout=300
- net_write_timeout=300
- # Wait timeout
- wait_timeout=86400
- interactive_timeout=86400
- # SLOW QUERY
- long_query_time=1
- slow_query_log=1
- slow-query-log-file=mysql-slow.log
- log_queries_not_using_indexes=1
- # LOGGING
- general_log=off
- general_log_file=general.log
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement