Overall system memory usage is very high for CMPs
Bug #1315783 reported by
QF Chen
This bug affects 1 person
| Affects | Status | Importance | Assigned to | Milestone | |
|---|---|---|---|---|---|
| Trafodion |
Fix Released
|
Critical
|
QF Chen | ||
Bug Description
Peter and Guy reported that overall memory usage for CMP is high. On average, it is 140-170MB per CMP. The current max JVM heap size is set at 4GB.
So it is critical to reduce the number CMPs.
This fix reduces the CMPs per executor from 3 to 2.
Revision history for this message
| QF Chen (qifan-chen) wrote | #1 |
| Changed in trafodion: | |
| assignee: | nobody → QF Chen (qifan-chen) |
| importance: | Undecided → Critical |
| milestone: | none → r0.6 |
| status: | New → Triaged |
| information type: | Proprietary → Public |
Revision history for this message
| QF Chen (qifan-chen) wrote | #2 |
| Changed in trafodion: | |
| status: | Triaged → Fix Committed |
| tags: | added: performance sql-cmp |
| Changed in trafodion: | |
| status: | Fix Committed → Fix Released |
To post a comment you must log in.
The fix prevents code from fetch histogram for meta-data tables and histogram tables.