mysqld Options
MariaDB starting with 10.4.6
From MariaDB 10.4.6, mariadbd
is a symlink to mysqld
.
MariaDB starting with 10.5.2
From MariaDB 10.5.2, mariadbd
is the name of the binary, with mysqld
a symlink .
Contents
- Option Prefixes
- Option File Options
- Compatibility Options
- Locale Options
- Windows Options
- Replication and Binary Logging Options
- --abort-slave-event-count
- --auto-increment-increment
- --auto-increment-offset
- --binlog-annotate-row-events
- --binlog-cache-size
- --binlog-checksum
- --binlog-commit-wait-count
- --binlog-commit-wait-usec
- --binlog-direct-non-transactional-updates
- --binlog-do-db
- --binlog-expire-logs-seconds
- --binlog-file-cache-size
- --binlog-format
- --binlog-ignore-db
- --binlog-optimize-thread-scheduling
- --binlog-row-event-max-size
- --binlog-row-image
- --binlog-row-metadata
- --binlog-stmt-cache-size
- --default-master-connection
- --disconnect-slave-event-count
- --flashback
- --gtid-cleanup-batch-size
- --gtid-domain-id
- --gtid-ignore-duplicates
- --gtid-strict-mode
- --init-rpl-role
- --init-slave
- --log-basename
- --log-bin
- --log-bin-compress
- --log-bin-compress-min-len
- --log-bin-index
- --log-bin-trust-function-creators
- --log-bin-trust-routine-creators
- --log-slave-updates
- --master-host
- --master-info-file
- --master-password
- --master-port
- --master-retry-count
- --master-ssl
- --master-ssl-ca
- --master-ssl-capath
- --master-ssl-cert
- --master-ssl-cipher
- --master-ssl-key
- --master-user
- --master-verify-checksum
- --max-binlog-cache-size
- --max-binlog-dump-events
- --max-binlog-size
- --max-binlog-stmt-cache-size
- --max-relay-log-size
- --read-binlog-speed-limit
- --relay-log
- --relay-log-index
- --relay-log-info-file
- --relay-log-purge
- --relay-log-recovery
- --relay-log-space-limit
- --replicate-annotate-row-events
- --replicate-do-db
- --replicate-do-table
- --replicate-events-marked-for-skip
- --replicate-ignore-db
- --replicate-ignore-table
- --replicate-rewrite-db
- --replicate-same-server-id
- --replicate-wild-do-table
- --replicate-wild-ignore-table
- --report-host
- --report-password
- --report-port
- --report-user
- --rpl-recovery-rank
- --server-id
- --slave-ddl-exec-mode
- --slave-compressed-protocol
- --slave-domain-parallel-threads
- --slave-exec-mode
- --slave-load-tmpdir
- --slave-max-allowed-packet
- --slave-net-timeout
- --slave-parallel-threads
- --slave-parallel-max-queued
- --slave-run-triggers-for-rbr
- --slave-skip-errors
- --slave-sql-verify-checksum
- --slave-transaction-retries
- --slave-transaction-retry-errors
- --slave-transaction-retry-interval
- --slave-type-conversions
- --sporadic-binlog-dump-fail
- --sync-binlog
- --sync-master-info
- --sync-relay-log
- --sync-relay-log-info
- --sysdate-is-now
- Replication and Binary Logging Options and System Variables
- Semisynchronous Replication Options and System Variables
- Optimizer Options
- --alter-algorithm
- --analyze-sample-percentage
- --big-tables
- --bulk-insert-buffer-size
- --expensive-subquery-limit
- --join-buffer-size
- --join-buffer-space-limit
- --join-cache-level
- --max-heap-table-size
- --max-join-size
- --max-seeks-for-key
- --max-sort-length
- --mrr-buffer-size
- --optimizer-max-sel-arg-weight
- --optimizer-prune-level
- --optimizer-search-depth
- --optimizer-selectivity-sampling-limit
- --optimizer-switch
- -optimizer-trace
- -optimizer-trace-max-mem-size
- --optimizer-use-condition-selectivity
- --query-alloc-block-size
- --query-prealloc-size
- --range-alloc-block-size
- --read-buffer-size
- --record-buffer
- --rowid-merge-buff-size
- --table-cache
- --table-definition-cache
- --table-open-cache
- --table-open-cache-instances
- --tmp-disk-table-size
- --tmp-memory-table-size
- --tmp-table-size
- --use-stat-tables
- Optimizer Options and System Variables
- Storage Engine Options
- --skip-bdb
- MyISAM Storage Engine Options
- --concurrent-insert
- --delayed-insert-limit
- --delayed-insert-timeout
- --delayed-queue-size
- --external-locking
- --keep-files-on-create
- --key-buffer-size
- --key-cache-age-threshold
- --key-cache-block-size
- --key-cache-division-limit
- --key-cache-file-hash-size
- --key-cache-segments
- --log-isam
- --myisam-block-size
- --myisam-data-pointer-size
- --myisam-max-sort-file-size
- --myisam-mmap-size
- --myisam-recover-options
- --myisam-repair-threads
- --myisam-sort-buffer-size
- --myisam-stats-method
- --myisam-use-mmap
- MyISAM Storage Engine Options and System Variables
- InnoDB Storage Engine Options
- --ignore-builtin-innodb
- --innodb
- --innodb-adaptive-checkpoint
- --innodb-adaptive-flushing
- --innodb-adaptive-flushing-lwm
- --innodb-adaptive-flushing-method
- --innodb-adaptive-hash-index
- --innodb-adaptive-hash-index-partitions
- --innodb-adaptive-hash-index-parts
- --innodb-adaptive-max-sleep-delay
- --innodb-additional-mem-pool-size
- --innodb-api-bk-commit-interval
- --innodb-api-disable-rowlock
- --innodb-api-enable-binlog
- --innodb-api-enable-mdl
- --innodb-api-trx-level
- --innodb-auto-lru-dump
- --innodb-autoextend-increment
- --innodb-autoinc-lock-mode
- --innodb-background-scrub-data-check-interval
- --innodb-background-scrub-data-compressed
- --innodb-background-scrub-data-interval
- --innodb-background-scrub-data-uncompressed
- --innodb-blocking-buffer-pool-restore
- --innodb-buf-dump-status-frequency
- --innodb-buffer-pool-chunk-size
- --innodb-buffer-pool-dump-at-shutdown
- --innodb-buffer-pool-dump-now
- --innodb-buffer-pool-dump-pct
- --innodb-buffer-pool-evict
- --innodb-buffer-pool-filename
- --innodb-buffer-pool-instances
- --innodb-buffer-pool-load-abort
- --innodb-buffer-pool-load-at-startup
- --innodb-buffer-pool-load-now
- --innodb-buffer-pool-load-pages-abort
- --innodb-buffer-pool-populate
- --innodb-buffer-pool-restore-at-startup
- --innodb-buffer-pool-shm-checksum
- --innodb-buffer-pool-shm-key
- --innodb-buffer-pool-size
- --innodb-change-buffer-max-size
- --innodb-change-buffering
- --innodb-change-buffering-debug
- --innodb-checkpoint-age-target
- --innodb-checksum-algorithm
- --innodb-checksums
- --innodb-cleaner-lsn-age-factor
- --innodb-cmp
- --innodb-cmp-per-index-enabled
- --innodb-cmp-reset
- --innodb-cmpmem
- --innodb-cmpmem-reset
- --innodb-commit-concurrency
- --innodb-compression-algorithm
- --innodb-compression-failure-threshold-pct
- --innodb-compression-level
- --innodb-compression-pad-pct-max
- --innodb-concurrency-tickets
- --innodb-corrupt-table-action
- --innodb-data-file-path
- --innodb-data-home-dir
- --innodb-deadlock-detect
- --innodb-deadlock-report
- --innodb-default-encryption-key-id
- --innodb-default-page-encryption-key
- --innodb-default-row-format
- --innodb-defragment
- --innodb-defragment-fill-factor
- --innodb-defragment-fill-factor-n-recs
- --innodb-defragment-frequency
- --innodb-defragment-n-pages
- --innodb-defragment-stats-accuracy
- --innodb-dict-size-limit
- --innodb-disable-sort-file-cache
- --innodb-doublewrite
- --innodb-doublewrite-file
- --innodb-empty-free-list-algorithm
- --innodb-enable-unsafe-group-commit
- --innodb-encrypt-log
- --innodb-encrypt-tables
- --innodb-encrypt-temporary-tables
- --innodb-encryption-rotate-key-age
- --innodb-encryption-rotation-iops
- --innodb-encryption-threads
- --innodb-extra-rsegments
- --innodb-extra-undoslots
- --innodb-fake-changes
- --innodb-fast-checksum
- --innodb-fast-shutdown
- --innodb-fatal-semaphore-wait-threshold
- --innodb-file-format
- --innodb-file-format-check
- --innodb-file-format-max
- --innodb-file-io-threads
- --innodb-file-per-table
- --innodb-filll-factor
- --innodb-flush-log-at-trx-commi
- --innodb-flush-method
- --innodb-flush-neighbor-pages
- --innodb-flush-neighbors
- --innodb-flush-sync
- --innodb-flushing-avg-loops
- --innodb-force-load-corrupted
- --innodb-force-primary-key
- --innodb-force-recovery
- --innodb-foreground-preflush
- --innodb-ft-aux-table
- --innodb-ft-cache-size
- --innodb-ft-enable-diag-print
- --innodb-ft-enable-stopword
- --innodb-ft-max-token-size
- --innodb-ft-min-token-size
- --innodb-ft-num-word-optimize
- --innodb-ft-result-cache-limit
- --innodb-ft-server-stopword-table
- --innodb-ft-sort-pll-degree
- --innodb-ft-total-cache-size
- --innodb-ft-user-stopword-table
- --innodb-ibuf-accel-rate
- --innodb-ibuf-active-contract
- --innodb-ibuf-max-size
- --innodb-idle-flush-pct
- --innodb-immediate-scrub-data-uncompressed
- --innodb-import-table-from-xtrabackup
- --innodb-index-stats
- --innodb-instant-alter-column-allowed
- --innodb-instrument-semaphores
- --innodb-io-capacity
- --innodb-io-capacity-max
- --innodb-large-prefix
- --innodb-lazy-drop-table
- --innodb-lock-schedule-algorithm
- --innodb-lock-wait-timeout
- --innodb-lock-waits
- --innodb-locking-fake-changes
- --innodb-locks
- --innodb-locks-unsafe-for-binlog
- --innodb-log-arch-dir
- --innodb-log-arch-expire-sec
- --innodb-log-archive
- --innodb-log-block-size
- --innodb-log-buffer-size
- --innodb-log-checksum-algorithm
- --innodb-log-checksums
- --innodb-log-compressed-pages
- --innodb-log-file-size
- --innodb-log-files-in-group|
- --innodb-log-group-home-dir
- --innodb-log-optimize-ddl
- --innodb-log-write-ahead-size
- --innodb-lru-flush-size
- --innodb-lru-scan-depth
- --innodb-max-bitmap-file-size
- --innodb-max-changed-pages
- --innodb-max-dirty-pages-pct
- --innodb-max-dirty-pages-pct-lwm
- --innodb-max-purge-lag
- --innodb-max-purge-lag-delay
- --innodb-max-purge-lag-wait
- --innodb-max-undo-log-size
- --innodb-merge-sort-block-size
- --innodb-mirrored-log-groups
- --innodb-monitor-disable
- --innodb-monitor-enable
- --innodb-monitor-reset
- --innodb-monitor-reset-all
- --innodb-mtflush-threads
- --innodb-numa-interleave
- --innodb-old-blocks-pct
- --innodb-old-blocks-time
- --innodb-online-alter-log-max-size
- --innodb-open-files
- --innodb-optimize-fulltext-only
- --innodb-page-cleaners
- --innodb-page-size
- --innodb-pass-corrupt-table
- --innodb-prefix-index-cluster-optimization
- --innodb-print-all-deadlocks
- --innodb-purge-batch-size
- --innodb-purge-rseg-truncate-frequency
- --innodb-purge-threads
- --innodb-random-read-ahead
- --innodb-read-ahead
- --innodb-read-ahead-threshold
- --innodb-read-io-threads
- --innodb-read-only
- --innodb-recovery-update-relay-log
- --innodb-replication-delay
- --innodb-rollback-on-timeout
- --innodb-rollback-segments
- --innodb-rseg
- --innodb-sched-priority-cleaner
- --innodb-safe-truncate
- --innodb-scrub-log
- --innodb-scrub-log-interval
- --innodb-scrub-log-speed
- --innodb-show-locks-held
- --innodb-show-verbose-locks
- --innodb-sort-buffer-size
- --innodb-spin-wait-delay
- --innodb-stats-auto-recalc
- --innodb-stats-auto-update
- --innodb-stats-include-delete-marked
- --innodb-stats-method
- --innodb-stats-modified-counter
- --innodb-stats-on-metadata
- --innodb-stats-persistent
- --innodb-stats-persistent-sample-pages
- --innodb-stats-sample-pages
- --innodb-stats-traditional
- --innodb-stats-transient-sample-pages
- --innodb-stats-update-need-lock
- --innodb-status-file
- --innodb-status-output
- --innodb-status-output-locks
- --innodb-strict-mode
- --innodb-support-xa
- --innodb-sync-array-size
- --innodb-sync-spin-loops
- --innodb-sys-indexes
- --innodb-sys-stats
- --innodb-sys-tables
- --innodb-table-locks
- --innodb-table-stats
- --innodb-temp-data-file-path
- --innodb-thread-concurrency
- --innodb-thread-concurrency-timer-based
- --innodb-thread-sleep-delay
- --innodb-tmpdir
- --innodb-track-changed-pages
- --innodb-track-redo-log-now
- --innodb-trx
- --innodb-undo-directory
- --innodb-undo-log-truncate
- --innodb-undo-logs
- --innodb-undo-tablespaces
- --innodb-use-atomic-writes
- --innodb-use-fallocate
- --innodb-use-global-flush-log-at-trx-commit
- --innodb-use-mtflush
- --innodb-use-native-aio
- --innodb-use-purge-thread
- --innodb-use-stacktrace
- --innodb-use-sys-malloc
- --innodb-use-sys-stats-table
- --innodb-use-trim
- --innodb-write-io-threads
- --skip-innodb
- --skip-innodb-checksums
- --skip-innodb-doublewrite
- InnoDB Storage Engine Options and System Variables
- Aria Storage Engine Options
- --aria-block-size
- --aria-checkpoint-interval
- --aria-checkpoint-log-activity
- --aria-encrypt-tables
- --aria-force-start-after-recovery-failures
- --aria-group-commit
- --aria-group-commit-interval
- --aria-log-dir-path
- --aria-log-file-size
- --aria-log-purge-type
- --aria-max-sort-file-size
- --aria-page-checksum
- --aria-pagecache-age-threshold
- --aria-pagecache-buffer-size
- --aria-pagecache-division-limit
- --aria-pagecache-file-hash-size
- --aria-recover
- --aria-recover-options
- --aria-repair-threads
- --aria-sort-buffer-size
- --aria-stats-method
- --aria-sync-log-dir
- --aria-used-for-temp-tables
- --deadlock-search-depth-long
- --deadlock-search-depth-short
- --deadlock-timeout-long
- --deadlock-timeout-short
- Aria Storage Engine Options and System Variables
- MyRocks Storage Engine Options
- S3 Storage Engine Options
- CONNECT Storage Engine Options
- --connect-class-path
- --connect-cond-push
- --connect-conv-size
- --connect-default-depth
- --connect-default-prec
- --connect-enable-mongo
- --connect-exact-info
- --connect-force-bson
- --connect-indx-map
- --connect-java-wrapper
- --connect-json-all-path
- --connect-json-grp-size
- --connect-json-null
- --connect-jvm-path
- --connect-type-conv
- --connect-use-tempfile
- --connect-work-size
- --connect-xtrace
- CONNECT Storage Engine Options and System Variables
- Spider Storage Engine Options
- Mroonga Storage Engine Options
- TokuDB Storage Engine Options
- Performance Schema Options
- --performance-schema
- --performance-schema-accounts-size
- --performance-schema-consumer-events-stages-current
- --performance-schema-consumer-events-stages-history
- --performance-schema-consumer-events-stages-history-long
- --performance-schema-consumer-events-statements-current
- --performance-schema-consumer-events-statements-history
- --performance-schema-consumer-events-statements-history-long
- --performance-schema-consumer-events-waits-current
- --performance-schema-consumer-events-waits-history
- --performance-schema-consumer-events-waits-history-long
- --performance-schema-consumer-global-instrumentation
- --performance-schema-consumer-statements-digest
- --performance-schema-consumer-thread-instrumentation
- --performance-schema-digests-size
- --performance-schema-events-stages-history-long-size
- --performance-schema-events-stages-history-size
- --performance-schema-events-statements-history-long-size
- --performance-schema-events-statements-history-size
- --performance-schema-events-transactions-history-long-size
- --performance-schema-events-transactions-history-size
- --performance-schema-events-waits-history-long-size
- --performance-schema-events-waits-history-size
- --performance-schema-hosts-size
- --performance-schema-max-cond-classes
- --performance-schema-max-cond-instances
- --performance-schema-max-digest-length
- --performance-schema-max-file-classes
- --performance-schema-max-file-handles
- --performance-schema-max-file-instances
- --performance-schema-max-index-stat
- --performance-schema-max-memory-classes
- --performance-schema-max-metadata-locks
- --performance-schema-max-mutex-classes
- --performance-schema-max-mutex-instances
- --performance-schema-max-prepared-statement-instances
- --performance-schema-max-program-instances
- --performance-schema-max-sql-text-length
- --performance-schema-max-rwlock-classes
- --performance-schema-max-rwlock-instances
- --performance-schema-max-socket-classes
- --performance-schema-max-socket-instances
- --performance-schema-max-stage-classes
- --performance-schema-max-statement-classes
- --performance-schema-max-statement-stack
- --performance-schema-max-table-handles
- --performance-schema-max-table-instances
- --performance-schema-max-table-lock-stat
- --performance-schema-max-thread-classes
- --performance-schema-max-thread-instances
- --performance-schema-session-connect-attrs-size
- --performance-schema-setup-actors-size
- --performance-schema-setup-objects-size
- --performance-schema-users-size
- Performance Schema Options and System Variables
- Galera Cluster Options
- --wsrep-auto-increment-control
- --wsrep-causal-reads
- --wsrep-certify-nonPK
- --wsrep-cluster-address
- --wsrep-cluster-name
- --wsrep-convert-LOCK-to-trx
- --wsrep-data-home-dir
- --wsrep-dbug-option
- --wsrep-debug
- --wsrep-desync
- --wsrep-dirty-reads
- --wsrep-drupal-282555-workaround
- --wsrep-forced-binlog-format
- --wsrep-gtid-domain-id
- --wsrep-gtid-mode
- --wsrep-ignore-apply-errors
- --wsrep-load-data-splitting
- --wsrep-log-conflicts
- --wsrep-max-ws-rows
- --wsrep-max-ws-size
- --wsrep-mode
- --wsrep-mysql-replication-bundle
- --wsrep-new-cluster
- --wsrep-node-address
- --wsrep-node-incoming-address
- --wsrep-node-name
- --wsrep-notify-cmd
- --wsrep-on
- --wsrep-OSU-method
- --wsrep-provider
- --wsrep-provider-options
- --wsrep-recover
- --wsrep-reject_queries
- --wsrep-replicate-myisam
- --wsrep-restart-slave
- --wsrep-retry-autocommit
- --wsrep-slave-FK-checks
- --wsrep-slave-threads
- --wsrep-slave-UK-checks
- --wsrep-sr-store
- --wsrep-sst-auth
- --wsrep-sst-donor
- --wsrep-sst-donor-rejects-queries
- --wsrep-sst-method
- --wsrep-sst-receive-address
- --wsrep-start-position
- --wsrep-strict-ddl
- --wsrep-sync-wait
- --wsrep-trx-fragment-size
- --wsrep-trx-fragment-unit
- Galera Cluster Options and System Variables
- Options When Debugging mysqld
- Other Options
- --allow-suspicious-udfs
- --autocommit
- --automatic-sp-privileges
- --back-log
- --basedir
- --bind-address
- --bootstrap
- --check-constraint-checks
- --chroot
- --column-compression-threshold
- --column-compression-zlib-level
- --column-compression-zlib-strategy
- --column-compression-zlib-wrap
- --completion-type
- --connect-timeout
- --datadir
- --date-format
- --datetime-format
- --deadlock-search-depth-long
- --deadlock-search-depth-short
- --deadlock-timeout-long
- --deadlock-timeout-short
- --default-password-lifetime
- --default-regex-flags
- --default-storage-engine
- --default-table-type
- --default-tmp-storage-engine
- --delay-key-write
- --des-key-file
- --disconnect-on-expired-password
- --div-precision-increment
- --encrypt-binlog
- --encrypt-tmp-disk-tables
- --encrypt-tmp-files
- --encryption-algorithm
- --engine-condition-pushdown
- --eq-range-index-dive-limit
- --event-scheduler
- --exit-info
- --expire-logs-days
- --explicit-defaults-for-timestamp
- --extra-max-connections
- --extra-port
- --flush
- --flush-time
- --ft-boolean-syntax
- --ft-max-word-len
- --ft-min-word-len
- --ft-query-expansion-limit
- --ft-stopword-file
- --general-log
- --general-log-file
- --getopt-prefix-matching
- --group-concat-max-len
- --help
- --histogram-size
- --histogram-type
- --host-cache-size
- --idle-readonly-transaction-timeout
- --idle-transaction-timeout
- --idle-write-transaction-timeout
- --ignore-db-dirs
- --in-predicate-conversion-threshold
- --init-connect
- --init-file
- --interactive-timeout
- --large-pages
- --local-infile
- --lock-wait-timeout
- --log
- --log-disabled_statements
- --log-error
- --log-output
- --log-queries-not-using-indexes
- --log-ddl-recovery
- --log-short-format
- --log-slow-admin-statements
- --log-slow-admin-statements
- --log-slow-file
- --log-slow-filter
- --log-slow-queries
- --log-slow-rate-limit
- --log-slow-slave-statements
- --log-slow-time
- --log-slow-verbosity
- --log-tc
- --log-tc-size
- --log-warnings
- --long-query-time
- --low-priority-updates
- --lower-case-table-names
- --master-connect-retry
- --max-allowed-packet
- --max-connections
- --max-connect-errors
- --max-delayed-threads
- --max-digest-length
- --max-error-count
- --max-length-for-sort-data
- --max-long-data-size
- --max-password-errors
- --max-prepared-stmt-count
- --max-recursive-iterations
- --max-rowid-filter-size
- --max-session-mem-used
- --max-sp-recursion-depth
- --max-statement-time
- --max-tmp-tables
- --max-user-connections
- --max-write-lock-count
- --memlock
- --metadata-locks-cache-size
- --metadata-locks-hash-instances
- --min-examined-row-limit
- --mrr-buffer-size
- --multi-range-count
- --mysql56-temporal-format
- --ndb-use-copying-alter-table
- --net-buffer-length
- --net-read-timeout
- --net-retry-count
- --net-write-timeout
- --one-thread
- --open-files-limit
- --pid-file
- --plugin-load
- --plugin-load-add
- --plugin-dir
- --plugin-maturity
- --port
- --port-open-timeout
- --preload-buffer-size
- --profiling-history-size
- --progress-report-time
- --query-cache-info
- --query-cache-limit
- --query-cache-min-res-unit
- --query-cache-size
- --query-cache-strip-comments
- --query-cache-type
- --query-cache-wlock-invalidate
- --read-rnd-buffer-size
- --read-only
- --require-secure-transport
- --safe-show-database
- --safe-user-create
- --safemalloc-mem-limit
- --secure-auth
- --secure-file-priv
- --secure-timestamp
- --session-track-schema
- --session-track-state-change
- --session-track-system-variables
- --session-track-transaction-info
- --show-slave-auth-info
- --skip-automatic-sp-privileges
- --skip-external-locking
- --skip-grant-tables
- --skip-host-cache
- --skip-large-pages
- --skip-log-error
- --skip-name-resolve
- --skip-networking
- --skip-partition
- --skip-show-database
- --skip-slave-start
- --skip-ssl
- --skip-symlink
- --skip-thread-priority
- --slow-launch-time
- --slow-query-log
- --slow-query-log-file
- --socket
- --sort-buffer-size
- --sql-bin-update-same
- --sql-if-exists
- --sql-mode
- --ssl
- --ssl-ca
- --ssl-capath
- --ssl-cert
- --ssl-cipher
- --ssl-crl
- --ssl-crlpath
- --ssl-key
- --stack-trace
- --standard-compliant-cte
- --stored-program-cache
- --strict-password-validation
- --symbolic-links
- --sync-frm
- --system-versioning-alter-history
- --system-versioning-asof
- --system-versioning-innodb-algorithm-simple
- --table-lock-wait-timeout
- --tc-heuristic-recover
- --tcp-keepalive-interval
- --tcp-keepalive-probes
- --tcp-keepalive-time
- --tcp-nodelay
- --temp-pool
- --test-expect-abort
- --test-ignore-wrong-options
- --thread-cache-size
- --thread-concurrency
- --thread-handling
- --thread-pool-dedicated-listener
- --thread-pool-exact-stats
- --thread-pool-idle-timeout
- --thread-pool-max-threads
- --thread-pool-min-threads
- --thread-pool-prio-kickup-timer
- --thread-pool-priority
- --thread-pool-size
- --thread-pool-stall-limit
- --thread-stack
- --timed-mutexes
- --time-format
- --tls_version
- --tmpdir
- --transaction-isolation
- --transaction-alloc-block-size
- --transaction-prealloc-size
- --transaction-read-only
- --updatable-views-with-limit
- --user
- --userstat
- --verbose
- --version
- --wait-timeout
- Other Options and System Variables
- Authentication Plugins - Options and System Variables
- Encryption Plugins - Options and System Variables
- Password Validation Plugins - Options and System Variables
- Audit Plugins - Options and System Variables
- Audit Plugin - server_audit
- server-audit
- server-audit-events
- server-audit-excl-users
- server-audit-file-path
- server-audit-file-rotate-now
- server-audit-file-rotate-size
- server-audit-file-rotations
- server-audit-incl-users
- server-audit-logging
- server-audit-mode
- server-audit-output-type
- server-audit-query-limit
- server-audit-syslog-facility
- server-audit-syslog-ident
- server-audit-syslog-info
- server-audit-syslog-priority
- Audit Plugin - SQL_ERROR_LOG
- Audit Plugin - QUERY_RESPONSE_TIME_AUDIT
- Audit Plugin - server_audit
- Daemon Plugins - Options and System Variables
- Daemon Plugin - handlersocket
- handlersocket-accept-balance
- handlersocket-address
- handlersocket-backlog
- handlersocket-epoll
- handlersocket-plain-secret
- handlersocket-plain-secret-wr
- handlersocket-port
- handlersocket-port-wr
- handlersocket-rcvbuf
- handlersocket-readsize
- handlersocket-sndbuf
- handlersocket-threads
- handlersocket-threads-wr
- handlersocket-timeout
- handlersocket-verbose
- handlersocket-wrlock-timeout
- Daemon Plugin - handlersocket
- Information Schema Plugins - Options and System Variables
- Information Schema Plugin - DISKS
- Information Schema Plugin - feedback
- Information Schema Plugin - LOCALES
- Information Schema Plugin - METADATA_LOCK_INFO
- Information Schema Plugin - QUERY_CACHE_INFO
- Information Schema Plugin - QUERY_RESPONSE_TIME
- Information Schema Plugin - user_variables
- Information Schema Plugin - WSREP_MEMBERSHIP
- Information Schema Plugin - WSREP_STATUS
- Replication Plugins - Options and System Variables
- Default Values
This page lists all of the options for mysqld
/ mariadbd
, ordered by topic. For a full alphabetical list of all mysqld options, as well as server and status variables, see Full list of MariaDB options, system and status variables.
In many cases, the entry here is a summary, and links to the full description.
By convention, server variables have usually been specified with an underscore in the configuration files, and a dash on the command line. You can however specify underscores as dashes - they are interchangeable.
See mysqld startup options for which files and groups mysqld reads for it's default options.
Option Prefixes
--autoset-*
- Description: Sets the option value automatically. Only supported for certain options. Available in MariaDB 10.1.7 and later.
--disable-*
- Description: For all boolean options, disables the setting (equivalent to setting it to
0
). Same as--skip
.
--enable-*
- Description: For all boolean options, enables the setting (equivalent to setting it to
1
).
--loose-*
- Description: Don't produce an error if the option doesn't exist.
--maximum-*
- Description: Sets the maximum value for the option.
--skip-*
- Description: For all boolean options, disables the setting (equivalent to setting it to
0
). Same as--disable
.
Option File Options
--defaults-extra-file
- Commandline:
--defaults-extra-file=name
- Description: Read this extra option file after all other option files are read.
--defaults-file
- Commandline:
--defaults-file=name
- Description: Only read options from the given option file.
--defaults-group-suffix
- Commandline:
--defaults-group-suffix=name
- Description: In addition to the default option groups, also read option groups with the given suffix.
--no-defaults
- Commandline:
--no-defaults
- Description: Don't read options from any option file.
--print-defaults
- Commandline:
--print-defaults
- Description: Read options from option files, print all option values, and then exit the program.
Compatibility Options
The following options have been added to MariaDB to make it more compliant with other MariaDB and MySQL versions:
-a, --ansi
- Description: Use ANSI SQL syntax instead of MySQL syntax. This mode will also set transaction isolation level serializable.
--new
- Description: Use new functionality that will exist in next version of MariaDB. This function exists to make it easier to prepare for an upgrade. For version 5.1 this functions enables the LIST and RANGE partitions functions for ndbcluster.
--old-style-user-limits
- Description: Enable old-style user limits (before MySQL 5.0.3, user resources were counted per each user+host vs. per account).
--safe-mode
- Description: Disable some potential unsafe optimizations. For 5.2, INSERT DELAYED is disabled, myisam_recover_options is set to DEFAULT (automatically recover crashed MyISAM files) and the query cache is disabled. For Aria tables, disable bulk insert optimization to enable one to use aria_read_log to recover tables even if tables are deleted (good for testing recovery).
--skip-new
- Description: Disables --new in 5.2. In 5.1 used to disable some new potentially unsafe functions.
Compatibility Options and System Variables
Locale Options
--character-set-client-handshake
- Commandline:
--character-set-client-handshake
- Description: Don't ignore client side character set value sent during handshake.
--default-character-set
- Commandline:
--default-character-set=name
- Description: Still available as an option for setting the default character set for clients and their connections, it was deprecated and removed in MariaDB 10.2 as a server option. Use character-set-server instead.
--language
- Description: This option can be used to set the server's language for error messages. This option can be specified either as a language name or as the path to the directory storing the language's error message file. See Server Locales for a list of supported locales and their associated languages.
- This option is deprecated. Use the
lc_messages
andlc_messages_dir
system variables instead. - See Setting the Language for Error Messages for more information.
- This option is deprecated. Use the
Locale Options and System Variables
- character-set-filesystem
- character-set-client
- character-set-connection
- character-set-database
- character-set-filesystem
- character-set-results
- character-set-server
- character-set-system
- character-sets-dir
- collation-connection
- collation-database
- collation-server
- default-week-format
- default-time-zone
- lc-messages
- lc-messages-dir
- lc-time-names
Windows Options
--console
- Description: Windows-only option that keeps the console window open and for writing log messages to stderr and stdout. If specified together with --log-error, the last option will take precedence.
--install
- Description: Windows-only option that installs the
mysqld
process as a Windows service.- The Windows service created with this option auto-starts. If you want a service that is started on demand, then use the
--install-manual
option. - This option takes a service name as an argument. If this option is provided without a service name, then the service name defaults to "MySQL".
- This option is deprecated and may be removed in a future version. See MDEV-19358 for more information.
- The Windows service created with this option auto-starts. If you want a service that is started on demand, then use the
--install-manual
- Description: Windows-only option that installs the
mysqld
process as a Windows service.- The Windows service created with this option is started on demand. If you want a service that auto-starts, use the
--install
option. - This option takes a service name as an argument. If this option is provided without a service name, then the service name defaults to "MySQL".
- This option is deprecated and may be removed in a future version. See MDEV-19358 for more information.
- The Windows service created with this option is started on demand. If you want a service that auto-starts, use the
--remove
- Description: Windows-only option that removes the Windows service created by the
--install
or--install-manual
options.- This option takes a service name as an argument. If this option is provided without a service name, then the service name defaults to "MySQL".
- This option is deprecated and may be removed in a future version. See MDEV-19358 for more information.
--slow-start-timeout
- Description: Windows-only option that defines the maximum number of milliseconds that the service control manager should wait before trying to kill the Windows service during startup. Defaults to
15000
.
--standalone
- Description: Windows-only option that has no effect. Kept for compatibility reasons.
Windows Options and System Variables
The following options and system variables are related to using MariaDB on Windows:
Replication and Binary Logging Options
The following options are related to replication and the binary log:
--abort-slave-event-count
- Commandline:
--abort-slave-event-count=#
- Description: Option used by mysql-test for debugging and testing of replication.
--binlog-do-db
- Commandline:
--binlog-do-db=name
- Description: This option allows you to configure a replication master to write statements and transactions affecting databases that match a specified name into its binary log. Since the filtered statements or transactions will not be present in the binary log, its replication slaves will not be able to replicate them.
- This option will not work with cross-database updates with statement-based logging. See the Statement-Based Logging section for more information.
- This option can not be set dynamically.
- When setting it on the command-line or in a server option group in an option file, the option does not accept a comma-separated list. If you would like to specify multiple filters, then you need to specify the option multiple times.
- See Replication Filters for more information.
--binlog-ignore-db
- Commandline:
--binlog-ignore-db=name
- Description: This option allows you to configure a replication master to not write statements and transactions affecting databases that match a specified name into its binary log. Since the filtered statements or transactions will not be present in the binary log, its replication slaves will not be able to replicate them.
- This option will not work with cross-database updates with statement-based logging. See the Statement-Based Logging section for more information.
- This option can not be set dynamically.
- When setting it on the command-line or in a server option group in an option file, the option does not accept a comma-separated list. If you would like to specify multiple filters, then you need to specify the option multiple times.
- See Replication Filters for more information.
--binlog-row-event-max-size
- Commandline:
--binlog-row-event-max-size=#
- Description: The maximum size of a row-based binary log event in bytes. Rows will be grouped into events smaller than this size if possible. The value has to be a multiple of 256.
- Default value
8192
(>= MariaDB 10.2.4)1024
(<= MariaDB 10.2.3)
--disconnect-slave-event-count
- Commandline:
--disconnect-slave-event-count=#
- Description: Option used by mysql-test for debugging and testing of replication.
--flashback
- Commandline:
--flashback
- Description: Setup the server to use flashback. This enables the binary log and sets
binlog_format=ROW
. - Introduced: MariaDB 10.2.4
--init-rpl-role
- Commandline:
--init-rpl-role=name
- Description: Set the replication role.
--log-basename
- Commandline:
--log-basename=name
- Description: Basename for all log files and the .pid file. This sets all log file names at once (in 'datadir') and is normally the only option you need for specifying log files. This is especially recommended to be set if you are using replication as it ensures that your log file names are not dependent on your host name. Sets names for log-bin, log-bin-index, relay-log, relay-log-index, general-log-file,
--log-slow-query-log-file
,--log-error-file
, and pid-file. - Introduced: MariaDB 5.2
--log-bin-trust-routine-creators
- Commandline:
--log-bin-trust-routine-creators
- Description: Deprecated, use log-bin-trust-function-creators.
--master-host
- Commandline:
--master-host=name
- Description: Master hostname or IP address for replication. If not set, the slave thread will not be started. Note that the setting of master-host will be ignored if there exists a valid master.info file.
--master-info-file
- Commandline:
--master-info-file=name
- Description: Name and location of the file where the
MASTER_LOG_FILE
andMASTER_LOG_POS
options (i.e. the binary log position on the master) and most otherCHANGE MASTER
options are written. The slave's I/O thread keeps this binary log position updated as it downloads events.- See CHANGE MASTER TO: Option Persistence for more information.
--master-password
- Commandline:
--master-password=name
- Description: The password the slave thread will authenticate with when connecting to the master. If not set, an empty password is assumed. The value in master.info will take precedence if it can be read.
--master-port
- Commandline:
--master-port=#
- Description: The port the master is listening on. If not set, the compiled setting of MYSQL_PORT is assumed. If you have not tinkered with configure options, this should be 3306. The value in master.info will take precedence if it can be read.
--master-retry-count
- Commandline:
--master-retry-count=#
- Description: Number of times a slave will attempt to connect to a master before giving up. The retry interval is determined by the MASTER_CONNECT_RETRY option for the CHANGE MASTER statement. A value of 0 means the slave will not stop attempting to reconnect. Reconnects are triggered when a slave has timed out. See slave_net_timeout.
- Default Value:
86400
- Range - 32 bit:
0 to 4294967295
- Range - 64 bit:
0 to 18446744073709551615
--master-ssl
- Commandline:
--master-ssl
- Description: Enable the slave to connect to the master using TLS.
--master-ssl-ca
- Commandline:
--master-ssl-ca[=name]
- Description: Master TLS CA file. Only applies if you have enabled master-ssl.
--master-ssl-capath
- Commandline:
--master-ssl-capath[=name]
- Description: Master TLS CA path. Only applies if you have enabled master-ssl.
--master-ssl-cert
- Commandline:
--master-ssl-cert[=name]
- Description: Master TLS certificate file name. Only applies if you have enabled master-ssl.
--master-ssl-cipher
- Commandline:
--master-ssl-cipher[=name]
- Description: Master TLS cipher. Only applies if you have enabled master-ssl.
--master-ssl-key
- Commandline:
--master-ssl-key[=name]
- Description: Master TLS keyfile name. Only applies if you have enabled master-ssl.
--master-user
- Commandline:
--master-user=name
- Description: The username the slave thread will use for authentication when connecting to the master. The user must have FILE privilege. If the master user is not set, user test is assumed. The value in master.info will take precedence if it can be read.
--max-binlog-dump-events
- Commandline:
--max-binlog-dump-events=#
- Description: Option used by mysql-test for debugging and testing of replication.
--replicate-rewrite-db
- Commandline:
--replicate-rewrite-db=master_database->slave_database
- Description: This option allows you to configure a replication slave to rewrite database names. It uses the format
master_database->slave_database
. If a slave encounters a binary log event in which the default database (i.e. the one selected by theUSE
statement) ismaster_database
, then the slave will apply the event inslave_database
instead.- This option will not work with cross-database updates with statement-based logging. See the Statement-Based Logging section for more information.
- This option only affects statements that involve tables. This option does not affect statements involving the database itself, such as
CREATE DATABASE
,ALTER DATABASE
, andDROP DATABASE
. - This option can not be set dynamically.
- When setting it on the command-line or in a server option group in an option file, the option does not accept a comma-separated list. If you would like to specify multiple filters, then you need to specify the option multiple times.
- See Replication Filters for more information.
--replicate-same-server-id
- Commandline:
--replicate-same-server-id
- Description: In replication, if set to 1, do not skip events having our server id. Default value is 0 (to break infinite loops in circular replication). Can't be set to 1 if log-slave-updates is used.
--sporadic-binlog-dump-fail
- Commandline:
--sporadic-binlog-dump-fail
- Description: Option used by mysql-test for debugging and testing of replication.
--sysdate-is-now
- Commandline:
--sysdate-is-now
- Description: Non-default option to alias SYSDATE() to NOW() to make it safe for replication. Since 5.0, SYSDATE() has returned a `dynamic' value different for different invocations, even within the same statement.
Replication and Binary Logging Options and System Variables
The following options and system variables are related to replication and the binary log:
- auto-increment-increment
- auto-increment-offset
- binlog-annotate-row-events
- binlog-cache-size
- binlog-checksum
- binlog-commit-wait-count
- binlog-commit-wait-usec
- binlog-direct-non-transactional-updates|
- binlog-expire-logs-seconds
- binlog-file-cache-size
- binlog-format
- binlog-optimize-thread-scheduling
- binlog-row-image
- binlog-row-metadata
- binlog-stmt-cache-size
- default-master-connection
- gtid-cleanup-batch-size
- gtid-domain-id
- gtid-ignore-duplicates
- gtid-strict-mode
- init-slave
- log-bin
- log-bin-compress
- log-bin-compress-min-len
- log-bin-index
- log-bin-trust-function-creators
- log-slave-updates
- master-verify-checksum
- max-binlog-cache-size
- max-binlog-size
- max-binlog-stmt-cache-size
- max-relay-log-size
- read-binlog-speed-limit
- relay-log
- relay-log-index
- relay-log-info-file
- relay-log-purge
- relay-log-recovery
- relay-log-space-limit
- replicate-annotate-row-events
- replicate-do-db
- replicate-do-table
- replicate-events-marked-for-skip
- replicate-ignore-db
- replicate-ignore-table
- replicate-wild-do-table
- replicate-wild-ignore-table
- report-host
- report-password
- report-port
- report-user
- rpl-recovery-rank
- server-id
- slave-compressed-protocol
- slave-ddl-exec-mode
- slave-domain-parallel-threads
- slave-exec-mode
- slave-load-tmpdir
- slave-max-allowed-packet
- slave-net-timeout
- slave-parallel-max-queued
- slave-parallel-threads
- slave-run-triggers-for-rbr
- slave-skip-errors
- slave-sql-verify-checksum
- slave-transaction-retries
- slave_transaction_retry_errors
- slave_transaction_retry_interval
- slave-type-conversions
- sync-binlog
- sync-master-info
- sync-relay-log
- sync-relay-log-info
Semisynchronous Replication Options and System Variables
The options and system variables related to Semisynchronous Replication are described here.
Optimizer Options
--record-buffer
- Commandline:
--record-buffer=#
- Description: Old alias for read_buffer_size.
- Removed: MariaDB 5.5
--table-cache
- Commandline:
--table-open-cache=#
- Description: Removed; use --table-open-cache instead.
- Removed: MariaDB 5.1.3
Optimizer Options and System Variables
- alter-algorithm
- analyze-sample-percentage
- big-tables
- bulk-insert-buffer-size
- expensive-subquery-limit
- join-buffer-size
- join-buffer-space-limit
- join-cache-level
- max-heap-table-size
- max-join-size
- max-seeks-for-key
- max-sort-length
- mrr-buffer-size
- optimizer-max-sel-arg-weight
- optimizer-prune-level
- optimizer-search-depth
- optimizer-selectivity-sampling-limit
- optimizer-switch
- optimizer-trace
- optimizer-trace-max-mem-size
- optimizer-use-condition-selectivity
- query-alloc-block-size
- query-prealloc-size
- range-alloc-block-size
- read-buffer-size
- rowid-merge-buff-size
- table-definition-cache
- table-open-cache
- table-open-cache-instances
- tmp-disk-table-size
- tmp-memory-table-size
- tmp-table-size
- use-stat-tables
Storage Engine Options
--skip-bdb
- Commandline:
----skip-bdb
- Description: Deprecated option; Exists only for compatibility with very old my.cnf files.
- Removed: MariaDB 10.5.1
MyISAM Storage Engine Options
The options related to the MyISAM storage engine are described below.
--external-locking
- Commandline:
--external-locking
- Description: Use system (external) locking (disabled by default). With this option enabled you can run myisamchk to test (not repair) tables while the server is running. Disable with --skip-external-locking.
--log-isam
- Commandline:
--log-isam[=file_name]
- Description: Enable the MyISAM log, which logs all MyISAM changes to file. If no filename is provided, the default, myisam.log is used.
MyISAM Storage Engine Options and System Variables
Some options and system variables related to the MyISAM storage engine can be found here. Direct links to many of them can be found below.
- concurrent-insert
- delayed-insert-limit
- delayed-insert-timeout
- delayed-queue-size
- keep-files-on-create
- key-buffer-size
- key-cache-age-threshold
- key-cache-block-size
- key-cache-division-limit
- key-cache-file-hash-size
- key-cache-segments
- myisam-block-size
- myisam-data-pointer-size
- myisam-max-sort-file-size
- myisam-mmap-size
- myisam-recover-options
- myisam-repair-threads
- myisam-sort-buffer-size
- myisam-stats-method
- myisam-use-mmap
InnoDB Storage Engine Options
The options related to the InnoDB storage engine are described below.
--innodb
- Commandline:
--innodb=value
,--skip-innodb
- Description: This variable controls whether or not to load the InnoDB storage engine. Possible values are
ON
,OFF
,FORCE
orFORCE_PLUS_PERMANENT
(from MariaDB 5.5). If set toOFF
(the same as --skip-innodb), since InnoDB is the default storage engine, the server will not start unless another storage engine has been chosen with --default-storage-engine.FORCE
means that the storage engine must be successfully loaded, or else the server won't start.FORCE_PLUS_PERMANENT
enables the plugin, but if plugin cannot initialize, the server will not start. In addition, the plugin cannot be uninstalled while the server is running.
--innodb-cmp
- Commandline:
--innodb-cmp
- Description:
- Default:
ON
--innodb-cmp-reset
- Commandline:
--innodb-cmp-reset
- Description:
- Default:
ON
--innodb-cmpmem
- Commandline:
--innodb-cmpmem
- Description:
- Default:
ON
--innodb-cmpmem-reset
- Commandline:
--innodb-cmpmem-reset
- Description:
- Default:
ON
--innodb-file-io-threads
- Commandline:
--innodb-file-io-threads
- Description:
- Default:
4
- Removed: MariaDB 10.3.0
--innodb-index-stats
- Commandline:
--innodb-index-stats
- Description:
- Default:
ON
- Removed: MariaDB 10.0.0
--innodb-lock-waits
- Commandline:
--innodb-lock-waits
- Description:
- Default:
ON
--innodb-locks
- Commandline:
--innodb-locks
- Description:
- Default:
ON
--innodb-rseg
- Commandline:
--innodb-rseg
- Description:
- Default:
ON
- Removed: MariaDB 10.0.0
--innodb-status-file
- Commandline:
--innodb-status-file
- Description:
- Default:
FALSE
--innodb-sys-indexes
- Commandline:
--innodb-sys-indexes
- Description:
- Default:
ON
--innodb-sys-stats
- Commandline:
--innodb-sys-stats
- Description:
- Default:
ON
- Removed: MariaDB 10.0.0
--innodb-sys-tables
- Commandline:
--innodb-sys-tables
- Description:
- Default:
ON
--innodb-table-stats
- Commandline:
--innodb-table-stats
- Description:
- Default:
ON
- Removed: MariaDB 10.0.0
--innodb-trx
- Commandline:
--innodb-trx
- Description:
- Default:
ON
InnoDB Storage Engine Options and System Variables
Some options and system variables related to the InnoDB storage engine can be found here. Direct links to many of them can be found below.
- ignore-builtin-innodb
- innodb-adaptive-checkpoint
- innodb-adaptive-flushing
- innodb-adaptive-flushing-lwm
- innodb-adaptive-flushing-method
- innodb-adaptive-hash-index
- innodb-adaptive-hash-index-partitions
- innodb-adaptive-hash-index-parts
- innodb-adaptive-max-sleep-delay
- innodb-additional-mem-pool-size
- innodb-api-bk-commit-interval
- innodb-api-disable-rowlock
- innodb-api-enable-binlog
- innodb-api-enable-mdl
- innodb-api-trx-level
- innodb-auto-lru-dump
- innodb-autoextend-increment
- innodb-autoinc-lock-mode
- innodb-background-scrub-data-check-interval
- innodb-background-scrub-data-compressed
- innodb-background-scrub-data-interval
- innodb-background-scrub-data-uncompressed
- innodb-blocking-buffer-pool-restore
- innodb-buf-dump-status-frequency
- innodb-buffer-pool-chunk-size
- innodb-buffer-pool-dump-at-shutdown
- innodb-buffer-pool-dump-now
- innodb-buffer-pool-dump-pct
- innodb-buffer-pool-evict
- innodb-buffer-pool-filename
- innodb-buffer-pool-instances
- innodb-buffer-pool-load-abort
- innodb-buffer-pool-load-at-startup
- innodb-buffer-pool-load-now
- innodb-buffer-pool-load-pages-abort
- innodb-buffer-pool-populate
- innodb-buffer-pool-restore-at-startup
- innodb-buffer-pool-shm-checksum
- innodb-buffer-pool-shm-key
- innodb-buffer-pool-size
- innodb-change-buffer-max-size
- innodb-change-buffering
- innodb-change-buffering-debug
- innodb-checkpoint-age-target
- innodb-checksum-algorithm
- innodb-checksums
- innodb-cleaner-lsn-age-factor
- innodb-cmp-per-index-enabled
- innodb-commit-concurrency
- innodb-compression-algorithm
- innodb-compression-failure-threshold-pct
- innodb-compression-level
- innodb-compression-pad-pct-max
- innodb-concurrency-tickets
- innodb-corrupt-table-action
- innodb-data-file-path
- innodb-data-home-dir
- innodb-deadlock-detect
- innodb-deadlock-report
- innodb-default-encryption-key-id
- innodb-default-page-encryption-key
- innodb-default-row-format
- innodb-defragment
- innodb-defragment-fill-factor
- innodb-defragment-fill-factor-n-recs
- innodb-defragment-frequency
- innodb-defragment-n-pages
- innodb-defragment-stats-accuracy
- innodb-dict-size-limit
- innodb_disable_sort_file_cache
- innodb-doublewrite
- innodb-doublewrite-file
- innodb-empty-free-list-algorithm
- innodb-enable-unsafe-group-commit
- innodb-encrypt-log
- innodb-encrypt-tables
- innodb-encrypt-temporary-tables
- innodb-encryption-rotate-key-age
- innodb-encryption-rotation_iops
- innodb-encryption-threads
- innodb-extra-rsegments
- innodb-extra-undoslots
- innodb-fake-changes
- innodb-fast-checksum
- innodb-fast-shutdown
- innodb-fatal-semaphore-wait-threshold
- innodb-file-format
- innodb-file-format-check
- innodb-file-format-max
- innodb-file-per-table
- innodb-fill-factor
- innodb-flush-log-at-trx-commit
- innodb-flush-method
- innodb-flush-neighbor-pages
- innodb-flush-neighbors
- innodb-flush-sync
- innodb-flushing-avg-loops
- innodb-force-load-corrupted
- innodb-force-primary-key
- innodb-force-recovery
- innodb-foreground-preflush
- innodb-ft-aux-table
- innodb-ft-cache-size
- innodb-ft-enable-diag-print
- innodb-ft-enable-stopword
- innodb-ft-max-token-size
- innodb-ft-min-token-size
- innodb-ft-num-word-optimize
- innodb-ft-result-cache-limit
- innodb-ft-server-stopword-table
- innodb-ft-sort-pll-degree
- innodb-ft-total-cache-size
- innodb-ft-user-stopword-table
- innodb-ibuf-accel-rate
- innodb-ibuf-active-contract
- innodb-ibuf-max-size
- innodb-idle-flush-pct
- innodb-immediate-scrub-data-uncompressed
- innodb-import-table-from-xtrabackup
- innodb-instant-alter-column-allowed
- innodb-instrument-semaphores
- innodb-io-capacity
- innodb-io-capacity-max
- innodb-large-prefix
- innodb-lazy-drop-table
- innodb-lock-schedule-algorithm
- innodb-locking-fake-changes
- innodb-locks-unsafe-for-binlog
- innodb-log-arch-dir
- innodb-log-arch-expire-sec
- innodb-log-archive
- innodb-log-block-size
- innodb-log-buffer-size
- innodb-log-checksum-algorithm
- innodb-log-checksums
- innodb-log-compressed-pages
- innodb-log-file-size
- innodb-log-files-in-group
- innodb-log-group-home-dir
- innodb-log-optimize-ddl
- innodb-log-write-ahead-size
- innodb-lru-flush-size
- innodb-lru-scan-depth
- innodb-max-bitmap-file-size
- innodb-max-changed-pages
- innodb-max-dirty-pages-pct
- innodb-max-dirty-pages-pct-lwm
- innodb-max-purge-lag
- innodb-max-purge-lag-delay
- innodb-max-purge-lag-wait
- innodb-max-undo-log-size
- innodb-merge-sort-block-size
- innodb-mirrored-log-groups
- innodb-monitor-disable
- innodb-monitor-enable
- innodb-monitor-reset
- innodb-monitor-reset-all
- innodb-mtflush-threads
- innodb-numa-interleave
- innodb-old-blocks-pct
- innodb-old-blocks-time
- innodb-online-alter-log-max-size
- innodb-open-files
- innodb-optimize-fulltext-only
- innodb-page-cleaners
- innodb-page-size
- innodb-pass-corrupt-table
- innodb-prefix-index-cluster-optimization
- innodb-print-all-deadlocks
- innodb-purge-batch-size
- innodb-purge-rseg-truncate-frequency
- innodb-purge-threads
- innodb-random-read-ahead
- innodb-read-ahead
- innodb-read-ahead-threshold
- innodb-read-io-threads
- innodb-read-only
- innodb-recovery-update-relay-log
- innodb-replication-delay
- innodb-rollback-on-timeout
- innodb-rollback-segments
- innodb-safe-truncate
- innodb-sched-priority-cleaner
- innodb-scrub-log
- innodb-scrub-log-interval
- innodb-scrub-log-speed
- innodb-show-locks-held
- innodb-show-verbose-locks
- innodb-sort-buffer-size
- innodb-spin-wait-delay
- innodb-stats-auto-recalc
- innodb-stats-auto-update
- innodb-stats-include-delete-marked
- innodb-stats-method
- innodb-stats-modified-counter
- innodb-stats-on-metadata
- innodb-stats-persistent
- innodb-stats-persistent-sample-pages
- innodb-stats-sample-pages
- innodb-stats-transient-sample-pages
- innodb-stats-traditional
- innodb-stats-update-need-lock
- innodb-status-output
- innodb-status-output-locks
- innodb-strict-mode
- innodb-support-xa
- innodb-sync-array-size
- innodb-sync-spin-loops
- innodb-table-locks
- innodb-temp-data-file-path
- innodb-thread-concurrency
- innodb-thread-concurrency-timer-based
- innodb-thread-sleep-delay
- innodb-tmpdir
- innodb-track-changed-pages
- innodb-track-redo-log-now
- innodb-undo-directory
- innodb-undo-log-truncate
- innodb-undo-logs
- innodb-undo-tablespaces
- innodb-use-atomic-writes
- innodb-use-fallocate
- innodb-use-global-flush-log-at-trx-commit
- innodb-use-mtflush
- innodb-use-native_aio
- innodb-use-purge-thread
- innodb-use-stacktrace
- innodb-use-sys-malloc
- innodb-use-sys-stats-table
- innodb-use-trim
- innodb-write-io-threads
- skip-innodb
- skip-innodb-checksums
- skip-innodb-doublewrite
Aria Storage Engine Options
The options related to the Aria storage engine are described below.
--aria-log-dir-path
- Commandline:
--aria-log-dir-path=value
- Description: Path to the directory where transactional log should be stored
- Default:
SAME AS DATADIR
Aria Storage Engine Options and System Variables
Some options and system variables related to the Aria storage engine can be found here. Direct links to many of them can be found below.
- aria-block-size
- aria-checkpoint-interval
- aria-checkpoint-log-activity
- aria-encrypt-tables
- aria-force-start-after-recovery-failures
- aria-group-commit
- aria-group-commit-interval
- aria-log-file-size
- aria-log-purge-type
- aria-max-sort-file-size
- aria-page-checksum
- aria-pagecache-age-threshold
- aria-pagecache-buffer-size
- aria-pagecache-division-limit
- aria-pagecache-file-hash-size
- aria-recover
- aria-recover-options
- aria-repair-threads
- aria-sort-buffer-size
- aria-stats-method
- aria-sync-log-dir
- aria-used-for-temp-tables
- deadlock-search-depth-long
- deadlock-search-depth-short
- deadlock-timeout-long
- deadlock-timeout-short
MyRocks Storage Engine Options
The options and system variables related to the MyRocks storage engine can be found here.
S3 Storage Engine Options
The options and system variables related to the S3 storage engine can be found here.
CONNECT Storage Engine Options
The options related to the CONNECT storage engine are described below.
CONNECT Storage Engine Options and System Variables
Some options and system variables related to the CONNECT storage engine can be found here. Direct links to many of them can be found below.
- connect-class-path
- connect-cond-push
- connect-conv-size
- connect-default-depth
- connect-default-prec
- connect-enable-mongo
- connect-exact-info
- connect-force_bson
- connect-indx-map
- connect-java-wrapper
- connect-json-all-path
- connect-json-grp-size
- connect-json-null
- connect-jvm-path
- connect-type-conv
- connect-use-tempfile
- connect-work-size
- connect-xtrace
Spider Storage Engine Options
The options and system variables related to the Spider storage engine can be found here.
Mroonga Storage Engine Options
The options and system variables related to the Mroonga storage engine can be found here.
TokuDB Storage Engine Options
The options and system variables related to the TokuDB storage engine can be found here.
Performance Schema Options
The options related to the Performance Schema are described below.
--performance-schema-consumer-events-stages-current
- Commandline:
--performance-schema-consumer-events-stages-current
- Description: Enable the events-stages-current consumer.
- Default:
OFF
--performance-schema-consumer-events-stages-history
- Commandline:
--performance-schema-consumer-events-stages-history
- Description: Enable the events-stages-history consumer.
- Default:
OFF
--performance-schema-consumer-events-stages-history-long
- Commandline:
--performance-schema-consumer-events-stages-history-long
- Description: Enable the events-stages-history-long consumer.
- Default:
OFF
--performance-schema-consumer-events-statements-current
- Commandline:
--performance-schema-consumer-events-statements-current
- Description: Enable the events-statements-current consumer. Use
--skip-performance-schema-consumer-events-statements-current
to disable. - Default:
ON
--performance-schema-consumer-events-statements-history
- Commandline:
--performance-schema-consumer-events-statements-history
- Description: Enable the events-statements-history consumer.
- Default:
OFF
--performance-schema-consumer-events-statements-history-long
- Commandline:
--performance-schema-consumer-events-statements-history-long
- Description: Enable the events-statements-history-long consumer.
- Default:
OFF
--performance-schema-consumer-events-waits-current
- Commandline:
--performance-schema-consumer-events-waits-current
- Description: Enable the events-waits-current consumer.
- Default:
OFF
--performance-schema-consumer-events-waits-history
- Commandline:
--performance-schema-consumer-events-waits-history
- Description: Enable the events-waits-history consumer.
- Default:
OFF
--performance-schema-consumer-events-waits-history-long
- Commandline:
--performance-schema-consumer-events-waits-history-long
- Description: Enable the events-waits-history-long consumer.
- Default:
OFF
--performance-schema-consumer-global-instrumentation
- Commandline:
--performance-schema-consumer-global-instrumentation
- Description: Enable the global-instrumentation consumer. Use
--skip-performance-schema-consumer-global-instrumentation
to disable. - Default:
ON
--performance-schema-consumer-statements-digest
- Commandline:
--performance-schema-consumer-statements-digest
- Description: Enable the statements-digest consumer. Use
--skip-performance-schema-consumer-statements-digest
to disable. - Default:
ON
--performance-schema-consumer-thread-instrumentation
- Commandline:
--performance-schema-consumer-thread-instrumentation
- Description: Enable the statements-thread-instrumentation. Use
--skip-performance-schema-thread-instrumentation
to disable. - Default:
ON
Performance Schema Options and System Variables
Some options and system variables related to the Performance Schema can be found here. Direct links to many of them can be found below.
- performance-schema
- performance-schema-accounts-size
- performance-schema-digests-size
- performance-schema-events-stages-history-long-size
- performance-schema-events-stages-history-size
- performance-schema-events-statements-history-long-size
- performance-schema-events-statements-history-size
- performance-schema-events-waits-history-long-size
- performance-schema-events-waits-history-size
- performance-schema-hosts-size
- performance-schema-max-cond-classes
- performance-schema-max-cond-instances
- performance-schema-max-digest-length
- performance-schema-max-file-classes
- performance-schema-max-file-handles
- performance-schema-max-file-instances
- performance-schema-max-mutex-classes
- performance-schema-max-mutex-instances
- performance-schema-max-rwlock-classes
- performance-schema-max-rwlock-instances
- performance-schema-max-socket-classes
- performance-schema-max-socket-instances
- performance-schema-max-stage-classes
- performance-schema-max-statement-classes
- performance-schema-max-table-handles
- performance-schema-max-table-instances
- performance-schema-max-thread-classes
- performance-schema-max-thread-instances
- performance-schema-session-connect-attrs-size
- performance-schema-setup-actors-size
- performance-schema-setup-objects-size
- performance-schema-users-size
Galera Cluster Options
The options related to Galera Cluster are described below.
--wsrep-new-cluster
- Commandline:
--wsrep-new-cluster
- Description: Bootstrap a cluster. It works by overriding the current value of wsrep_cluster_address. It is recommended not to add this option to the config file as this will trigger bootstrap on every server start.
Galera Cluster Options and System Variables
Some options and system variables related to Galera Cluster can be found here. Direct links to many of them can be found below.
- wsrep-auto-increment-control
- wsrep-causal-reads
- wsrep-certify-nonPK
- wsrep-cluster-address
- wsrep-cluster-name
- wsrep-convert-LOCK-to-trx
- wsrep-data-home-dir
- wsrep-dbug-option
- wsrep-debug
- wsrep-desync
- wsrep-dirty-reads
- wsrep-drupal-282555-workaround
- wsrep-forced-binlog-format
- wsrep-gtid-domain-id
- wsrep-gtid-mode
- wsrep-ignore-apply-errors
- wsrep-load-data-splitting
- wsrep-log-conflicts
- wsrep-max-ws-rows
- wsrep-max-ws-size
- wsrep-mode
- wsrep-mysql-replication-bundle
- wsrep-node-address
- wsrep-node-incoming-address
- wsrep-node-name
- wsrep-notify-cmd
- wsrep-on
- wsrep-OSU-method
- wsrep-provider
- wsrep-provider-options
- wsrep-recover
- wsrep-reject_queries
- wsrep-retry-autocommit
- wsrep-slave-FK-checks
- wsrep-slave-threads
- wsrep-slave-UK-checks
- wsrep-sr-store
- wsrep-sst-auth
- wsrep-sst-donor
- wsrep-sst-donor-rejects-queries
- wsrep-sst-method
- wsrep-sst-receive-address
- wsrep-start-position
- wsrep-strict-ddl
- wsrep-sync-wait
- wsrep-trx_fragment_size
- wsrep-trx_fragment_unit
Options When Debugging mysqld
--debug-assert-if-crashed-table
- Description: Do an assert in handler::print_error() if we get a crashed table.
--debug-binlog-fsync-sleep
- Description:
--debug-binlog-fsync-sleep=#
If not set to zero, sets the number of micro-seconds to sleep after running fsync() on the binary log to flush transactions to disk. This can thus be used to artificially increase the perceived cost of such an fsync().
--debug-crc-break
- Description:
--debug-crc-break=#
Call my_debug_put_break_here() if crc matches this number (for debug).
--debug-flush
- Description: Default debug log with flush after write.
--debug-no-sync
- Description:
debug-no-sync[=#]
Disables system sync calls. Only for running tests or debugging!
--debug-sync-timeout
- Description:
debug-sync-timeout[=#]
Enable the debug sync facility and optionally specify a default wait timeout in seconds. A zero value keeps the facility disabled.
--gdb
- Description: Set up signals usable for debugging.
--silent-startup
- Description: Don't print Notes to the error log during startup.
- Introduced: MariaDB 10.1.8
--sync-sys
- Description: Enable/disable system sync calls. Syncs should only be turned off (
--disable-sync-sys
) when running tests or debugging! Replaced by debug-no-sync from MariaDB 5.5. - Removed: MariaDB 5.5
--thread-alarm
- Description: Enable/disable system thread alarm calls. Should only be turned off (
--disable-thread-alarm
) when running tests or debugging!
Debugging Options and System Variables
Other Options
--allow-suspicious-udfs
- Commandline:
--allow-suspicious-udfs
- Description: Allows use of user-defined functions consisting of only one symbol
x()
without correspondingx_init()
orx_deinit()
. That also means that one can load any function from any library, for exampleexit()
fromlibc.so
. Not recommended unless you require old UDF's with one symbol that cannot be recompiled
--bootstrap
- Commandline:
--bootstrap
- Description: Used by mysql installation scripts, such as mysql_install_db to execute SQL scripts before any privilege or system tables exist. Do no use while an existing MariaDB instance is running.
--chroot
- Commandline:
--chroot=name
- Description: Chroot mysqld daemon during startup.
--des-key-file
- Commandline:
--des-key-file=name
- Description: Load keys for des_encrypt() and des_encrypt from given file.
--exit-info
- Commandline:
--exit-info[=#]
- Description: Used for debugging. Use at your own risk.
--getopt-prefix-matching
- Commandline:
--getopt-prefix-matching={0|1}
- Description: Makes it possible to disable historical "unambiguous prefix" matching in the command-line option parsing.
- Default: TRUE
- Introduced: MariaDB 10.1.3
--help
- Commandline:
--help
- Description: Displays help with many commandline options described, and exits.
--log-ddl-recovery
- Commandline:
--log-ddl-recovery=name
- Description: Path to file used for recovery of DDL statements after a crash.
- Default Value:
ddl-recover.log
- Introduced: MariaDB 10.6.1
--log-short-format
- Commandline:
--log-short-format
- Description: Don't log extra information to update and slow-query logs.
--log-slow-file
- Commandline:
--log-slow-file=name
- Description: Log slow queries to given log file. Defaults logging to hostname-slow.log
--log-slow-time
- Commandline:
--log-slow-time=#
- Description: Log all queries that have taken more than long-query-time seconds to execute to the slow query log, if active. The argument will be treated as a decimal value with microsecond precision.
--log-tc
- Commandline:
--log-tc=name
- Description: Defines the path to the memory-mapped file-based transaction coordinator log, which is only used if the binary log is disabled. If you have two or more XA-capable storage engines enabled, then a transaction coordinator log must be available. See Transaction Coordinator Log for more information. Also see the the
log_tc_size
system variable and the--tc-heuristic-recover
option. - Default Value:
tc.log
--master-connect-retry
- Commandline:
--master-connect-retry=#
- Description: Deprecated in 5.1.17 and removed in 5.5. The number of seconds the slave thread will sleep before retrying to connect to the master, in case the master goes down or the connection is lost.
--memlock
- Commandline:
--memlock
- Description: Lock mysqld in memory.
--ndb-use-copying-alter-table
- Commandline:
--ndb-use-copying-alter-table
- Description: Force ndbcluster to always copy tables at alter table (should only be used if on-line alter table fails).
--one-thread
- Commandline:
--one-thread
- Description: (Deprecated): Only use one thread (for debugging under Linux). Use thread-handling=no-threads instead.
- Removed: MariaDB 10.0.4
--plugin-load
- Commandline:
--plugin-load=name
- Description: This option can be used to configure the server to load specific plugins. This option uses the following format:
- Plugins can be specified in the format
name=library
, wherename
is the plugin name andlibrary
is the plugin library. This format installs a single plugin from the given plugin library. - Plugins can also be specified in the format
library
, wherelibrary
is the plugin library. This format installs all plugins from the given plugin library. - Multiple plugins can be specified by separating them with semicolons.
- Plugins can be specified in the format
- Special care must be taken when specifying the
--plugin-load
option multiple times, or when specifying both the--plugin-load
option and the--plugin-load-add
option together. The--plugin-load
option resets the plugin load list, and this can cause unexpected problems if you are not aware. The--plugin-load-add
option does not reset the plugin load list, so it is much safer to use. See Plugin Overview: Specifying Multiple Plugin Load Options for more information. - See Plugin Overview: Installing a Plugin with Plugin Load Options for more information.
--plugin-load-add
- Commandline:
--plugin-load-add=name
- Description: This option can be used to configure the server to load specific plugins. This option uses the following format:
- Plugins can be specified in the format
name=library
, wherename
is the plugin name andlibrary
is the plugin library. This format installs a single plugin from the given plugin library. - Plugins can also be specified in the format
library
, wherelibrary
is the plugin library. This format installs all plugins from the given plugin library. - Multiple plugins can be specified by separating them with semicolons.
- Plugins can be specified in the format
- Special care must be taken when specifying both the
--plugin-load
option and the--plugin-load-add
option together. The--plugin-load
option resets the plugin load list, and this can cause unexpected problems if you are not aware. The--plugin-load-add
option does not reset the plugin load list, so it is much safer to use. See Plugin Overview: Specifying Multiple Plugin Load Options for more information. - See Plugin Overview: Installing a Plugin with Plugin Load Options for more information.
- Introduced: MariaDB 10.0.1
--port-open-timeout
- Commandline:
--port-open-timeout=#
- Description: Maximum time in seconds to wait for the port to become free. (Default: No wait).
<<toc-item slug="server-system-variables#proxy_protocol_networks
" level=3>>--proxy-protocol-networks
<</toc-item>>
--safe-user-create
- Commandline:
--safe-user-create
- Description: Don't allow new user creation by the user who has no write privileges to the mysql.user table.
--safemalloc-mem-limit
- Commandline:
--safemalloc-mem-limit=#
- Description: Simulate memory shortage when compiled with the
option.--
with-debug=full
--show-slave-auth-info
- Commandline:
--show-slave-auth-info
- Description: Show user and password in SHOW SLAVE HOSTS on this master.
--skip-grant-tables
- Commandline:
--skip-grant-tables
- Description: Start without grant tables. This gives all users FULL ACCESS to all tables, which is useful in case of a lost root password. Use mysqladmin flush-privileges, mysqladmin reload or FLUSH PRIVILEGES to resume using the grant tables.
--skip-host-cache
- Commandline:
--skip-host-cache
- Description: Don't cache host names.
--skip-partition
- Commandline:
--skip-partition
,--disable-partition
- Description: Disables user-defined partitioning. Previously partitioned tables cannot be accessed or modifed. Tables can still be seen with SHOW TABLES or by viewing the INFORMATION_SCHEMA.TABLES table. Tables can be dropped with DROP TABLE, but this only removes .frm files, not the associated .par files, which will need to be removed manually.
--skip-slave-start
- Commandline:
--skip-slave-start
- Description: If set, slave is not autostarted.
--skip-ssl
- Commandline:
--skip-ssl
- Description: Disable TLS connections.
--skip-symlink
- Commandline:
--skip-symlink
- Description: Don't allow symlinking of tables. Deprecated and removed in MariaDB 5.5. Use symbolic-links with the
skip
option prefix instead. - Removed: MariaDB 5.5
--skip-thread-priority
- Commandline:
--skip-thread-priority
- Description: Don't give threads different priorities. Deprecated and removed in MariaDB 10.0.
- Removed: MariaDB 10.0
--sql-bin-update-same
- Commandline:
--sql-bin-update-same=#
- Description: The update log was deprecated in version 5.0 and replaced by the binary log, so this option did nothing since then. Deprecated and removed in MariaDB 5.5.
- Removed: MariaDB 5.5
--ssl
- Commandline:
--ssl
- Description: Enable TLS for connection (automatically enabled with other flags). Disable with '
'.--
skip-ssl
--stack-trace
- Commandline:
--stack-trace
,--skip-stack-trace
- Description: Print a stack trace on failure. Enabled by default, disable with
-skip-stack-trace
.
--symbolic-links
- Commandline:
--symbolic-links
- Description: Enables symbolic link support. When set, the
have_symlink
system variable shows asYES
. Silently ignored in Windows.
--tc-heuristic-recover
- Commandline:
--tc-heuristic-recover=name
- Description: If manual heuristic recovery is needed, this option defines the decision to use in the heuristic recovery process. Manual heuristic recovery may be needed if the transaction coordination log is missing or if it doesn't contain all prepared transactions. This option can be set to
OFF
,COMMIT
, orROLLBACK
. The default isOFF
. See also the--log-tc
server option and thelog_tc_size
system variable.
--temp-pool
- Commandline:
--temp-pool
- Description: Using this option will cause most temporary files created to use a small set of names, rather than a unique name for each new file. Defaults to
1
until MariaDB 10.5.6, use--skip-temp-pool
to disable. Deprecated and defaults to0
from MariaDB 10.5.7, as benchmarking shows it causes a heavy mutex contention.
--test-expect-abort
- Commandline:
--test-expect-abort
- Description: Expect that server aborts with 'abort'; Don't write out server variables on 'abort'. Useful only for test scripts.
--test-ignore-wrong-options
- Commandline:
--test-ignore-wrong-options
- Description: Ignore wrong enums values in command line arguments. Useful only for test scripts.
--user
- Commandline:
--user=name
- Description: Run mysqld daemon as user.
--verbose
- Commandline:
-v
,--verbose
- Description: Used with help option for detailed help.
Other Options and System Variables
- allow-suspicious-udfs
- automatic-sp-privileges
- back-log
- basedir
- check-constraint-checks
- column-compression-threshold
- column-compression-zlib-level
- column-compression-zlib-strategy
- column-compression-zlib-wrap
- completion-type
- connect-timeout
- datadir
- date-format
- datetime-format
- deadlock-search-depth-long
- deadlock-search-depth-short
- deadlock-timeout-long
- deadlock-timeout-short
- default-password-lifetime
- default-regex-flags
- default-storage-engine
- default-table-type
- delay-key-write
- disconnect-on-expired-password
- div-precision-increment
- enable-named-pipe
- encrypt-binlog
- encrypt-tmp-disk-tables
- encrypt-tmp-files
- encryption-algorithm
- engine-condition-pushdown
- eq-range-index-dive-limit
- event-scheduler
- expire-logs-days
- explicit-defaults-for-timestamp
- extra-max-connections
- extra-port
- flush
- flush-time
- ft-boolean-syntax
- ft-max-word-len
- ft-min-word-len
- ft-query-expansion-limit
- ft-stopword-file
- general-log
- general-log-file
- group-concat-max-len
- histogram-size
- histogram-type
- host-cache-size
- idle-readonly-transaction-timeout
- idle-transaction-timeout
- idle-write-transaction-timeout
- ignore-db-dirs
- in-predicate-conversion-threshold
- init-connect
- init-file
- interactive-timeout
- large-pages
- local-infile
- lock-wait-timeout
- log
- log-disabled-statements
- log-error
- log-output
- log-queries-not-using-indexes
- log-slow-admin-statements
- log-slow-disabled-statements
- log-slow-filter
- log-slow-queries
- log-slow-rate-limit
- log-slow-verbosity
- log-tc-size
- log-warnings
- long-query-time
- low-priority-updates
- lower-case-table-names
- max-allowed-packet
- max-connections
- max-connect-errors
- max-delayed-threads
- max-digest-length
- max-error-count
- max-length-for-sort-data
- max-long-data-size
- max-password-errors
- max-prepared-stmt-count
- max-recursive-iterations
- max-rowid-filter-size
- max-session-mem-used
- max-sp-recursion-depth
- max-statement-time
- max-tmp-tables
- max-user-connections
- max-write-lock-count
- metadata-locks-cache-size
- metadata-locks-hash-instances
- min-examined-row-limit
- mrr-buffer-size
- multi-range-count
- --mysql56-temporal-format
- net-buffer-length
- net-read-timeout
- net-retry-count
- net-write-timeout
- open-files-limit
- pid-file
- plugin-dir
- plugin-maturity
- port
- preload-buffer-size
- profiling-history-size
- progress-report-time
- proxy-protocol-networks
- query-cache-limit
- query-cache-min-res-unit
- query-cache-strip-comments
- query-cache-wlock-invalidate
- read-rnd-buffer-size
- read-only
- require-secure-transport
- safe-show-database
- secure-auth
- secure-file-priv
- secure-timestamp
- session-track-schema
- session-track-state-change
- session-track-system-variables
- session-track-transaction-info
- skip-automatic-sp-privileges
- skip-external-locking
- skip-large-pages
- skip-log-error
- skip-name-resolve
- skip-networking
- skip-show-database
- slow-launch-time
- slow-query-log
- slow-query-log-file
- socket
- sort-buffer-size
- sql-if-exists
- sql-mode
- ssl-ca
- ssl-capath
- ssl-cert
- ssl-cipher
- ssl-crl
- ssl-crlpath
- ssl-key
- standards_compliant_cte
- stored-program-cache
- strict_password_validation
- sync-frm
- system-versioning-alter-history
- system-versioning-asof
- system-versioning-innodb-algorithm-simple
- table-lock-wait-timeout
- tcp-keepalive-interval
- tcp-keepalive-probes
- tcp-keepalive-time
- tcp-nodelay
- thread-cache-size
- thread-concurrency
- thread-handling
- thread-pool-dedicated-listener
- thread-pool-exact-stats
- thread-pool-idle-timeout
- thread-pool-max-threads
- thread-pool-min-threads
- thread-pool-oversubscribe
- thread-pool-prio-kickup-timer
- thread-pool-priority
- thread-pool-size
- thread-pool-stall-limit
- thread-stack
- timed-mutexes
- time-format
- tls-version
- tmpdir
- transaction-isolation
- transaction-alloc-block-size
- transaction-prealloc-size
- transaction-read-only
- updatable-views-with-limit
- userstat
- version
- wait-timeout
Authentication Plugins - Options and System Variables
Authentication Plugin - ed25519
The options related to the ed25519
authentication plugin can be found here.
Authentication Plugin - gssapi
The system variables related to the gssapi
authentication plugin can be found here.
The options related to the gssapi
authentication plugin can be found here.
Authentication Plugin - named_pipe
The options related to the named_pipe
authentication plugin can be found here.
Authentication Plugin - pam
The system variables related to the pam
authentication plugin can be found here.
The options related to the pam
authentication plugin can be found here.
Authentication Plugin - unix_socket
The options related to the unix_socket
authentication plugin can be found here.
Encryption Plugins - Options and System Variables
Encryption Plugin - aws_key_management
The system variables related to the aws_key_management
encryption plugin can be found here.
The options elated to the aws_key_management
encryption plugin can be found here.
Encryption Plugin - file_key_management
The system variables related to the file_key_management
encryption plugin can be found here.
The options related to the file_key_management
encryption plugin can be found here.
Password Validation Plugins - Options and System Variables
Password Validation Plugin - simple_password_check
The system variables related to the simple_password_check
password validation plugin can be found here.
The options related to the simple_password_check
password validation plugin can be found here.
Password Validation Plugin - cracklib_password_check
The system variables related to the cracklib_password_check
password validation plugin can be found here.
The options related to the cracklib_password_check
password validation plugin can be found here.
Audit Plugins - Options and System Variables
Audit Plugin - server_audit
Options and system variables related to the server_audit
audit plugin can be found here.
Audit Plugin - SQL_ERROR_LOG
The system variables related to the SQL_ERROR_LOG
audit plugin can be found here.
The options related to the SQL_ERROR_LOG
audit plugin can be found here.
Audit Plugin - QUERY_RESPONSE_TIME_AUDIT
The options related to the QUERY_RESPONSE_TIME_AUDIT
audit plugin can be found here.
Daemon Plugins - Options and System Variables
Daemon Plugin - handlersocket
The options for the HandlerSocket plugin are all described on the HandlerSocket Configuration Option page.
Information Schema Plugins - Options and System Variables
Information Schema Plugin - DISKS
The options related to the DISKS
information schema plugin can be found here.
Information Schema Plugin - feedback
The system variables related to the feedback
plugin can be found here.
The options related to the feedback
plugin can be found here.
Information Schema Plugin - LOCALES
The options related to the LOCALES
information schema plugin can be found here.
Information Schema Plugin - METADATA_LOCK_INFO
The options related to the METADATA_LOCK_INFO
information schema plugin can be found here.
Information Schema Plugin - QUERY_CACHE_INFO
The options related to the QUERY_CACHE_INFO
information schema plugin can be found here.
Information Schema Plugin - QUERY_RESPONSE_TIME
The system variables related to the QUERY_RESPONSE_TIME
information schema plugin can be found here.
The options related to the QUERY_RESPONSE_TIME
information schema plugin can be found here.
Information Schema Plugin - user_variables
The options related to the user_variables
information schema plugin can be found here.
Information Schema Plugin - WSREP_MEMBERSHIP
The options related to the WSREP_MEMBERSHIP
information schema plugin can be found here.
Information Schema Plugin - WSREP_STATUS
The options related to the WSREP_STATUS
information schema plugin can be found here.
Replication Plugins - Options and System Variables
Replication Plugin - rpl_semi_sync_master
The system variables related to the rpl_semi_sync_master
replication plugin can be found here.
The options related to the rpl_semi_sync_master
replication plugin can be found here.
Replication Plugin - rpl_semi_sync_slave
The system variables related to the rpl_semi_sync_slave
replication plugin can be found here.
The options related to the rpl_semi_sync_slave
replication plugin can be found here.
Default Values
You can verify the default values for an option by doing:
mysqld --no-defaults --help --verbose