Outdated Version
You are viewing an older version of this section. View current production version.
System Variables
Full List of System Variables
| Name | Description | Example Setting |
|---|---|---|
| aggregator_failure_detection | Aggregator heartbeat | ON |
| autocommit | Auto-commit transactions | ON |
| basedir | Base directory. | . |
| character_set_client | Client character set. | utf8 |
| character_set_connection | Connection character set. | utf8 |
| character_set_filesystem | File system character set. | binary |
| character_set_results | Results character set. | utf8 |
| character_set_server | Server character set. | utf8 |
| character_set_system | System character set. | utf8 |
| character_sets_dir | Character sets directory. | /var/lib/memsql/share/charsets/ |
| collation_connection | Connection collation. | utf8_general_ci |
| collation_database | Database collation. | utf8_general_ci |
| collation_server | Server collation. | utf8_general_ci |
| compile_only | Compile only (ON or OFF). | OFF |
| connect_timeout | Connection timeout. | 10 |
| core-file | Core file (ON or OFF). | ON |
| critical_diagnostics | Critical Diagnostics (ON or OFF). | OFF |
| date_format | Data format. | %Y-%m-%d |
| datetime_format | Date / time format. | %Y-%m-%d %H:%i:%s |
| default_partitions_per_leaf | Number of default partitions by leaf. | 8 |
| error_count | Error count. | 0 |
| external_user | External user | |
| flat_plancache | Flat plancache (ON or OFF). | OFF |
| flush-before-replicate | Flush before replicate (ON or OFF). | OFF |
| general_log | General log (ON or OFF) | OFF |
| hostname | Host name. | my_host |
| interactive_timeout | Interactive timeout. | 28800 |
| kerberos_server_keytab | Kerberos server keytab. | |
| lc_messages | Lc messages. | en_US |
| lc_messages_dir | Lc messages directory. | /var/lib/memsql/share/ |
| lc_time_names | Lc time names. | en_US |
| leaf_failure_detection | Leaf failure detection (ON or OFF). | ON |
| load_data_batch_size | Load data batch size. | 50 |
| local_infile | Local infile (ON or OFF). | ON |
| lock_wait_timeout | Lock wait timeout. | 60 |
| locked_in_memory | Locked in memory (ON or OFF). | OFF |
| master_aggregator | Master aggregator. | |
| max_allowed_packet | Maximum allowed per packet. | 104857600 |
| max_connections | Maximum connections. | 8192 |
| max_pooled_connections | Maximum pooled connections. | 256 |
| max_user_connections | Maximum user connections. | 0 |
| maximum_memory | Maximum memory used, in MB. WARNING: do not set to more than 90% of system RAM | 58982 |
| maximum_table_memory | Maximum memory for data, in MB. WARNING: do not set to more than 90% of system RAM | 52428 |
| memsql_version | MemSQL version number. | |
| memsql_version_hash | MemSQL version hash. | |
| net_buffer_length | Net buffer length. | 16384 |
| net_read_timeout | Net read timeout. | 3600 |
| net_retry_count | Net retry count. | 10 |
| net_write_timeout | Net write timeout. | 3600 |
| pid_file | Location of the PID file. | /var/lib/memsql/memsql.pid |
| pipelines_batches_metadata_to_keep | The number of Pipelines batch metadata entries to persist before they are overwritten by incoming batches. | 1000 |
| pipelines_kafka_version | The Kafka version used for the Kafka extractor. | 0.8.2.2 |
| pipelines_max_errors_per_partition | 1000 | |
| pipelines_max_offsets_per_batch_partition | The maximum number of data source partition offsets to extract in a single batch transaction. | 100096 |
| pipelines_max_retries_per_batch_partition | The number of retry attempts for writing batch partition data to the destination table. | 4 |
| pipelines_stderr_bufsize | The buffer size for standard error output in bytes. | 1048576 |
| pipelines_stop_on_error | Specifies whether or not each pipeline in the cluster should stop when an error occurs. | ON |
| plan_expiration_minutes | Plan expiration limit (minutes). | 720 |
| port | MemSQL port number. | 3306 |
| protocol_version | Protocol version. | 10 |
| proxy_user | Proxy user. | |
| query_parallelism | Query parallelism. | 0 |
| redundancy_level | Redundancy level (1 or 2). | 1 |
| reported_hostname | Reported hostname. | |
| secure_file_priv | Secure file privilege. | |
| snapshot-trigger-size | Snapshot trigger size. | 268435456 |
| snapshots-to-keep | Snapshots to keep. | 2 |
| socket | Socket. | memsql.sock |
| sql_quote_show_create | SQL Quote Show Create (ON or OFF). | ON |
| sync-slave-timeout | Sync slave timeout. | 10000 |
| system_time_zone | System time zone. | PST |
| table_precompiled_header | Table precompiled header (ON or OFF). | ON |
| thread_cache_size | Thread cache size. | 0 |
| thread_handling | Thread handling. | one-thread-per-connection |
| thread_stack | Thread stack. | 1048576 |
| time_format | Time format. | %H:%i:%s |
| time_zone | Time zone. | SYSTEM |
| timestamp | Timestamp. | 1391112305 |
| tmpdir | Temporary directory. | . |
| transaction-buffer | Transaction buffer. | 67108864 |
| tx_isolation | Transaction isolation. | READ-COMMITTED |
| version | Version. | 5.5.8 |
| version_comment | Version comment. | MemSQL source distribution (compatible: MySQL Enterprise & MySQL Commercial) |
| version_compile_machine | Version compile machine. | x86_64 |
| version_compile_os | Version compile operating system. | Linux |
| wait_timeout | Wait timeout. | 28800 |
| warn_level | Warning level. | WARNINGS |
| warning_count | Warning count. | 0 |
