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

  • Commandline: --log-bin-index=name
  • Description: File that holds the names for last binary log files.

--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
  • Description: Log all MyISAM changes to file.

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

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 all described on the QUERY_RESPONSE_TIME plugin page.

Server Audit

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

SQL_ERROR_LOG Pluign

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