Advertisement
shalvie

Problematic my.cnf for Slave

May 31st, 2013
66
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.02 KB | None | 0 0
  1. [mysqld]
  2.  
  3. # *** configuration options
  4.  
  5.  
  6. datadir=/var/lib/mysql
  7. tmpdir=mysqltmp
  8. pid-file=mysqld.pid
  9. log-error=mysqld_error.log
  10. socket=mysql.sock
  11. port=3306
  12.  
  13. skip-name-resolve
  14.  
  15.  
  16. ndbcluster
  17.  
  18. ndb-connectstring=172.16.101.252:1186
  19.  
  20. ndb_use_exact_count=0
  21.  
  22.  
  23. ndb_index_stat_enable=0
  24.  
  25.  
  26. ndb_force_send=1
  27.  
  28. engine_condition_pushdown=1
  29.  
  30.  
  31. # *** Replication related settings
  32.  
  33. server-id=4
  34.  
  35. skip-slave-start
  36.  
  37.  
  38. log-bin=/var/lib/mysql/mysql-bin
  39.  
  40. relay-log = /var/log/mysql/relay-bin
  41.  
  42.  
  43. binlog_format=mixed
  44.  
  45. #Generic Options
  46.  
  47. group_concat_max_len = 1000000
  48.  
  49. max_allowed_packet = 1G
  50.  
  51. back_log = 50
  52.  
  53. max_connect_errors = 10
  54.  
  55. table_cache = 1024
  56.  
  57. table_open_cache = 64
  58.  
  59. binlog_cache_size = 1M
  60.  
  61. max_heap_table_size = 64M
  62.  
  63. sort_buffer_size = 8M
  64.  
  65. join_buffer_size = 8M
  66.  
  67. thread_cache_size = 10
  68.  
  69. query_cache_size = 1G
  70.  
  71. query_cache_limit = 20M
  72.  
  73. thread_stack = 192K
  74.  
  75. tmp_table_size = 962M
  76.  
  77. #*** MyISAM Specific options
  78.  
  79. key_buffer_size = 16M
  80.  
  81. read_buffer_size = 256K
  82.  
  83. read_rnd_buffer_size = 512K
  84.  
  85. bulk_insert_buffer_size = 64M
  86.  
  87. myisam_sort_buffer_size = 512K
  88.  
  89. myisam_max_sort_file_size = 10G
  90.  
  91. net_buffer_length = 8K
  92.  
  93. # *** INNODB Specific options ***
  94.  
  95. innodb_file_per_table
  96.  
  97. innodb_additional_mem_pool_size = 2M
  98.  
  99. innodb_buffer_pool_size = 16M
  100.  
  101. innodb_thread_concurrency = 16
  102.  
  103. innodb_log_file_size = 256M
  104.  
  105.  
  106. innodb_log_files_in_group = 3
  107.  
  108. innodb_log_group_home_dir=/var/lib/mysql/innodb
  109.  
  110. innodb_max_dirty_pages_pct = 90
  111.  
  112. innodb_lock_wait_timeout = 120
  113.  
  114. innodb_data_home_dir = /var/lib/mysql/innodb
  115.  
  116.  
  117. [mysqldump]
  118.  
  119. quick
  120.  
  121. max_allowed_packet = 16M
  122.  
  123. [mysql]
  124.  
  125. no-auto-rehash
  126.  
  127. [mysql_cluster]
  128.  
  129. ndb-connectstring=172.16.101.252:1186
  130.  
  131.  
  132. [myisamchk]
  133.  
  134. key_buffer = 20M
  135. sort_buffer_size = 20M
  136. read_buffer = 2M
  137. write_buffer = 2M
  138.  
  139. [mysqlhotcopy]
  140. interactive-timeout
  141.  
  142. [mysql.server]
  143.  
  144. user=mysql
  145.  
  146. [mysqld_safe]
  147.  
  148. open-files-limit = 8192
  149. err-log=/var/log/mysql/mysqld_error.log
  150. pid-file=mysqld.pid
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement