Advertisement
Guest User

Untitled

a guest
Jul 26th, 2012
29
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 5.26 KB | None
  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 = Sloppyjoe1997
  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 = 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. #bind-address="127.0.0.1"
  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 = 32M
  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
Advertisement
RAW Paste Data Copied
Advertisement