This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-13. For the latest, interactive version please visit https://mariadb.com/kb/.

mariadbd Options

Contents

  1. Option Prefixes
    1. --autoset-*
    2. --disable-*
    3. --enable-*
    4. --loose-*
    5. --maximum-*
    6. --skip-*
  2. Option File Options
    1. --defaults-extra-file
    2. --defaults-file
    3. --defaults-group-suffix
    4. --no-defaults
    5. --print-defaults
  3. Compatibility Options
    1. -a, --ansi
    2. --new
    3. --old
    4. --old-alter-table
    5. --old-mode
    6. --old-passwords
    7. --old-style-user-limits
    8. --safe-mode
    9. --show-old-temporals
    10. --skip-new
    11. Compatibility Options and System Variables
  4. Locale Options
    1. --character-set-client-handshake
    2. --character-set-filesystem
    3. --character-set-server
    4. --character-sets-dir
    5. --collation-server
    6. --default-character-set
    7. --default-time-zone
    8. --default-week-format
    9. --language
    10. --lc-messages
    11. --lc-messages-dir
    12. --lc-time-names
    13. Locale Options and System Variables
  5. Windows Options
    1. --console
    2. --named-pipe
    3. --install
    4. --install-manual
    5. --remove
    6. --slow-start-timeout
    7. --standalone
    8. Windows Options and System Variables
  6. Replication and Binary Logging Options
    1. --abort-slave-event-count
    2. --auto-increment-increment
    3. --auto-increment-offset
    4. --binlog-alter-two-phase
    5. --binlog-annotate-row-events
    6. --binlog-cache-size
    7. --binlog-checksum
    8. --binlog-commit-wait-count
    9. --binlog-commit-wait-usec
    10. --binlog-direct-non-transactional-updates
    11. --binlog-do-db
    12. --binlog-expire-logs-seconds
    13. --binlog-file-cache-size
    14. --binlog-format
    15. --binlog-gtid-index
    16. --binlog-gtid-index-page-size
    17. --binlog-gtid-index-span-min
    18. --binlog-ignore-db
    19. --binlog-legacy-event-pos
    20. --binlog-optimize-thread-scheduling
    21. --binlog-row-event-max-size
    22. --binlog-row-image
    23. --binlog-row-metadata
    24. --binlog-space-limit
    25. --binlog-stmt-cache-size
    26. --default-master-connection
    27. --disconnect-slave-event-count
    28. --flashback
    29. --gtid-cleanup-batch-size
    30. --gtid-domain-id
    31. --gtid-ignore-duplicates
    32. --gtid-strict-mode
    33. --init-rpl-role
    34. --init-slave
    35. --log-basename
    36. --log-bin
    37. --log-bin-compress
    38. --log-bin-compress-min-len
    39. --log-bin-index
    40. --log-bin-trust-function-creators
    41. --log-bin-trust-routine-creators
    42. --log-slave-updates
    43. --master-host
    44. --master-info-file
    45. --master-password
    46. --master-port
    47. --master-retry-count
    48. --master-ssl
    49. --master-ssl-ca
    50. --master-ssl-capath
    51. --master-ssl-cert
    52. --master-ssl-cipher
    53. --master-ssl-key
    54. --master-user
    55. --master-verify-checksum
    56. --max-binlog-cache-size
    57. --max-binlog-dump-events
    58. --max-binlog-size
    59. --max-binlog-stmt-cache-size
    60. --max-binlog-total-size
    61. --max-relay-log-size
    62. --read-binlog-speed-limit
    63. --relay-log
    64. --relay-log-index
    65. --relay-log-info-file
    66. --relay-log-purge
    67. --relay-log-recovery
    68. --relay-log-space-limit
    69. --replicate-annotate-row-events
    70. --replicate-do-db
    71. --replicate-do-table
    72. --replicate-events-marked-for-skip
    73. --replicate-ignore-db
    74. --replicate-ignore-table
    75. --replicate-rewrite_db
    76. --replicate-same-server-id
    77. --replicate-wild-do-table
    78. --replicate-wild-ignore-table
    79. --report-host
    80. --report-password
    81. --report-port
    82. --report-user
    83. --rpl-recovery-rank
    84. --server-id
    85. --slave-abort-blocking-timeout
    86. --slave-compressed-protocol
    87. --slave-connections-needed-for-purge
    88. --slave-ddl-exec-mode
    89. --slave-domain-parallel-threads
    90. --slave-exec-mode
    91. --slave-load-tmpdir
    92. --slave-max-allowed-packet
    93. --slave-max-statement-time
    94. --slave-net-timeout
    95. --slave-parallel-threads
    96. --slave-parallel-max-queued
    97. --slave-run-triggers-for-rbr
    98. --slave-skip-errors
    99. --slave-sql-verify-checksum
    100. --slave-transaction-retries
    101. --slave-transaction-retry-errors
    102. --slave-transaction-retry-interval
    103. --slave-type-conversions
    104. --sporadic-binlog-dump-fail
    105. --sync-binlog
    106. --sync-master-info
    107. --sync-relay-log
    108. --sync-relay-log-info
    109. --sysdate-is-now
    110. Replication and Binary Logging Options and System Variables
    111. Semisynchronous Replication Options and System Variables
      1. rpl-semi-sync-master-enabled
      2. rpl-semi-sync-master-timeout
      3. rpl-semi-sync-master-trace-level
      4. rpl-semi-sync-master-wait-no-slave
      5. rpl-semi-sync-master-wait-point
      6. rpl-semi-sync-slave-delay-master
      7. rpl-semi-sync-slave-kill-conn-timeout
      8. rpl-semi-sync-slave-enabled
      9. rpl-semi-sync-slave-trace-level
  7. Optimizer Options
    1. --alter-algorithm
    2. --analyze-sample-percentage
    3. --big-tables
    4. --bulk-insert-buffer-size
    5. --expensive-subquery-limit
    6. --join-buffer-size
    7. --join-buffer-space-limit
    8. --join-cache-level
    9. --max-heap-table-size
    10. --max-join-size
    11. --max-seeks-for-key
    12. --max-sort-length
    13. --mrr-buffer-size
    14. --optimizer-adjust-secondary-key-costs
    15. --optimizer-extra-pruning-depth
    16. --optimizer-join-limit-pref-ratio
    17. --optimizer-max-sel-arg-weight
    18. --optimizer-max-sel-args
    19. --optimizer-prune-level
    20. --optimizer-search-depth
    21. --optimizer-selectivity-sampling-limit
    22. --optimizer-switch
    23. --optimizer-trace
    24. --optimizer-trace-max-mem-size
    25. --optimizer-use-condition-selectivity
    26. --query-alloc-block-size
    27. --query-prealloc-size
    28. --range-alloc-block-size
    29. --read-buffer-size
    30. --record-buffer
    31. --rowid-merge-buff-size
    32. --table-cache
    33. --table-definition-cache
    34. --table-open-cache
    35. --table-open-cache-instances
    36. --tmp-disk-table-size
    37. --tmp-memory-table-size
    38. --tmp-table-size
    39. --use-stat-tables
    40. Optimizer Options and System Variables
  8. Storage Engine Options
    1. --skip-bdb
    2. --external-locking
    3. MyISAM Storage Engine Options
      1. --concurrent-insert
      2. --delayed-insert-limit
      3. --delayed-insert-timeout
      4. --delayed-queue-size
      5. --keep-files-on-create
      6. --key-buffer-size
      7. --key-cache-age-threshold
      8. --key-cache-block-size
      9. --key-cache-division-limit
      10. --key-cache-file-hash-size
      11. --key-cache-segments
      12. --log-isam
      13. --myisam-block-size
      14. --myisam-data-pointer-size
      15. --myisam-max-sort-file-size
      16. --myisam-mmap-size
      17. --myisam-recover-options
      18. --myisam-repair-threads
      19. --myisam-sort-buffer-size
      20. --myisam-stats-method
      21. --myisam-use-mmap
      22. MyISAM Storage Engine Options and System Variables
    4. InnoDB Storage Engine Options
      1. --ignore-builtin-innodb
      2. --innodb
      3. --innodb-adaptive-checkpoint
      4. --innodb-adaptive-flushing
      5. --innodb-adaptive-flushing-lwm
      6. --innodb-adaptive-flushing-method
      7. --innodb-adaptive-hash-index
      8. --innodb-adaptive-hash-index-partitions
      9. --innodb-adaptive-hash-index-parts
      10. --innodb-adaptive-max-sleep-delay
      11. --innodb-additional-mem-pool-size
      12. --innodb-alter-copy-bulk
      13. --innodb-api-bk-commit-interval
      14. --innodb-api-disable-rowlock
      15. --innodb-api-enable-binlog
      16. --innodb-api-enable-mdl
      17. --innodb-api-trx-level
      18. --innodb-auto-lru-dump
      19. --innodb-autoextend-increment
      20. --innodb-autoinc-lock-mode
      21. --innodb-background-scrub-data-check-interval
      22. --innodb-background-scrub-data-compressed
      23. --innodb-background-scrub-data-interval
      24. --innodb-background-scrub-data-uncompressed
      25. --innodb-blocking-buffer-pool-restore
      26. --innodb-buf-dump-status-frequency
      27. --innodb-buffer-pool-chunk-size
      28. --innodb-buffer-pool-dump-at-shutdown
      29. --innodb-buffer-pool-dump-now
      30. --innodb-buffer-pool-dump-pct
      31. --innodb-buffer-pool-evict
      32. --innodb-buffer-pool-filename
      33. --innodb-buffer-pool-instances
      34. --innodb-buffer-pool-load-abort
      35. --innodb-buffer-pool-load-at-startup
      36. --innodb-buffer-pool-load-now
      37. --innodb-buffer-pool-load-pages-abort
      38. --innodb-buffer-pool-populate
      39. --innodb-buffer-pool-restore-at-startup
      40. --innodb-buffer-pool-shm-checksum
      41. --innodb-buffer-pool-shm-key
      42. --innodb-buffer-pool-size
      43. --innodb-change-buffer-max-size
      44. --innodb-change-buffering
      45. --innodb-change-buffering-debug
      46. --innodb-checkpoint-age-target
      47. --innodb-checksum-algorithm
      48. --innodb-checksums
      49. --innodb-cleaner-lsn-age-factor
      50. --innodb-cmp
      51. --innodb-cmp-per-index-enabled
      52. --innodb-cmp-reset
      53. --innodb-cmpmem
      54. --innodb-cmpmem-reset
      55. --innodb-commit-concurrency
      56. --innodb-compression-algorithm
      57. --innodb-compression-failure-threshold-pct
      58. --innodb-compression-level
      59. --innodb-compression-pad-pct-max
      60. --innodb-concurrency-tickets
      61. --innodb-corrupt-table-action
      62. --innodb-data-file-buffering
      63. --innodb-data-file-path
      64. --innodb-data-file-write-through
      65. --innodb-data-home-dir
      66. --innodb-deadlock-detect
      67. --innodb-deadlock-report
      68. --innodb-default-encryption-key-id
      69. --innodb-default-page-encryption-key
      70. --innodb-default-row-format
      71. --innodb-defragment
      72. --innodb-defragment-fill-factor
      73. --innodb-defragment-fill-factor-n-recs
      74. --innodb-defragment-frequency
      75. --innodb-defragment-n-pages
      76. --innodb-defragment-stats-accuracy
      77. --innodb-dict-size-limit
      78. --innodb-disable-sort-file-cache
      79. --innodb-doublewrite
      80. --innodb-doublewrite-file
      81. --innodb-empty-free-list-algorithm
      82. --innodb-enable-unsafe-group-commit
      83. --innodb-encrypt-log
      84. --innodb-encrypt-tables
      85. --innodb-encrypt-temporary-tables
      86. --innodb-encryption-rotate-key-age
      87. --innodb-encryption-rotation-iops
      88. --innodb-encryption-threads
      89. --innodb-extra-rsegments
      90. --innodb-extra-undoslots
      91. --innodb-fake-changes
      92. --innodb-fast-checksum
      93. --innodb-fast-shutdown
      94. --innodb-fatal-semaphore-wait-threshold
      95. --innodb-file-format
      96. --innodb-file-format-check
      97. --innodb-file-format-max
      98. --innodb-file-io-threads
      99. --innodb-file-per-table
      100. --innodb-filll-factor
      101. --innodb-flush-log-at-trx-commi
      102. --innodb-flush-method
      103. --innodb-flush-neighbor-pages
      104. --innodb-flush-neighbors
      105. --innodb-flush-sync
      106. --innodb-flushing-avg-loops
      107. --innodb-force-load-corrupted
      108. --innodb-force-primary-key
      109. --innodb-force-recovery
      110. --innodb-foreground-preflush
      111. --innodb-ft-aux-table
      112. --innodb-ft-cache-size
      113. --innodb-ft-enable-diag-print
      114. --innodb-ft-enable-stopword
      115. --innodb-ft-max-token-size
      116. --innodb-ft-min-token-size
      117. --innodb-ft-num-word-optimize
      118. --innodb-ft-result-cache-limit
      119. --innodb-ft-server-stopword-table
      120. --innodb-ft-sort-pll-degree
      121. --innodb-ft-total-cache-size
      122. --innodb-ft-user-stopword-table
      123. --innodb-ibuf-accel-rate
      124. --innodb-ibuf-active-contract
      125. --innodb-ibuf-max-size
      126. --innodb-idle-flush-pct
      127. --innodb-immediate-scrub-data-uncompressed
      128. --innodb-import-table-from-xtrabackup
      129. --innodb-index-stats
      130. --innodb-instant-alter-column-allowed
      131. --innodb-instrument-semaphores
      132. --innodb-io-capacity
      133. --innodb-io-capacity-max
      134. --innodb-large-prefix
      135. --innodb-lazy-drop-table
      136. --innodb-lock-schedule-algorithm
      137. --innodb-lock-wait-timeout
      138. --innodb-lock-waits
      139. --innodb-locking-fake-changes
      140. --innodb-locks
      141. --innodb-locks-unsafe-for-binlog
      142. --innodb-log-arch-dir
      143. --innodb-log-arch-expire-sec
      144. --innodb-log-archive
      145. --innodb-log-block-size
      146. --innodb-log-buffer-size
      147. --innodb-log-checksum-algorithm
      148. --innodb-log-checksums
      149. --innodb-log-compressed-pages
      150. --innodb-log-file-buffering
      151. --innodb-log-file-size
      152. --innodb-log-file-write-through
      153. --innodb-log-files-in-group
      154. --innodb-log-group-home-dir
      155. --innodb-log-optimize-ddl
      156. --innodb-log-spin-wait-delay
      157. --innodb-log-write-ahead-size
      158. --innodb-lru-flush-size
      159. --innodb-lru-scan-depth
      160. --innodb-max-bitmap-file-size
      161. --innodb-max-changed-pages
      162. --innodb-max-dirty-pages-pct
      163. --innodb-max-dirty-pages-pct-lwm
      164. --innodb-max-purge-lag
      165. --innodb-max-purge-lag-delay
      166. --innodb-max-purge-lag-wait
      167. --innodb-max-undo-log-size
      168. --innodb-merge-sort-block-size
      169. --innodb-mirrored-log-groups
      170. --innodb-monitor-disable
      171. --innodb-monitor-enable
      172. --innodb-monitor-reset
      173. --innodb-monitor-reset-all
      174. --innodb-mtflush-threads
      175. --innodb-numa-interleave
      176. --innodb-old-blocks-pct
      177. --innodb-old-blocks-time
      178. --innodb-online-alter-log-max-size
      179. --innodb-open-files
      180. --innodb-optimize-fulltext-only
      181. --innodb-page-cleaners
      182. --innodb-page-size
      183. --innodb-pass-corrupt-table
      184. --innodb-prefix-index-cluster-optimization
      185. --innodb-print-all-deadlocks
      186. --innodb-purge-batch-size
      187. --innodb-purge-rseg-truncate-frequency
      188. --innodb-purge-threads
      189. --innodb-random-read-ahead
      190. --innodb-read-ahead
      191. --innodb-read-ahead-threshold
      192. --innodb-read-io-threads
      193. --innodb-read-only
      194. --innodb-recovery-update-relay-log
      195. --innodb-replication-delay
      196. --innodb-rollback-on-timeout
      197. --innodb-rollback-segments
      198. --innodb-rseg
      199. --innodb-sched-priority-cleaner
      200. --innodb-safe-truncate
      201. --innodb-scrub-log
      202. --innodb-scrub-log-interval
      203. --innodb-scrub-log-speed
      204. --innodb-show-locks-held
      205. --innodb-show-verbose-locks
      206. --innodb-snapshot-isolation
      207. --innodb-sort-buffer-size
      208. --innodb-spin-wait-delay
      209. --innodb-stats-auto-recalc
      210. --innodb-stats-auto-update
      211. --innodb-stats-include-delete-marked
      212. --innodb-stats-method
      213. --innodb-stats-modified-counter
      214. --innodb-stats-on-metadata
      215. --innodb-stats-persistent
      216. --innodb-stats-persistent-sample-pages
      217. --innodb-stats-sample-pages
      218. --innodb-stats-traditional
      219. --innodb-stats-transient-sample-pages
      220. --innodb-stats-update-need-lock
      221. --innodb-status-file
      222. --innodb-status-output
      223. --innodb-status-output-locks
      224. --innodb-strict-mode
      225. --innodb-support-xa
      226. --innodb-sync-array-size
      227. --innodb-sync-spin-loops
      228. --innodb-sys-indexes
      229. --innodb-sys-stats
      230. --innodb-sys-tables
      231. --innodb-table-locks
      232. --innodb-table-stats
      233. --innodb-temp-data-file-path
      234. --innodb-thread-concurrency
      235. --innodb-thread-concurrency-timer-based
      236. --innodb-thread-sleep-delay
      237. --innodb-tmpdir
      238. --innodb-track-changed-pages
      239. --innodb-track-redo-log-now
      240. --innodb-trx
      241. --innodb-truncate-temporary-tablespace-now
      242. --innodb-undo-directory
      243. --innodb-undo-log-truncate
      244. --innodb-undo-logs
      245. --innodb-undo-tablespaces
      246. --innodb-use-atomic-writes
      247. --innodb-use-fallocate
      248. --innodb-use-global-flush-log-at-trx-commit
      249. --innodb-use-mtflush
      250. --innodb-use-native-aio
      251. --innodb-use-purge-thread
      252. --innodb-use-stacktrace
      253. --innodb-use-sys-malloc
      254. --innodb-use-sys-stats-table
      255. --innodb-use-trim
      256. --innodb-write-io-threads
      257. --skip-innodb
      258. --skip-innodb-checksums
      259. --skip-innodb-doublewrite
      260. InnoDB Storage Engine Options and System Variables
    5. Aria Storage Engine Options
      1. --aria-block-size
      2. --aria-checkpoint-interval
      3. --aria-checkpoint-log-activity
      4. --aria-encrypt-tables
      5. --aria-force-start-after-recovery-failures
      6. --aria-group-commit
      7. --aria-group-commit-interval
      8. --aria-log-dir-path
      9. --aria-log-file-size
      10. --aria-log-purge-type
      11. --aria-max-sort-file-size
      12. --aria-page-checksum
      13. --aria-pagecache-age-threshold
      14. --aria-pagecache-buffer-size
      15. --aria-pagecache-division-limit
      16. --aria-pagecache-file-hash-size
      17. --aria-recover
      18. --aria-recover-options
      19. --aria-repair-threads
      20. --aria-sort-buffer-size
      21. --aria-stats-method
      22. --aria-sync-log-dir
      23. --aria-used-for-temp-tables
      24. --deadlock-search-depth-long
      25. --deadlock-search-depth-short
      26. --deadlock-timeout-long
      27. --deadlock-timeout-short
      28. Aria Storage Engine Options and System Variables
    6. MyRocks Storage Engine Options
    7. S3 Storage Engine Options
      1. --s3-access-key
      2. --s3-block-size
      3. --s3-bucket
      4. --s3-debug
      5. --s3-host-name
      6. --s3-pagecache-age-threshold
      7. --s3-pagecache-buffer-size
      8. --s3-pagecache-division-limit
      9. --s3-pagecache-file-hash-size
      10. --s3-port
      11. --s3-protocol-version
      12. --s3-region
      13. --s3-secret-key
      14. --s3-slave-ignore-updates
      15. --s3-use-http
    8. CONNECT Storage Engine Options
      1. --connect-class-path
      2. --connect-cond-push
      3. --connect-conv-size
      4. --connect-default-depth
      5. --connect-default-prec
      6. --connect-enable-mongo
      7. --connect-exact-info
      8. --connect-force-bson
      9. --connect-indx-map
      10. --connect-java-wrapper
      11. --connect-json-all-path
      12. --connect-json-grp-size
      13. --connect-json-null
      14. --connect-jvm-path
      15. --connect-type-conv
      16. --connect-use-tempfile
      17. --connect-work-size
      18. --connect-xtrace
      19. CONNECT Storage Engine Options and System Variables
    9. Spider Storage Engine Options
    10. Mroonga Storage Engine Options
    11. TokuDB Storage Engine Options
    12. Vector Options
  9. Performance Schema Options
    1. --performance-schema
    2. --performance-schema-accounts-size
    3. --performance-schema-consumer-events-stages-current
    4. --performance-schema-consumer-events-stages-history
    5. --performance-schema-consumer-events-stages-history-long
    6. --performance-schema-consumer-events-statements-current
    7. --performance-schema-consumer-events-statements-history
    8. --performance-schema-consumer-events-statements-history-long
    9. --performance-schema-consumer-events-waits-current
    10. --performance-schema-consumer-events-waits-history
    11. --performance-schema-consumer-events-waits-history-long
    12. --performance-schema-consumer-global-instrumentation
    13. --performance-schema-consumer-statements-digest
    14. --performance-schema-consumer-thread-instrumentation
    15. --performance-schema-digests-size
    16. --performance-schema-events-stages-history-long-size
    17. --performance-schema-events-stages-history-size
    18. --performance-schema-events-statements-history-long-size
    19. --performance-schema-events-statements-history-size
    20. --performance-schema-events-transactions-history-long-size
    21. --performance-schema-events-transactions-history-size
    22. --performance-schema-events-waits-history-long-size
    23. --performance-schema-events-waits-history-size
    24. --performance-schema-hosts-size
    25. --performance-schema-max-cond-classes
    26. --performance-schema-max-cond-instances
    27. --performance-schema-max-digest-length
    28. --performance-schema-max-file-classes
    29. --performance-schema-max-file-handles
    30. --performance-schema-max-file-instances
    31. --performance-schema-max-index-stat
    32. --performance-schema-max-memory-classes
    33. --performance-schema-max-metadata-locks
    34. --performance-schema-max-mutex-classes
    35. --performance-schema-max-mutex-instances
    36. --performance-schema-max-prepared-statement-instances
    37. --performance-schema-max-program-instances
    38. --performance-schema-max-sql-text-length
    39. --performance-schema-max-rwlock-classes
    40. --performance-schema-max-rwlock-instances
    41. --performance-schema-max-socket-classes
    42. --performance-schema-max-socket-instances
    43. --performance-schema-max-stage-classes
    44. --performance-schema-max-statement-classes
    45. --performance-schema-max-statement-stack
    46. --performance-schema-max-table-handles
    47. --performance-schema-max-table-instances
    48. --performance-schema-max-table-lock-stat
    49. --performance-schema-max-thread-classes
    50. --performance-schema-max-thread-instances
    51. --performance-schema-session-connect-attrs-size
    52. --performance-schema-setup-actors-size
    53. --performance-schema-setup-objects-size
    54. --performance-schema-users-size
    55. Performance Schema Options and System Variables
  10. Galera Cluster Options
    1. --wsrep-allowlist
    2. --wsrep-auto-increment-control
    3. --wsrep-causal-reads
    4. --wsrep-certify-nonPK
    5. --wsrep-cluster-address
    6. --wsrep-cluster-name
    7. --wsrep-convert-LOCK-to-trx
    8. --wsrep-data-home-dir
    9. --wsrep-dbug-option
    10. --wsrep-debug
    11. --wsrep-desync
    12. --wsrep-dirty-reads
    13. --wsrep-drupal-282555-workaround
    14. --wsrep-forced-binlog-format
    15. --wsrep-gtid-domain-id
    16. --wsrep-gtid-mode
    17. --wsrep-ignore-apply-errors
    18. --wsrep-load-data-splitting
    19. --wsrep-log-conflicts
    20. --wsrep-max-ws-rows
    21. --wsrep-max-ws-size
    22. --wsrep-mode
    23. --wsrep-mysql-replication-bundle
    24. --wsrep-new-cluster
    25. --wsrep-node-address
    26. --wsrep-node-incoming-address
    27. --wsrep-node-name
    28. --wsrep-notify-cmd
    29. --wsrep-on
    30. --wsrep-OSU-method
    31. --wsrep-provider
    32. --wsrep-provider-options
    33. --wsrep-recover
    34. --wsrep-reject_queries
    35. --wsrep-replicate-myisam
    36. --wsrep-restart-slave
    37. --wsrep-retry-autocommit
    38. --wsrep-slave-FK-checks
    39. --wsrep-slave-threads
    40. --wsrep-slave-UK-checks
    41. --wsrep-sr-store
    42. --wsrep-sst-auth
    43. --wsrep-sst-donor
    44. --wsrep-sst-donor-rejects-queries
    45. --wsrep-sst-method
    46. --wsrep-sst-receive-address
    47. --wsrep-start-position
    48. --wsrep-status-file
    49. --wsrep-strict-ddl
    50. --wsrep-sync-wait
    51. --wsrep-trx-fragment-size
    52. --wsrep-trx-fragment-unit
    53. Galera Cluster Options and System Variables
  11. Options When Debugging mariadbd
    1. --core-file
    2. --debug
    3. --debug-assert-if-crashed-table
    4. --debug-binlog-fsync-sleep
    5. --debug-crc-break
    6. --debug-flush
    7. --debug-no-thread-alarm
    8. --debug-no-sync
    9. --debug-sync-timeout
    10. --gdb
    11. --silent-startup
    12. --sync-sys
    13. --thread-alarm
    14. Debugging Options and System Variables
  12. Other Options
    1. --allow-suspicious-udfs
    2. --autocommit
    3. --automatic-sp-privileges
    4. --back-log
    5. --basedir
    6. --bind-address
    7. --block-encryption-mode
    8. --bootstrap
    9. --check-constraint-checks
    10. --chroot
    11. --column-compression-threshold
    12. --column-compression-zlib-level
    13. --column-compression-zlib-strategy
    14. --column-compression-zlib-wrap
    15. --completion-type
    16. --connect-timeout
    17. --datadir
    18. --date-format
    19. --datetime-format
    20. --deadlock-search-depth-long
    21. --deadlock-search-depth-short
    22. --deadlock-timeout-long
    23. --deadlock-timeout-short
    24. --default-password-lifetime
    25. --default-regex-flags
    26. --default-storage-engine
    27. --default-table-type
    28. --default-tmp-storage-engine
    29. --delay-key-write
    30. --des-key-file
    31. --disconnect-on-expired-password
    32. --div-precision-increment
    33. --encrypt-binlog
    34. --encrypt-tmp-disk-tables
    35. --encrypt-tmp-files
    36. --encryption-algorithm
    37. --engine-condition-pushdown
    38. --eq-range-index-dive-limit
    39. --event-scheduler
    40. --exit-info
    41. --expire-logs-days
    42. --explicit-defaults-for-timestamp
    43. --extra-max-connections
    44. --extra-port
    45. --flush
    46. --flush-time
    47. --ft-boolean-syntax
    48. --ft-max-word-len
    49. --ft-min-word-len
    50. --ft-query-expansion-limit
    51. --ft-stopword-file
    52. --general-log
    53. --general-log-file
    54. --getopt-prefix-matching
    55. --group-concat-max-len
    56. --help
    57. --histogram-size
    58. --histogram-type
    59. --host-cache-size
    60. --idle-readonly-transaction-timeout
    61. --idle-transaction-timeout
    62. --idle-write-transaction-timeout
    63. --ignore-db-dirs
    64. --in-predicate-conversion-threshold
    65. --init-connect
    66. --init-file
    67. --interactive-timeout
    68. --large-pages
    69. --local-infile
    70. --lock-wait-timeout
    71. --log
    72. --log-disabled_statements
    73. --log-error
    74. --log-output
    75. --log-queries-not-using-indexes
    76. --log-ddl-recovery
    77. --log-short-format
    78. --log-slow-admin-statements
    79. --log-slow-always-query-time
    80. --log-slow-disabled-statements
    81. --log-slow-file
    82. --log-slow-filter
    83. --log-slow-min-examined-row_limit
    84. --log-slow-queries
    85. --log-slow-query
    86. --log-slow-query-file
    87. --log-slow-query-time
    88. --log-slow-rate-limit
    89. --log-slow-slave-statements
    90. --log-slow-time
    91. --log-slow-verbosity
    92. --log-tc
    93. --log-tc-size
    94. --log-warnings
    95. --long-query-time
    96. --low-priority-updates
    97. --lower-case-table-names
    98. --master-connect-retry
    99. --max-allowed-packet
    100. --max-connections
    101. --max-connect-errors
    102. --max-delayed-threads
    103. --max-digest-length
    104. --max-error-count
    105. --max-length-for-sort-data
    106. --max-long-data-size
    107. --max-password-errors
    108. --max-prepared-stmt-count
    109. --max-recursive-iterations
    110. --max-rowid-filter-size
    111. --max-session-mem-used
    112. --max-sp-recursion-depth
    113. --max-statement-time
    114. --max-tmp-session-space-usage
    115. --max-tmp-tables
    116. --max-tmp-total-space-usage
    117. --max-user-connections
    118. --max-write-lock-count
    119. --memlock
    120. --metadata-locks-cache-size
    121. --metadata-locks-hash-instances
    122. --min-examined-row-limit
    123. --mrr-buffer-size
    124. --multi-range-count
    125. --mysql56-temporal-format
    126. --ndb-use-copying-alter-table
    127. --net-buffer-length
    128. --net-read-timeout
    129. --net-retry-count
    130. --net-write-timeout
    131. --one-thread
    132. --open-files-limit
    133. --pid-file
    134. --plugin-load
    135. --plugin-load-add
    136. --plugin-dir
    137. --plugin-maturity
    138. --port
    139. --port-open-timeout
    140. --preload-buffer-size
    141. --profiling-history-size
    142. --progress-report-time
    143. --proxy-protocol-networks
    144. --query-cache-info
    145. --query-cache-limit
    146. --query-cache-min-res-unit
    147. --query-cache-size
    148. --query-cache-strip-comments
    149. --query-cache-type
    150. --query-cache-wlock-invalidate
    151. --read-rnd-buffer-size
    152. --read-only
    153. --redirect-url
    154. --require-secure-transport
    155. --safe-show-database
    156. --safe-user-create
    157. --safemalloc-mem-limit
    158. --secure-auth
    159. --secure-file-priv
    160. --secure-timestamp
    161. --session-track-schema
    162. --session-track-state-change
    163. --session-track-system-variables
    164. --session-track-transaction-info
    165. --show-slave-auth-info
    166. --skip-automatic-sp-privileges
    167. --skip-external-locking
    168. --skip-grant-tables
    169. --skip-host-cache
    170. --skip-large-pages
    171. --skip-log-error
    172. --skip-name-resolve
    173. --skip-networking
    174. --skip-partition
    175. --skip-show-database
    176. --skip-slave-start
    177. --skip-ssl
    178. --skip-symlink
    179. --skip-thread-priority
    180. --slow-launch-time
    181. --slow-query-log
    182. --slow-query-log-file
    183. --socket
    184. --sort-buffer-size
    185. --sql-bin-update-same
    186. --sql-if-exists
    187. --sql-mode
    188. --ssl
    189. --ssl-ca
    190. --ssl-capath
    191. --ssl-cert
    192. --ssl-cipher
    193. --ssl-crl
    194. --ssl-crlpath
    195. --ssl-key
    196. --stack-trace
    197. --standard-compliant-cte
    198. --stored-program-cache
    199. --strict-password-validation
    200. --symbolic-links
    201. --sync-frm
    202. --system-versioning-alter-history
    203. --system-versioning-asof
    204. --system-versioning-innodb-algorithm-simple
    205. --system-versioning-insert-history
    206. --table-lock-wait-timeout
    207. --tc-heuristic-recover
    208. --tcp-keepalive-interval
    209. --tcp-keepalive-probes
    210. --tcp-keepalive-time
    211. --tcp-nodelay
    212. --temp-pool
    213. --test-expect-abort
    214. --test-ignore-wrong-options
    215. --thread-cache-size
    216. --thread-concurrency
    217. --thread-handling
    218. --thread-pool-dedicated-listener
    219. --thread-pool-exact-stats
    220. --thread-pool-idle-timeout
    221. --thread-pool-max-threads
    222. --thread-pool-min-threads
    223. --thread-pool-prio-kickup-timer
    224. --thread-pool-priority
    225. --thread-pool-size
    226. --thread-pool-stall-limit
    227. --thread-stack
    228. --timed-mutexes
    229. --time-format
    230. --tls_version
    231. --tmpdir
    232. --transaction-isolation
    233. --transaction-alloc-block-size
    234. --transaction-prealloc-size
    235. --transaction-read-only
    236. --updatable-views-with-limit
    237. --user
    238. --userstat
    239. --verbose
    240. --version
    241. --wait-timeout
  13. Other Options and System Variables
  14. Authentication Plugins - Options and System Variables
    1. Authentication Plugin - ed25519
      1. ed25519
    2. Authentication Plugin - gssapi
      1. gssapi
      2. gssapi_keytab_path
      3. gssapi_principal_name
      4. gssapi_mech_name
    3. Authentication Plugin - named_pipe
      1. named_pipe
    4. Authentication Plugin - pam
      1. pam
      2. pam_debug
      3. pam_use_cleartext_plugin
      4. pam_winbind_workaround
    5. Authentication Plugin - unix_socket
      1. unix_socket
  15. Encryption Plugins - Options and System Variables
    1. Encryption Plugin - aws_key_management
      1. aws_key_management
      2. aws_key_management_key_spec
      3. aws_key_management_log_level
      4. aws_key_management_master_key_id
      5. aws_key_management_mock
      6. aws_key_management_region
      7. aws_key_management_request_timeout
      8. aws_key_management_rotate_key
    2. Encryption Plugin - file_key_management
      1. file_key_management
      2. file_key_management_encryption_algorithm
      3. file_key_management_filekey
      4. file_key_management_filename
  16. Password Validation Plugins - Options and System Variables
    1. Password Validation Plugin - simple_password_check
      1. simple_password_check
      2. simple_password_check_digits
      3. simple_password_check_letters_same_case
      4. simple_password_check_minimal_length
      5. simple_password_check_other_characters
    2. Password Validation Plugin - cracklib_password_check
      1. cracklib_password_check
      2. cracklib_password_check_dictionary
  17. Audit Plugins - Options and System Variables
    1. Audit Plugin - server_audit
      1. server-audit
      2. server-audit-events
      3. server-audit-excl-users
      4. server-audit-file-path
      5. server-audit-file-rotate-now
      6. server-audit-file-rotate-size
      7. server-audit-file-rotations
      8. server-audit-incl-users
      9. server-audit-logging
      10. server-audit-mode
      11. server-audit-output-type
      12. server-audit-query-limit
      13. server-audit-syslog-facility
      14. server-audit-syslog-ident
      15. server-audit-syslog-info
      16. server-audit-syslog-priority
    2. Audit Plugin - SQL_ERROR_LOG
      1. sql_error_log
      2. sql_error_log_filename
      3. sql_error_log_filename
      4. sql_error_log_rate
      5. sql_error_log_rotate
      6. sql_error_log_rotations
      7. sql_error_log_size_limit
    3. Audit Plugin - QUERY_RESPONSE_TIME_AUDIT
      1. query_response_time_audit
  18. Daemon Plugins - Options and System Variables
    1. Daemon Plugin - handlersocket
      1. handlersocket-accept-balance
      2. handlersocket-address
      3. handlersocket-backlog
      4. handlersocket-epoll
      5. handlersocket-plain-secret
      6. handlersocket-plain-secret-wr
      7. handlersocket-port
      8. handlersocket-port-wr
      9. handlersocket-rcvbuf
      10. handlersocket-readsize
      11. handlersocket-sndbuf
      12. handlersocket-threads
      13. handlersocket-threads-wr
      14. handlersocket-timeout
      15. handlersocket-verbose
      16. handlersocket-wrlock-timeout
  19. Information Schema Plugins - Options and System Variables
    1. Information Schema Plugin - DISKS
      1. disks
    2. Information Schema Plugin - feedback
      1. feedback
      2. feedback_http_proxy
      3. feedback_send_retry_wait
      4. feedback_send_timeout
      5. feedback_url
      6. feedback_user_info
    3. Information Schema Plugin - LOCALES
      1. locales
    4. Information Schema Plugin - METADATA_LOCK_INFO
      1. metadata_lock_info
    5. Information Schema Plugin - QUERY_CACHE_INFO
      1. query_cache_info
    6. Information Schema Plugin - QUERY_RESPONSE_TIME
      1. query_response_time
      2. query_response_time_flush
      3. query_response_time_range_base
      4. query_response_time_exec_time_debug
      5. query_response_time_stats
    7. Information Schema Plugin - user_variables
      1. user_variables
    8. Information Schema Plugin - WSREP_MEMBERSHIP
      1. wsrep_membership
    9. Information Schema Plugin - WSREP_STATUS
      1. wsrep_status
  20. Replication Plugins - Options and System Variables
    1. Replication Plugin - rpl_semi_sync_master
      1. rpl_semi_sync_master
      2. rpl-semi-sync-master-enabled
      3. rpl-semi-sync-master-timeout
      4. rpl-semi-sync-master-trace-level
      5. rpl-semi-sync-master-wait-no-slave
      6. rpl-semi-sync-master-wait-point
    2. Replication Plugin - rpl_semi_sync_slave
      1. rpl_semi_sync_slave
      2. rpl-semi-sync-slave-delay-master
      3. rpl-semi-sync-slave-kill-conn-timeout
      4. rpl-semi-sync-slave-enabled
      5. rpl-semi-sync-slave-trace-level
  21. Default Values

