Advertisement
Guest User

Untitled

a guest
Dec 8th, 2020
410
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.58 KB | None | 0 0
  1.  
  2. [server]
  3.  
  4. [mysqld]
  5. default_storage_engine = InnoDB
  6. innodb_buffer_pool_instances = 24 # Use 1 instance per 1GB of InnoDB pool size
  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 = 1G
  11. log_error = /var/log/mysql.log
  12.  
  13. max_connections = 200000
  14. innodb_file_per_table=1
  15. lower_case_table_names=0
  16. skip-name-resolve
  17. performance_schema=off
  18. query_cache_type=0
  19. [galera]
  20.  
  21. [embedded]
  22.  
  23. [mariadb]
  24.  
  25. [mariadb-10.5]
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement