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_class_path
--connect-class-path=value
string
connect_cond_push
--connect-cond-push={0|1}
boolean
ON
connect_conv_size
--connect-conv-size=#
numeric
1024
8192
0
to 65500
connect_enable_mongo
--connect-enable-mongo={0|1}
boolean
OFF
connect_exact_info
--connect-exact-info=#
boolean
OFF
connect_indx_map
--connect-indx-map=#
boolean
OFF
connect_java_wrapper
--connect-java-wrapper=val
string
wrappers/JdbcInterface
connect_json_grp_size
--connect-json-grp-size=#
numeric
10
1
to 2147483647
connect_json_null
--connect-json-null=value
string
<null>
connect_jvm_path
--connect-jvm_path=value
string
connect_type_conv
NO
: The default until Connect 1.06.005, no conversion takes place, and a TYPE_ERROR is returned, resulting in a “not supported” message. YES
: The default from Connect 1.06.006. The column is internally converted to a column declared as VARCHAR(n), n
being the value of connect_conv_size. FORCE
(>= Connect 1.06.006): Also convert ODBC blob columns to TYPE_STRING. 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. --connect-type-conv=#
enum
NO
, YES
or SKIP
YES
(>= Connect 1.06.006), NO
(<= Connect 1.06.005) connect_use_tempfile
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 to NO
, 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. --connect-use-tempfile=#
enum
AUTO
connect_work_size
--connect-work-size=#
numeric
67108864
4194304
upwards, depending on the physical memory size connect_xtrace
0
(no trace), or to other values 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. In some Linux versions, this is re-routed into the error log file. Console tracing can be set on the command line or later by names or values. Valid values (from Connect 1.06.006) include: 0
: No trace YES
or 1
: Basic trace MORE
or 2
: More tracing INDEX
or 4
: Index construction MEMORY
or 8
: Allocating and freeing memory SUBALLOC
or 16
: Sub-allocating in work area QUERY
or 32
: Constructed query sent to external server STMT
or 64
: Currently executing statement HANDLER
or 128
: Creating and dropping CONNECT handlers BLOCK
or 256
: Creating and dropping CONNECT objects MONGO
or 512
: Mongo and REST (from Connect 1.06.0010) tracing set global connect_xtrace=0; No trace
set global connect_xtrace='YES'; By name
set global connect_xtrace=1; By value
set global connect_xtrace='QUERY,STMT'; By name
set global connect_xtrace=96; By value
set global connect_xtrace=1023; Trace all
--connect-xtrace=#
set
(>= Connect 1.06.006), integer
(<= Connect 1.06.005) 0
0
to 2147483647
(<= Connect 1.06.005)
© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/connect-system-variables/