This page lists all of the options for mariadbd (called mysqld before MariaDB 10.5), ordered by topic. For a full alphabetical list of all mariadbd 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 Configuring MariaDB with Option Files for which files and groups mariadbd reads for it's default options.

Prior to MariaDB 10.5, the client used to be called mysqld, and can still be accessed under this name, via a symlink in Linux, or an alternate binary in Windows.

Option Prefixes

--autoset-*

  • Description: Sets the option value automatically. Only supported for certain options.

--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


--defaults-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


--print-defaults


Compatibility Options

The following options have been added to MariaDB to make it more compliant with other MariaDB and MySQL versions. Options that are also system variables are listed after:

-a, --ansi


--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.

--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.

Compatibility Options and System Variables

Locale Options

Options that are also system variables are listed after:

--character-set-client-handshake

  • Commandline: --character-set-client-handshake
  • Description: Don't ignore client side character set value sent during handshake. --skip-character-set-client-handshake will ignore the client value and use the default server value.

--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


Locale Options and System Variables

Windows Options

Options that are also system variables are listed after:

--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 mariadbd 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 "MARIADB".
    • This option is deprecated and may be removed in a future version. See MDEV-19358 for more information.

--install-manual

  • Description: Windows-only option that installs the mariadbd 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 "MARIADB".
    • This option is deprecated and may be removed in a future version. See MDEV-19358 for more information.

