Contents

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

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.

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

Replication and Binary Logging Options

--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: Tells the master it should log updates for the specified database, and exclude all others not explicitly mentioned. See Using and Maintaining the Binary Log.

--binlog-ignore-db


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

  • Commandline: --master-info-file=name
  • Description: The location and name of the file that remembers the master and where the I/O replication thread is in the master's binary logs.

--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-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=from_db->to_db
  • Description: If a statement has from_db as the default database (USE), it will replicate to the to_db database. For example, USE from_db; INSERT ... will perform the insert in the to_db database. For multiple rewrite rules, use this option multiple times. Only table statements are replicated, not those affecting the database, such as DROP DATABASE. Cross-database updates do not work with this option, database name translation takes place before any other --replicate-* rules are tested, and statements that use table names qualified with database names do not work with other filters such as --replicate-do-table.

    If the > character is a special character, the options can be quoted, for example replicate-rewrite-db="master_db_name->slave_db_name"

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

Optimizer Options

--record-buffer


--table-cache


Optimizer Options and System Variables

MyISAM Options

--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 Options and System Variables

InnoDB Options

--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-buffer-pool-pages

  • Commandline: --innodb-buffer-pool-pages
  • Description:
  • Default: ON

--innodb-buffer-pool-blob

  • Commandline: --innodb-buffer-pool-blob
  • Description:
  • Default: ON

--innodb-buffer-pool-index

  • Commandline: --innodb-buffer-pool-index
  • Description:
  • Default: ON

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

  • Commandline: --innodb-expand-import
  • Description:
  • Default: 0

--innodb-fast-recovery

  • Commandline: --innodb-fast-recovery
  • Description:
  • Default: FALSE

--innodb-file-io-threads

  • Commandline: --innodb-file-io-threads
  • Description:
  • Default: 4

--innodb-flush-log-at-trx-commit-session

  • Commandline: --innodb-flush-log-at-trx-commit-session
  • Description:
  • Default: 3

--innodb-index-stats

  • Commandline: --innodb-index-stats
  • Description:
  • Default: ON

--innodb-lock-waits

  • Commandline: --innodb-lock-waits
  • Description:
  • Default: ON

--innodb-locks

  • Commandline: --innodb-locks
  • Description:
  • Default: ON

--innodb-overwrite-relay-log-info

  • Commandline: --innodb-overwrite-relay-log-info
  • Description:
  • Default: FALSE

--innodb-rseg

  • Commandline: --innodb-rseg
  • Description:
  • Default: ON

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

--innodb-sys-tables

  • Commandline: --innodb-sys-tables
  • Description:
  • Default: ON

--innodb-table-stats

  • Commandline: --innodb-table-stats
  • Description:
  • Default: ON

--innodb-trx

  • Commandline: --innodb-trx
  • Description:
  • Default: ON

InnoDB Options and System Variables

Aria Options

The following options are used with the Aria storage engine.

Performance Schema Options

The following options are used with MariaDB's Performance Schema.

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

CONNECT Options

The following options are used with the CONNECT storage engine.

Galera Options

The following options are used with Galera Cluster.

--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 Options and System Variables

MyRocks Options

The following options are used with MyRocks.

MyRocks Options and System Variables

Options When Debugging mysqld

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

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

OptionDescriptionIntroduced
-#, --debug[=name]Use logging through the DBUG library. Just using --debug will write a trace of what mysqld is doing to /tmp/mysqld.trace.
--debug-assert-if-crashed-tableDo an assert in handler::print_error() if we get a crashed table.
-debug-crc-break=# Call my_debug_put_break_here() if crc matches this number (for debug).
--debug-flushDefault debug log with flush after write.
--debug-no-thread-alarm=#
--debug-sync-timeout[=#]Enable the debug sync facility and optionally specify a default wait timeout in seconds. A zero value keeps the facility disabled.
--gdbSet up signals usable for debugging.
--silent-startupDon't print Notes to the error log during startup.MariaDB 10.1.8
--sync-sys Enable/disable system sync calls. Syncs should only be turned off (--disable-sync-sys) when running tests or debugging!
--thread-alarmEnable/disable system thread alarm calls. Should only be turned off (--disable-thread-alarm) when running tests or debugging!MariaDB 5.3
--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().MariaDB 5.3

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: Set the default character set (deprecated 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.

--ignore-db-dir

  • Commandline: --ignore-db-dir=name
  • Description: Tells the server that this directory can never be a database. That means two things - firstly it is ignored by the SHOW DATABASES command and INFORMATION_SCHEMA tables. And secondly, USE, CREATE DATABASE and SELECT statements will return an error if the database from the ignored list specified. Use this option several times if you need to ignore more than one directory. To make the list empty set the void value to the option as --ignore-db-dir=. Corresponding read-only variable ignore_db_dirs shows the current list.
  • Introduced: MariaDB 5.3.9

--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: Path to transaction coordinator log (used for transactions that affect more than one storage engine, when binary log is disabled).

--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: Optional semicolon-separated list of plugins to load, where each plugin is identified as name=library, where name is the plugin name and library is the plugin library in plugin_dir.

--plugin-load-add

  • Commandline: --plugin-load-add=name
  • Description: Takes the same type of arguments that --plugin-load does and complements --plugin-load by appending its argument to the list specified by --plugin-load. So --plugin-load can be considered a composite option consisting of resetting the plugin load list and then calling --plugin-load-add to process the argument. Note that the order in which you specify --plugin-load and --plugin-load-add is important : "--plugin-load=x --plugin-load-add=y" will be equivalent to "--plugin-load=x,y" whereas "--plugin-load-add=y --plugin-load=x" will be equivalent to "plugin-load=x".
  • 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


--skip-stack-trace

  • Commandline: --skip-stack-trace
  • Description: Don't print a stack trace on failure.

  • 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
  • Description: Print a stack trace on failure.

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

--tc-heuristic-recover

  • Commandline: --tc-heuristic-recover=name
  • Description: Decision to use in heuristic recover process. Possible values are COMMIT or ROLLBACK.

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

cracklib_password_check plugin

The options for the cracklib_password_check plugin are all described on the cracklib_password_check Plugin page.

Feedback plugin

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

HandlerSocket Plugin

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

Query_Response_Time plugin

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

Semisynchronous Replication Plugin

The options for the Semisynchronous Replication plugin are described on the Semisynchronous Replication plugin page.

Server Audit

The options for the MariaDB Audit plugin are described on the Server Audi System Variables page.

simple_password_check plugin

The options for the simple_password_check plugin are described on the simple_password_check page.

SQL_ERROR_LOG Plugin

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

Default Values

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

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

The default values are at the end of this list

Comments

Comments loading...