Guest User

Untitled

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