Bug #37632 ALL REPORT MEM spams to stdout

• Submitted: 25 Jun 2008 14:25
• Modified: 3 Mar 2010 11:56
• Reporter: Johan Andersson
• Status: Closed
• Category: MySQL Cluster: Cluster (NDB) storage engine
• Severity: S3 (Non-critical)
• Version: mysql-5.1-telco-7.0
• OS: Any
• Assigned to: Magnus Blåudd
• CPU Architecture: Any
• Tags: all report mem, MySQL Cluster 6.X, NDB_MGM

[25 Jun 2008 14:25] Johan Andersson

Description:
"all report mem" spams to std out when MemReportFrequency is set.
 

without MemReportFrequency in config.ini:

ndb_mgm> Node 3: Data usage is 0%(26 32K pages of total 32768)
Node 3: Index usage is 0%(13 8K pages of total 16416)
Node 4: Data usage is 0%(26 32K pages of total 32768)
Node 4: Index usage is 0%(13 8K pages of total 16416)
Node 5: Data usage is 0%(26 32K pages of total 32768)
Node 5: Index usage is 0%(13 8K pages of total 16416)
Node 6: Data usage is 0%(26 32K pages of total 32768)
Node 6: Index usage is 0%(13 8K pages of total 16416)

ndb_mgm> 

ndb_mgm> all report mem
Connected to Management Server at: localhost:1186

With MemReportFrequency in config.ini

ndb_mgm> Node 3: Data usage is 0%(26 32K pages of total 32768)
Node 3: Index usage is 0%(13 8K pages of total 16416)
Node 4: Data usage is 0%(26 32K pages of total 32768)
Node 4: Index usage is 0%(13 8K pages of total 16416)
Node 5: Data usage is 0%(26 32K pages of total 32768)
Node 5: Index usage is 0%(13 8K pages of total 16416)
Node 6: Data usage is 0%(26 32K pages of total 32768)
Node 6: Index usage is 0%(13 8K pages of total 16416)
Node 6: Data usage is 0%(26 32K pages of total 32768)
Node 6: Index usage is 0%(13 8K pages of total 16416)
Node 3: Data usage is 0%(26 32K pages of total 32768)
Node 3: Index usage is 0%(13 8K pages of total 16416)
Node 5: Data usage is 0%(26 32K pages of total 32768)
Node 5: Index usage is 0%(13 8K pages of total 16416)
Node 4: Data usage is 0%(26 32K pages of total 32768)
Node 4: Index usage is 0%(13 8K pages of total 16416)
Node 6: Data usage is 0%(26 32K pages of total 32768)
Node 6: Index usage is 0%(13 8K pages of total 16416)
Node 3: Data usage is 0%(26 32K pages of total 32768)
Node 3: Index usage is 0%(13 8K pages of total 16416)
Node 5: Data usage is 0%(26 32K pages of total 32768)
Node 5: Index usage is 0%(13 8K pages of total 16416)
Node 4: Data usage is 0%(26 32K pages of total 32768)
Node 4: Index usage is 0%(13 8K pages of total 16416)
Node 6: Data usage is 0%(26 32K pages of total 32768)
Node 6: Index usage is 0%(13 8K pages of total 16416)
Node 3: Data usage is 0%(26 32K pages of total 32768)
Node 3: Index usage is 0%(13 8K pages of total 16416)

How to repeat:
start a cluster with 
MemReportFrequency=10

ndb_mgm> 
all report mem

start a cluster without MemReportFrequency

ndb_mgm>
all report mem

Suggested fix:
print it only once in case MemReport.. is set.

[25 Jun 2008 19:36] Sveta Smirnova

Thank you for the report.

Verified as described using mysql-5.1-telco-6.4 tree.

[22 May 2009 8:40] Johan Andersson

Its in all versions 6.3,7.0 :(

[2 Mar 2010 9:31] Bugs System

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/102006

[2 Mar 2010 17:59] Bugs System

Pushed into 5.1.41-ndb-7.0.14 (revid:[e-mail]-20100302174920-7j3bpj5kjfg54b69) (version source revid:[e-mail]-20100302171239-97hayyf3l0q2rrz3) (merge vers: 5.1.41-ndb-7.0.14) (pib:16)

[2 Mar 2010 18:00] Bugs System

Pushed into 5.1.41-ndb-6.3.33 (revid:[e-mail]-20100302171238-yphjt5qcs8epldzm) (version source revid:[e-mail]-20100302171238-yphjt5qcs8epldzm) (merge vers: 5.1.41-ndb-6.3.33) (pib:16)

[3 Mar 2010 10:15] Magnus Blåudd

Pushed to 6.3.33, 7.0.14 and 7.1.2-beta

[3 Mar 2010 11:56] Jon Stephens

Documented bugfix in the NDB-6.3.33. 7.0.14, and 7.1.2 changelogs, as follows:

        When the MemReportFrequency configuration parameter was set in
        config.ini, the ndb_mgm client REPORT MEMORYUSAGE command
        printed its output multiple times.

Closed.