--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 "MARIADB".
    • 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. Options that are also system variables are listed after:

--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 replicas will not be able to replicate them.

--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 replicas will not be able to replicate them.

--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. Available as a system variable from MariaDB 11.2.0.
  • Default value 8192

--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.

--init-rpl-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.

--log-bin-trust-routine-creators


--master-host

  • Commandline: --master-host=name
  • Description: Primary hostname or IP address for replication. If not set, the replica 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


--master-password

  • Commandline: --master-password=name
  • Description: The password the replica thread will authenticate with when connecting to the primary. 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 replica will attempt to connect to a primary 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 replica will not stop attempting to reconnect. Reconnects are triggered when a replica has timed out. See slave_net_timeout.
  • Default Value: 86400 through 10.5, 100000 as of 10.6
  • Range - 32 bit: 0 to 4294967295
  • Range - 64 bit: 0 to 18446744073709551615

--master-ssl


--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 replica thread will use for authentication when connecting to the primary. The user must have FILE privilege. If the primary 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-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:

Semisynchronous Replication Options and System Variables

The options and system variables related to Semisynchronous Replication are described here.

Optimizer Options

Options that are also system variables are listed after:

--record-buffer


--table-cache


Optimizer Options and System Variables

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

--external-locking


MyISAM Storage Engine Options

