Advertisement
Guest User

Untitled

a guest
Feb 28th, 2019
206
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 6.55 KB | None | 0 0
  1. # Example MySQL config file for small systems.
  2. #
  3. # This is for a system with little memory (<= 64M) where MySQL is only used
  4. # from time to time and it's important that the mysqld daemon
  5. # doesn't use much resources.
  6. #
  7. # You can copy this file to
  8. # /program files (x86)/steam/steamapps/common/arma 2 operation arrowhead/@DayZ_Blizzard/mysql/bin/my.cnf to set global options,
  9. # mysql-data-dir/my.cnf to set server-specific options (in this
  10. # installation this directory is /program files (x86)/steam/steamapps/common/arma 2 operation arrowhead/@DayZ_Blizzard/mysql/data) or
  11. # ~/.my.cnf to set user-specific options.
  12. #
  13. # In this file, you can use all long options that a program supports.
  14. # If you want to know which options a program supports, run the program
  15. # with the "--help" option.
  16.  
  17. # The following options will be passed to all MySQL clients
  18. [client]
  19. # password = your_password
  20. port = 3306
  21. socket = "/program files (x86)/steam/steamapps/common/arma 2 operation arrowhead/@DayZ_Blizzard/mysql/mysql.sock"
  22.  
  23. # Here follows entries for some specific programs
  24.  
  25. # The MySQL server
  26. [mysqld]
  27. port= 3306
  28. socket = "/program files (x86)/steam/steamapps/common/arma 2 operation arrowhead/@DayZ_Blizzard/mysql/mysql.sock"
  29. basedir = "/program files (x86)/steam/steamapps/common/arma 2 operation arrowhead/@DayZ_Blizzard/mysql"
  30. tmpdir = "/program files (x86)/steam/steamapps/common/arma 2 operation arrowhead/@DayZ_Blizzard/tmp"
  31. datadir = "/program files (x86)/steam/steamapps/common/arma 2 operation arrowhead/@DayZ_Blizzard/mysql/data"
  32. pid_file = "mysql.pid"
  33. skip-external-locking
  34. key_buffer = 16M
  35. max_allowed_packet = 1M
  36. table_cache = 64
  37. sort_buffer_size = 512K
  38. net_buffer_length = 8K
  39. read_buffer_size = 256K
  40. read_rnd_buffer_size = 512K
  41. myisam_sort_buffer_size = 8M
  42. log_error = "mysql_error.log"
  43.  
  44. #bind-address="127.0.0.1"
  45.  
  46. # Where do all the plugins live
  47. plugin_dir = "/program files (x86)/steam/steamapps/common/arma 2 operation arrowhead/@DayZ_Blizzard/mysql/data/lib/plugin/"
  48.  
  49. # Don't listen on a TCP/IP port at all. This can be a security enhancement,
  50. # if all processes that need to connect to mysqld run on the same host.
  51. # All interaction with mysqld must be made via Unix sockets or named pipes.
  52. # Note that using this option without enabling named pipes on Windows
  53. # (via the "enable-named-pipe" option) will render mysqld useless!
  54. #
  55. # commented in by lampp security
  56. #skip-networking
  57. skip-federated
  58.  
  59. # Replication Master Server (default)
  60. # binary logging is required for replication
  61. # log-bin deactivated by default since XAMPP 1.4.11
  62. #log-bin=mysql-bin
  63.  
  64. # required unique id between 1 and 2^32 - 1
  65. # defaults to 1 if master-host is not set
  66. # but will not function as a master if omitted
  67. server-id = 1
  68.  
  69. # Replication Slave (comment out master section to use this)
  70. #
  71. # To configure this host as a replication slave, you can choose between
  72. # two methods :
  73. #
  74. # 1) Use the CHANGE MASTER TO command (fully described in our manual) -
  75. # the syntax is:
  76. #
  77. # CHANGE MASTER TO MASTER_HOST=<host>, MASTER_PORT=<port>,
  78. # MASTER_USER=<user>, MASTER_PASSWORD=<password> ;
  79. #
  80. # where you replace <host>, <user>, <password> by quoted strings and
  81. # <port> by the master's port number (3306 by default).
  82. #
  83. # Example:
  84. #
  85. # CHANGE MASTER TO MASTER_HOST='125.564.12.1', MASTER_PORT=3306,
  86. # MASTER_USER='joe', MASTER_PASSWORD='secret';
  87. #
  88. # OR
  89. #
  90. # 2) Set the variables below. However, in case you choose this method, then
  91. # start replication for the first time (even unsuccessfully, for example
  92. # if you mistyped the password in master-password and the slave fails to
  93. # connect), the slave will create a master.info file, and any later
  94. # change in this file to the variables' values below will be ignored and
  95. # overridden by the content of the master.info file, unless you shutdown
  96. # the slave server, delete master.info and restart the slaver server.
  97. # For that reason, you may want to leave the lines below untouched
  98. # (commented) and instead use CHANGE MASTER TO (see above)
  99. #
  100. # required unique id between 2 and 2^32 - 1
  101. # (and different from the master)
  102. # defaults to 2 if master-host is set
  103. # but will not function as a slave if omitted
  104. #server-id = 2
  105. #
  106. # The replication master for this slave - required
  107. #master-host = <hostname>
  108. #
  109. # The username the slave will use for authentication when connecting
  110. # to the master - required
  111. #master-user = <username>
  112. #
  113. # The password the slave will authenticate with when connecting to
  114. # the master - required
  115. #master-password = <password>
  116. #
  117. # The port the master is listening on.
  118. # optional - defaults to 3306
  119. #master-port = <port>
  120. #
  121. # binary logging - not required for slaves, but recommended
  122. #log-bin=mysql-bin
  123.  
  124.  
  125. # Point the following paths to different dedicated disks
  126. #tmpdir = "/program files (x86)/steam/steamapps/common/arma 2 operation arrowhead/@DayZ_Blizzard/tmp"
  127. #log-update = /path-to-dedicated-directory/hostname
  128.  
  129. # Uncomment the following if you are using BDB tables
  130. #bdb_cache_size = 4M
  131. #bdb_max_lock = 10000
  132.  
  133. # Comment the following if you are using InnoDB tables
  134. #skip-innodb
  135. innodb_data_home_dir = "/program files (x86)/steam/steamapps/common/arma 2 operation arrowhead/@DayZ_Blizzard/mysql/data"
  136. innodb_data_file_path = ibdata1:10M:autoextend
  137. innodb_log_group_home_dir = "/program files (x86)/steam/steamapps/common/arma 2 operation arrowhead/@DayZ_Blizzard/mysql/data"
  138. #innodb_log_arch_dir = "/program files (x86)/steam/steamapps/common/arma 2 operation arrowhead/@DayZ_Blizzard/mysql/data"
  139. ## You can set .._buffer_pool_size up to 50 - 80 %
  140. ## of RAM but beware of setting memory usage too high
  141. innodb_buffer_pool_size = 16M
  142. innodb_additional_mem_pool_size = 2M
  143. ## Set .._log_file_size to 25 % of buffer pool size
  144. innodb_log_file_size = 5M
  145. innodb_log_buffer_size = 8M
  146. innodb_flush_log_at_trx_commit = 1
  147. innodb_lock_wait_timeout = 50
  148.  
  149. ## UTF 8 Settings
  150. #init-connect=\'SET NAMES utf8\'
  151. #collation_server=utf8_unicode_ci
  152. #character_set_server=utf8
  153. #skip-character-set-client-handshake
  154. #character_sets-dir="/program files (x86)/steam/steamapps/common/arma 2 operation arrowhead/@DayZ_Blizzard/mysql/share/charsets"
  155.  
  156. [mysqldump]
  157. quick
  158. max_allowed_packet = 16M
  159.  
  160. [mysql]
  161. no-auto-rehash
  162. # Remove the next comment character if you are not familiar with SQL
  163. #safe-updates
  164.  
  165. [isamchk]
  166. key_buffer = 20M
  167. sort_buffer_size = 20M
  168. read_buffer = 2M
  169. write_buffer = 2M
  170.  
  171. [myisamchk]
  172. key_buffer = 20M
  173. sort_buffer_size = 20M
  174. read_buffer = 2M
  175. write_buffer = 2M
  176.  
  177. [mysqlhotcopy]
  178. interactive-timeout
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement