daily pastebin goal
69%
SHARE
TWEET

Untitled

a guest Sep 19th, 2016 53 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. wait_timeout=28800
  2. interactive_timeout = 28800
  3.    
  4. # Example MySQL config file for medium systems.
  5. #
  6. # This is for a system with little memory (32M - 64M) where MySQL plays
  7. # an important part, or systems up to 128M where MySQL is used together with
  8. # other programs (such as a web server)
  9. #
  10. # You can copy this file to
  11. # /etc/my.cnf to set global options,
  12. # mysql-data-dir/my.cnf to set server-specific options (in this
  13. # installation this directory is C:mysqldata) or
  14. # ~/.my.cnf to set user-specific options.
  15. #
  16. # In this file, you can use all long options that a program supports.
  17. # If you want to know which options a program supports, run the program
  18. # with the "--help" option.
  19.  
  20. # The following options will be passed to all MySQL clients
  21. [client]
  22. #password   = your_password
  23. port        = 3306
  24. socket      = /tmp/mysql.sock
  25.  
  26. # Here follows entries for some specific programs
  27.  
  28. # The MySQL server
  29. [wampmysqld]
  30. port        = 3306
  31. socket      = /tmp/mysql.sock
  32. key_buffer = 16M
  33. max_allowed_packet = 64M
  34. table_cache = 64
  35. sort_buffer_size = 512K
  36. net_buffer_length = 8K
  37. read_buffer_size = 256K
  38. read_rnd_buffer_size = 512K
  39. myisam_sort_buffer_size = 8M
  40. basedir=c:/wamp/bin/mysql/mysql5.5.16
  41. log-error=c:/wamp/logs/mysql.log
  42. datadir=c:/wamp/bin/mysql/mysql5.5.16/data
  43.  
  44. # Don't listen on a TCP/IP port at all. This can be a security enhancement,
  45. # if all processes that need to connect to mysqld run on the same host.
  46. # All interaction with mysqld must be made via Unix sockets or named pipes.
  47. # Note that using this option without enabling named pipes on Windows
  48. # (via the "enable-named-pipe" option) will render mysqld useless!
  49. #
  50. #skip-networking
  51.  
  52. # Disable Federated by default
  53. skip-federated
  54.  
  55. # Replication Master Server (default)
  56. # binary logging is required for replication
  57. log-bin=mysql-bin
  58.  
  59. # binary logging format - mixed recommended
  60. binlog_format=mixed
  61.  
  62. # required unique id between 1 and 2^32 - 1
  63. # defaults to 1 if master-host is not set
  64. # but will not function as a master if omitted
  65. server-id   = 1
  66.  
  67. # Replication Slave (comment out master section to use this)
  68. #
  69. # To configure this host as a replication slave, you can choose between
  70. # two methods :
  71. #
  72. # 1) Use the CHANGE MASTER TO command (fully described in our manual) -
  73. #    the syntax is:
  74. #
  75. #    CHANGE MASTER TO MASTER_HOST=<host>, MASTER_PORT=<port>,
  76. #    MASTER_USER=<user>, MASTER_PASSWORD=<password> ;
  77. #
  78. #    where you replace <host>, <user>, <password> by quoted strings and
  79. #    <port> by the master's port number (3306 by default).
  80. #
  81. #    Example:
  82. #
  83. #    CHANGE MASTER TO MASTER_HOST='125.564.12.1', MASTER_PORT=3306,
  84. #    MASTER_USER='joe', MASTER_PASSWORD='secret';
  85. #
  86. # OR
  87. #
  88. # 2) Set the variables below. However, in case you choose this method, then
  89. #    start replication for the first time (even unsuccessfully, for example
  90. #    if you mistyped the password in master-password and the slave fails to
  91. #    connect), the slave will create a master.info file, and any later
  92. #    change in this file to the variables' values below will be ignored and
  93. #    overridden by the content of the master.info file, unless you shutdown
  94. #    the slave server, delete master.info and restart the slaver server.
  95. #    For that reason, you may want to leave the lines below untouched
  96. #    (commented) and instead use CHANGE MASTER TO (see above)
  97. #
  98. # required unique id between 2 and 2^32 - 1
  99. # (and different from the master)
  100. # defaults to 2 if master-host is set
  101. # but will not function as a slave if omitted
  102. #server-id       = 2
  103. #
  104. # The replication master for this slave - required
  105. #master-host     =   <hostname>
  106. #
  107. # The username the slave will use for authentication when connecting
  108. # to the master - required
  109. #master-user     =   <username>
  110. #
  111. # The password the slave will authenticate with when connecting to
  112. # the master - required
  113. #master-password =   <password>
  114. #
  115. # The port the master is listening on.
  116. # optional - defaults to 3306
  117. #master-port     =  <port>
  118. #
  119. # binary logging - not required for slaves, but recommended
  120. #log-bin=mysql-bin
  121.  
  122. # Point the following paths to different dedicated disks
  123. #tmpdir     = /tmp/    
  124. #log-update     = /path-to-dedicated-directory/hostname
  125.  
  126. # Uncomment the following if you are using InnoDB tables
  127. #innodb_data_home_dir = C:mysqldata/
  128. #innodb_data_file_path = ibdata1:10M:autoextend
  129. #innodb_log_group_home_dir = C:mysqldata/
  130. #innodb_log_arch_dir = C:mysqldata/
  131. # You can set .._buffer_pool_size up to 50 - 80 %
  132. # of RAM but beware of setting memory usage too high
  133. #innodb_buffer_pool_size = 16M
  134. #innodb_additional_mem_pool_size = 2M
  135. # Set .._log_file_size to 25 % of buffer pool size
  136. #innodb_log_file_size = 5M
  137. #innodb_log_buffer_size = 8M
  138. #innodb_flush_log_at_trx_commit = 1
  139. #innodb_lock_wait_timeout = 50
  140.  
  141. [mysqldump]
  142. quick
  143. max_allowed_packet = 64M
  144.  
  145. [mysql]
  146. no-auto-rehash
  147. # Remove the next comment character if you are not familiar with SQL
  148. #safe-updates
  149.  
  150. [isamchk]
  151. key_buffer = 20M
  152. sort_buffer_size = 20M
  153. read_buffer = 2M
  154. write_buffer = 2M
  155.  
  156. [myisamchk]
  157. key_buffer = 20M
  158. sort_buffer_size = 20M
  159. read_buffer = 2M
  160. write_buffer = 2M
  161.  
  162. [mysqlhotcopy]
  163. wait_timeout=28800
  164. interactive_timeout = 28800
  165.  
  166. [mysqld]
  167. wait_timeout=28800
  168. interactive_timeout = 28800
  169. port=3306
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top