本文共 15371 字,大约阅读时间需要 51 分钟。
PSjamsBond-0-0-0:/root-# cat /DDM_SUBTREE/usr/dhafw/data/mysql/config.ini
# file "config.ini" - showing minimal setup with 1 DB node # This file is placed in the start directory of ndb_mgmd, # the management server.# 09-02-2012 FV CRI # 00633278.01 : ACOS #54804 : db status is always KOM after using WA in ticket 54582
[API DEFAULT]
[TCP DEFAULT]
#PortNumber: 28002SendBufferMemory = 3M
[NDB_MGMD DEFAULT] PortNumber = 2200 DataDir=/var/local/nectar/log[NDB_MGMD] id=1 hostname=STATION_A ArbitrationRank: 1
[NDBD DEFAULT] ServerPort = 28002
DataDir=/user/database/log #DataDir=/var/local/nectar/log/ NoOfReplicas = 1 DataMemory = 5000M IndexMemory = 650M MaxLCPStartDelay: 300 MaxNoOfSavedMessages: 5 MaxNoOfSubscriptions: 2000 MaxNoOfSubscribers: 4000 LockPagesInMainMemory: 2 #StartPartialTimeout: 10000 StartPartitionedTimeout: 60000 StartFailureTimeout: 0 HeartbeatIntervalDbDb: 3000 HeartbeatIntervalDbApi: 3000 ArbitrationTimeout: 30000 MaxNoOfOrderedIndexes: 500 MaxNoOfTables = 1000 MaxNoOfUniqueHashIndexes: 500 MaxNoOfAttributes: 5000 MaxNoOfTriggers: 2000 TimebetweenLocalCheckpoints: 20 TimebetweenGlobalCheckpoints: 2000 #TransactionInactiveTimeout: 0 TransactionDeadlockDetectionTimeout = 1000 TransactionInactiveTimeout: 500000 TimeBetweenInactiveTransactionAbortCheck: 1500 NoOfFragmentLogFiles = 16 InitFragmentLogFiles=full LogLevelStartup: 15 LogLevelShutdown: 15 LogLevelConnection: 15 LogLevelInfo: 15 LogLevelError: 15 LogLevelNodeRestart: 15 LogLevelCheckpoint: 1 StopOnError: Y DiskCheckpointSpeed=4M ODirect=1MaxNoOfConcurrentOperations = 65000
FragmentLogFileSize = 256M StartPartialTimeout = 30000 [NDBD] id=3 hostname=STATION_A FileSystemPath: /user/database/ndbd[MYSQLD] id=7 hostname=STATION_A
[MYSQLD]
[MYSQLD]
[MYSQLD]
[MYSQLD]
[MYSQLD]
[MYSQLD]
[MYSQLD]
[MYSQLD]
PSjamsBond-0-0-0:/root-# ddmEnv
PSjamsBond-0-0-0:/root-# ndb_mgm -- NDB Cluster -- Management Client --
PSjamsBond-0-0-0:/root-# ddmEnv
PSjamsBond-0-0-0:/root-# ndb_mgm -- NDB Cluster -- Management Client -- ndb_mgm> show; Connected to Management Server at: STATION_A:2200 Cluster Configuration --------------------- [ndbd(NDB)] 1 node(s) id=3 @169.254.200.1 (mysql-5.1.61 ndb-7.1.22, Nodegroup: 0, Master)[ndb_mgmd(MGM)] 1 node(s) id=1 @169.254.200.1 (mysql-5.1.61 ndb-7.1.22)
[mysqld(API)] 235 node(s) id=7 @169.254.200.1 (mysql-5.1.61 ndb-7.1.22)
id=8 (not connected, accepting connect from any host) id=9 (not connected, accepting connect from any host) id=10 (not connected, accepting connect from any host) id=11 (not connected, accepting connect from any host) id=12 (not connected, accepting connect from any host) id=13 (not connected, accepting connect from any host) id=14 (not connected, accepting connect from any host) id=15 (not connected, accepting connect from any host) id=16 (not connected, accepting connect from any host) id=17 (not connected, accepting connect from any host) id=18 (not connected, accepting connect from any host) id=19 (not connected, accepting connect from any host) id=20 (not connected, accepting connect from any host) id=21 (not connected, accepting connect from any host) id=22 (not connected, accepting connect from any host) id=23 (not connected, accepting connect from any host) id=24 (not connected, accepting connect from any host) id=25 (not connected, accepting connect from any host) id=26 (not connected, accepting connect from any host) id=27 (not connected, accepting connect from any host) id=28 (not connected, accepting connect from any host) id=29 (not connected, accepting connect from any host) id=30 (not connected, accepting connect from any host) id=31 (not connected, accepting connect from any host) id=32 (not connected, accepting connect from any host) id=33 (not connected, accepting connect from any host) id=34 (not connected, accepting connect from any host) id=35 (not connected, accepting connect from any host) id=36 (not connected, accepting connect from any host) id=37 (not connected, accepting connect from any host) id=38 (not connected, accepting connect from any host) id=39 (not connected, accepting connect from any host) id=40 (not connected, accepting connect from any host) id=41 (not connected, accepting connect from any host) id=42 (not connected, accepting connect from any host) id=43 (not connected, accepting connect from any host) id=44 (not connected, accepting connect from any host) id=45 (not connected, accepting connect from any host) id=46 (not connected, accepting connect from any host) id=47 (not connected, accepting connect from any host) id=48 (not connected, accepting connect from any host) id=49 (not connected, accepting connect from any host) id=50 (not connected, accepting connect from any host) id=51 (not connected, accepting connect from any host) id=52 (not connected, accepting connect from any host) id=53 (not connected, accepting connect from any host) id=54 (not connected, accepting connect from any host) id=55 (not connected, accepting connect from any host) id=56 (not connected, accepting connect from any host) id=57 (not connected, accepting connect from any host) id=58 (not connected, accepting connect from any host) id=59 (not connected, accepting connect from any host) id=60 (not connected, accepting connect from any host) id=61 (not connected, accepting connect from any host) id=62 (not connected, accepting connect from any host) id=63 (not connected, accepting connect from any host) id=64 (not connected, accepting connect from any host) id=65 (not connected, accepting connect from any host) id=66 (not connected, accepting connect from any host) id=67 (not connected, accepting connect from any host) id=68 (not connected, accepting connect from any host) id=69 (not connected, accepting connect from any host) id=70 (not connected, accepting connect from any host) id=71 (not connected, accepting connect from any host) id=72 (not connected, accepting connect from any host) id=73 (not connected, accepting connect from any host) id=74 (not connected, accepting connect from any host) id=75 (not connected, accepting connect from any host) id=76 (not connected, accepting connect from any host) id=77 (not connected, accepting connect from any host) id=78 (not connected, accepting connect from any host) id=79 (not connected, accepting connect from any host) id=80 (not connected, accepting connect from any host) id=81 (not connected, accepting connect from any host) id=82 (not connected, accepting connect from any host) id=83 (not connected, accepting connect from any host) id=84 (not connected, accepting connect from any host) id=85 (not connected, accepting connect from any host) id=86 (not connected, accepting connect from any host) id=87 (not connected, accepting connect from any host) id=88 (not connected, accepting connect from any host) id=89 (not connected, accepting connect from any host) id=90 (not connected, accepting connect from any host) id=91 (not connected, accepting connect from any host) id=92 (not connected, accepting connect from any host) id=93 (not connected, accepting connect from any host) id=94 (not connected, accepting connect from any host) id=95 (not connected, accepting connect from any host) id=96 (not connected, accepting connect from any host) id=97 (not connected, accepting connect from any host) id=98 (not connected, accepting connect from any host) id=99 (not connected, accepting connect from any host) id=100 (not connected, accepting connect from any host) id=101 (not connected, accepting connect from any host) id=102 (not connected, accepting connect from any host) id=103 (not connected, accepting connect from any host) id=104 (not connected, accepting connect from any host) id=105 (not connected, accepting connect from any host) id=106 (not connected, accepting connect from any host) id=107 (not connected, accepting connect from any host) id=108 (not connected, accepting connect from any host) id=109 (not connected, accepting connect from any host) id=110 (not connected, accepting connect from any host) id=111 (not connected, accepting connect from any host) id=112 (not connected, accepting connect from any host) id=113 (not connected, accepting connect from any host) id=114 (not connected, accepting connect from any host) id=115 (not connected, accepting connect from any host) id=116 (not connected, accepting connect from any host) id=117 (not connected, accepting connect from any host) id=118 (not connected, accepting connect from any host) id=119 (not connected, accepting connect from any host) id=120 (not connected, accepting connect from any host) id=121 (not connected, accepting connect from any host) id=122 (not connected, accepting connect from any host) id=123 (not connected, accepting connect from any host) id=124 (not connected, accepting connect from any host) id=125 (not connected, accepting connect from any host) id=126 (not connected, accepting connect from any host) id=127 (not connected, accepting connect from any host) id=128 (not connected, accepting connect from any host) id=129 (not connected, accepting connect from any host) id=130 (not connected, accepting connect from any host) id=131 (not connected, accepting connect from any host) id=132 (not connected, accepting connect from any host) id=133 (not connected, accepting connect from any host) id=134 (not connected, accepting connect from any host) id=135 (not connected, accepting connect from any host) id=136 (not connected, accepting connect from any host) id=137 (not connected, accepting connect from any host) id=138 (not connected, accepting connect from any host) id=139 (not connected, accepting connect from any host) id=140 (not connected, accepting connect from any host) id=141 (not connected, accepting connect from any host) id=142 (not connected, accepting connect from any host) id=143 (not connected, accepting connect from any host) id=144 (not connected, accepting connect from any host) id=145 (not connected, accepting connect from any host) id=146 (not connected, accepting connect from any host) id=147 (not connected, accepting connect from any host) id=148 (not connected, accepting connect from any host) id=149 (not connected, accepting connect from any host) id=150 (not connected, accepting connect from any host) id=151 (not connected, accepting connect from any host) id=152 (not connected, accepting connect from any host) id=153 (not connected, accepting connect from any host) id=154 (not connected, accepting connect from any host) id=155 (not connected, accepting connect from any host) id=156 (not connected, accepting connect from any host) id=157 (not connected, accepting connect from any host) id=158 (not connected, accepting connect from any host) id=159 (not connected, accepting connect from any host) id=160 (not connected, accepting connect from any host) id=161 (not connected, accepting connect from any host) id=162 (not connected, accepting connect from any host) id=163 (not connected, accepting connect from any host) id=164 (not connected, accepting connect from any host) id=165 (not connected, accepting connect from any host) id=166 (not connected, accepting connect from any host) id=167 (not connected, accepting connect from any host) id=168 (not connected, accepting connect from any host) id=169 (not connected, accepting connect from any host) id=170 (not connected, accepting connect from any host) id=171 (not connected, accepting connect from any host) id=172 (not connected, accepting connect from any host) id=173 (not connected, accepting connect from any host) id=174 (not connected, accepting connect from any host) id=175 (not connected, accepting connect from any host) id=176 (not connected, accepting connect from any host) id=177 (not connected, accepting connect from any host) id=178 (not connected, accepting connect from any host) id=179 (not connected, accepting connect from any host) id=180 (not connected, accepting connect from any host) id=181 (not connected, accepting connect from any host) id=182 (not connected, accepting connect from any host) id=183 (not connected, accepting connect from any host) id=184 (not connected, accepting connect from any host) id=185 (not connected, accepting connect from any host) id=186 (not connected, accepting connect from any host) id=187 (not connected, accepting connect from any host) id=188 (not connected, accepting connect from any host) id=189 (not connected, accepting connect from any host) id=190 (not connected, accepting connect from any host) id=191 (not connected, accepting connect from any host) id=192 (not connected, accepting connect from any host) id=193 (not connected, accepting connect from any host) id=194 (not connected, accepting connect from any host) id=195 (not connected, accepting connect from any host) id=196 (not connected, accepting connect from any host) id=197 (not connected, accepting connect from any host) id=198 (not connected, accepting connect from any host) id=199 (not connected, accepting connect from any host) id=200 (not connected, accepting connect from any host) id=201 (not connected, accepting connect from any host) id=202 (not connected, accepting connect from any host) id=203 (not connected, accepting connect from any host) id=204 (not connected, accepting connect from any host) id=205 (not connected, accepting connect from any host) id=206 (not connected, accepting connect from any host) id=207 (not connected, accepting connect from any host) id=208 (not connected, accepting connect from any host) id=209 (not connected, accepting connect from any host) id=210 (not connected, accepting connect from any host) id=211 (not connected, accepting connect from any host) id=212 (not connected, accepting connect from any host) id=213 (not connected, accepting connect from any host) id=214 (not connected, accepting connect from any host) id=215 (not connected, accepting connect from any host) id=216 (not connected, accepting connect from any host) id=217 (not connected, accepting connect from any host) id=218 (not connected, accepting connect from any host) id=219 (not connected, accepting connect from any host) id=220 (not connected, accepting connect from any host) id=221 (not connected, accepting connect from any host) id=222 (not connected, accepting connect from any host) id=223 (not connected, accepting connect from any host) id=224 (not connected, accepting connect from any host) id=225 (not connected, accepting connect from any host) id=226 (not connected, accepting connect from any host) id=227 (not connected, accepting connect from any host) id=228 (not connected, accepting connect from any host) id=229 (not connected, accepting connect from any host) id=230 (not connected, accepting connect from any host) id=231 (not connected, accepting connect from any host) id=232 (not connected, accepting connect from any host) id=233 (not connected, accepting connect from any host) id=234 (not connected, accepting connect from any host) id=235 (not connected, accepting connect from any host) id=236 (not connected, accepting connect from any host) id=237 (not connected, accepting connect from any host) id=238 (not connected, accepting connect from any host) id=239 (not connected, accepting connect from any host) id=240 (not connected, accepting connect from any host) id=241 (not connected, accepting connect from any host)ndb_mgm>
转载地址:https://kerry.blog.csdn.net/article/details/8751110 如侵犯您的版权,请留言回复原文章的地址,我们会给您删除此文章,给您带来不便请您谅解!