Advertisement
Guest User

Untitled

a guest
Dec 8th, 2020
505
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.79 KB | None | 0 0
  1. #############################################
  2. [server]
  3.  
  4. [mysqld]
  5. default_storage_engine = InnoDB
  6. ## INNODB settings
  7. innodb_buffer_pool_size = 24G # Use up to 70-80% of RAM
  8. innodb_flush_method = O_DIRECT
  9. innodb_log_buffer_size = 16M
  10. innodb_log_file_size = 6G
  11. innodb_file_per_table=1
  12. ## Logging
  13. log_error = /var/log/mysql.log
  14. #log_queries_not_using_indexes = 1
  15. long_query_time = 1
  16. slow_query_log = 1
  17. slow_query_log_file = /var/log/mysql-slow.log
  18. ## Extras
  19. lower_case_table_names=0
  20. max_connections = 10000
  21. performance_schema=on
  22. query_cache_size=0
  23. query_cache_type=0
  24. query_cache_limit=8M
  25. skip-name-resolve
  26.  
  27. [galera]
  28.  
  29. [embedded]
  30.  
  31. [mariadb]
  32.  
  33. [mariadb-10.5]
  34.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement