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

Other Compatibility Options

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

  • Commandline: --master-ssl
  • Description: Enable the slave to connect to the master using SSL.

--master-ssl-ca

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

--master-ssl-capath

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

--master-ssl-cert

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

--master-ssl-cipher

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

--master-ssl-key

  • Commandline: --master-ssl-key[=name]
  • Description: Master SSL 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.

Other replication and binary logging options

Optimizer options

--record-buffer


--table-cache


Other optimizer options

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.

Other 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, or FORCE. If set to OFF (the same as --skjp-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.

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

Other InnoDB options

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.

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.

Other Galera options

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.

OptionDescriptionIntroduced
--core-fileWrite core on errors.
-#, --debug[=name]Use logging trough 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.
--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 UDFs consisting of only one symbol xxx() without corresponding xxx_init() or xxx_deinit(). That also means that one can load any function from any library, for example exit() from libc.so

--bootstrap

  • Commandline: --bootstrap
  • Description: Used by mysql installation scripts.

--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.
  • 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-admin-statements

  • Commandline: --log-slow-admin-statements
  • Description: Log slow OPTIMIZE, ANALYZE, ALTER and other administrative statements to the slow log if it is open.

--log-slow-file

  • Commandline: --log-slow-file=name
  • Description: Log slow queries to given log file. Defaults logging to hostname-slow.log

--log-slow-slave-statements

  • Commandline: --log-slow-slave-statements
  • Description: Log slow statements executed by slave thread to the slow log if it is open.

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

  • Commandline: --skip-ssl
  • Description: Disable SSL connections.

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

More other options

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