Advertisement
Guest User

Untitled

a guest
Jan 22nd, 2017
79
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.57 KB | None | 0 0
  1. [mariadb]
  2. server_id=3314
  3. log-bin
  4. log-basename=master_co_denver_ne
  5.  
  6. [mysqld]
  7. datadir=c:/data/co-denver-ne
  8. #skip-networking
  9. enable-named-pipe
  10. socket=MySQL-CO-Denver-NE
  11. port=3314
  12. max_connections=100000
  13. skip-external-locking
  14. key_buffer_size = 384M
  15. max_allowed_packet = 50M
  16. table_open_cache = 512
  17. sort_buffer_size = 2M
  18. read_buffer_size = 2M
  19. read_rnd_buffer_size = 8M
  20. myisam_sort_buffer_size = 64M
  21. thread_cache_size = 900
  22. query_cache_size = 0
  23. query_cache_type = 0
  24. innodb_lock_wait_timeout = 5000
  25. table_definition_cache = 486
  26. innodb_open_files = 512
  27. innodb_read_io_threads = 64
  28. innodb_buffer_pool_size = 4G
  29. innodb_flush_log_at_trx_commit = 2
  30. innodb_file_per_table = 1
  31. innodb_log_file_size = 1G
  32. skip-name-resolve
  33.  
  34. #innodb_data_home_dir = C:\\data\\innodb\\co-denver-ne\\
  35. #innodb_data_file_path = ibdata1:2000M;ibdata2:10M:autoextend
  36. #innodb_log_group_home_dir = C:\\data\\tmp\\co-denver-ne
  37. # You can set .._buffer_pool_size up to 50 - 80 %
  38. # of RAM but beware of setting memory usage too high
  39. #innodb_buffer_pool_size = 10000M
  40. #innodb_additional_mem_pool_size = 20M
  41. # Set .._log_file_size to 25 % of buffer pool size
  42. #innodb_log_file_size = 2500M
  43. #innodb_log_buffer_size = 8M
  44. #innodb_flush_log_at_trx_commit = 1
  45.  
  46. [client]
  47. socket=MySQL-CO-Denver-NE
  48. protocol=pipe
  49. port=3314
  50.  
  51. [mysqldump]
  52. quick
  53. max_allowed_packet = 16M
  54.  
  55. [mysql]
  56. no-auto-rehash
  57. # Remove the next comment character if you are not familiar with SQL
  58. #safe-updates
  59.  
  60. [myisamchk]
  61. key_buffer_size = 256M
  62. sort_buffer_size = 256M
  63. read_buffer = 2M
  64. write_buffer = 2M
  65.  
  66. [mysqlhotcopy]
  67. interactive-timeout
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement