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-safe-truncate
    196. --innodb-scrub-log
    197. --innodb-scrub-log-interval
    198. --innodb-scrub-log-speed
    199. --innodb-show-locks-held
    200. --innodb-show-verbose-locks
    201. --innodb-sort-buffer-size
    202. --innodb-spin-wait-delay
    203. --innodb-stats-auto-recalc
    204. --innodb-stats-auto-update
    205. --innodb-stats-include-delete-marked
    206. --innodb-stats-method
    207. --innodb-stats-modified-counter
    208. --innodb-stats-on-metadata
    209. --innodb-stats-persistent
    210. --innodb-stats-persistent-sample-pages
    211. --innodb-stats-sample-pages
    212. --innodb-stats-traditional
    213. --innodb-stats-transient-sample-pages
    214. --innodb-stats-update-need-lock
    215. --innodb-status-file
    216. --innodb-status-output
    217. --innodb-status-output-locks
    218. --innodb-strict-mode
    219. --innodb-support-xa
    220. --innodb-sync-array-size
    221. --innodb-sync-spin-loops
    222. --innodb-sys-indexes
    223. --innodb-sys-stats
    224. --innodb-sys-tables
    225. --innodb-table-locks
    226. --innodb-table-stats
    227. --innodb-temp-data-file-path
    228. --innodb-thread-concurrency
    229. --innodb-thread-concurrency-timer-based
    230. --innodb-thread-sleep-delay
    231. --innodb-tmpdir
    232. --innodb-track-changed-pages
    233. --innodb-track-redo-log-now
    234. --innodb-trx
    235. --innodb-undo-directory
    236. --innodb-undo-log-truncate
    237. --innodb-undo-logs
    238. --innodb-undo-tablespaces
    239. --innodb-use-atomic-writes
    240. --innodb-use-fallocate
    241. --innodb-use-global-flush-log-at-trx-commit
    242. --innodb-use-mtflush
    243. --innodb-use-native-aio
    244. --innodb-use-purge-thread
    245. --innodb-use-stacktrace
    246. --innodb-use-sys-malloc
    247. --innodb-use-sys-stats-table
    248. --innodb-use-trim
    249. --innodb-write-io-threads
    250. --skip-innodb
    251. --skip-innodb-checksums
    252. --skip-innodb-doublewrite
    253. InnoDB 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-dir-path
    9. --aria-log-file-size
    10. --aria-log-purge-type
    11. --aria-max-sort-file-size
    12. --aria-page-checksum
    13. --aria-pagecache-age-threshold
    14. --aria-pagecache-buffer-size
    15. --aria-pagecache-division-limit
    16. --aria-pagecache-file-hash-size
    17. --aria-recover
    18. --aria-recover-options
    19. --aria-repair-threads
    20. --aria-sort-buffer-size
    21. --aria-stats-method
    22. --aria-sync-log-dir
    23. --aria-used-for-temp-tables
    24. --deadlock-search-depth-long
    25. --deadlock-search-depth-short
    26. --deadlock-timeout-long
    27. --deadlock-timeout-short
  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-cond-push
    3. --connect-conv-size
    4. --connect-enable-mongo
    5. --connect-exact-info
    6. --connect-indx-map
    7. --connect-java-wrapper
    8. --connect-json-grp-size
    9. --connect-json-null
    10. --connect-jvm-path
    11. --connect-type-conv
    12. --connect-use-tempfile
    13. --connect-work-size
    14. --connect-xtrace
  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. --eq-range-index-dive-limit
    49. --event-scheduler
    50. --exit-info
    51. --expire-logs-days
    52. --explicit-defaults-for-timestamp
    53. --extra-max-connections
    54. --extra-port
    55. --flush
    56. --flush-time
    57. --ft-boolean-syntax
    58. --ft-max-word-len
    59. --ft-min-word-len
    60. --ft-query-expansion-limit
    61. --ft-stopword-file
    62. --general-log
    63. --general-log-file
    64. --getopt-prefix-matching
    65. --group-concat-max-len
    66. --help
    67. --histogram-size
    68. --histogram-type
    69. --host-cache-size
    70. --idle-readonly-transaction-timeout
    71. --idle-transaction-timeout
    72. --idle-write-transaction-timeout
    73. --ignore-db-dirs
    74. --init-connect
    75. --init-file
    76. --interactive-timeout
    77. --language
    78. --large-pages
    79. --lc-messages
    80. --lc-messages-dir
    81. --lc-time-names
    82. --local-infile
    83. --lock-wait-timeout
    84. --log
    85. --log-disabled_statements
    86. --log-error
    87. --log-long-format
    88. --log-output
    89. --log-queries-not-using-indexes
    90. --log-short-format
    91. --log-slow-admin-statements
    92. --log-slow-admin-statements
    93. --log-slow-file
    94. --log-slow-filter
    95. --log-slow-queries
    96. --log-slow-rate-limit
    97. --log-slow-slave-statements
    98. --log-slow-time
    99. --log-slow-verbosity
    100. --log-tc
    101. --log-tc-size
    102. --log-update
    103. --log-warnings
    104. --long-query-time
    105. --low-priority-updates
    106. --lower-case-table-names
    107. --master-connect-retry
    108. --max-allowed-packet
    109. --max-connections
    110. --max-connect-errors
    111. --max-delayed-threads
    112. --max-digest-length
    113. --max-error-count
    114. --max-length-for-sort-data
    115. --max-long-data-size
    116. --max-prepared-stmt-count
    117. --max-recursive-iterations
    118. --max-session-mem-used
    119. --max-sp-recursion-depth
    120. --max-statement-time
    121. --max-tmp-tables
    122. --max-user-connections
    123. --max-write-lock-count
    124. --memlock
    125. --metadata-locks-cache-size
    126. --metadata-locks-hash-instances
    127. --min-examined-row-limit
    128. --mrr-buffer-size
    129. --multi-range-count
    130. --mysql56-temporal-format
    131. --ndb-use-copying-alter-table
    132. --net-buffer-length
    133. --net-read-timeout
    134. --net-retry-count
    135. --net-write-timeout
    136. --no-defaults
    137. --one-thread
    138. --open-files-limit
    139. --pid-file
    140. --plugin-load
    141. --plugin-load-add
    142. --plugin-dir
    143. --plugin-maturity
    144. --port
    145. --port-open-timeout
    146. --preload-buffer-size
    147. --print-defaults
    148. --profiling-history-size
    149. --progress-report-time
    150. --query-cache-limit
    151. --query-cache-min-res-unit
    152. --query-cache-size
    153. --query-cache-strip-comments
    154. --query-cache-type
    155. --query-cache-wlock-invalidate
    156. --read-rnd-buffer-size
    157. --read-only
    158. --safe-show-database
    159. --safe-user-create
    160. --safemalloc-mem-limit
    161. --secure-auth
    162. --secure-file-priv
    163. --secure-timestamp
    164. --session-track-schema
    165. --session-track-state-change
    166. --session-track-system-variables
    167. --session-track-transaction-info
    168. --set-variable
    169. --show-slave-auth-info
    170. --skip-automatic-sp-privileges
    171. --skip-external-locking
    172. --skip-grant-tables
    173. --skip-host-cache
    174. --skip-large-pages
    175. --skip-locking
    176. --skip-log-error
    177. --skip-name-resolve
    178. --skip-networking
    179. --skip-partition
    180. --skip-show-database
    181. --skip-slave-start
    182. --skip-ssl
    183. --skip-stack-trace
    184. --skip-symbolic-links
    185. --skip-symlink
    186. --skip-thread-priority
    187. --slow-launch-time
    188. --slow-query-log
    189. --slow-query-log-file
    190. --socket
    191. --sort-buffer-size
    192. --sql-bin-update-same
    193. --sql-mode
    194. --ssl
    195. --ssl-ca
    196. --ssl-capath
    197. --ssl-cert
    198. --ssl-cipher
    199. --ssl-crl
    200. --ssl-crlpath
    201. --ssl-key
    202. --stack-trace
    203. --standard-compliant-cte
    204. --stored-program-cache
    205. --strict-password-validation
    206. --symbolic-links
    207. --sync-frm
    208. --system-versioning-alter-history
    209. --system-versioning-asof
    210. --system-versioning-innodb-algorithm-simple
    211. --table-lock-wait-timeout
    212. --tc-heuristic-recover
    213. --tcp-keepalive-interval
    214. --tcp-keepalive-probes
    215. --tcp-keepalive-time
    216. --tcp-nodelay
    217. --temp-pool
    218. --test-expect-abort
    219. --test-ignore-wrong-options
    220. --thread-cache-size
    221. --thread-concurrency
    222. --thread-handling
    223. --thread-pool-idle-timeout
    224. --thread-pool-max-threads
    225. --thread-pool-min-threads
    226. --thread-pool-prio-kickup-timer
    227. --thread-pool-priority
    228. --thread-pool-size
    229. --thread-pool-stall-limit
    230. --thread-stack
    231. --timed-mutexes
    232. --time-format
    233. --tmpdir
    234. --transaction-isolation
    235. --transaction-alloc-block-size
    236. --transaction-prealloc-size
    237. --transaction-read-only
    238. --updatable-views-with-limit
    239. --use-symbolic-links
    240. --user
    241. --userstat
    242. --verbose
    243. --version
    244. --wait-timeout
    245. --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. Mroonga Storage Engine
  25. TokuDB Storage Engine
  26. 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.

--aria-log-dir-path

  • Commandline: --aria-log-dir-path=value
  • Description: Path to the directory where transactional log should be stored
  • Default: SAME AS DATADIR

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.

--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 System Variables page.

Mroonga Storage Engine

The options for the Mroonga storage engine are described on the Mroonga System Variables page.

TokuDB Storage Engine

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