mysqld Options

Contents

  1. Negative Options
    1. --disable-*
    2. --skip-*
  2. Compatibility Options
    1. -a, --ansi
    2. --disable-unix-socket
    3. --new
    4. --old
    5. --old-alter-table
    6. --old-mode
    7. --old-passwords
    8. --old-style-user-limits
    9. --safe-mode
    10. --skip-new
    11. Compatibility Options and System Variables
  3. Windows Options
    1. --console
    2. --enable-named-pipe
    3. --install
    4. --install-manual
    5. --remove
    6. --slow-start-timeout
    7. --standalone
    8. Windows Options and System Variables
  4. 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-file-cache-size
    12. --binlog-format
    13. --binlog-ignore-db
    14. --binlog-row-event-max-size
    15. --binlog-optimize-thread-scheduling
    16. --binlog-row-image
    17. --binlog-stmt-cache-size
    18. --default-master-connection
    19. --disconnect-slave-event-count
    20. --flashback
    21. --gtid-cleanup-batch-size
    22. --gtid-domain-id
    23. --gtid-ignore-duplicates
    24. --gtid-strict-mode
    25. --init-rpl-role
    26. --init-slave
    27. --log-basename
    28. --log-bin
    29. --log-bin-compress
    30. --log-bin-compress-min-len
    31. --log-bin-index
    32. --log-bin-trust-function-creators
    33. --log-bin-trust-routine-creators
    34. --log-slave-updates
    35. --master-host
    36. --master-info-file
    37. --master-password
    38. --master-port
    39. --master-retry-count
    40. --master-ssl
    41. --master-ssl-ca
    42. --master-ssl-capath
    43. --master-ssl-cert
    44. --master-ssl-cipher
    45. --master-ssl-key
    46. --master-user
    47. --master-verify-checksum
    48. --max-binlog-cache-size
    49. --max-binlog-dump-events
    50. --max-binlog-size
    51. --max-binlog-stmt-cache-size
    52. --max-relay-log-size
    53. --read-binlog-speed-limit
    54. --relay-log
    55. --relay-log-index
    56. --relay-log-info-file
    57. --relay-log-purge
    58. --relay-log-recovery
    59. --relay-log-space-limit
    60. --replicate-annotate-row-events
    61. --replicate-do-db
    62. --replicate-do-table
    63. --replicate-events-marked-for-skip
    64. --replicate-ignore-db
    65. --replicate-ignore-table
    66. --replicate-rewrite-db
    67. --replicate-same-server-id
    68. --replicate-wild-do-table
    69. --replicate-wild-ignore-table
    70. --report-host
    71. --report-password
    72. --report-port
    73. --report-user
    74. --rpl-recovery-rank
    75. --server-id
    76. --slave-ddl-exec-mode
    77. --slave-compressed-protocol
    78. --slave-domain-parallel-threads
    79. --slave-exec-mode
    80. --slave-load-tmpdir
    81. --slave-max-allowed-packet
    82. --slave-net-timeout
    83. --slave-parallel-threads
    84. --slave-parallel-max-queued
    85. --slave-run-triggers-for-rbr
    86. --slave-skip-errors
    87. --slave-sql-verify-checksum
    88. --slave-transaction-retries
    89. --slave-transaction-retry-errors
    90. --slave-transaction-retry-interval
    91. --slave-type-conversions
    92. --sporadic-binlog-dump-fail
    93. --sync-binlog
    94. --sync-master-info
    95. --sync-relay-log
    96. --sync-relay-log-info
    97. --sysdate-is-now
    98. Replication and Binary Logging Options and System Variables
    99. 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
  5. 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-prune-level
    15. --optimizer-search-depth
    16. --optimizer-selectivity-sampling-limit
    17. --optimizer-switch
    18. -optimizer-trace
    19. -optimizer-trace-max-mem-size
    20. --optimizer-use-condition-selectivity
    21. --query-alloc-block-size
    22. --query-prealloc-size
    23. --range-alloc-block-size
    24. --read-buffer-size
    25. --record-buffer
    26. --rowid-merge-buff-size
    27. --table-cache
    28. --table-definition-cache
    29. --table-open-cache
    30. --table-open-cache-instances
    31. --tmp-disk-table-size
    32. --tmp-memory-table-size
    33. --tmp-table-size
    34. --use-stat-tables
    35. Optimizer Options and System Variables
  6. Storage Engine Options
    1. MyISAM Storage Engine Options
      1. --concurrent-insert
      2. --delay-key-write-for-all-tables
      3. --delayed-insert-limit
      4. --delayed-insert-timeout
      5. --delayed-queue-size
      6. --external-locking
      7. --keep-files-on-create
      8. --key-buffer-size
      9. --key-cache-age-threshold
      10. --key-cache-block-size
      11. --key-cache-division-limit
      12. --key-cache-file-hash-size
      13. --key-cache-segments
      14. --log-isam
      15. --myisam-block-size
      16. --myisam-data-pointer-size
      17. --myisam-max-sort-file-size
      18. --myisam-mmap-size
      19. --myisam-recover-options
      20. --myisam-repair-threads
      21. --myisam-sort-buffer-size
      22. --myisam-stats-method
      23. --myisam-use-mmap
      24. MyISAM Storage Engine Options and System Variables
    2. 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-populate
      37. --innodb-buffer-pool-restore-at-startup
      38. --innodb-buffer-pool-shm-checksum
      39. --innodb-buffer-pool-shm-key
      40. --innodb-buffer-pool-size
      41. --innodb-change-buffer-max-size
      42. --innodb-change-buffering
      43. --innodb-change-buffering-debug
      44. --innodb-checkpoint-age-target
      45. --innodb-checksum-algorithm
      46. --innodb-checksums
      47. --innodb-cleaner-lsn-age-factor
      48. --innodb-cmp
      49. --innodb-cmp-per-index-enabled
      50. --innodb-cmp-reset
      51. --innodb-cmpmem
      52. --innodb-cmpmem-reset
      53. --innodb-commit-concurrency
      54. --innodb-compression-algorithm
      55. --innodb-compression-failure-threshold-pct
      56. --innodb-compression-level
      57. --innodb-compression-pad-pct-max
      58. --innodb-concurrency-tickets
      59. --innodb-corrupt-table-action
      60. --innodb-data-file-path
      61. --innodb-data-home-dir
      62. --innodb-deadlock-detect
      63. --innodb-default-encryption-key-id
      64. --innodb-default-page-encryption-key
      65. --innodb-default-row-format
      66. --innodb-defragment
      67. --innodb-defragment-fill-factor
      68. --innodb-defragment-fill-factor-n-recs
      69. --innodb-defragment-frequency
      70. --innodb-defragment-n-pages
      71. --innodb-defragment-stats-accuracy
      72. --innodb-dict-size-limit
      73. --innodb-disable-sort-file-cache
      74. --innodb-doublewrite
      75. --innodb-doublewrite-file
      76. --innodb-empty-free-list-algorithm
      77. --innodb-enable-unsafe-group-commit
      78. --innodb-encrypt-log
      79. --innodb-encrypt-tables
      80. --innodb-encryption-rotate-key-age
      81. --innodb-encryption-rotation-iops
      82. --innodb-encryption-threads
      83. --innodb-extra-rsegments
      84. --innodb-extra-undoslots
      85. --innodb-fake-changes
      86. --innodb-fast-checksum
      87. --innodb-fast-shutdown
      88. --innodb-fatal-semaphore-wait-threshold
      89. --innodb-file-format
      90. --innodb-file-format-check
      91. --innodb-file-format-max
      92. --innodb-file-io-threads
      93. --innodb-file-per-table
      94. --innodb-filll-factor
      95. --innodb-flush-log-at-trx-commi
      96. --innodb-flush-method
      97. --innodb-flush-neighbor-pages
      98. --innodb-flush-neighbors
      99. --innodb-flush-sync
      100. --innodb-flushing-avg-loops
      101. --innodb-force-load-corrupted
      102. --innodb-force-primary-key
      103. --innodb-force-recovery
      104. --innodb-foreground-preflush
      105. --innodb-ft-aux-table
      106. --innodb-ft-cache-size
      107. --innodb-ft-enable-diag-print
      108. --innodb-ft-enable-stopword
      109. --innodb-ft-max-token-size
      110. --innodb-ft-min-token-size
      111. --innodb-ft-num-word-optimize
      112. --innodb-ft-result-cache-limit
      113. --innodb-ft-server-stopword-table
      114. --innodb-ft-sort-pll-degree
      115. --innodb-ft-total-cache-size
      116. --innodb-ft-user-stopword-table
      117. --innodb-ibuf-accel-rate
      118. --innodb-ibuf-active-contract
      119. --innodb-ibuf-max-size
      120. --innodb-idle-flush-pct
      121. --innodb-immediate-scrub-data-uncompressed
      122. --innodb-import-table-from-xtrabackup
      123. --innodb-index-stats
      124. --innodb-instrument-semaphores
      125. --innodb-io-capacity
      126. --innodb-io-capacity-max
      127. --innodb-large-prefix
      128. --innodb-lazy-drop-table
      129. --innodb-lock-schedule-algorithm
      130. --innodb-lock-wait-timeout
      131. --innodb-lock-waits
      132. --innodb-locking-fake-changes
      133. --innodb-locks
      134. --innodb-locks-unsafe-for-binlog
      135. --innodb-log-arch-dir
      136. --innodb-log-arch-expire-sec
      137. --innodb-log-archive
      138. --innodb-log-block-size
      139. --innodb-log-buffer-size
      140. --innodb-log-checksum-algorithm
      141. --innodb-log-checksums
      142. --innodb-log-compressed-pages
      143. --innodb-log-file-size
      144. --innodb-log-files-in-group|
      145. --innodb-log-group-home-dir
      146. --innodb-log-optimize-ddl
      147. --innodb-log-write-ahead-size
      148. --innodb-lru-scan-depth
      149. --innodb-max-bitmap-file-size
      150. --innodb-max-changed-pages
      151. --innodb-max-dirty-pages-pct
      152. --innodb-max-dirty-pages-pct-lwm
      153. --innodb-max-purge-lag
      154. --innodb-max-purge-lag-delay
      155. --innodb-max-undo-log-size
      156. --innodb-merge-sort-block-size
      157. --innodb-mirrored-log-groups
      158. --innodb-monitor-disable
      159. --innodb-monitor-enable
      160. --innodb-monitor-reset
      161. --innodb-monitor-reset-all
      162. --innodb-mtflush-threads
      163. --innodb-numa-interleave
      164. --innodb-old-blocks-pct
      165. --innodb-old-blocks-time
      166. --innodb-online-alter-log-max-size
      167. --innodb-open-files
      168. --innodb-optimize-fulltext-only
      169. --innodb-page-cleaners
      170. --innodb-page-size
      171. --innodb-pass-corrupt-table
      172. --innodb-prefix-index-cluster-optimization
      173. --innodb-print-all-deadlocks
      174. --innodb-purge-batch-size
      175. --innodb-purge-rseg-truncate-frequency
      176. --innodb-purge-threads
      177. --innodb-random-read-ahead
      178. --innodb-read-ahead
      179. --innodb-read-ahead-threshold
      180. --innodb-read-io-threads
      181. --innodb-read-only
      182. --innodb-recovery-update-relay-log
      183. --innodb-replication-delay
      184. --innodb-rollback-on-timeout
      185. --innodb-rollback-segments
      186. --innodb-rseg
      187. --innodb-sched-priority-cleaner
      188. --innodb-safe-truncate
      189. --innodb-scrub-log
      190. --innodb-scrub-log-interval
      191. --innodb-scrub-log-speed
      192. --innodb-show-locks-held
      193. --innodb-show-verbose-locks
      194. --innodb-sort-buffer-size
      195. --innodb-spin-wait-delay
      196. --innodb-stats-auto-recalc
      197. --innodb-stats-auto-update
      198. --innodb-stats-include-delete-marked
      199. --innodb-stats-method
      200. --innodb-stats-modified-counter
      201. --innodb-stats-on-metadata
      202. --innodb-stats-persistent
      203. --innodb-stats-persistent-sample-pages
      204. --innodb-stats-sample-pages
      205. --innodb-stats-traditional
      206. --innodb-stats-transient-sample-pages
      207. --innodb-stats-update-need-lock
      208. --innodb-status-file
      209. --innodb-status-output
      210. --innodb-status-output-locks
      211. --innodb-strict-mode
      212. --innodb-support-xa
      213. --innodb-sync-array-size
      214. --innodb-sync-spin-loops
      215. --innodb-sys-indexes
      216. --innodb-sys-stats
      217. --innodb-sys-tables
      218. --innodb-table-locks
      219. --innodb-table-stats
      220. --innodb-temp-data-file-path
      221. --innodb-thread-concurrency
      222. --innodb-thread-concurrency-timer-based
      223. --innodb-thread-sleep-delay
      224. --innodb-tmpdir
      225. --innodb-track-changed-pages
      226. --innodb-track-redo-log-now
      227. --innodb-trx
      228. --innodb-undo-directory
      229. --innodb-undo-log-truncate
      230. --innodb-undo-logs
      231. --innodb-undo-tablespaces
      232. --innodb-use-atomic-writes
      233. --innodb-use-fallocate
      234. --innodb-use-global-flush-log-at-trx-commit
      235. --innodb-use-mtflush
      236. --innodb-use-native-aio
      237. --innodb-use-purge-thread
      238. --innodb-use-stacktrace
      239. --innodb-use-sys-malloc
      240. --innodb-use-sys-stats-table
      241. --innodb-use-trim
      242. --innodb-write-io-threads
      243. --skip-innodb
      244. --skip-innodb-checksums
      245. --skip-innodb-doublewrite
      246. InnoDB Storage Engine Options and System Variables
    3. 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
    4. MyRocks Storage Engine Options
      1. --rocksdb-access-hint-on-compaction-start
      2. --rocksdb-advise-random-on-open
      3. --rocksdb-allow-concurrent-memtable-write
      4. --rocksdb-allow-mmap-reads
      5. --rocksdb-allow-mmap-writes
      6. --rocksdb-background-sync
      7. --rocksdb-base-background-compactions
      8. --rocksdb-blind-delete-primary-key
      9. --rocksdb-block-cache-size
      10. --rocksdb-block-restart-interval
      11. --rocksdb-block-size
      12. --rocksdb-block-size-deviation
      13. --rocksdb-bulk-load
      14. --rocksdb-bulk-load-allow-unsorted
      15. --rocksdb-bulk-load-size
      16. --rocksdb-bytes-per-sync
      17. --rocksdb-cache-index-and-filter-blocks
      18. --rocksdb-checksums-pct
      19. -rocksdb-collect-sst-properties
      20. --rocksdb-commit-in-the-middle
      21. --rocksdb-compact-cf
      22. --rocksdb-compaction-readahead-size
      23. --rocksdb-compaction-sequential-deletes
      24. --rocksdb-compaction-sequential-deletes-count-sd
      25. --rocksdb-compaction-sequential-deletes-file-size
      26. --rocksdb-compaction-sequential-deletes-window
      27. --rocksdb-concurrent-prepare
      28. --rocksdb-create-checkpoint
      29. --rocksdb-create-if-missing
      30. --rocksdb-create-missing-column-families
      31. --rocksdb-datadir
      32. --rocksdb-db-write-buffer-size
      33. --rocksdb-deadlock-detect
      34. --rocksdb-deadlock-detect-depth
      35. --rocksdb-debug-optimizer-no-zero-cardinality
      36. --rocksdb-debug-ttl-ignore-pk
      37. --rocksdb-debug-ttl-read-filter-ts
      38. --rocksdb-debug-ttl-rec-ts
      39. --rocksdb-debug-ttl-snapshot-ts
      40. --rocksdb-default-cf-options
      41. --rocksdb-delayed-write-rate
      42. --rocksdb-delete-obsolete-files-period-micros
      43. --rocksdb-enable-2pc
      44. --rocksdb-enable-bulk-load-api
      45. --rocksdb-enable-thread-tracking
      46. --rocksdb-enable-ttl
      47. --rocksdb-enable-ttl-read-filtering
      48. --rocksdb-enable-write-thread-adaptive-yield
      49. --rocksdb-error-if-exists
      50. --rocksdb-flush-log-at-trx-commit
      51. --rocksdb-flush-memtable-on-analyze
      52. --rocksdb-force-compute-memtable-stats
      53. --rocksdb-force-compute-memtable-stats-cachetime
      54. --rocksdb-force-flush-memtable-and-lzero-now
      55. --rocksdb-force-flush-memtable-now
      56. --rocksdb-force-index-records-in-range
      57. --rocksdb-git-hash
      58. --rocksdb-hash-index-allow-collision
      59. --rocksdb-index-type
      60. --rocksdb-info-log-level
      61. --rocksdb-io-write-timeout
      62. --rocksdb-is-fd-close-on-exec
      63. --rocksdb-keep-log-file_num
      64. --rocksdb-large-prefix
      65. --rocksdb-lock-scanned-rows
      66. --rocksdb-lock-wait-timeout
      67. --rocksdb-log-file-time-to-roll
      68. --rocksdb-manifest-preallocation-size
      69. --rocksdb-manual-wal-flush
      70. --rocksdb-master-skip-tx-api
      71. --rocksdb-max-background-compactions
      72. --rocksdb-max-background-flushes
      73. --rocksdb-max-background-jobs
      74. --rocksdb-max-latest-deadlocks
      75. --rocksdb-max-log-file-size
      76. --rocksdb-max-manifest-file-size
      77. --rocksdb-max-open-files
      78. --rocksdb-max-row-locks
      79. --rocksdb-max-subcompactions
      80. --rocksdb-max-total-wal-size
      81. --rocksdb-merge-buf-size
      82. --rocksdb-merge-combine-read-size
      83. --rocksdb-merge-tmp-file-removal-delay-ms#
      84. --rocksdb-new-table-reader-for-compaction-inputs
      85. --rocksdb-no-block-cache
      86. --rocksdb-override-cf-options
      87. --rocksdb-paranoid-checks
      88. --rocksdb-pause-background-work
      89. --rocksdb-perf-context-level
      90. --rocksdb-persistent-cache-path
      91. --rocksdb-persistent-cache-size-mb
      92. --rocksdb-pin-l0-filter-and-index-blocks-in-cache
      93. --rocksdb-print-snapshot-conflict-queries
      94. --rocksdb-rate-limiter-bytes-per-sec
      95. --rocksdb-read-free-rpl-tables
      96. --rocksdb-records-in-range
      97. --rocksdb-reset-stats
      98. --rocksdb-seconds-between-stat-computes
      99. --rocksdb-signal-drop-index-thread
      100. --rocksdb-sim-cache-size
      101. --rocksdb-skip-bloom-filter-on-read
      102. --rocksdb-skip-fill-cache
      103. --rocksdb-skip-unique-check-tables
      104. --rocksdb-sst-mgr-rate-bytes-per-sec
      105. --rocksdb-stats-dump-period-sec
      106. --rocksdb-store-row-debug-checksums
      107. --rocksdb-strict-collation-check
      108. --rocksdb-strict-collation-exceptions
      109. --rocksdb-supported-compression-types
      110. --rocksdb-table-cache-numshardbits
      111. --rocksdb-table-stats-sampling-pct
      112. --rocksdb-tmpdir
      113. --rocksdb-trace-sst-api
      114. --rocksdb-unsafe-for-binlog
      115. --rocksdb-update-cf-options
      116. --rocksdb-use-adaptive-mutex
      117. --rocksdb-use-clock-cache
      118. --rocksdb-use-direct-io-for-flush-and-compaction
      119. --rocksdb-use-direct-reads
      120. --rocksdb-use-fsync
      121. --rocksdb-validate-tables
      122. --rocksdb-verify-row-debug-checksums
      123. --rocksdb-wal-bytes-per-sync
      124. --rocksdb-wal-dir
      125. --rocksdb-wal-recovery-mode
      126. --rocksdb-wal-size-limit-mb
      127. --rocksdb-wal-ttl-seconds
      128. --rocksdb-whole-key-filtering
      129. --rocksdb-write-batch-max-bytes
      130. --rocksdb-write-disable-wal
      131. --rocksdb-write-ignore-missing-column-families
      132. MyRocks Storage Engine Options and System Variables
    5. S3 Storage Engine Options
      1. --s3-access-key
      2. --s3-block-size
      3. --s3-bucket
      4. --s3-pagecache-age-threshold
      5. --s3-pagecache-buffer-size
      6. --s3-pagecache-division-limit
      7. --s3-region
      8. --s3-secret-key
    6. CONNECT Storage Engine Options
      1. --connect-class-path
      2. --connect-cond-push
      3. --connect-conv-size
      4. --connect-enable-mongo
      5. --connect-exact-info
      6. --connect-indx-map
      7. --connect-java-wrapper
      8. --connect-json-grp-size
      9. --connect-json-null
      10. --connect-jvm-path
      11. --connect-type-conv
      12. --connect-use-tempfile
      13. --connect-work-size
      14. --connect-xtrace
      15. CONNECT Storage Engine Options and System Variables
    7. Spider Storage Engine Options
    8. Mroonga Storage Engine Options
    9. TokuDB Storage Engine Options
  7. 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-waits-history-long-size
    21. --performance-schema-events-waits-history-size
    22. --performance-schema-hosts-size
    23. --performance-schema-max-cond-classes
    24. --performance-schema-max-cond-instances
    25. --performance-schema-max-digest-length
    26. --performance-schema-max-file-classes
    27. --performance-schema-max-file-handles
    28. --performance-schema-max-file-instances
    29. --performance-schema-max-mutex-classes
    30. --performance-schema-max-mutex-instances
    31. --performance-schema-max-rwlock-classes
    32. --performance-schema-max-rwlock-instances
    33. --performance-schema-max-socket-classes
    34. --performance-schema-max-socket-instances
    35. --performance-schema-max-stage-classes
    36. --performance-schema-max-statement-classes
    37. --performance-schema-max-table-handles
    38. --performance-schema-max-table-instances
    39. --performance-schema-max-thread-classes
    40. --performance-schema-max-thread-instances
    41. --performance-schema-session-connect-attrs-size
    42. --performance-schema-setup-actors-size
    43. --performance-schema-setup-objects-size
    44. --performance-schema-users-size
    45. Performance Schema Options and System Variables
  8. 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-mysql-replication-bundle
    22. --wsrep-new-cluster
    23. --wsrep-node-address
    24. --wsrep-node-incoming-address
    25. --wsrep-node-name
    26. --wsrep-notify-cmd
    27. --wsrep-on
    28. --wsrep-OSU-method
    29. --wsrep-provider
    30. --wsrep-provider-options
    31. --wsrep-recover
    32. --wsrep-reject_queries
    33. --wsrep-replicate-myisam
    34. --wsrep-restart-slave
    35. --wsrep-retry-autocommit
    36. --wsrep-slave-FK-checks
    37. --wsrep-slave-threads
    38. --wsrep-slave-UK-checks
    39. --wsrep-sr-store
    40. --wsrep-sst-auth
    41. --wsrep-sst-donor
    42. --wsrep-sst-donor-rejects-queries
    43. --wsrep-sst-method
    44. --wsrep-sst-receive-address
    45. --wsrep-start-position
    46. --wsrep-sync-wait
    47. --wsrep-trx-fragment-size
    48. --wsrep-trx-fragment-unit
    49. Galera Cluster Options and System Variables
  9. 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
  10. Other Options
    1. --allow-suspicious-udfs
    2. --autocommit
    3. --automatic-sp-privileges
    4. --back-log
    5. --basedir
    6. --bind-address
    7. --bootstrap
    8. --character-set-client-handshake
    9. --character-set-filesystem
    10. --character-set-server
    11. --character-sets-dir
    12. --check-constraint-checks
    13. --chroot
    14. --collation-server
    15. --column-compression-threshold
    16. --column-compression-zlib-level
    17. --column-compression-zlib-strategy
    18. --column-compression-zlib-wrap
    19. --completion-type
    20. --connect-timeout
    21. --datadir
    22. --date-format
    23. --datetime-format
    24. --deadlock-search-depth-long
    25. --deadlock-search-depth-short
    26. --deadlock-timeout-long
    27. --deadlock-timeout-short
    28. --default-character-set
    29. --default-collation
    30. --default-password-lifetime
    31. --default-regex-flags
    32. --default-storage-engine
    33. --default-table-type
    34. --default-tmp-storage-engine
    35. --default-time-zone
    36. --default-week-format
    37. --defaults-extra-file
    38. --defaults-file
    39. --delay-key-write
    40. --des-key-file
    41. --disconnect-on-expired-password
    42. --div-precision-increment
    43. --enable-locking
    44. --encrypt-binlog
    45. --encrypt-tmp-disk-tables
    46. --encrypt-tmp-files
    47. --encryption-algorithm
    48. --engine-condition-pushdown
    49. --eq-range-index-dive-limit
    50. --event-scheduler
    51. --exit-info
    52. --expire-logs-days
    53. --explicit-defaults-for-timestamp
    54. --extra-max-connections
    55. --extra-port
    56. --flush
    57. --flush-time
    58. --ft-boolean-syntax
    59. --ft-max-word-len
    60. --ft-min-word-len
    61. --ft-query-expansion-limit
    62. --ft-stopword-file
    63. --general-log
    64. --general-log-file
    65. --getopt-prefix-matching
    66. --group-concat-max-len
    67. --help
    68. --histogram-size
    69. --histogram-type
    70. --host-cache-size
    71. --idle-readonly-transaction-timeout
    72. --idle-transaction-timeout
    73. --idle-write-transaction-timeout
    74. --ignore-db-dirs
    75. --init-connect
    76. --init-file
    77. --interactive-timeout
    78. --language
    79. --large-pages
    80. --lc-messages
    81. --lc-messages-dir
    82. --lc-time-names
    83. --local-infile
    84. --lock-wait-timeout
    85. --log
    86. --log-disabled_statements
    87. --log-error
    88. --log-long-format
    89. --log-output
    90. --log-queries-not-using-indexes
    91. --log-short-format
    92. --log-slow-admin-statements
    93. --log-slow-admin-statements
    94. --log-slow-file
    95. --log-slow-filter
    96. --log-slow-queries
    97. --log-slow-rate-limit
    98. --log-slow-slave-statements
    99. --log-slow-time
    100. --log-slow-verbosity
    101. --log-tc
    102. --log-tc-size
    103. --log-update
    104. --log-warnings
    105. --long-query-time
    106. --low-priority-updates
    107. --lower-case-table-names
    108. --master-connect-retry
    109. --max-allowed-packet
    110. --max-connections
    111. --max-connect-errors
    112. --max-delayed-threads
    113. --max-digest-length
    114. --max-error-count
    115. --max-length-for-sort-data
    116. --max-long-data-size
    117. --max-password-errors
    118. --max-prepared-stmt-count
    119. --max-recursive-iterations
    120. --max-rowid-filter-size
    121. --max-session-mem-used
    122. --max-sp-recursion-depth
    123. --max-statement-time
    124. --max-tmp-tables
    125. --max-user-connections
    126. --max-write-lock-count
    127. --memlock
    128. --metadata-locks-cache-size
    129. --metadata-locks-hash-instances
    130. --min-examined-row-limit
    131. --mrr-buffer-size
    132. --multi-range-count
    133. --mysql56-temporal-format
    134. --ndb-use-copying-alter-table
    135. --net-buffer-length
    136. --net-read-timeout
    137. --net-retry-count
    138. --net-write-timeout
    139. --no-defaults
    140. --one-thread
    141. --open-files-limit
    142. --pid-file
    143. --plugin-load
    144. --plugin-load-add
    145. --plugin-dir
    146. --plugin-maturity
    147. --port
    148. --port-open-timeout
    149. --preload-buffer-size
    150. --print-defaults
    151. --profiling-history-size
    152. --progress-report-time
    153. --query-cache-limit
    154. --query-cache-min-res-unit
    155. --query-cache-size
    156. --query-cache-strip-comments
    157. --query-cache-type
    158. --query-cache-wlock-invalidate
    159. --read-rnd-buffer-size
    160. --read-only
    161. --safe-show-database
    162. --safe-user-create
    163. --safemalloc-mem-limit
    164. --secure-auth
    165. --secure-file-priv
    166. --secure-timestamp
    167. --session-track-schema
    168. --session-track-state-change
    169. --session-track-system-variables
    170. --session-track-transaction-info
    171. --set-variable
    172. --show-slave-auth-info
    173. --skip-automatic-sp-privileges
    174. --skip-external-locking
    175. --skip-grant-tables
    176. --skip-host-cache
    177. --skip-large-pages
    178. --skip-locking
    179. --skip-log-error
    180. --skip-name-resolve
    181. --skip-networking
    182. --skip-partition
    183. --skip-show-database
    184. --skip-slave-start
    185. --skip-ssl
    186. --skip-symbolic-links
    187. --skip-symlink
    188. --skip-thread-priority
    189. --slow-launch-time
    190. --slow-query-log
    191. --slow-query-log-file
    192. --socket
    193. --sort-buffer-size
    194. --sql-bin-update-same
    195. --sql-mode
    196. --ssl
    197. --ssl-ca
    198. --ssl-capath
    199. --ssl-cert
    200. --ssl-cipher
    201. --ssl-crl
    202. --ssl-crlpath
    203. --ssl-key
    204. --stack-trace
    205. --standard-compliant-cte
    206. --stored-program-cache
    207. --strict-password-validation
    208. --symbolic-links
    209. --sync-frm
    210. --system-versioning-alter-history
    211. --system-versioning-asof
    212. --system-versioning-innodb-algorithm-simple
    213. --table-lock-wait-timeout
    214. --tc-heuristic-recover
    215. --tcp-keepalive-interval
    216. --tcp-keepalive-probes
    217. --tcp-keepalive-time
    218. --tcp-nodelay
    219. --temp-pool
    220. --test-expect-abort
    221. --test-ignore-wrong-options
    222. --thread-cache-size
    223. --thread-concurrency
    224. --thread-handling
    225. --thread-pool-idle-timeout
    226. --thread-pool-max-threads
    227. --thread-pool-min-threads
    228. --thread-pool-prio-kickup-timer
    229. --thread-pool-priority
    230. --thread-pool-size
    231. --thread-pool-stall-limit
    232. --thread-stack
    233. --timed-mutexes
    234. --time-format
    235. --tmpdir
    236. --transaction-isolation
    237. --transaction-alloc-block-size
    238. --transaction-prealloc-size
    239. --transaction-read-only
    240. --updatable-views-with-limit
    241. --use-symbolic-links
    242. --user
    243. --userstat
    244. --verbose
    245. --version
    246. --wait-timeout
    247. --warnings
  11. Other Options and System Variables
  12. Authentication Plugin Options and System Variables
    1. Authentication Plugin - gssapi
      1. gssapi_keytab_path
      2. gssapi_principal_name
      3. gssapi_mech_name
    2. Authentication Plugin - pam
      1. pam-debug
      2. pam-use-cleartext-plugin
      3. pam-winbind-workaround
  13. Encryption Plugin Options and System Variables
    1. Encryption Plugin - aws_key_management
      1. aws-key-management-master-key-id
      2. aws-key-management-request-timeout
      3. aws-key-management-rotate-key
      4. aws-key-management-region
      5. aws-key-management-key-spec
      6. aws-key-management-log-level
      7. aws-key-management-mock
    2. Encryption Plugin - file_key_management
      1. file-key-management-encryption-algorithm
      2. file-key-management-filekey
      3. file-key-management-filename
  14. Password Validation Plugin Options and System Variables
    1. Password Validation Plugin - simple_password_check
      1. simple-password-check-digits
      2. simple-password-check-letters-same-case
      3. simple-password-check-minimal-length
      4. simple-password-check-other-characters
    2. Password Validation Plugin - cracklib_password_check
      1. cracklib-password-check
      2. cracklib-password-check-dictionary
  15. Audit Plugin Options and System Variables
    1. Audit Plugin - server_audit
      1. server-audit-events
      2. server-audit-excl-users
      3. server-audit-file-path
      4. server-audit-file-rotate-now
      5. server-audit-file-rotate-size
      6. server-audit-file-rotations
      7. server-audit-incl-users
      8. server-audit-logging
      9. server-audit-mode
      10. server-audit-output-type
      11. server-audit-query-limit
      12. server-audit-syslog-facility
      13. server-audit-syslog-ident
      14. server-audit-syslog-info
      15. server-audit-syslog-priority
  16. Feedback Plugin
    1. feedback
    2. feedback-http-proxy
    3. feedback-send-retry-wait
    4. feedback-send-timeout
    5. feedback-url
    6. feedback-user-info
  17. Query_Response_Time Plugin
    1. query-response-time-range-base
    2. query-response-time-stats
  18. SQL_ERROR_LOG Plugin
    1. sql-error-log-filename
    2. sql-error-log-rate
    3. sql-error-log-rotate
    4. sql-error-log-rotations
    5. sql-error-log-size-limit
  19. HandlerSocket Plugin
    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
  20. Default Values

