API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Oct 15th, 2019
117
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 6.57 KB | None | 0 0
raw download clone embed print report
  1. ▼NDB config.ini
  2. [tcp default]
  3. SendBufferMemory=64M
  4. ReceiveBufferMemory=64M
  5.  
  6. [ndb_mgmd default]
  7. DataDir=/var/lib/mysql-cluster
  8.  
  9. [ndb_mgmd]
  10. HostName=10.3.65.1
  11. NodeId=1
  12.  
  13. [ndb_mgmd]
  14. HostName=10.3.65.22
  15. NodeId=2
  16.  
  17. [ndbd default]
  18. DataDir=/var/lib/mysql-cluster
  19. FileSystemPath=/var/lib/mysql-cluster
  20. BackupDataDir=/var/ndbbackup
  21. NoOfReplicas=2
  22.  
  23. LockPagesInMainMemory=1
  24.  
  25. SharedGlobalMemory=4G
  26. DataMemory=90G
  27. StringMemory=128M
  28. LongMessageBuffer=128M
  29. TransactionBufferMemory=64M
  30.  
  31. TotalSendBufferMemory=256M
  32. ODirect=1
  33.  
  34. EnableRedoControl=1
  35.  
  36. HeartbeatIntervalDbDb = 10000
  37. HeartbeatIntervalDbApi = 3000
  38.  
  39. TimeBetweenLocalCheckpoints=22
  40. TimeBetweenGlobalCheckpoints=2000
  41. MaxBufferedEpochs=10000
  42. RedoBuffer=128M
  43. TransactionDeadlockDetectionTimeout=6000
  44. StartPartitionedTimeout=4294967039
  45. TwoPassInitialNodeRestartCopy=1
  46. BuildIndexThreads=12
  47. NoOfFragmentLogFiles=24
  48. NoOfFragmentLogParts=16
  49. FragmentLogFileSize=256M
  50. InitFragmentLogFiles=FULL
  51.  
  52. CompressedBackup=1
  53.  
  54. MaxNoOfExecutionThreads = 12
  55. MaxNoOfAttributes = 20000
  56. MaxNoOfTables = 1024
  57. MaxNoOfConcurrentOperations = 300000
  58. MaxNoOfLocalOperations = 330000
  59. MaxNoOfConcurrentScans = 500
  60. MaxNoOfOrderedIndexes = 4000
  61. MaxNoOfUniqueHashIndexes = 300
  62. MaxNoOfConcurrentTransactions = 50000
  63. MaxParallelScansPerFragment=1024
  64.  
  65. Numa=1
  66.  
  67. [ndbd]
  68. HostName = 10.3.65.11
  69. NodeId = 11
  70.  
  71. [ndbd]
  72. HostName = 10.3.65.12
  73. NodeId = 12
  74.  
  75. [mysqld]
  76. NodeId=101
  77.  
  78. [mysqld]
  79.  
  80. [mysqld]
  81.  
  82. [mysqld]
  83.  
  84. [mysqld]
  85.  
  86. [mysqld]
  87.  
  88. [mysqld]
  89.  
  90. [mysqld]
  91.  
  92. [mysqld]
  93.  
  94. [mysqld]
  95.  
  96. [mysqld]
  97.  
  98. [mysqld]
  99.  
  100. [mysqld]
  101.  
  102. [mysqld]
  103.  
  104. [mysqld]
  105.  
  106. [mysqld]
  107.  
  108. [mysqld]
  109.  
  110. [mysqld]
  111.  
  112. [mysqld]
  113.  
  114. [mysqld]
  115.  
  116. [mysqld]
  117.  
  118. [mysqld]
  119.  
  120. [mysqld]
  121.  
  122. [mysqld]
  123.  
  124. [mysqld]
  125.  
  126. [mysqld]
  127.  
  128. [mysqld]
  129.  
  130. [mysqld]
  131.  
  132. [mysqld]
  133.  
  134. [mysqld]
  135.  
  136. =================================================================================
  137. ▼NDB config.ini(Shared Memory Connections)
  138. [tcp default]
  139. SendBufferMemory=64M
  140. ReceiveBufferMemory=64M
  141.  
  142. [ndb_mgmd default]
  143. DataDir=/var/lib/mysql-cluster
  144.  
  145. [ndb_mgmd]
  146. HostName=10.3.65.1
  147. NodeId=1
  148.  
  149. [ndb_mgmd]
  150. HostName=10.3.65.22
  151. NodeId=2
  152.  
  153. [shm default]
  154. ShmSize=128M
  155. ShmSpintime=200
  156. SendBufferMemory=16M
  157.  
  158. [ndbd default]
  159. UseShm=1
  160. DataDir=/var/lib/mysql-cluster
  161. FileSystemPath=/var/lib/mysql-cluster
  162. BackupDataDir=/var/ndbbackup
  163. NoOfReplicas=2
  164.  
  165. LockPagesInMainMemory=1
  166.  
  167. SharedGlobalMemory=4G
  168. DataMemory=90G
  169. StringMemory=128M
  170. LongMessageBuffer=128M
  171. TransactionBufferMemory=64M
  172.  
  173. TotalSendBufferMemory=256M
  174. ODirect=1
  175.  
  176. EnableRedoControl=1
  177.  
  178. HeartbeatIntervalDbDb = 10000
  179. HeartbeatIntervalDbApi = 3000
  180.  
  181. TimeBetweenLocalCheckpoints=22
  182. TimeBetweenGlobalCheckpoints=2000
  183. MaxBufferedEpochs=10000
  184. RedoBuffer=128M
  185. TransactionDeadlockDetectionTimeout=6000
  186. StartPartitionedTimeout=4294967039
  187. TwoPassInitialNodeRestartCopy=1
  188. BuildIndexThreads=12
  189. NoOfFragmentLogFiles=24
  190. NoOfFragmentLogParts=16
  191. FragmentLogFileSize=256M
  192. InitFragmentLogFiles=FULL
  193.  
  194. CompressedBackup=1
  195.  
  196. MaxNoOfExecutionThreads = 12
  197. MaxNoOfAttributes = 20000
  198. MaxNoOfTables = 1024
  199. MaxNoOfConcurrentOperations = 300000
  200. MaxNoOfLocalOperations = 330000
  201. MaxNoOfConcurrentScans = 500
  202. MaxNoOfOrderedIndexes = 4000
  203. MaxNoOfUniqueHashIndexes = 300
  204. MaxNoOfConcurrentTransactions = 50000
  205. MaxParallelScansPerFragment=1024
  206.  
  207. Numa=1
  208.  
  209. [ndbd]
  210. HostName = 10.3.65.11
  211. NodeId = 11
  212.  
  213. [ndbd]
  214. HostName = 10.3.65.12
  215. NodeId = 12
  216.  
  217.  
  218. [mysqld]
  219. NodeId=101
  220. HostName = 10.3.65.11
  221.  
  222. [mysqld]
  223. NodeId=102
  224. HostName = 10.3.65.11
  225.  
  226. [mysqld]
  227. NodeId=103
  228. HostName = 10.3.65.11
  229.  
  230. [mysqld]
  231. NodeId=104
  232. HostName = 10.3.65.11
  233.  
  234. [mysqld]
  235. NodeId=105
  236. HostName = 10.3.65.11
  237.  
  238. [mysqld]
  239. NodeId=106
  240. HostName = 10.3.65.11
  241.  
  242. [mysqld]
  243. NodeId=107
  244. HostName = 10.3.65.12
  245.  
  246. [mysqld]
  247. NodeId=108
  248. HostName = 10.3.65.12
  249.  
  250. [mysqld]
  251. NodeId=109
  252. HostName = 10.3.65.12
  253.  
  254. [mysqld]
  255. NodeId=110
  256. HostName = 10.3.65.12
  257.  
  258. [mysqld]
  259. NodeId=111
  260. HostName = 10.3.65.12
  261.  
  262. [mysqld]
  263. NodeId=112
  264. HostName = 10.3.65.12
  265.  
  266. [mysqld]
  267.  
  268. [mysqld]
  269.  
  270. [mysqld]
  271.  
  272. [mysqld]
  273.  
  274. [mysqld]
  275.  
  276. [mysqld]
  277.  
  278. [mysqld]
  279.  
  280. [mysqld]
  281.  
  282. [mysqld]
  283.  
  284. [mysqld]
  285.  
  286. [mysqld]
  287.  
  288. [mysqld]
  289.  
  290. [mysqld]
  291.  
  292. [mysqld]
  293.  
  294. [mysqld]
  295.  
  296. [mysqld]
  297.  
  298. [mysqld]
  299.  
  300. [mysqld]
  301.  
  302. =================================================================================
  303. ▼NDB my.cnf
  304. [mysqld]
  305. ndbcluster
  306. datadir=/var/lib/mysql-cluster
  307. socket=/var/lib/mysql-cluster/mysql.sock
  308. user=mysql
  309. symbolic-links=0
  310. max_connections=4096
  311. character-set-server = utf8
  312. ndb-cluster-connection-pool=6
  313. thread_cache_size=4096
  314. query_cache_type=0
  315.  
  316. back_log = 10240
  317.  
  318. table_open_cache = 40960
  319. table_open_cache_instances = 16
  320.  
  321. skip-external-locking
  322. skip-name-resolve
  323.  
  324. open_files_limit = 65535
  325.  
  326. performance_schema_instrument='%sync%=on'
  327.  
  328. skip-log-bin
  329.  
  330. log_timestamps = SYSTEM
  331. log-error=/var/log/mysqld.log
  332.  
  333. [mysqld_safe]
  334. pid-file=/var/run/mysqld/mysqld.pid
  335.  
  336. [client]
  337. socket=/var/lib/mysql-cluster/mysql.sock
  338.  
  339. [mysql_cluster]
  340. ndb-connectstring=10.3.65.1,10.3.65.22
  341.  
  342. =================================================================================
  343.  
  344.  
  345. ▼InnoDB my.cnf
  346. [mysqld]
  347.  
  348. datadir=/var/lib/mysql
  349.  
  350. max_connections = 8192
  351. character-set-server = utf8
  352. skip-external-locking
  353. key_buffer_size = 16M
  354. max_allowed_packet = 16M
  355. sort_buffer_size = 64K
  356. net_buffer_length = 8K
  357. read_buffer_size = 256K
  358. read_rnd_buffer_size = 512K
  359. join_buffer_size = 64K
  360. myisam_sort_buffer_size = 8M
  361. loose-query_cache_type = 0
  362. loose-query_cache_size = 0
  363. loose-query_cache_limit = 2M
  364. thread_cache_size = 1024
  365. table_open_cache = 20480
  366. table_open_cache_instances = 16
  367.  
  368. max_heap_table_size = 128M
  369. tmp_table_size = 64M
  370.  
  371. performance_schema = ON
  372.  
  373. innodb_monitor_enable = 'all'
  374.  
  375. back_log = 1024
  376.  
  377. sync_binlog = 1
  378. skip-log-bin
  379. #log-bin=mysql-bin
  380. log_slave_updates
  381. master_info_repository = TABLE
  382. relay_log_info_repository = TABLE
  383. binlog_format=row
  384. server-id = 21
  385. expire_logs_days = 7
  386.  
  387. gtid_mode = ON
  388. enforce_gtid_consistency = ON
  389.  
  390. open_files_limit = 65535
  391. max_prepared_stmt_count = 65528
  392.  
  393. innodb_strict_mode
  394. loose-innodb_file_format = Barracuda
  395. innodb_buffer_pool_instances = 20
  396. innodb_buffer_pool_size = 84G
  397. innodb_log_buffer_size = 64M
  398. innodb_log_file_size = 1G
  399. innodb_log_files_in_group = 4
  400. innodb_max_dirty_pages_pct = 90
  401. innodb_max_dirty_pages_pct_lwm = 10
  402. innodb_flush_method = O_DIRECT
  403. innodb_thread_concurrency = 0
  404. innodb_purge_threads = 4
  405. innodb_read_io_threads = 16
  406. innodb_write_io_threads = 16
  407. innodb_flush_neighbors = 0
  408. innodb_io_capacity = 10000
  409. innodb_io_capacity_max = 15000
  410. innodb_lru_scan_depth = 4000
  411. innodb_open_files = 3000
  412.  
  413. innodb_print_all_deadlocks = 1
  414.  
  415. innodb_change_buffer_max_size = 10
  416.  
  417. innodb_checksums = 1
  418. innodb_checksum_algorithm = crc32
  419.  
  420. innodb_adaptive_flushing = 1
  421. innodb_adaptive_flushing_lwm = 10
  422. innodb_read_ahead_threshold = 0
  423.  
  424. innodb_max_purge_lag_delay=1000000
  425. innodb_max_purge_lag=100000
  426.  
  427. log_timestamps = SYSTEM
  428. innodb_buffer_pool_dump_at_shutdown = ON
  429. innodb_buffer_pool_load_at_startup = OFF
  430. innodb_buffer_pool_dump_pct = 100
  431. innodb_page_cleaners = 24
  432. innodb_numa_interleave = ON
  433.  
  434. skip-name-resolve
  435.  
  436. log_error = /var/lib/mysql/mysql.err
  437.  
  438. [mysql]
  439. no-auto-rehash
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
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
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!