Bug #4592 Memory not accounted for

• Submitted: 17 Jul 2004 19:39
• Modified: 27 Jul 2004 2:09
• Reporter: Johan Andersson
• Status: Not a Bug
• Category: MySQL Cluster: Cluster (NDB) storage engine
• Severity: S3 (Non-critical)
• Version: mysql 4.1 bk src
• OS: Linux (RH9)
• Assigned to: Jonas Oreland
• CPU Architecture: Any

[17 Jul 2004 19:39] Johan Andersson

Description:
Memory is not accounted for. We need to know how much memory that is consumed by one db node:
1) with default configuration (should be stated in documentation)
2) List in documenatation how much each config item requires (i.e, how much does one Operation record require, one Transaction record, what is the implication of memory if setting MaxNoOfTables to 128 instead of 32?)... etc...

How to repeat:
 

Suggested fix:
Add a command at mysql client that shows how much and where the memory has been allocated:
SHOW STATUS NDB 2

Config property                  current setting   memory used
MaxNoOfOperations         8192                   8MB
Communication buffers                                16MB
DataMemory                       256MB               256MB

Total:                                                                280MB

[27 Jul 2004 2:09] Jonas Oreland

This is a feature request, please add a WL-entry and have Martin prioritize it.