This page lists all of the options for mysqld, 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.

All boolean options can be disabled with the prefix disable or skip.

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.

Negative Options

--disable-*

  • Description: For all boolean options, disables the setting (equivalent to setting it to 0). Same as --skip.

--skip-*

  • Description: For all boolean options, disables the setting (equivalent to setting it to 0). Same as --disable.

Compatibility Options

The following options have been added to MariaDB to make it more compliant with other MariaDB and MySQL versions:

-a, --ansi


--disable-unix-socket


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

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 serves as a dummy option to start as a standalone server.

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

  • Commandline: --replicate-rewrite-db=master_database->slave_database
  • Description: This option allows you to configure a replication slave to rewrite database names. It uses the format master_database->slave_database. If a slave encounters a binary log event in which the default database (i.e. the one selected by the USE statement) is master_database, then the slave will apply the event in slave_database instead.
    • This option will not work with cross-database updates with statement-based logging. See the Statement-Based Logging section for more information.
    • This option only affects statements that involve tables. This option does not affect statements involving the database itself, such as CREATE DATABASE, ALTER DATABASE, and DROP DATABASE.
    • This option can not be set dynamically.
    • When setting it on the command-line or in a server option group in an option file, the option does not accept a comma-separated list. If you would like to specify multiple filters, then you need to specify the option multiple times.
    • See Replication Filters for more information.

