daily pastebin goal
32%
SHARE
TWEET

Untitled

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