Advertisement
daredevil001

my.cnf

Dec 12th, 2021
1,252
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. # ./mysql-config/my.cnf
  2.  
  3. [mysqld]
  4. #sql-mode = NO_ENGINE_SUBSTITUTION
  5. max_allowed_packet = 512M
  6. #query_cache_type = 1
  7. #query_cache_limit = 1M
  8. #tmpdir = /tmp
  9. #tmp_table_size = 290M
  10. #max_heap_table_size = 290M
  11. #join_buffer_size = 4M
  12. innodb_buffer_pool_size = 2G
  13. innodb_buffer_pool_instances = 2
  14. #table_cache = 1200
  15. slow_query_log = 1
  16. slow_query_log_file = /var/log/mysql/mysql-slow.log
  17. long_query_time = 1
  18. bind-address = 0.0.0.0
  19. group_concat_max_len = 18446744073709551615
  20.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement