Advertisement
shalvie

Problematic my.cnf for Master

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