[MCOL-446] mycnf config change request Created: 2016-12-06  Updated: 2020-08-25  Resolved: 2017-12-07

Status: Closed
Project: MariaDB ColumnStore
Component/s: None
Affects Version/s: 1.0.5
Fix Version/s: 1.0.12, 1.1.3

Type: New Feature Priority: Minor
Reporter: David Hill (Inactive) Assignee: Daniel Lee (Inactive)
Resolution: Fixed Votes: 1
Labels: None

Sprint: 2017-24

 Description   

Please consider adding these, at least the character set related items and max_length_for_sort_data to the file /usr/local/Calpont/bin/myCnf-include-args.text so that if a customer has them defined they get preserved during an upgrade. (values included for reference, as the file only contains the setting name)
The general and slow log items are not as important as the rest.

max_length_for_sort_data= 8388608
tmpdir = /db_storage/mysql_tmp/
log-error = /db_storage/log/mysqld.log
general_log_file = /db_storage/log/query.log
slow_query_log_file = /db_storage/log/slow_query.log
general-log = 0
slow-query-log = 0
character-set-server=utf8
collation-server=utf8_general_ci
init-connect='SET NAMES utf8'
binlog_format = ROW

please add this one to the list.
secure-auth

it defaults to off, allowing less secure password encryption to be used and stored in the mysql.users table.

http://dev.mysql.com/doc/refman/5.1/en/server-options.html#option_mysqld_secure-auth

 Comments   
Comment by David Hill (Inactive) [ 2016-12-06 ]

For InfiniDB Issue #10267

Comment by David Hill (Inactive) [ 2017-12-05 ]

Actually Ben just needs to see this this functionality works... This is a file that was intended for the customer to update where they can define what variables gets applied in my.cnf during an upgrade process. This was done for InfiniDB, just need to make sure the functionality still works and then we will need to get this documented.

Comment by Ben Thompson (Inactive) [ 2017-12-05 ]

Should only find strings in myCnf-include-args.text if it is preceeded by nothing but 'spaces' or '#' and followed by 'spaces' or '=' and will still update if a different setting is commented out earlier in the file.

example:
# tmpdir = /tmp
tmpdir = /different/tmp

the value will still be preserved in upgrade.

Comment by Daniel Lee (Inactive) [ 2017-12-07 ]

Builds verified: GitHub source

1.0.12-1

/root/columnstore/mariadb-columnstore-server
commit 7ec285d104a8e68320cbf14b44ee8509693fbda2
Merge: 25e9d05 f546eaf
Author: David.Hall <david.hall@mariadb.com>
Date: Wed Dec 6 10:04:56 2017 -0600

Merge pull request #81 from mariadb-corporation/MCOL-1082-1.0

MCOL-1082 Preserve row_count through vtable

/root/columnstore/mariadb-columnstore-server/mariadb-columnstore-engine
commit b295c8fc0f827546e81b4e50135eb8dceb2a3fb9
Merge: 22cb352 26f7344
Author: david hill <david.hill@mariadb.com>
Date: Wed Dec 6 11:02:56 2017 -0600

Merge pull request #340 from mariadb-corporation/MCOL-445

MCOL-445: Modify getConfig and setConfig to be case insensitive on va…

1.1.3-1

/root/columnstore/mariadb-columnstore-server
commit 0b3b26032aa60d2937cd06535946d7d8575cd4fd
Merge: 632e265 101ea14
Author: David.Hall <david.hall@mariadb.com>
Date: Wed Dec 6 10:05:32 2017 -0600

Merge pull request #80 from mariadb-corporation/MCOL-1082

MCOL-1082 Preserve row_count through vtable

/root/columnstore/mariadb-columnstore-server/mariadb-columnstore-engine
commit 71a901e8b38bca584ece8d7b070ad263c4b65c3f
Merge: 4d80266 addd719
Author: David.Hall <david.hall@mariadb.com>
Date: Wed Dec 6 11:17:49 2017 -0600

Merge pull request #341 from mariadb-corporation/MCOL-1083

MCOL-1083 Fix NULL row init for TEXT/BLOB

Verified that postConfigure handled the myCnf-include-args.text file during upgrade.

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