[MCOL-972] PmMaxMemorySmallSide configuration value not carried forward in upgrade Created: 2017-10-12  Updated: 2017-10-27  Resolved: 2017-10-27

Status: Closed
Project: MariaDB ColumnStore
Component/s: None
Affects Version/s: 1.1.0
Fix Version/s: 1.1.1

Type: Bug Priority: Minor
Reporter: David Hill (Inactive) Assignee: Daniel Lee (Inactive)
Resolution: Fixed Votes: 0
Labels: None

Sprint: 2017-21

 Description   

In a customer upgrade from 1.0 to 1.1, PmMaxMemorySmallSide change made during 1.0 wasn't carried forward during the 1.1 upgrade process.

Check other configuration settings referenced in any KB tuning documents and made sure that are added into the upgrade logic.

 Comments   
Comment by David Hill (Inactive) [ 2017-10-23 ]

Will add these Columnstore.xml to the upgrade parameter set. These are all referred to in the tuning guides:

ColScanReadAheadBlocks
PrefetchThreshold
MaxOutstandingRequests
PmMaxMemorySmallSide
AllowDiskBasedJoin
TempFileCompression
TempFilePath

Comment by David Hill (Inactive) [ 2017-10-23 ]

1.1.1 changes

commit 8a9508af9479fa6dfb9bdd196b11395e86daadfe
Merge: 6d7fd19 8706f0a
Author: david hill <david.hill@mariadb.com>
Date: Mon Oct 23 15:38:07 2017 -0500

1.2

commit 618fba4763caf74dfddcfa30cffaf82a67dba2dc
Author: david hill <david.hill@mariadb.com>
Date: Mon Oct 23 15:40:48 2017 -0500

MCOL-972 - added tuning parameters to upgrade process

tools/configMgt/autoConfigure.cpp | 34 ++++++++++++++++++++++++++++++++++

------------------------------------------
To test, on a installed system, change one or more of the new parameters listed early. then perform upgrade and made sure you change is carried forward.

Comment by Daniel Lee (Inactive) [ 2017-10-27 ]

Build verified: 1.1.1.-1 rpm package

Did a 1.0.12-1 installation and upgraded it to 1.1.1.-1 with the following customized parameter values:

ColScanReadAheadBlocks 512 to 1024
PrefetchThreshold 1 to 2
MaxOutstandingRequests 20 to 21
PmMaxMemorySmallSide 64m to 32m
AllowDiskBasedJoin N to Y
TempFileCompression Y to N
TempFilePath to /tmp

Generated at Thu Feb 08 02:25:12 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.