Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #############################################
- [server]
- [mysqld]
- default_storage_engine = InnoDB
- ## INNODB settings
- innodb_buffer_pool_size = 24G # Use up to 70-80% of RAM
- innodb_flush_method = O_DIRECT
- innodb_log_buffer_size = 16M
- innodb_log_file_size = 6G
- innodb_file_per_table=1
- ## Logging
- log_error = /var/log/mysql.log
- #log_queries_not_using_indexes = 1
- long_query_time = 1
- slow_query_log = 1
- slow_query_log_file = /var/log/mysql-slow.log
- ## Extras
- lower_case_table_names=0
- max_connections = 10000
- performance_schema=on
- query_cache_size=0
- query_cache_type=0
- query_cache_limit=8M
- skip-name-resolve
- [galera]
- [embedded]
- [mariadb]
- [mariadb-10.5]
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement