[server] Settings
Server settings in vectorwise.conf affect the X100 Server.
max_profiles_per_database
Specifies the number of profiles to keep in memory for a database. If exceeded, oldest profiles are dropped.
Default: 1
max_profiles_per_session
Specifies the number of profiles to keep in memory for a session.
Default: 1
port
Specifies the TCP/IP port on which the X100 Server will listen for connections.
If zero or omitted, the server will dynamically assign a port when it first starts up. A nonzero value should only be defined in a database specific vectorwise.dbname.conf; it must not be defined in the installation-wide vectorwise.conf.
A fixed nonzero port number can be useful in situations where remote direct connections are needed, such as from the vwload utility, and there is a firewall between the client and server. In such cases, the fixed port can be made known to the firewall to allow vwload to connect to the X100 Server. The system administrator should choose a port that does not conflict with other listen ports on the network.
Default: 0
profile_per_query
Generates a profile file for each query. The profiles will be saved in the directory dbname/CBM/profiles in timestamp-named files. Valid values: true and false.
Default: false
profile_per_query_dir
Specifies the directory to which profile files are written when using profile_per_query = true.
The installation owner must have write permission to the directory.
Default: empty
profile_maxfiles
Specifies the maximum number of profile files retained when using profile_per_query = true. When this threshold is exceeded, the profile files are deleted (starting from the oldest ones) until the limit is met.
Default: 1000
profile_maxsize
Specifies the maximum total size (in bytes) of profile files retained when using profile_per_query = true. When this threshold is exceeded, the profile files are deleted (starting from the oldest ones) until the limit is met.
Default: 100M
profiling
Collects and prints profiling information. Setting this parameter to false may give the highest performance on short-running queries.
Default: true
vwlog_rotation_use_size_threshold (bool):
If true, the log file will get rotated automatically after surpassing a size limit that can be specified by setting the below property.
DEFAULT: false
vwlog_rotation_size_threshold:
Must be a value between 4M and 4G.
DEFAULT: 200M
vwlog_rotation_use_time_threshold (bool):
If true, the log file will get rotated automatically after a fixed duration. This can be specified by setting the below property.
DEFAULT: false
vwlog_rotation_time_interval:
Must be iso-8601 format: “P[#days]DT[#hours]H[#minutes]M[#seconds]S”
'P' stands for 'period', i.e., days, weeks, months, and years; 'T' stand for 'time', i.e., hours, minutes, and seconds.
Note that 'D' (days) is the largest valid input measure, 'Y' (years), 'M' (months), and 'W' (weeks) are not supported. If 'days' is the smallest unit that is used, then the letter 'T' is optional (e.g. P1D (1 day) is the same as P1DT). However, it is mandatory that the string should begin with a 'P'. Further examples for valid intervals are:
PT1H (1 hour), PT12H30M, P2D4H30M15S, …
DEFAULT: P1D
Must be between PT30M and P180D.
vwlog_rotation_use_auto_compression (bool):
Enable or disable the automatic compression of rotated log files. If enabled, the old log file will get compressed to .gz format.
DEFAULT: false
Last modified date: 08/14/2024