Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- mysqlimport: Error: 1114, The table 'doc_archive' is full, when using table: doc_archive
- ndb_mgm> all report memory
- Node 31: Data usage is 45%(179865 32K pages of total 393216)
- Node 31: Index usage is 67%(88761 8K pages of total 131200)
- Node 32: Data usage is 45%(179863 32K pages of total 393216)
- Node 32: Index usage is 67%(88761 8K pages of total 131200)
- [ndbd default]
- # Options affecting ndbd processes on all data nodes:
- NoOfReplicas=2 # Number of replicas
- DataMemory=12G # How much memory to allocate for data storage
- IndexMemory=1G # How much memory to allocate for index storage
- # For DataMemory and IndexMemory, we have used the
- # default values. Since the "world" database takes up
- # only about 500KB, this should be more than enough for
- # this example Cluster setup.
- MaxNoOfOrderedIndexes=8192
- MaxNoOfUniqueHashIndexes=512
- MaxNoOfAttributes=100000
- MaxNoOfExecutionThreads=8
- MaxNoOfConcurrentOperations=256000
- MaxNoOfTables=2048
- MaxBufferedEpochs=100000
- TimeBetweenEpochsTimeout=32000
- TransactionDeadlockDetectionTimeout=1000000
- TransactionInactiveTimeout=10000000
- MaxNoOfTriggers=3072 # Default is 768
- datadir=/var/lib/mysql-cluster # Directory for this data node's data files
- serverport=1187
- NoOfFragmentLogFiles=1125
- RedoBuffer=32M
- [ndb_mgmd]
- # Management process options:
- nodeid=30
- hostname=192.168.2.30
- datadir=/var/lib/mysql-cluster
- [ndbd]
- nodeid=31
- hostname=192.168.2.31
- [ndbd]
- nodeid=32
- hostname=192.168.2.32
- [mysqld]
- nodeid=33
- hostname=192.168.2.33
- [mysqld]
- nodeid=34
- hostname=192.168.2.34
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement