mysqld Options

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. --relay-log
    47. --relay-log-index
    48. --relay-log-info-file
    49. --relay-log-purge
    50. --relay-log-recovery
    51. --relay-log-space-limit
    52. --replicate-annotate-row-events
    53. --replicate-do-db
    54. --replicate-do-table
    55. --replicate-events-marked-for-skip
    56. --replicate-ignore-db
    57. --replicate-ignore-table
    58. --replicate-rewrite-db
    59. --replicate-same-server-id
    60. --replicate-wild-do-table
    61. --replicate-wild-ignore-table
    62. --report-host
    63. --report-password
    64. --report-port
    65. --report-user
    66. --rpl-recovery-rank
    67. --server-id
    68. --slave-ddl-exec-mode
    69. --slave-compressed-protocol
    70. --slave-domain-parallel-threads
    71. --slave-exec-mode
    72. --slave-load-tmpdir
    73. --slave-max-allowed-packet
    74. --slave-net-timeout
    75. --slave-parallel-threads
    76. --slave-parallel-max-queued
    77. --slave-run-triggers-for-rbr
    78. --slave-skip-errors
    79. --slave-sql-verify-checksum
    80. --slave-transaction-retries
    81. --slave-type-conversions
    82. --sporadic-binlog-dump-fail
    83. --sync-binlog
    84. --sync-master-info
    85. --sync-relay-log
    86. --sync-relay-log-info
    87. --sysdate-is-now
    88. 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. --tmp-table-size
    27. --use-stat-tables
    28. 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-max-sleep-delay
    10. --innodb-additional-mem-pool-size
    11. --innodb-api-bk-commit-interval
    12. --innodb-api-disable-rowlock
    13. --innodb-api-enable-binlog
    14. --innodb-api-enable-mdl
    15. --innodb-api-trx-level
    16. --innodb-auto-lru-dump
    17. --innodb-autoextend-increment
    18. --innodb-autoinc-lock-mode
    19. --innodb-background-scrub-data-check-interval
    20. --innodb-background-scrub-data-compressed
    21. --innodb-background-scrub-data-interval
    22. --innodb-background-scrub-data-uncompressed
    23. --innodb-blocking-buffer-pool-restore
    24. --innodb-buf-dump-status-frequency
    25. --innodb-buffer-pool-dump-at-shutdown
    26. --innodb-buffer-pool-dump-now
    27. --innodb-buffer-pool-dump-pct
    28. --innodb-buffer-pool-filename
    29. --innodb-buffer-pool-instances
    30. --innodb-buffer-pool-load-abort
    31. --innodb-buffer-pool-load-at-startup
    32. --innodb-buffer-pool-load-now
    33. --innodb-buffer-pool-pages
    34. --innodb-buffer-pool-blob
    35. --innodb-buffer-pool-index
    36. --innodb-buffer-pool-populate
    37. --innodb-buffer-pool-restore-at-startup
    38. --innodb-buffer-pool-shm-checksum
    39. --innodb-buffer-pool-shm-key
    40. --innodb-buffer-pool-size
    41. --innodb-change-buffer-max-size
    42. --innodb-change-buffering
    43. --innodb-checkpoint-age-target
    44. --innodb-checksum-algorithm
    45. --innodb-checksums
    46. --innodb-cleaner-lsn-age-factor
    47. --innodb-cmp
    48. --innodb-cmp-per-index-enabled
    49. --innodb-cmp-reset
    50. --innodb-cmpmem
    51. --innodb-cmpmem-reset
    52. --innodb-commit-concurrency
    53. --innodb-compression-algorithm
    54. --innodb-compression-failure-threshold-pct
    55. --innodb-compression-level
    56. --innodb-compression-pad-pct-max
    57. --innodb-concurrency-tickets
    58. --innodb-corrupt-table-action
    59. --innodb-data-file-path
    60. --innodb-data-home-dir
    61. --innodb-default-encryption-key-id
    62. --innodb-default-page-encryption-key
    63. --innodb-defragment
    64. --innodb-defragment-fill-factor
    65. --innodb-defragment-fill-factor-n-recs
    66. --innodb-defragment-frequency
    67. --innodb-defragment-n-pages
    68. --innodb-defragment-stats-accuracy
    69. --innodb-dict-size-limit
    70. --innodb-disable-sort-file-cache
    71. --innodb-doublewrite
    72. --innodb-doublewrite-file
    73. --innodb-empty-free-list-algorithm
    74. --innodb-enable-unsafe-group-commit
    75. --innodb-encrypt-log
    76. --innodb-encrypt-tables
    77. --innodb-encryption-rotate-key-age
    78. --innodb-encryption-rotation-iops
    79. --innodb-encryption-threads
    80. --innodb-expand-import
    81. --innodb-extra-rsegments
    82. --innodb-extra-undoslots
    83. --innodb-fast-checksum
    84. --innodb-fast-recovery
    85. --innodb-fast-shutdown
    86. --innodb-fatal-semaphore-wait-threshold
    87. --innodb-file-format
    88. --innodb-file-format-check
    89. --innodb-file-format-max
    90. --innodb-file-io-threads
    91. --innodb-file-per-table
    92. --innodb-flush-log-at-trx-commi
    93. --innodb-flush-log-at-trx-commit-session
    94. --innodb-flush-method
    95. --innodb-flush-neighbor-pages
    96. --innodb-flush-neighbors
    97. --innodb-flushing_avg_loops
    98. --innodb-force-load-corrupted
    99. --innodb-force-primary-key
    100. --innodb-force-recovery
    101. --innodb-foreground_preflush
    102. --innodb-ft-aux-table
    103. --innodb-ft-cache-size
    104. --innodb-ft-enable-diag_print
    105. --innodb-ft-enable-stopword
    106. --innodb-ft-max-token-size
    107. --innodb-ft-min-token-size
    108. --innodb-ft-num-word-optimize
    109. --innodb-ft-result-cache-limit
    110. --innodb-ft-server-stopword-table
    111. --innodb-ft-sort-pll-degree
    112. --innodb-ft-total-cache-size
    113. --innodb-ft-user-stopword-table
    114. --innodb-ibuf-accel-rate
    115. --innodb-ibuf-active-contract
    116. --innodb-ibuf-max-size
    117. --innodb-idle-flush-pct
    118. --innodb-immediate-scrub-data-uncompressed
    119. --innodb-import-table-from-xtrabackup
    120. --innodb-index-stats
    121. --innodb-instrument-semaphores
    122. --innodb-io-capacity
    123. --innodb-io-capacity-max
    124. --innodb-large-prefix
    125. --innodb-lazy-drop-table
    126. --innodb-lock-wait-timeout
    127. --innodb-lock-waits
    128. --innodb-locking-fake-changes
    129. --innodb-locks
    130. --innodb-locks-unsafe-for-binlog
    131. --innodb-log-arch-dir
    132. --innodb-log-arch-expire-sec
    133. --innodb-log-archive
    134. --innodb-log-block-size
    135. --innodb-log-buffer-size
    136. --innodb-log-checksum-algorithm
    137. --innodb-log-compressed-pages
    138. --innodb-log-file-size
    139. --innodb-log-files-in-group|
    140. --innodb-log-group-home-dir
    141. --innodb-lru-scan-depth
    142. --innodb-max-bitmap-file-size
    143. --innodb-max-changed-pages
    144. --innodb-max-dirty-pages-pct
    145. --innodb-max-dirty-pages-pct-lwm
    146. --innodb-max-purge-lag
    147. --innodb-max-purge-lag-delay
    148. --innodb-merge-sort-block-size
    149. --innodb-mirrored-log-groups
    150. --innodb-monitor_disable
    151. --innodb-monitor_enable
    152. --innodb-monitor_reset
    153. --innodb-monitor_reset-all
    154. --innodb-mtflush-threads
    155. --innodb-old-blocks-pct
    156. --innodb-old-blocks-time
    157. --innodb-online-alter-log-max-size
    158. --innodb-open-files
    159. --innodb-optimize-fulltext-only
    160. --innodb-overwrite-relay-log-info
    161. --innodb-page-size
    162. --innodb-pass-corrupt-table
    163. --innodb-prefix-index-cluster-optimization
    164. --innodb-print-all-deadlocks
    165. --innodb-purge-batch-size
    166. --innodb-purge-threads
    167. --innodb-random-read-ahead
    168. --innodb-read-ahead
    169. --innodb-read-ahead-threshold
    170. --innodb-read-io-threads
    171. --innodb-read-only
    172. --innodb-recovery-update-relay-log
    173. --innodb-replication-delay
    174. --innodb-rollback-on-timeout
    175. --innodb-rollback-segments
    176. --innodb-rseg
    177. --innodb-sched-priority-cleaner
    178. --innodb-scrub-log
    179. --innodb-scrub-log-interval
    180. --innodb-scrub-log-speed
    181. --innodb-show-locks-held
    182. --innodb-show-verbose-locks
    183. --innodb-sort-buffer-size
    184. --innodb-spin-wait-delay
    185. --innodb-stats-auto-recalc
    186. --innodb-stats-auto-update
    187. --innodb-stats-method
    188. --innodb-stats-modified-counter
    189. --innodb-stats-on-metadata
    190. --innodb-stats-persistent
    191. --innodb-stats-persistent-sample-pages
    192. --innodb-stats-sample-pages
    193. --innodb-stats-traditional
    194. --innodb-stats-transient-sample-pages
    195. --innodb-stats-update-need-lock
    196. --innodb-status-file
    197. --innodb-status-output
    198. --innodb-status-output-locks
    199. --innodb-strict-mode
    200. --innodb-support-xa
    201. --innodb-sync-array-size
    202. --innodb-sync-spin-loops
    203. --innodb-sys-indexes
    204. --innodb-sys-stats
    205. --innodb-sys-tables
    206. --innodb-table-locks
    207. --innodb-table-stats
    208. --innodb-thread-concurrency
    209. --innodb-thread-concurrency-timer-based
    210. --innodb-thread-sleep-delay
    211. --innodb-track-changed-pages
    212. --innodb-trx
    213. --innodb-undo-directory
    214. --innodb-undo_logs
    215. --innodb-undo-tablespaces
    216. --innodb-use-atomic-writes
    217. --innodb-use-fallocate
    218. --innodb-use-global-flush-log-at-trx-commit
    219. --innodb-use-mtflush
    220. --innodb-use-native-aio
    221. --innodb-use-purge-thread
    222. --innodb-use-stacktrace
    223. --innodb-use-sys-malloc
    224. --innodb-use-sys-stats-table
    225. --innodb-use-trim
    226. --innodb-write-io-threads
    227. --skip-innodb
    228. --skip-innodb-checksums
    229. --skip-innodb-doublewrite
    230. InnoDB sysem 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-json-grp-size
    6. --connect-jvm-path
    7. --connect-type-conv
    8. --connect-use-tempfile
    9. --connect-work-size
    10. --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. --chroot
    13. --collation-server
    14. --completion-type
    15. --connect-timeout
    16. --datadir
    17. --date-format
    18. --datetime-format
    19. --deadlock-search-depth-long
    20. --deadlock-search-depth-short
    21. --deadlock-timeout-long
    22. --deadlock-timeout-short
    23. --default-character-set
    24. --default-collation
    25. --default-regex-flags
    26. --default-storage-engine
    27. --default-table-type
    28. --default-tmp-storage-engine
    29. --default-time-zone
    30. --default-week-format
    31. --delay_key_write
    32. --des-key-file
    33. --div-precision-increment
    34. --enable-locking
    35. --enable-named-pipe
    36. --encrypt-binlog
    37. --encrypt-tmp-disk-tables
    38. --encrypt-tmp-files
    39. --encryption-algorithm
    40. --engine-condition-pushdown
    41. --event-scheduler
    42. --exit-info
    43. --expire-logs-days
    44. --explicit-defaults-for-timestamp
    45. --extra-max-connections
    46. --extra-port
    47. --flush
    48. --flush-time
    49. --ft-boolean-syntax
    50. --ft-max-word-len
    51. --ft-min-word-len
    52. --ft-query-expansion-limit
    53. --ft-stopword-file
    54. --general-log
    55. --general-log-file
    56. --getopt-prefix-matching
    57. --group-concat-max-len
    58. --help
    59. --histogram-size
    60. --histogram-type
    61. --host-cache-size
    62. --ignore-db-dir
    63. --init-connect
    64. --init-file
    65. --interactive-timeout
    66. --language
    67. --large-pages
    68. --lc-messages
    69. --lc-messages-dir
    70. --lc-time-names
    71. --local-infile
    72. --lock-wait-timeout
    73. --log
    74. --log-error
    75. --log-long-format
    76. --log-output
    77. --log-queries-not-using-indexes
    78. --log-short-format
    79. --log-slow-admin-statements
    80. --log-slow-file
    81. --log-slow-filter
    82. --log-slow-queries
    83. --log-slow-rate-limit
    84. --log-slow-slave-statements
    85. --log-slow-time
    86. --log-slow-verbosity
    87. --log-tc
    88. --log-tc-size
    89. --log-update
    90. --log-warnings
    91. --long-query-time
    92. --low-priority-updates
    93. --lower-case-table-names
    94. --master-connect-retry
    95. --max-allowed-packet
    96. --max-connections
    97. --max-connect-errors
    98. --max-delayed-threads
    99. --max-digest-length
    100. --max-error-count
    101. --max-length-for-sort-data
    102. --max-long-data-size
    103. --max-prepared-stmt-count
    104. --max-sp-recursion-depth
    105. --max-statement_time
    106. --max-tmp-tables
    107. --max-user-connections
    108. --max-write-lock-count
    109. --memlock
    110. --metadata-locks-cache-size
    111. --metadata-locks-hash-instances
    112. --min-examined-row-limit
    113. --mrr-buffer-size
    114. --multi-range-count
    115. --mysql56-temporal-format
    116. --ndb-use-copying-alter-table
    117. --net-buffer-length
    118. --net-read-timeout
    119. --net-retry-count
    120. --net-write-timeout
    121. --one-thread
    122. --open-files-limit
    123. --pid-file
    124. --plugin-load
    125. --plugin-load-add
    126. --plugin-dir
    127. --plugin-maturity
    128. --port
    129. --port-open-timeout
    130. --preload-buffer-size
    131. --profiling-history-size
    132. --progress-report-time
    133. --query-cache-limit
    134. --query-cache-min-res-unit
    135. --query-cache-size
    136. --query-cache-strip-comments
    137. --query-cache-type
    138. --query-cache-wlock-invalidate
    139. --read-rnd-buffer-size
    140. --read-only
    141. --safe-show-database
    142. --safe-user-create
    143. --safemalloc-mem-limit
    144. --secure-auth
    145. --secure-file-priv
    146. --set-variable
    147. --show-slave-auth-info
    148. --skip-automatic-sp-privileges
    149. --skip-external-locking
    150. --skip-grant-tables
    151. --skip-host-cache
    152. --skip-large-pages
    153. --skip-locking
    154. --skip-name-resolve
    155. --skip-networking
    156. --skip-show-database
    157. --skip-slave-start
    158. --skip-ssl
    159. --skip-stack-trace
    160. --skip-symbolic-links
    161. --skip-symlink
    162. --skip-thread-priority
    163. --slow_launch_time
    164. --slow-query-log
    165. --slow-query-log-file
    166. --socket
    167. --sort-buffer-size
    168. --sql-bin-update-same
    169. --sql-mode
    170. --ssl
    171. --ssl-ca
    172. --ssl-capath
    173. --ssl-cert
    174. --ssl-cipher
    175. --ssl-crl
    176. --ssl-crlpath
    177. --ssl-key
    178. --stored-program-cache
    179. --strict-password-validation
    180. --symbolic-links
    181. --sync-frm
    182. --table-lock-wait-timeout
    183. --tc-heuristic-recover
    184. --temp-pool
    185. --test-expect-abort
    186. --test-ignore-wrong-options
    187. --thread-cache-size
    188. --thread_concurrency
    189. --thread-handling
    190. --thread-pool-algorithm
    191. --thread-pool-high-priority-connection
    192. --thread_pool-idle-timeout
    193. --thread_pool-max-threads
    194. --thread_pool-max-unused-threads
    195. --thread_pool-min-threads
    196. --thread_pool-prio-kickup-timer
    197. --thread_pool-size
    198. --thread_pool-stall-limit
    199. --thread_stack
    200. --timed-mutexes
    201. --time-format
    202. --tmpdir
    203. --transaction-isolation
    204. --transaction-alloc-block-size
    205. --transaction-prealloc-size
    206. --transaction-read-only
    207. --updatable-views-with-limit
    208. --use-symbolic-links
    209. --user
    210. --userstat
    211. --verbose
    212. --version
    213. --wait-timeout
    214. --warnings
    215. Other system variables
  12. cracklib_password_check plugin
    1. cracklib_password_check_dictionary
  13. Feedback plugin
    1. feedback
    2. feedback_http_proxy
    3. feedback_send_retry_wait
    4. feedback_send_timeout
    5. feedback_url
    6. feedback_user_info
  14. 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
  15. Query_Response_Time plugin
    1. query-response-time-range-base
    2. query-response-time-stats
  16. 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
  17. 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
  18. 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
  19. 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
  20. Default values

This page lists all of the options for mysqld, ordered by topic. For a full alphabetical list of all mysqld options, as well as server and status variables, see Full list of MariaDB options, system and status variables.

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.

--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=name
  • Description: Updates to a database with a different name than the original. 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 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 sysem 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

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

  • Commandline: --skip-grant-tables
  • Description: Start without grant tables. This gives all users FULL ACCESS to all tables.

--skip-host-cache

  • Commandline: --skip-host-cache
  • Description: Don't cache host names.

--skip-locking


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