--replicate-same-server-id

  • Commandline: --replicate-same-server-id
  • Description: In replication, if set to 1, do not skip events having our server id. Default value is 0 (to break infinite loops in circular replication). Can't be set to 1 if log-slave-updates is used.

--sporadic-binlog-dump-fail

  • Commandline: --sporadic-binlog-dump-fail
  • Description: Option used by mysql-test for debugging and testing of replication.

--sysdate-is-now

  • Commandline: --sysdate-is-now
  • Description: Non-default option to alias SYSDATE() to NOW() to make it safe for replication. Since 5.0, SYSDATE() has returned a `dynamic' value different for different invocations, even within the same statement.

Replication and Binary Logging Options and System Variables

The following options and system variables are related to replication and the binary log:

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

MyISAM Storage Engine Options

The options related to the MyISAM storage engine are described below.

--delay-key-write-for-all-tables

  • Commandline: --delay-key-write-for-all-tables
  • Description: Don't flush key buffers between writes for any MyISAM table. (Deprecated option, use --delay-key-write=all instead.)

--external-locking

  • Commandline: --external-locking
  • Description: Use system (external) locking (disabled by default). With this option enabled you can run myisamchk to test (not repair) tables while the server is running. Disable with --skip-external-locking.

--log-isam

  • Commandline: --log-isam[=file_name]
  • Description: Enable the MyISAM log, which logs all MyISAM changes to file. If no filename is provided, the default, myisam.log is used.

MyISAM Storage Engine Options and System Variables

Some options and system variables related to the MyISAM storage engine can be found here. Direct links to many of them can be found below.

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 related to the MyRocks storage engine are described below.

MyRocks Storage Engine Options and System Variables

Some options and system variables related to the MyRocks storage engine can be found here. Direct links to many of them can be found below.

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

--core-file

  • Description: Write core file when mysqld crashes. The file name and location are system dependent; on Linux it is usually called core.pid, written to the data directory.

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

--character-set-client-handshake

  • Commandline: --character-set-client-handshake
  • Description: Don't ignore client side character set value sent during handshake.

--chroot

  • Commandline: --chroot=name
  • Description: Chroot mysqld daemon during startup.

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

--default-collation

  • Commandline: --default-collation=name
  • Description: Set the default collation (deprecated option, use collation-server instead).

--defaults-extra-file


--defaults-file


--des-key-file

  • Commandline: --des-key-file=name
  • Description: Load keys for des_encrypt() and des_encrypt from given file.

--enable-locking

  • Commandline: --enable-locking
  • Description: Deprecated option, use external-locking instead.

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

  • Commandline: --log-long-format
  • Description: Log some extra information to update log. Please note that this option is deprecated; see log-short-format.

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

--log-update

  • Commandline: --log-update[=name]
  • Description: The update log is deprecated since version 5.0, is replaced by the binary log and this option just turns on --log-bin instead.

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

--no-defaults


--one-thread

  • Commandline: --one-thread
  • Description: (Deprecated): Only use one thread (for debugging under Linux). Use thread-handling=no-threads instead.

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

--print-defaults


<<toc-item slug="server-system-variables#proxy_protocol_networks " level=3>>--proxy-protocol-networks<</toc-item>>

--safe-user-create

  • Commandline: --safe-user-create
  • Description: Don't allow new user creation by the user who has no write privileges to the mysql.user table.

--safemalloc-mem-limit

  • Commandline: --safemalloc-mem-limit=#
  • Description: Simulate memory shortage when compiled with the --with-debug=full option.

--set-variable

  • Commandline: --set-variable=name
  • Description: Change the value of a variable. Please note that this option is deprecated; you can set variables directly with --variable-name=value.

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


--skip-partition

  • Commandline: --skip-partition, --disable-partition
  • Description: Disables user-defined partitioning. Previously partitioned tables cannot be accessed or modifed. Tables can still be seen with SHOW TABLES or by viewing the INFORMATION_SCHEMA.TABLES table. Tables can be dropped with DROP TABLE, but this only removes .frm files, not the associated .par files, which will need to be removed manually.

--skip-slave-start

  • Commandline: --skip-slave-start
  • Description: If set, slave is not autostarted.

--skip-ssl


  • Commandline: --skip-symbolic-links
  • Description: Don't allow symlinking of tables.

  • Commandline: --skip-symlink
  • Description: Don't allow symlinking of tables. Deprecated and removed in MariaDB 5.5. Use[ [#-skip-symbolic-links--skip-symbolic-links]] instead.
  • Removed: MariaDB 5.5

--skip-thread-priority

  • Commandline: --skip-thread-priority
  • Description: Don't give threads different priorities. Deprecated and removed in MariaDB 10.0.
  • Removed: MariaDB 10.0

--sql-bin-update-same

  • Commandline: --sql-bin-update-same=#
  • Description: The update log was deprecated in version 5.0 and replaced by the binary log, so this option did nothing since then. Deprecated and removed in MariaDB 5.5.
  • Removed: MariaDB 5.5

--ssl

  • Commandline: --ssl
  • Description: Enable TLS for connection (automatically enabled with other flags). Disable with '--skip-ssl'.

--stack-trace

  • Commandline: --stack-trace, --skip-stack-trace
  • Description: Print a stack trace on failure. Enabled by default, disable with -skip-stack-trace.

  • Commandline: --symbolic-links
  • Description: Enable symbolic link support.

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

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

  • Commandline: --use-symbolic-links
  • Description: Enable symbolic link support. Deprecated option; use --symbolic-links instead.

--user

  • Commandline: --user=name
  • Description: Run mysqld daemon as user.

--verbose

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

--warnings

  • Commandline: --warnings[=#]
  • Description: Deprecated; use log-warnings instead.

Other Options and System Variables

Authentication Plugin Options and System Variables

Authentication Plugin - gssapi

The options and system variables related to the gssapi authentication plugin can be found here.

Authentication Plugin - pam

The options and system variables related to the pam authentication plugin can be found here.

Encryption Plugin Options and System Variables

Encryption Plugin - aws_key_management

The options and system variables related to the aws_key_management encryption plugin can be found here.

Encryption Plugin - file_key_management

The options and system variables related to the file_key_management encryption plugin can be found here.

Password Validation Plugin Options and System Variables

Password Validation Plugin - simple_password_check

The options and system variables related to the simple_password_check password validation plugin can be found here.

Password Validation Plugin - cracklib_password_check

The options and system variables related to the cracklib_password_check password validation plugin can be found here.

Audit Plugin Options and System Variables

Audit Plugin - server_audit

The options and system variables related to the server_audit audit plugin can be found here.

Feedback Plugin

The options for the Feedback Plugin are all described on the Feedback Plugin page.

Query_Response_Time Plugin

The options for the Query_Response_Time plugin are described on the QUERY_RESPONSE_TIME plugin page.

SQL_ERROR_LOG Plugin

The options for the SQL_ERROR_LOG plugin are described on the SQL_ERROR_LOG Plugin System Variables page.

HandlerSocket Plugin

The options for the HandlerSocket plugin are all described on the HandlerSocket Configuration Option page.

Default Values

You can verify the default values for an option by doing:

mysqld --no-defaults --help --verbose

Comments

Comments loading...