The options related to the MyISAM storage engine are described below. Options that are also system variables are listed after:

--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.

InnoDB Storage Engine Options

The options related to the InnoDB storage engine are described below. Options that are also system variables are listed after:

--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 or FORCE_PLUS_PERMANENT (from MariaDB 5.5). If set to OFF (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.

Aria Storage Engine Options

The options related to the Aria storage engine are described below. Options that are also system variables are listed after:

--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.

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.

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.

Vector Options

The options and system variables related to Vectors storage engine (beginning with mhnsw) can be found here.

Performance Schema Options

The options related to the Performance Schema are described below. Options that are also system variables are listed after:

--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.

Galera Cluster Options

The options related to Galera Cluster are described below. Options that are also system variables are listed after:

--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.

Options When Debugging mariadbd

--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.

--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

Options that are also system variables are listed after:

--allow-suspicious-udfs

  • Commandline: --allow-suspicious-udfs
  • Description: Allows use of user-defined functions consisting of only one symbol x() without corresponding x_init() or x_deinit(). That also means that one can load any function from any library, for example exit() from libc.so. Not recommended unless you require old UDFs with one symbol that cannot be recompiled. From MariaDB 10.10, available as a system variable as well.

--bootstrap

  • Commandline: --bootstrap
  • Description: Used by mariadb installation scripts, such as mariadb-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 mariadbd 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. From MariaDB 11.5, includes deprecation information.

--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 replica 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 mariadbd 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


--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, where name is the plugin name and library is the plugin library. This format installs a single plugin from the given plugin library.
    • Plugins can also be specified in the format library, where library is the plugin library. This format installs all plugins from the given plugin library.
    • Multiple plugins can be specified by separating them with semicolons.
  • 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, where name is the plugin name and library is the plugin library. This format installs a single plugin from the given plugin library.
    • Plugins can also be specified in the format library, where library is the plugin library. This format installs all plugins from the given plugin library.
    • Multiple plugins can be specified by separating them with semicolons.
  • 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.

--port-open-timeout

  • Commandline: --port-open-timeout=#
  • Description: Maximum time in seconds to wait for the port to become free. (Default: No wait).

--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 --with-debug=full option.

--show-slave-auth-info

  • Commandline: --show-slave-auth-info
  • Description: Show user and password in SHOW SLAVE HOSTS on this primary.

--skip-grant-tables

Because the Event Scheduler also depends on the grant tables for its functionality, it is automatically disabled when running with --skip-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, replica is not autostarted.

--skip-ssl



--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.

  • Commandline: --symbolic-links
  • Description: Enables symbolic link support. When set, the have_symlink system variable shows as YES. Silently ignored in Windows. Use --skip-symbolic-links to disable.

--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, or ROLLBACK. The default is OFF. See also the --log-tc server option and the log_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 to 0 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 mariadbd daemon as user.

--verbose

  • Commandline: -v, --verbose
  • Description: Used with help option for detailed help.

Other Options and System Variables

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 options and system variables 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:

mariadbd --no-defaults --help --verbose
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.