Advertisement
Guest User

Untitled

a guest
Aug 4th, 2015
184
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.55 KB | None | 0 0
  1. mysqlimport: Error: 1114, The table 'doc_archive' is full, when using table: doc_archive
  2.  
  3. ndb_mgm> all report memory
  4. Node 31: Data usage is 45%(179865 32K pages of total 393216)
  5. Node 31: Index usage is 67%(88761 8K pages of total 131200)
  6. Node 32: Data usage is 45%(179863 32K pages of total 393216)
  7. Node 32: Index usage is 67%(88761 8K pages of total 131200)
  8.  
  9. [ndbd default]
  10. # Options affecting ndbd processes on all data nodes:
  11.  
  12. NoOfReplicas=2 # Number of replicas
  13.  
  14. DataMemory=12G # How much memory to allocate for data storage
  15.  
  16. IndexMemory=1G # How much memory to allocate for index storage
  17. # For DataMemory and IndexMemory, we have used the
  18. # default values. Since the "world" database takes up
  19. # only about 500KB, this should be more than enough for
  20. # this example Cluster setup.
  21.  
  22. MaxNoOfOrderedIndexes=8192
  23. MaxNoOfUniqueHashIndexes=512
  24. MaxNoOfAttributes=100000
  25. MaxNoOfExecutionThreads=8
  26. MaxNoOfConcurrentOperations=256000
  27. MaxNoOfTables=2048
  28. MaxBufferedEpochs=100000
  29. TimeBetweenEpochsTimeout=32000
  30. TransactionDeadlockDetectionTimeout=1000000
  31. TransactionInactiveTimeout=10000000
  32. MaxNoOfTriggers=3072 # Default is 768
  33.  
  34. datadir=/var/lib/mysql-cluster # Directory for this data node's data files
  35. serverport=1187
  36.  
  37. NoOfFragmentLogFiles=1125
  38. RedoBuffer=32M
  39.  
  40. [ndb_mgmd]
  41. # Management process options:
  42. nodeid=30
  43. hostname=192.168.2.30
  44. datadir=/var/lib/mysql-cluster
  45.  
  46. [ndbd]
  47. nodeid=31
  48. hostname=192.168.2.31
  49.  
  50. [ndbd]
  51. nodeid=32
  52. hostname=192.168.2.32
  53.  
  54. [mysqld]
  55. nodeid=33
  56. hostname=192.168.2.33
  57.  
  58. [mysqld]
  59. nodeid=34
  60. hostname=192.168.2.34
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement