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

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

Replication and binary logging options

--abort-slave-event-count

  • Commandline: --abort-slave-event-count=#
  • Description: Option used by mysql-test for debugging and testing of replication.

--binlog-do-db

  • Commandline: --binlog-do-db=name
  • Description: Tells the master it should log updates for the specified database, and exclude all others not explicitly mentioned. See Using and Maintaining the Binary Log.

--binlog-ignore-db


--binlog-row-event-max-size

  • Commandline: --binlog-row-event-max-size=#
  • Description: The maximum size of a row-based binary log event in bytes. Rows will be grouped into events smaller than this size if possible. The value has to be a multiple of 256.
  • Default value

--disconnect-slave-event-count

  • Commandline: --disconnect-slave-event-count=#
  • Description: Option used by mysql-test for debugging and testing of replication.

--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 depending on your host name. Sets names for log-bin, log-bin-index, relay-log, relay-log-index, general-log-file, --log-slow-query-log-file, --log-error-file, and pid-file.
  • Introduced: MariaDB 5.2

--log-bin-trust-routine-creators


--master-host

  • Commandline: --master-host=name
  • Description: Master hostname or IP address for replication. If not set, the slave thread will not be started. Note that the setting of master-host will be ignored if there exists a valid master.info file.

--master-info-file

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

--master-password

  • Commandline: --master-password=name
  • Description: The password the slave thread will authenticate with when connecting to the master. If not set, an empty password is assumed. The value in master.info will take precedence if it can be read.

--master-port

  • Commandline: --master-port=#
  • Description: The port the master is listening on. If not set, the compiled setting of MYSQL_PORT is assumed. If you have not tinkered with configure options, this should be 3306. The value in master.info will take precedence if it can be read.

--master-ssl


--master-ssl-ca

  • Commandline: --master-ssl-ca[=name]
  • Description: Master TLS CA file. Only applies if you have enabled master-ssl.

--master-ssl-capath

  • Commandline: --master-ssl-capath[=name]
  • Description: Master TLS CA path. Only applies if you have enabled master-ssl.

--master-ssl-cert

  • Commandline: --master-ssl-cert[=name]
  • Description: Master TLS certificate file name. Only applies if you have enabled master-ssl.

--master-ssl-cipher

  • Commandline: --master-ssl-cipher[=name]
  • Description: Master TLS cipher. Only applies if you have enabled master-ssl.

--master-ssl-key

  • Commandline: --master-ssl-key[=name]
  • Description: Master TLS keyfile name. Only applies if you have enabled master-ssl.

--master-user

  • Commandline: --master-user=name
  • Description: The username the slave thread will use for authentication when connecting to the master. The user must have FILE privilege. If the master user is not set, user test is assumed. The value in master.info will take precedence if it can be read.

--max-binlog-dump-events

  • Commandline: --max-binlog-dump-events=#
  • Description: Option used by mysql-test for debugging and testing of replication.

--replicate-rewrite-db

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

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

--replicate-same-server-id

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

--sporadic-binlog-dump-fail

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

--support-flashback

  • Commandline: --support-flashback
  • Description: Setup the server to use flashback. This enables binary log in row mode and will enable extra logging for DDL's needed by flashback feature.
  • Introduced: MariaDB 10.2.4

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

Optimizer options

--record-buffer


--table-cache


Optimizer 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

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

--bind-address

  • Commandline: --bind-address=addr
  • Description: By default, the MariaDB server listens for TCP/IP connections on a network socket bound to a single address, 0.0.0.0. You can specify an alternative when the server starts using this option; either a host name, an IPv4 or an IPv6 address. In Debian and Ubuntu, the default bind_address is 127.0.0.1, which binds the server to listen on localhost only.
  • Data Type: string
  • Valid Values: Host name, IPv4, IPv6 (>= MariaDB 5.5)

--bootstrap

  • Commandline: --bootstrap
  • Description: Used by mysql installation scripts, such as mysql_install_db to execute SQL scripts before any privilege or system tables exist. Do no use while an existing MariaDB instance is running.

--character-set-client-handshake

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

--chroot

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

--default-character-set

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

--default-collation

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

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

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

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

  • 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 system variables

cracklib_password_check plugin

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

Feedback plugin

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

HandlerSocket plugin

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

Query_Response_Time plugin

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

Semisynchronous Replication plugin

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

Server Audit

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

simple_password_check plugin

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

SQL_ERROR_LOG plugin

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

Default values

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

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

The default values are at the end of this list

Comments

Comments loading...
Loading