Bug #40088 Without MemReportFrequency DUMP MEMORY USAGE returns no results to the ndb_mgm>

• Submitted: 16 Oct 2008 19:47
• Modified: 9 Sep 2009 19:12
• Reporter: Matthew Montgomery
• Status: Closed
• Category: MySQL Cluster: Cluster (NDB) storage engine
• Severity: S3 (Non-critical)
• Version: mysql-5.1-telco-7.0
• OS: Linux
• Assigned to: Bernd Ocklin
• CPU Architecture: Any
• Tags: 5.1-telco-6.4 -> 6.4.0

[16 Oct 2008 19:47] Matthew Montgomery

Description:
Using ALL REPORT MEMORY USAGE does not return the results to the ndb_mgm> screen.

When MemReportFrequency is set ALL REPORT... does behave like ALL DUMP 1000 and return usage results.

ndb_mgm> all dump memory usage; 
Sending dump signal with data:
0x00000000 0x00000000 Sending dump signal with data:
0x00000000 0x00000000 

vrs.

ndb_mgm> all dump 1000 
Sending dump signal with data:
0x000003e8 Sending dump signal with data:
0x000003e8 
Node 2: Data usage is 0%(20 32K pages of total 2560)
ndb_mgm> Node 2: Index usage is 0%(16 8K pages of total 2336)
Node 3: Data usage is 0%(20 32K pages of total 2560)
Node 3: Index usage is 0%(16 8K pages of total 2336)

With MemReportFrequency defined I receive

ndb_mgm> all dump memory usage; 
Connected to Management Server at: 192.168.23.10:1186
Sending dump signal with data:
0x00000000 0x00000000 Sending dump signal with data:
0x00000000 0x00000000 
ndb_mgm> Node 2: Data usage is 1%(30 32K pages of total 2560)
Node 2: Index usage is 0%(22 8K pages of total 2336)
Node 3: Data usage is 1%(30 32K pages of total 2560)
Node 3: Index usage is 0%(22 8K pages of total 2336)

And same results:

ndb_mgm> all dump 1000
Sending dump signal with data:
0x000003e8 Sending dump signal with data:
0x000003e8 
Node 2: Data usage is 1%(30 32K pages of total 2560)
ndb_mgm> Node 2: Index usage is 0%(22 8K pages of total 2336)
Node 3: Data usage is 1%(30 32K pages of total 2560)
Node 3: Index usage is 0%(22 8K pages of total 2336)

How to repeat:
Do not set MemReportFrequency in the config.ini

Suggested fix:
Make ALL DUMP MEMORY USAGE behave as an alias of ALL DUMP 1000

[9 Sep 2009 19:12] MySQL Verification Team

Not reproduced using 7.0.7 - closing.

matt@silo:~/mysql/sandbox/7.0.7$ ndb_mgm
-- NDB Cluster -- Management Client --
ndb_mgm> all report mem
Connected to Management Server at: localhost:1186

Node 2: Data usage is 1%(30 32K pages of total 2560)
Node 2: Index usage is 6%(162 8K pages of total 2336)
Node 3: Data usage is 1%(30 32K pages of total 2560)
Node 3: Index usage is 6%(162 8K pages of total 2336)
ndb_mgm> 

$ cat config.ini 
[ndbd default]
NoOfReplicas=2
Datadir=/home/matt/mysql/sandbox/7.0.7/mysql-cluster

[ndb_mgmd]
Datadir=/home/matt/mysql/sandbox/7.0.7/mysql-cluster
Hostname=silo

[ndbd]
Hostname=silo
[ndbd]
Hostname=silo

[API]
[API]
[API]