[MCOL-3585] update some defaults in config file Created: 2019-11-04 Updated: 2019-12-05 Resolved: 2019-11-22 |
|
| Status: | Closed |
| Project: | MariaDB ColumnStore |
| Component/s: | ExeMgr |
| Affects Version/s: | 1.4.0 |
| Fix Version/s: | 1.4.1 |
| Type: | Task | Priority: | Major |
| Reporter: | Patrick LeBlanc (Inactive) | Assignee: | Patrick LeBlanc (Inactive) |
| Resolution: | Done | Votes: | 0 |
| Labels: | None | ||
| Sprint: | 2019-06 |
| Description |
|
Some of the defaults are more appropriate to the machines ~ 10-15 years ago. Time to update... 1) PM join threshold. With ssds it makes sense to take some mem from cache and use it for larger pm joins. I would suggest a min of 1GB. The key is named PmMaxMemorySmallSide. There also isn't much reason to have large buffers between jobsteps, so I would suggest trimming FifoSizeLargeSide, and FifoSize. Benchmark a little to confirm. |
| Comments |
| Comment by Jose Rojas (Inactive) [ 2019-11-21 ] |
|
Updated PmMaxMemorySmall, FifoSizeLargeSize, and FifoSize settings from config file. RowAggrThreads and RowAggrBuckets are already being automated. I updated automation. Now automating MaxOutstandingRequests as well. Decreasing FifoSize and FifoSizeLargeSide did not cause any performance hit. |
| Comment by Patrick LeBlanc (Inactive) [ 2019-11-22 ] |
|
Merged it |