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-optimize-ddl
    153. --innodb-log-write-ahead-size
    154. --innodb-lru-scan-depth
    155. --innodb-max-bitmap-file-size
    156. --innodb-max-changed-pages
    157. --innodb-max-dirty-pages-pct
    158. --innodb-max-dirty-pages-pct-lwm
    159. --innodb-max-purge-lag
    160. --innodb-max-purge-lag-delay
    161. --innodb-max-undo-log-size
    162. --innodb-merge-sort-block-size
    163. --innodb-mirrored-log-groups
    164. --innodb-monitor-disable
    165. --innodb-monitor-enable
    166. --innodb-monitor-reset
    167. --innodb-monitor-reset-all
    168. --innodb-mtflush-threads
    169. --innodb-numa-interleave
    170. --innodb-old-blocks-pct
    171. --innodb-old-blocks-time
    172. --innodb-online-alter-log-max-size
    173. --innodb-open-files
    174. --innodb-optimize-fulltext-only
    175. --innodb-overwrite-relay-log-info
    176. --innodb-page-cleaners
    177. --innodb-page-size
    178. --innodb-pass-corrupt-table
    179. --innodb-prefix-index-cluster-optimization
    180. --innodb-print-all-deadlocks
    181. --innodb-purge-batch-size
    182. --innodb-purge-rseg-truncate-frequency
    183. --innodb-purge-threads
    184. --innodb-random-read-ahead
    185. --innodb-read-ahead
    186. --innodb-read-ahead-threshold
    187. --innodb-read-io-threads
    188. --innodb-read-only
    189. --innodb-recovery-update-relay-log
    190. --innodb-replication-delay
    191. --innodb-rollback-on-timeout
    192. --innodb-rollback-segments
    193. --innodb-rseg
    194. --innodb-sched-priority-cleaner
    195. --innodb-scrub-log
    196. --innodb-scrub-log-interval
    197. --innodb-scrub-log-speed
    198. --innodb-show-locks-held
    199. --innodb-show-verbose-locks
    200. --innodb-sort-buffer-size
    201. --innodb-spin-wait-delay
    202. --innodb-stats-auto-recalc
    203. --innodb-stats-auto-update
    204. --innodb-stats-include-delete-marked
    205. --innodb-stats-method
    206. --innodb-stats-modified-counter
    207. --innodb-stats-on-metadata
    208. --innodb-stats-persistent
    209. --innodb-stats-persistent-sample-pages
    210. --innodb-stats-sample-pages
    211. --innodb-stats-traditional
    212. --innodb-stats-transient-sample-pages
    213. --innodb-stats-update-need-lock
    214. --innodb-status-file
    215. --innodb-status-output
    216. --innodb-status-output-locks
    217. --innodb-strict-mode
    218. --innodb-support-xa
    219. --innodb-sync-array-size
    220. --innodb-sync-spin-loops
    221. --innodb-sys-indexes
    222. --innodb-sys-stats
    223. --innodb-sys-tables
    224. --innodb-table-locks
    225. --innodb-table-stats
    226. --innodb-temp-data-file-path
    227. --innodb-thread-concurrency
    228. --innodb-thread-concurrency-timer-based
    229. --innodb-thread-sleep-delay
    230. --innodb-tmpdir
    231. --innodb-track-changed-pages
    232. --innodb-track-redo-log-now
    233. --innodb-trx
    234. --innodb-undo-directory
    235. --innodb-undo-log-truncate
    236. --innodb-undo-logs
    237. --innodb-undo-tablespaces
    238. --innodb-use-atomic-writes
    239. --innodb-use-fallocate
    240. --innodb-use-global-flush-log-at-trx-commit
    241. --innodb-use-mtflush
    242. --innodb-use-native-aio
    243. --innodb-use-purge-thread
    244. --innodb-use-stacktrace
    245. --innodb-use-sys-malloc
    246. --innodb-use-sys-stats-table
    247. --innodb-use-trim
    248. --innodb-write-io-threads
    249. --skip-innodb
    250. --skip-innodb-checksums
    251. --skip-innodb-doublewrite
    252. 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-reject_queries
    32. --wsrep-replicate-myisam
    33. --wsrep-restart-slave
    34. --wsrep-retry-autocommit
    35. --wsrep-slave-FK-checks
    36. --wsrep-slave-threads
    37. --wsrep-slave-UK-checks
    38. --wsrep-sst-auth
    39. --wsrep-sst-donor
    40. --wsrep-sst-donor-rejects-queries
    41. --wsrep-sst-method
    42. --wsrep-sst-receive-address
    43. --wsrep-start-position
    44. --wsrep-sync-wait
    45. 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-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 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. --secure-timestamp
    163. --session-track-schema
    164. --session-track-state-change
    165. --session-track-system-variables
    166. --session-track-transaction-info
    167. --set-variable
    168. --show-slave-auth-info
    169. --skip-automatic-sp-privileges
    170. --skip-external-locking
    171. --skip-grant-tables
    172. --skip-host-cache
    173. --skip-large-pages
    174. --skip-locking
    175. --skip-name-resolve
    176. --skip-networking
    177. --skip-partition
    178. --skip-show-database
    179. --skip-slave-start
    180. --skip-ssl
    181. --skip-stack-trace
    182. --skip-symbolic-links
    183. --skip-symlink
    184. --skip-thread-priority
    185. --slow-launch-time
    186. --slow-query-log
    187. --slow-query-log-file
    188. --socket
    189. --sort-buffer-size
    190. --sql-bin-update-same
    191. --sql-mode
    192. --ssl
    193. --ssl-ca
    194. --ssl-capath
    195. --ssl-cert
    196. --ssl-cipher
    197. --ssl-crl
    198. --ssl-crlpath
    199. --ssl-key
    200. --stack-trace
    201. --standard-compliant-cte
    202. --stored-program-cache
    203. --strict-password-validation
    204. --symbolic-links
    205. --sync-frm
    206. --system-versioning-alter-history
    207. --system-versioning-asof
    208. --system-versioning-innodb-algorithm-simple
    209. --table-lock-wait-timeout
    210. --tc-heuristic-recover
    211. --tcp-keepalive-interval
    212. --tcp-keepalive-probes
    213. --tcp-keepalive-time
    214. --tcp-nodelay
    215. --temp-pool
    216. --test-expect-abort
    217. --test-ignore-wrong-options
    218. --thread-cache-size
    219. --thread-concurrency
    220. --thread-handling
    221. --thread-pool-idle-timeout
    222. --thread-pool-max-threads
    223. --thread-pool-min-threads
    224. --thread-pool-prio-kickup-timer
    225. --thread-pool-priority
    226. --thread-pool-size
    227. --thread-pool-stall-limit
    228. --thread-stack
    229. --timed-mutexes
    230. --time-format
    231. --tmpdir
    232. --transaction-isolation
    233. --transaction-alloc-block-size
    234. --transaction-prealloc-size
    235. --transaction-read-only
    236. --updatable-views-with-limit
    237. --use-symbolic-links
    238. --user
    239. --userstat
    240. --verbose
    241. --version
    242. --wait-timeout
    243. --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. file_key_management Plugin
  17. 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
  18. Query_Response_Time plugin
    1. query-response-time-range-base
    2. query-response-time-stats
  19. 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
  20. 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
  21. 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
  22. 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
  23. Spider Storage Engine
  24. 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. To apply to multiple databases, use the option multiple times. A comma-delimited list is not accepted, since a database name can contain a comma.

--binlog-ignore-db

  • Commandline: --binlog-ignore-db=name
  • Description: Tells the master that updates to the given database should not be logged to the binary log. See Using and Maintaining the Binary Log. To apply to multiple databases, use the option multiple times. A comma-delimited list is not accepted, since a database name can contain a comma.

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

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

file_key_management Plugin

The options for the file_key_management Plugin are described on the Encryption Key Management 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.

Spider Storage Engine

The options for the Spider storage engine are described on the Spider Server 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...