CONNECT System Variables
You are viewing an old version of this article. View
the current version here.
Contents
This page documents system variables related to the CONNECT storage engine. See Server System Variables for a complete list of system variables and instructions on setting them.
See also the Full list of MariaDB options, system and status variables.
connect_conv_size
- Description: The size of the VARCHAR created when converting from a TEXT type. See connect_type_conv.
- Commandline:
--connect-conv-size=#
- Scope: Session (> MariaDB 10.0.17), Global (<= MariaDB 10.0.16)
- Dynamic: Yes
- Data Type:
numeric
- Default Value:
8192
- Range:
0
to65500
connect_exact_info
- Description: Whether or not the CONNECT engine should return an exact record number value to information queries. It is OFF by default because this information can take a very long time for large variable record length tables or for remote tables, especially if the remote server is not available. It can be set to ON when exact values are desired, for instance when querying the repartition of rows in a partition table.
- Commandline:
--connect-exact-info=#
- Scope: Session
- Dynamic: Yes
- Data Type:
boolean
- Default Value:
OFF
- Introduced:
MariaDB 10.0.15
connect_indx_map
- Description: Enable file mapping for index files. To accelerate the indexing process, CONNECT makes an index structure in memory from the index file. This can be done by reading the index file or using it as if it was in memory by “file mapping”. Set to 0 (file read, the default) or 1 (file mapping).
- Commandline:
--connect-indx-map=#
- Scope: Global
- Dynamic: Yes
- Data Type:
boolean
- Default Value:
OFF
connect_type_conv
- Description: Determines the handling of TEXT columns.
NO
: The default, no conversion takes place, and a TYPE_ERROR is returned, resulting in a “not supported” message.YES
: The column is internally converted to a column declared as VARCHAR(n),n
being the value of connect_conv_size.SKIP
: No conversion. When the column declaration is provided via Discovery (meaning the CONNECT table is created without a column description), this column is not generated. Also applies to ODBC tables.
- Commandline:
--connect-type-conv=#
- Scope: Session (> MariaDB 10.0.17), Global (<= MariaDB 10.0.16)
- Dynamic: Yes
- Data Type:
enum
- Valid Values:
NO
,YES
orSKIP
- Default Value:
NO
connect_use_tempfile
- Description:
NO
: The first algorithm is always used. Because it can cause errors when updating variable record length tables, this value should be set only for testing.AUTO
: This is the default value. It leaves CONNECT to choose the algorithm to use. Currently it is equivalent toNO
, except when updating variable record length tables (DOS, CSV or FMT) with file mapping forced to OFF.YES
: Using a temporary file is chosen with some exceptions. These are when file mapping is ON, for VEC tables and when deleting from DBF tables (soft delete). For variable record length tables, file mapping is forced to OFF.FORCE
: Like YES but forces file mapping to be OFF for all table types.TEST
: Reserved for CONNECT development.
- Commandline:
--connect-use-tempfile=#
- Scope: Session
- Dynamic: Yes
- Data Type:
enum
- Default Value:
AUTO
- Introduced:
MariaDB 10.0.15
connect_work_size
- Description: Size of the CONNECT work area used for memory allocation. Permits allocating a larger memory sub-allocation space when dealing with very large if sub-allocation fails. If the specified value is too big and memory allocation fails, the size of the work area remains but the variable value is not modified and should be reset.
- Commandline:
--connect-work-size=#
- Scope: Global, Session (Session-only from CONNECT 1.03.005)
- Dynamic: Yes
- Data Type:
numeric
- Default Value:
67108864
- Range:
4194304
upwards, depending on the physical memory size - Introduced:
MariaDB 10.0.11
connect_xtrace
- Description: Console trace value. Set n to
0
(no trace), to 1 or 2 (more trace) if a console tracing is desired. Note that to test this handler, MariaDB should be executed with the --console parameter because CONNECT prints some error and trace messages on the console. - Commandline:
--connect-xtrace=#
- Scope: Global
- Dynamic: Yes
- Data Type:
numeric
- Default Value:
0
- Range:
0
to2147483647
Comments
Comments loading...
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.