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

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

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.

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

  • Commandline: --log-tc-size=#
  • Description: Size of transaction coordinator log.

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

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