8.2.21 DUMP 1000

CodeSymbolKernel Block(s)
1000DumpPageMemoryDBACC, DBTUP

Description.  Prints data node memory usage (ACC and TUP), as both a number of data pages, and the percentage of DataMemory and IndexMemory used.

Sample Output. 

2014-10-15 12:06:29 [MgmtSrvr] INFO     -- Node 5: Data usage is 0%(12 32K pages of total 32768)
2014-10-15 12:06:29 [MgmtSrvr] INFO     -- Node 5: Index usage is 0%(24 8K pages of total 131104)
2014-10-15 12:06:29 [MgmtSrvr] INFO     -- Node 5: Resource 0 min: 34186 max: 74615 curr: 36334
2014-10-15 12:06:29 [MgmtSrvr] INFO     -- Node 5: Resource 3 min: 65544 max: 65544 curr: 32788
2014-10-15 12:06:29 [MgmtSrvr] INFO     -- Node 5: Resource 4 min: 720 max: 720 curr: 100
2014-10-15 12:06:29 [MgmtSrvr] INFO     -- Node 5: Resource 5 min: 1152 max: 1152 curr: 1088
2014-10-15 12:06:29 [MgmtSrvr] INFO     -- Node 5: Resource 6 min: 800 max: 1000 curr: 117
2014-10-15 12:06:29 [MgmtSrvr] INFO     -- Node 5: Resource 7 min: 2240 max: 2240 curr: 2240
2014-10-15 12:06:29 [MgmtSrvr] INFO     -- Node 5: Resource 9 min: 64 max: 0 curr: 1
2014-10-15 12:06:29 [MgmtSrvr] INFO     -- Node 6: Data usage is 0%(12 32K pages of total 32768)
2014-10-15 12:06:29 [MgmtSrvr] INFO     -- Node 6: Index usage is 0%(24 8K pages of total 131104)
2014-10-15 12:06:29 [MgmtSrvr] INFO     -- Node 6: Resource 0 min: 34207 max: 74615 curr: 36313
2014-10-15 12:06:29 [MgmtSrvr] INFO     -- Node 6: Resource 3 min: 65544 max: 65544 curr: 32788
2014-10-15 12:06:29 [MgmtSrvr] INFO     -- Node 6: Resource 4 min: 720 max: 720 curr: 95
2014-10-15 12:06:29 [MgmtSrvr] INFO     -- Node 6: Resource 5 min: 1152 max: 1152 curr: 1088
2014-10-15 12:06:29 [MgmtSrvr] INFO     -- Node 6: Resource 6 min: 800 max: 1000 curr: 102
2014-10-15 12:06:29 [MgmtSrvr] INFO     -- Node 6: Resource 7 min: 2240 max: 2240 curr: 2240
2014-10-15 12:06:29 [MgmtSrvr] INFO     -- Node 6: Resource 9 min: 64 max: 0 curr: 1

Note

When invoked as ALL DUMP 1000, this command reports memory usage for each data node separately, in turn.

Additional Information.  Beginning with MySQL Cluster NDB 6.2.3 and MySQL Cluster NDB 6.3.0, you can use the ndb_mgm client REPORT MEMORYUSAGE to obtain this information (see Commands in the MySQL Cluster Management Client). Beginning with MySQL Cluster NDB 7.1.0, you can also query the memoryusage table (in the ndbinfo database) for this information.