Advertisement
Guest User

Untitled

a guest
Apr 7th, 2020
47
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.77 KB | None | 0 0
  1. [mysqld]
  2. datadir=C:/Program Files/MariaDB 10.4/data
  3. port=3306
  4. character-set-server=utf8
  5.  
  6. innodb-page-size=32768
  7. innodb_buffer_pool_size=32G
  8. innodb_log_file_size=16G
  9. innodb_log_buffer_size=64M
  10. innodb_flush_log_at_trx_commit=1
  11. innodb_io_capacity=1000
  12. thread_cache_size=256
  13. max_connections=10000
  14. sync_binlog=1
  15. max_allowed_packet=2G
  16.  
  17. innodb_log_files_in_group = 3
  18. innodb_buffer_pool_instances=24
  19. key_buffer_size=384M
  20. read_buffer_size=2M
  21. read_rnd_buffer_size=8M
  22. query_cache_size=32M
  23. net_read_timeout=300
  24. net_write_timeout=300
  25.  
  26.  
  27. # Wait timeout
  28. wait_timeout=86400
  29. interactive_timeout=86400
  30.  
  31. # SLOW QUERY
  32. long_query_time=1
  33. slow_query_log=1
  34. slow-query-log-file=mysql-slow.log
  35. log_queries_not_using_indexes=1
  36.  
  37. # LOGGING
  38. general_log=off
  39. general_log_file=general.log
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement