[MCOL-1448] Document how to enable the local query option during installation Created: 2018-05-30  Updated: 2018-05-30  Resolved: 2018-05-30

Status: Closed
Project: MariaDB ColumnStore
Component/s: Documentation
Affects Version/s: None
Fix Version/s: Icebox

Type: Task Priority: Major
Reporter: Geoff Montee (Inactive) Assignee: Geoff Montee (Inactive)
Resolution: Fixed Votes: 0
Labels: None


 Description   

The local query option can be enabled on Performance Modules (PMs). The documentation says:

To enable/disable the use of the local PM Query at the session level, the following command is used. Once the session has ended, any subsequent session will return to the default for the instance.

set infinidb_local_query = n
where n is:

  • 0 (disabled)
  • 1 (enabled)

  • At the session level, this variable applies only to executing a query on an individual PM and will error if executed on the UM. The PM must be set up with the local query option during installation.

https://mariadb.com/kb/en/library/configuring-columnstore-local-pm-query-mode/

It doesn't specifically say how to set up the local query option during installation. It looks like this is one of the questions asked by postConfigure. If this is how it's set up, maybe the page should mentioned postConfigure specifically, and then link to the relevant documentation page?

https://mariadb.com/kb/en/library/installing-and-configuring-a-multi-server-columnstore-system-11x/



 Comments   
Comment by David Hill (Inactive) [ 2018-05-30 ]

document updated

https://mariadb.com/kb/en/library/configuring-columnstore-local-pm-query-mode/

Comment by Geoff Montee (Inactive) [ 2018-05-30 ]

Thanks, hill!

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