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

  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-annotate-row-events
    5. --binlog-cache-size
    6. --binlog-checksum
    7. --binlog-commit-wait-count
    8. --binlog-commit-wait-usec
    9. --binlog-direct-non-transactional-updates
    10. --binlog-do-db
    11. --binlog-expire-logs-seconds
    12. --binlog-file-cache-size
    13. --binlog-format
    14. --binlog-ignore-db
    15. --binlog-optimize-thread-scheduling
    16. --binlog-row-event-max-size
    17. --binlog-row-image
    18. --binlog-row-metadata
    19. --binlog-stmt-cache-size
    20. --default-master-connection
    21. --disconnect-slave-event-count
    22. --flashback
    23. --gtid-cleanup-batch-size
    24. --gtid-domain-id
    25. --gtid-ignore-duplicates
    26. --gtid-strict-mode
    27. --init-rpl-role
    28. --init-slave
    29. --log-basename
    30. --log-bin
    31. --log-bin-compress
    32. --log-bin-compress-min-len
    33. --log-bin-index
    34. --log-bin-trust-function-creators
    35. --log-bin-trust-routine-creators
    36. --log-slave-updates
    37. --master-host
    38. --master-info-file
    39. --master-password
    40. --master-port
    41. --master-retry-count
    42. --master-ssl
    43. --master-ssl-ca
    44. --master-ssl-capath
    45. --master-ssl-cert
    46. --master-ssl-cipher
    47. --master-ssl-key
    48. --master-user
    49. --master-verify-checksum
    50. --max-binlog-cache-size
    51. --max-binlog-dump-events
    52. --max-binlog-size
    53. --max-binlog-stmt-cache-size
    54. --max-relay-log-size
    55. --read-binlog-speed-limit
    56. --relay-log
    57. --relay-log-index
    58. --relay-log-info-file
    59. --relay-log-purge
    60. --relay-log-recovery
    61. --relay-log-space-limit
    62. --replicate-annotate-row-events
    63. --replicate-do-db
    64. --replicate-do-table
    65. --replicate-events-marked-for-skip
    66. --replicate-ignore-db
    67. --replicate-ignore-table
    68. --replicate-rewrite_db
    69. --replicate-same-server-id
    70. --replicate-wild-do-table
    71. --replicate-wild-ignore-table
    72. --report-host
    73. --report-password
    74. --report-port
    75. --report-user
    76. --rpl-recovery-rank
    77. --server-id
    78. --slave-ddl-exec-mode
    79. --slave-compressed-protocol
    80. --slave-domain-parallel-threads
    81. --slave-exec-mode
    82. --slave-load-tmpdir
    83. --slave-max-allowed-packet
    84. --slave-net-timeout
    85. --slave-parallel-threads
    86. --slave-parallel-max-queued
    87. --slave-run-triggers-for-rbr
    88. --slave-skip-errors
    89. --slave-sql-verify-checksum
    90. --slave-transaction-retries
    91. --slave-transaction-retry-errors
    92. --slave-transaction-retry-interval
    93. --slave-type-conversions
    94. --sporadic-binlog-dump-fail
    95. --sync-binlog
    96. --sync-master-info
    97. --sync-relay-log
    98. --sync-relay-log-info
    99. --sysdate-is-now
    100. Replication and Binary Logging Options and System Variables
    101. 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-max-sel-arg-weight
    15. --optimizer-prune-level
    16. --optimizer-search-depth
    17. --optimizer-selectivity-sampling-limit
    18. --optimizer-switch
    19. -optimizer-trace
    20. -optimizer-trace-max-mem-size
    21. --optimizer-use-condition-selectivity
    22. --query-alloc-block-size
    23. --query-prealloc-size
    24. --range-alloc-block-size
    25. --read-buffer-size
    26. --record-buffer
    27. --rowid-merge-buff-size
    28. --table-cache
    29. --table-definition-cache
    30. --table-open-cache
    31. --table-open-cache-instances
    32. --tmp-disk-table-size
    33. --tmp-memory-table-size
    34. --tmp-table-size
    35. --use-stat-tables
    36. 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-api-bk-commit-interval
      13. --innodb-api-disable-rowlock
      14. --innodb-api-enable-binlog
      15. --innodb-api-enable-mdl
      16. --innodb-api-trx-level
      17. --innodb-auto-lru-dump
      18. --innodb-autoextend-increment
      19. --innodb-autoinc-lock-mode
      20. --innodb-background-scrub-data-check-interval
      21. --innodb-background-scrub-data-compressed
      22. --innodb-background-scrub-data-interval
      23. --innodb-background-scrub-data-uncompressed
      24. --innodb-blocking-buffer-pool-restore
      25. --innodb-buf-dump-status-frequency
      26. --innodb-buffer-pool-chunk-size
      27. --innodb-buffer-pool-dump-at-shutdown
      28. --innodb-buffer-pool-dump-now
      29. --innodb-buffer-pool-dump-pct
      30. --innodb-buffer-pool-evict
      31. --innodb-buffer-pool-filename
      32. --innodb-buffer-pool-instances
      33. --innodb-buffer-pool-load-abort
      34. --innodb-buffer-pool-load-at-startup
      35. --innodb-buffer-pool-load-now
      36. --innodb-buffer-pool-load-pages-abort
      37. --innodb-buffer-pool-populate
      38. --innodb-buffer-pool-restore-at-startup
      39. --innodb-buffer-pool-shm-checksum
      40. --innodb-buffer-pool-shm-key
      41. --innodb-buffer-pool-size
      42. --innodb-change-buffer-max-size
      43. --innodb-change-buffering
      44. --innodb-change-buffering-debug
      45. --innodb-checkpoint-age-target
      46. --innodb-checksum-algorithm
      47. --innodb-checksums
      48. --innodb-cleaner-lsn-age-factor
      49. --innodb-cmp
      50. --innodb-cmp-per-index-enabled
      51. --innodb-cmp-reset
      52. --innodb-cmpmem
      53. --innodb-cmpmem-reset
      54. --innodb-commit-concurrency
      55. --innodb-compression-algorithm
      56. --innodb-compression-failure-threshold-pct
      57. --innodb-compression-level
      58. --innodb-compression-pad-pct-max
      59. --innodb-concurrency-tickets
      60. --innodb-corrupt-table-action
      61. --innodb-data-file-path
      62. --innodb-data-home-dir
      63. --innodb-deadlock-detect
      64. --innodb-deadlock-report
      65. --innodb-default-encryption-key-id
      66. --innodb-default-page-encryption-key
      67. --innodb-default-row-format
      68. --innodb-defragment
      69. --innodb-defragment-fill-factor
      70. --innodb-defragment-fill-factor-n-recs
      71. --innodb-defragment-frequency
      72. --innodb-defragment-n-pages
      73. --innodb-defragment-stats-accuracy
      74. --innodb-dict-size-limit
      75. --innodb-disable-sort-file-cache
      76. --innodb-doublewrite
      77. --innodb-doublewrite-file
      78. --innodb-empty-free-list-algorithm
      79. --innodb-enable-unsafe-group-commit
      80. --innodb-encrypt-log
      81. --innodb-encrypt-tables
      82. --innodb-encrypt-temporary-tables
      83. --innodb-encryption-rotate-key-age
      84. --innodb-encryption-rotation-iops
      85. --innodb-encryption-threads
      86. --innodb-extra-rsegments
      87. --innodb-extra-undoslots
      88. --innodb-fake-changes
      89. --innodb-fast-checksum
      90. --innodb-fast-shutdown
      91. --innodb-fatal-semaphore-wait-threshold
      92. --innodb-file-format
      93. --innodb-file-format-check
      94. --innodb-file-format-max
      95. --innodb-file-io-threads
      96. --innodb-file-per-table
      97. --innodb-filll-factor
      98. --innodb-flush-log-at-trx-commi
      99. --innodb-flush-method
      100. --innodb-flush-neighbor-pages
      101. --innodb-flush-neighbors
      102. --innodb-flush-sync
      103. --innodb-flushing-avg-loops
      104. --innodb-force-load-corrupted
      105. --innodb-force-primary-key
      106. --innodb-force-recovery
      107. --innodb-foreground-preflush
      108. --innodb-ft-aux-table
      109. --innodb-ft-cache-size
      110. --innodb-ft-enable-diag-print
      111. --innodb-ft-enable-stopword
      112. --innodb-ft-max-token-size
      113. --innodb-ft-min-token-size
      114. --innodb-ft-num-word-optimize
      115. --innodb-ft-result-cache-limit
      116. --innodb-ft-server-stopword-table
      117. --innodb-ft-sort-pll-degree
      118. --innodb-ft-total-cache-size
      119. --innodb-ft-user-stopword-table
      120. --innodb-ibuf-accel-rate
      121. --innodb-ibuf-active-contract
      122. --innodb-ibuf-max-size
      123. --innodb-idle-flush-pct
      124. --innodb-immediate-scrub-data-uncompressed
      125. --innodb-import-table-from-xtrabackup
      126. --innodb-index-stats
      127. --innodb-instant-alter-column-allowed
      128. --innodb-instrument-semaphores
      129. --innodb-io-capacity
      130. --innodb-io-capacity-max
      131. --innodb-large-prefix
      132. --innodb-lazy-drop-table
      133. --innodb-lock-schedule-algorithm
      134. --innodb-lock-wait-timeout
      135. --innodb-lock-waits
      136. --innodb-locking-fake-changes
      137. --innodb-locks
      138. --innodb-locks-unsafe-for-binlog
      139. --innodb-log-arch-dir
      140. --innodb-log-arch-expire-sec
      141. --innodb-log-archive
      142. --innodb-log-block-size
      143. --innodb-log-buffer-size
      144. --innodb-log-checksum-algorithm
      145. --innodb-log-checksums
      146. --innodb-log-compressed-pages
      147. --innodb-log-file-buffering
      148. --innodb-log-file-size
      149. --innodb-log-files-in-group
      150. --innodb-log-group-home-dir
      151. --innodb-log-optimize-ddl
      152. --innodb-log-write-ahead-size
      153. --innodb-lru-flush-size
      154. --innodb-lru-scan-depth
      155. --innodb-max-bitmap-file-size
      156. --innodb-max-changed-pages
      157. --innodb-max-dirty-pages-pct
      158. --innodb-max-dirty-pages-pct-lwm
      159. --innodb-max-purge-lag
      160. --innodb-max-purge-lag-delay
      161. --innodb-max-purge-lag-wait
      162. --innodb-max-undo-log-size
      163. --innodb-merge-sort-block-size
      164. --innodb-mirrored-log-groups
      165. --innodb-monitor-disable
      166. --innodb-monitor-enable
      167. --innodb-monitor-reset
      168. --innodb-monitor-reset-all
      169. --innodb-mtflush-threads
      170. --innodb-numa-interleave
      171. --innodb-old-blocks-pct
      172. --innodb-old-blocks-time
      173. --innodb-online-alter-log-max-size
      174. --innodb-open-files
      175. --innodb-optimize-fulltext-only
      176. --innodb-page-cleaners
      177. --innodb-page-size
      178. --innodb-pass-corrupt-table
      179. --innodb-prefix-index-cluster-optimization
      180. --innodb-print-all-deadlocks
      181. --innodb-purge-batch-size
      182. --innodb-purge-rseg-truncate-frequency
      183. --innodb-purge-threads
      184. --innodb-random-read-ahead
      185. --innodb-read-ahead
      186. --innodb-read-ahead-threshold
      187. --innodb-read-io-threads
      188. --innodb-read-only
      189. --innodb-recovery-update-relay-log
      190. --innodb-replication-delay
      191. --innodb-rollback-on-timeout
      192. --innodb-rollback-segments
      193. --innodb-rseg
      194. --innodb-sched-priority-cleaner
      195. --innodb-safe-truncate
      196. --innodb-scrub-log
      197. --innodb-scrub-log-interval
      198. --innodb-scrub-log-speed
      199. --innodb-show-locks-held
      200. --innodb-show-verbose-locks
      201. --innodb-sort-buffer-size
      202. --innodb-spin-wait-delay
      203. --innodb-stats-auto-recalc
      204. --innodb-stats-auto-update
      205. --innodb-stats-include-delete-marked
      206. --innodb-stats-method
      207. --innodb-stats-modified-counter
      208. --innodb-stats-on-metadata
      209. --innodb-stats-persistent
      210. --innodb-stats-persistent-sample-pages
      211. --innodb-stats-sample-pages
      212. --innodb-stats-traditional
      213. --innodb-stats-transient-sample-pages
      214. --innodb-stats-update-need-lock
      215. --innodb-status-file
      216. --innodb-status-output
      217. --innodb-status-output-locks
      218. --innodb-strict-mode
      219. --innodb-support-xa
      220. --innodb-sync-array-size
      221. --innodb-sync-spin-loops
      222. --innodb-sys-indexes
      223. --innodb-sys-stats
      224. --innodb-sys-tables
      225. --innodb-table-locks
      226. --innodb-table-stats
      227. --innodb-temp-data-file-path
      228. --innodb-thread-concurrency
      229. --innodb-thread-concurrency-timer-based
      230. --innodb-thread-sleep-delay
      231. --innodb-tmpdir
      232. --innodb-track-changed-pages
      233. --innodb-track-redo-log-now
      234. --innodb-trx
      235. --innodb-undo-directory
      236. --innodb-undo-log-truncate
      237. --innodb-undo-logs
      238. --innodb-undo-tablespaces
      239. --innodb-use-atomic-writes
      240. --innodb-use-fallocate
      241. --innodb-use-global-flush-log-at-trx-commit
      242. --innodb-use-mtflush
      243. --innodb-use-native-aio
      244. --innodb-use-purge-thread
      245. --innodb-use-stacktrace
      246. --innodb-use-sys-malloc
      247. --innodb-use-sys-stats-table
      248. --innodb-use-trim
      249. --innodb-write-io-threads
      250. --skip-innodb
      251. --skip-innodb-checksums
      252. --skip-innodb-doublewrite
      253. 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
  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-auto-increment-control
    2. --wsrep-causal-reads
    3. --wsrep-certify-nonPK
    4. --wsrep-cluster-address
    5. --wsrep-cluster-name
    6. --wsrep-convert-LOCK-to-trx
    7. --wsrep-data-home-dir
    8. --wsrep-dbug-option
    9. --wsrep-debug
    10. --wsrep-desync
    11. --wsrep-dirty-reads
    12. --wsrep-drupal-282555-workaround
    13. --wsrep-forced-binlog-format
    14. --wsrep-gtid-domain-id
    15. --wsrep-gtid-mode
    16. --wsrep-ignore-apply-errors
    17. --wsrep-load-data-splitting
    18. --wsrep-log-conflicts
    19. --wsrep-max-ws-rows
    20. --wsrep-max-ws-size
    21. --wsrep-mode
    22. --wsrep-mysql-replication-bundle
    23. --wsrep-new-cluster
    24. --wsrep-node-address
    25. --wsrep-node-incoming-address
    26. --wsrep-node-name
    27. --wsrep-notify-cmd
    28. --wsrep-on
    29. --wsrep-OSU-method
    30. --wsrep-provider
    31. --wsrep-provider-options
    32. --wsrep-recover
    33. --wsrep-reject_queries
    34. --wsrep-replicate-myisam
    35. --wsrep-restart-slave
    36. --wsrep-retry-autocommit
    37. --wsrep-slave-FK-checks
    38. --wsrep-slave-threads
    39. --wsrep-slave-UK-checks
    40. --wsrep-sr-store
    41. --wsrep-sst-auth
    42. --wsrep-sst-donor
    43. --wsrep-sst-donor-rejects-queries
    44. --wsrep-sst-method
    45. --wsrep-sst-receive-address
    46. --wsrep-start-position
    47. --wsrep-strict-ddl
    48. --wsrep-sync-wait
    49. --wsrep-trx-fragment-size
    50. --wsrep-trx-fragment-unit
    51. Galera Cluster Options and System Variables
  11. Options When Debugging mysqld
    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. --bootstrap
    8. --check-constraint-checks
    9. --chroot
    10. --column-compression-threshold
    11. --column-compression-zlib-level
    12. --column-compression-zlib-strategy
    13. --column-compression-zlib-wrap
    14. --completion-type
    15. --connect-timeout
    16. --datadir
    17. --date-format
    18. --datetime-format
    19. --deadlock-search-depth-long
    20. --deadlock-search-depth-short
    21. --deadlock-timeout-long
    22. --deadlock-timeout-short
    23. --default-password-lifetime
    24. --default-regex-flags
    25. --default-storage-engine
    26. --default-table-type
    27. --default-tmp-storage-engine
    28. --delay-key-write
    29. --des-key-file
    30. --disconnect-on-expired-password
    31. --div-precision-increment
    32. --encrypt-binlog
    33. --encrypt-tmp-disk-tables
    34. --encrypt-tmp-files
    35. --encryption-algorithm
    36. --engine-condition-pushdown
    37. --eq-range-index-dive-limit
    38. --event-scheduler
    39. --exit-info
    40. --expire-logs-days
    41. --explicit-defaults-for-timestamp
    42. --extra-max-connections
    43. --extra-port
    44. --flush
    45. --flush-time
    46. --ft-boolean-syntax
    47. --ft-max-word-len
    48. --ft-min-word-len
    49. --ft-query-expansion-limit
    50. --ft-stopword-file
    51. --general-log
    52. --general-log-file
    53. --getopt-prefix-matching
    54. --group-concat-max-len
    55. --help
    56. --histogram-size
    57. --histogram-type
    58. --host-cache-size
    59. --idle-readonly-transaction-timeout
    60. --idle-transaction-timeout
    61. --idle-write-transaction-timeout
    62. --ignore-db-dirs
    63. --in-predicate-conversion-threshold
    64. --init-connect
    65. --init-file
    66. --interactive-timeout
    67. --large-pages
    68. --local-infile
    69. --lock-wait-timeout
    70. --log
    71. --log-disabled_statements
    72. --log-error
    73. --log-output
    74. --log-queries-not-using-indexes
    75. --log-ddl-recovery
    76. --log-short-format
    77. --log-slow-admin-statements
    78. --log-slow-disabled-statements
    79. --log-slow-file
    80. --log-slow-filter
    81. --log-slow-min-examined-row_limit
    82. --log-slow-queries
    83. --log-slow-query
    84. --log-slow-query-file-name
    85. --log-slow-query-time
    86. --log-slow-rate-limit
    87. --log-slow-slave-statements
    88. --log-slow-time
    89. --log-slow-verbosity
    90. --log-tc
    91. --log-tc-size
    92. --log-warnings
    93. --long-query-time
    94. --low-priority-updates
    95. --lower-case-table-names
    96. --master-connect-retry
    97. --max-allowed-packet
    98. --max-connections
    99. --max-connect-errors
    100. --max-delayed-threads
    101. --max-digest-length
    102. --max-error-count
    103. --max-length-for-sort-data
    104. --max-long-data-size
    105. --max-password-errors
    106. --max-prepared-stmt-count
    107. --max-recursive-iterations
    108. --max-rowid-filter-size
    109. --max-session-mem-used
    110. --max-sp-recursion-depth
    111. --max-statement-time
    112. --max-tmp-tables
    113. --max-user-connections
    114. --max-write-lock-count
    115. --memlock
    116. --metadata-locks-cache-size
    117. --metadata-locks-hash-instances
    118. --min-examined-row-limit
    119. --mrr-buffer-size
    120. --multi-range-count
    121. --mysql56-temporal-format
    122. --ndb-use-copying-alter-table
    123. --net-buffer-length
    124. --net-read-timeout
    125. --net-retry-count
    126. --net-write-timeout
    127. --one-thread
    128. --open-files-limit
    129. --pid-file
    130. --plugin-load
    131. --plugin-load-add
    132. --plugin-dir
    133. --plugin-maturity
    134. --port
    135. --port-open-timeout
    136. --preload-buffer-size
    137. --profiling-history-size
    138. --progress-report-time
    139. --proxy-protocol-networks
    140. --query-cache-info
    141. --query-cache-limit
    142. --query-cache-min-res-unit
    143. --query-cache-size
    144. --query-cache-strip-comments
    145. --query-cache-type
    146. --query-cache-wlock-invalidate
    147. --read-rnd-buffer-size
    148. --read-only
    149. --require-secure-transport
    150. --safe-show-database
    151. --safe-user-create
    152. --safemalloc-mem-limit
    153. --secure-auth
    154. --secure-file-priv
    155. --secure-timestamp
    156. --session-track-schema
    157. --session-track-state-change
    158. --session-track-system-variables
    159. --session-track-transaction-info
    160. --show-slave-auth-info
    161. --skip-automatic-sp-privileges
    162. --skip-external-locking
    163. --skip-grant-tables
    164. --skip-host-cache
    165. --skip-large-pages
    166. --skip-log-error
    167. --skip-name-resolve
    168. --skip-networking
    169. --skip-partition
    170. --skip-show-database
    171. --skip-slave-start
    172. --skip-ssl
    173. --skip-symlink
    174. --skip-thread-priority
    175. --slow-launch-time
    176. --slow-query-log
    177. --slow-query-log-file
    178. --socket
    179. --sort-buffer-size
    180. --sql-bin-update-same
    181. --sql-if-exists
    182. --sql-mode
    183. --ssl
    184. --ssl-ca
    185. --ssl-capath
    186. --ssl-cert
    187. --ssl-cipher
    188. --ssl-crl
    189. --ssl-crlpath
    190. --ssl-key
    191. --stack-trace
    192. --standard-compliant-cte
    193. --stored-program-cache
    194. --strict-password-validation
    195. --symbolic-links
    196. --sync-frm
    197. --system-versioning-alter-history
    198. --system-versioning-asof
    199. --system-versioning-innodb-algorithm-simple
    200. --system-versioning-insert-history
    201. --table-lock-wait-timeout
    202. --tc-heuristic-recover
    203. --tcp-keepalive-interval
    204. --tcp-keepalive-probes
    205. --tcp-keepalive-time
    206. --tcp-nodelay
    207. --temp-pool
    208. --test-expect-abort
    209. --test-ignore-wrong-options
    210. --thread-cache-size
    211. --thread-concurrency
    212. --thread-handling
    213. --thread-pool-dedicated-listener
    214. --thread-pool-exact-stats
    215. --thread-pool-idle-timeout
    216. --thread-pool-max-threads
    217. --thread-pool-min-threads
    218. --thread-pool-prio-kickup-timer
    219. --thread-pool-priority
    220. --thread-pool-size
    221. --thread-pool-stall-limit
    222. --thread-stack
    223. --timed-mutexes
    224. --time-format
    225. --tls_version
    226. --tmpdir
    227. --transaction-isolation
    228. --transaction-alloc-block-size
    229. --transaction-prealloc-size
    230. --transaction-read-only
    231. --updatable-views-with-limit
    232. --user
    233. --userstat
    234. --verbose
    235. --version
    236. --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 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


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

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


Locale Options and System Variables

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.

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

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

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


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


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


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

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

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

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

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

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.

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.

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


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


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

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

--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, slave 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 mysqld 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 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

Comments

Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.