SHARE
TWEET

Untitled

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