Variables (--variable-name=value) and boolean options {FALSE|TRUE} Value (after reading options) ------------------------------------------------- ------------------------ abort-slave-event-count 0 admin-port 0 admission-control-by-trx FALSE admission-control-filter allow-document-type FALSE allow-multiple-engines FALSE allow-noncurrent-db-rw ON allow-suspicious-udfs FALSE archive ON auto-increment-increment 1 auto-increment-offset 1 autocommit TRUE automatic-sp-privileges TRUE avoid-temporal-upgrade FALSE back-log 80 basedir /data/gagarin/opt/builds/production/myrocks-mysql_common-5.6.27.75-jet-4-e34c228/ big-tables FALSE bind-address * binlog-cache-size 32768 binlog-checksum NONE binlog-direct-non-transactional-updates FALSE binlog-error-action IGNORE_ERROR binlog-format STATEMENT binlog-gtid-simple-recovery FALSE binlog-order-commits TRUE binlog-row-event-max-size 8192 binlog-row-image FULL binlog-rows-query-log-events FALSE binlog-stmt-cache-size 32768 binlogging-impossible-mode IGNORE_ERROR blackhole ON block-create-memory FALSE block-create-myisam FALSE block-create-no-primary-key FALSE block-encryption-mode aes-128-ecb bulk-insert-buffer-size 8388608 character-set-client-handshake TRUE character-set-filesystem binary character-set-server utf8 character-sets-dir /data/gagarin/opt/builds/production/myrocks-mysql_common-5.6.27.75-jet-4-e34c228/share/mysql/charsets/ chroot (No default value) collation-server utf8_bin completion-type NO_CHAIN concurrent-insert AUTO connect-timeout 10 console FALSE core-file FALSE datadir /jet/prs/mysqld/data/ date-format %Y-%m-%d datetime-format %Y-%m-%d %H:%i:%s default-storage-engine rocksdb default-time-zone (No default value) default-tmp-storage-engine MyISAM default-week-format 0 delay-key-write ON delayed-insert-limit 100 delayed-insert-timeout 300 delayed-queue-size 1000 des-key-file (No default value) disable-trigger FALSE disable-working-set-size FALSE disconnect-on-expired-password TRUE disconnect-slave-event-count 0 div-precision-increment 4 enable-gtid-mode-on-new-slave-with-old-master FALSE end-markers-in-json FALSE enforce-gtid-consistency FALSE eq-range-index-dive-limit 10 event-scheduler OFF expand-fast-index-creation FALSE expire-logs-days 0 explicit-defaults-for-timestamp FALSE external-locking FALSE fatal-semaphore-timeout 600 federated ON filesort-max-file-size 0 flush FALSE flush-time 0 ft-boolean-syntax + -><()~*:""&| ft-max-word-len 84 ft-min-word-len 4 ft-query-expansion-limit 20 ft-stopword-file (No default value) gap-lock-exceptions (No default value) gap-lock-log-file /jet/prs/mysqld/data/download-gaplock.log gap-lock-raise-error FALSE gap-lock-write-log FALSE gdb FALSE general-log FALSE general-log-file /jet/log/mysqld/general.log general-query-throttling-limit 0 group-concat-max-len 1024 gtid-mode OFF gtid-precommit FALSE help TRUE histogram-step-size-binlog-fsync 16ms histogram-step-size-binlog-group-commit 1 histogram-step-size-connection-create 16ms histogram-step-size-ddl-command 64ms histogram-step-size-delete-command 64us histogram-step-size-handler-command 16ms histogram-step-size-insert-command 128us histogram-step-size-other-command 16ms histogram-step-size-select-command 128us histogram-step-size-transaction-command 16ms histogram-step-size-update-command 16ms hll-data-size-log2 14 host-cache-size 279 ignore-builtin-innodb FALSE init-connect init-file (No default value) init-slave innodb ON innodb-adaptive-flushing TRUE innodb-adaptive-flushing-lwm 10 innodb-adaptive-hash-index TRUE innodb-adaptive-max-sleep-delay 150000 innodb-additional-mem-pool-size 8388608 innodb-aio-old-usecs 500000 innodb-aio-outstanding-requests 256 innodb-aio-slow-usecs 500000 innodb-api-bk-commit-interval 5 innodb-api-disable-rowlock FALSE innodb-api-enable-binlog FALSE innodb-api-enable-mdl FALSE innodb-api-trx-level 0 innodb-autoextend-increment 64 innodb-autoinc-lock-mode 1 innodb-buffer-page ON innodb-buffer-page-lru ON innodb-buffer-pool-chunk-size 0 innodb-buffer-pool-dump-at-shutdown FALSE innodb-buffer-pool-dump-now FALSE innodb-buffer-pool-dump-pct 100 innodb-buffer-pool-filename (No default value) innodb-buffer-pool-instances 0 innodb-buffer-pool-load-abort FALSE innodb-buffer-pool-load-at-startup FALSE innodb-buffer-pool-load-now FALSE innodb-buffer-pool-populate FALSE innodb-buffer-pool-resizing-timeout 10 innodb-buffer-pool-size 134217728 innodb-buffer-pool-stats ON innodb-change-buffer-max-size 25 innodb-change-buffering all innodb-checksum-algorithm facebook innodb-checksums TRUE innodb-cmp ON innodb-cmp-per-index ON innodb-cmp-per-index-enabled FALSE innodb-cmp-per-index-reset ON innodb-cmp-reset ON innodb-cmpmem ON innodb-cmpmem-reset ON innodb-commit-concurrency 0 innodb-compression-failure-threshold-pct 5 innodb-compression-level 6 innodb-compression-pad-pct-max 50 innodb-concurrency-tickets 5000 innodb-data-file-path (No default value) innodb-data-home-dir (No default value) innodb-deadlock-detect TRUE innodb-defragment TRUE innodb-defragment-fill-factor 0.9 innodb-defragment-fill-factor-n-recs 20 innodb-defragment-frequency 100 innodb-defragment-max-runtime-pct 50 innodb-defragment-n-pages 7 innodb-defragment-pause FALSE innodb-defragment-stats-accuracy 0 innodb-disable-sort-file-cache FALSE innodb-doublewrite 1 innodb-dump-core-without-large-mem-buf TRUE innodb-enable-slave-update-table-stats FALSE innodb-evicted-pages-sampling-ratio 0 innodb-fast-shutdown 1 innodb-file-format Antelope innodb-file-format-check TRUE innodb-file-format-max Antelope innodb-file-io-threads 4 innodb-file-per-table TRUE innodb-file-status ON innodb-flush-log-at-timeout 1 innodb-flush-log-at-trx-commit 0 innodb-flush-method (No default value) innodb-flush-neighbors 1 innodb-flushing-avg-loops 30 innodb-force-index-records-in-range 0 innodb-force-load-corrupted FALSE innodb-force-recovery 0 innodb-fsync-freq 1048576 innodb-ft-aux-table (No default value) innodb-ft-being-deleted ON innodb-ft-cache-size 8000000 innodb-ft-config ON innodb-ft-default-stopword ON innodb-ft-deleted ON innodb-ft-enable-diag-print FALSE innodb-ft-enable-stopword TRUE innodb-ft-index-cache ON innodb-ft-index-table ON innodb-ft-max-token-size 84 innodb-ft-min-token-size 3 innodb-ft-num-word-optimize 2000 innodb-ft-result-cache-limit 2000000000 innodb-ft-server-stopword-table (No default value) innodb-ft-sort-pll-degree 2 innodb-ft-total-cache-size 640000000 innodb-ft-user-stopword-table (No default value) innodb-histogram-step-size-async-read (No default value) innodb-histogram-step-size-async-write (No default value) innodb-histogram-step-size-double-write (No default value) innodb-histogram-step-size-file-flush-time (No default value) innodb-histogram-step-size-fsync (No default value) innodb-histogram-step-size-log-write (No default value) innodb-histogram-step-size-sync-read (No default value) innodb-histogram-step-size-sync-write (No default value) innodb-idle-flush-pct 100 innodb-io-capacity 200 innodb-io-capacity-max 18446744073709551615 innodb-large-prefix FALSE innodb-load-table-thread-num 10 innodb-lock-wait-timeout 50 innodb-lock-waits ON innodb-locks ON innodb-locks-unsafe-for-binlog FALSE innodb-log-buffer-size 16777216 innodb-log-compressed-pages FALSE innodb-log-file-size 50331648 innodb-log-files-in-group 2 innodb-log-group-home-dir (No default value) innodb-lra-n-spaces 3 innodb-lra-pages-before-sleep 1024 innodb-lra-size 0 innodb-lra-sleep 50 innodb-lru-manager-max-sleep-time 1000 innodb-lru-scan-depth 1024 innodb-max-dirty-pages-pct 75 innodb-max-dirty-pages-pct-lwm 0.001 innodb-max-purge-lag 0 innodb-max-purge-lag-delay 0 innodb-metrics ON innodb-mirrored-log-groups 0 innodb-monitor-disable (No default value) innodb-monitor-enable (No default value) innodb-monitor-gaplock-query FALSE innodb-monitor-gaplock-query-filename (No default value) innodb-monitor-gaplock-query-print-verbose FALSE innodb-monitor-reset (No default value) innodb-monitor-reset-all (No default value) innodb-old-blocks-pct 37 innodb-old-blocks-time 1000 innodb-online-alter-log-max-size 134217728 innodb-open-files 0 innodb-optimize-fulltext-only FALSE innodb-page-cleaner-adaptive-sleep FALSE innodb-page-size 16384 innodb-prefix-index-cluster-optimization FALSE innodb-print-all-deadlocks FALSE innodb-purge-batch-size 300 innodb-purge-threads 1 innodb-random-read-ahead FALSE innodb-read-ahead-threshold 56 innodb-read-io-threads 4 innodb-read-only FALSE innodb-recv-ibuf-operations FALSE innodb-replication-delay 0 innodb-rollback-on-timeout FALSE innodb-rollback-segments 128 innodb-segment-reserve-factor 0.01 innodb-simulate-comp-failures 0 innodb-sort-buffer-size 1048576 innodb-spin-wait-delay 6 innodb-stats-auto-recalc TRUE innodb-stats-method nulls_equal innodb-stats-on-metadata FALSE innodb-stats-persistent TRUE innodb-stats-persistent-sample-pages 20 innodb-stats-recalc-threshold 0.1 innodb-stats-sample-pages 8 innodb-stats-transient-sample-pages 8 innodb-status-file FALSE innodb-status-output FALSE innodb-status-output-locks FALSE innodb-strict-mode FALSE innodb-support-xa TRUE innodb-sync-array-size 1 innodb-sync-checkpoint-limit 0 innodb-sync-pool-size 1024 innodb-sync-spin-loops 30 innodb-sys-columns ON innodb-sys-datafiles ON innodb-sys-docstore-fields ON innodb-sys-fields ON innodb-sys-foreign ON innodb-sys-foreign-cols ON innodb-sys-indexes ON innodb-sys-tables ON innodb-sys-tablespaces ON innodb-sys-tablestats ON innodb-table-locks TRUE innodb-thread-concurrency 0 innodb-thread-sleep-delay 10000 innodb-tmpdir (No default value) innodb-trx ON innodb-trx-log-write-block-size 4096 innodb-txlog-init-rate 134217728 innodb-undo-directory . innodb-undo-logs 128 innodb-undo-tablespaces 0 innodb-use-fdatasync FALSE innodb-use-native-aio TRUE innodb-use-sys-malloc TRUE innodb-write-io-threads 4 innodb-zlib-strategy 0 innodb-zlib-wrap FALSE interactive-timeout 28800 join-buffer-size 262144 keep-files-on-create FALSE key-buffer-size 8388608 key-cache-age-threshold 300 key-cache-block-size 1024 key-cache-division-limit 100 language /data/gagarin/opt/builds/production/myrocks-mysql_common-5.6.27.75-jet-4-e34c228/share/mysql/ large-pages FALSE lc-messages en_US lc-messages-dir /data/gagarin/opt/builds/production/myrocks-mysql_common-5.6.27.75-jet-4-e34c228/share/mysql/ lc-time-names en_US legacy-user-name-pattern (No default value) local-infile TRUE lock-wait-timeout 604800 log-bin (No default value) log-bin-index (No default value) log-bin-trust-function-creators FALSE log-bin-use-v1-row-events FALSE log-column-names FALSE log-datagram FALSE log-datagram-usecs 0 log-error log-global-var-changes FALSE log-gtid-unsafe-statements TRUE log-isam myisam.log log-legacy-user FALSE log-only-query-comments TRUE log-output FILE log-queries-not-using-indexes FALSE log-raw FALSE log-short-format FALSE log-slave-updates FALSE log-slow-admin-statements FALSE log-slow-extra FALSE log-slow-slave-statements FALSE log-tc tc.log log-tc-size 24576 log-throttle-queries-not-using-indexes 0 log-warnings 1 long-query-time 10 low-priority-updates FALSE lower-case-table-names 0 master-info-file master.info master-info-repository FILE master-retry-count 86400 master-verify-checksum FALSE max-allowed-packet 4194304 max-binlog-cache-size 18446744073709547520 max-binlog-dump-events 0 max-binlog-size 1073741824 max-binlog-stmt-cache-size 18446744073709547520 max-connect-errors 100 max-connections 151 max-delayed-threads 20 max-digest-length 1024 max-error-count 64 max-heap-table-size 16777216 max-join-size 18446744073709551615 max-length-for-sort-data 1024 max-nonsuper-connections 0 max-prepared-stmt-count 16382 max-relay-log-size 0 max-running-queries 0 max-seeks-for-key 18446744073709551615 max-sort-length 1024 max-sp-recursion-depth 0 max-tmp-tables 32 max-user-connections 0 max-waiting-queries 0 max-write-lock-count 18446744073709551615 memlock FALSE metadata-locks-cache-size 1024 metadata-locks-hash-instances 256 min-examined-row-limit 0 mts-dynamic-rebalance FALSE mts-imbalance-threshold 90 multi-range-count 256 myisam-block-size 1024 myisam-data-pointer-size 6 myisam-max-sort-file-size 9223372036853727232 myisam-mmap-size 18446744073709551615 myisam-recover-options OFF myisam-repair-threads 1 myisam-sort-buffer-size 8388608 myisam-stats-method nulls_unequal myisam-use-mmap FALSE net-buffer-length 16384 net-compression-level 6 net-read-timeout 30 net-retry-count 10 net-write-timeout 60 new FALSE num-conn-handling-threads 1 num-sharded-locks 1 old FALSE old-alter-table FALSE old-passwords 0 old-style-user-limits FALSE open-files-limit 5000 optimizer-prune-level 1 optimizer-search-depth 62 optimizer-switch index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,engine_condition_pushdown=on,index_condition_pushdown=on,mrr=on,mrr_cost_based=on,block_nested_loop=on,batched_key_access=off,materialization=on,semijoin=on,loosescan=on,firstmatch=on,subquery_materialization_cost_based=on,use_index_extensions=on,skip_scan=off,skip_scan_cost_based=on optimizer-trace optimizer-trace-features greedy_search=on,range_optimizer=on,dynamic_range=on,repeated_subselect=on optimizer-trace-limit 1 optimizer-trace-max-mem-size 16384 optimizer-trace-offset -1 part-scan-max 10 partition ON peak-lag-sample-rate 100 peak-lag-time 60 per-user-session-var-default-val (No default value) per-user-session-var-user-name-delimiter (No default value) pid-file /jet/prs/mysqld/data/download.pid plugin-dir /jet/var/mysqld/plugin/ port 3306 port-open-timeout 0 preload-buffer-size 32768 process-can-disable-bin-log TRUE profiling-history-size 15 protocol-mode query-alloc-block-size 8192 query-cache-limit 1048576 query-cache-min-res-unit 4096 query-cache-size 1048576 query-cache-type OFF query-cache-wlock-invalidate FALSE query-prealloc-size 8192 range-alloc-block-size 4096 range-optimizer-max-mem-size 1536000 rbr-idempotent-tables (No default value) read-buffer-size 131072 read-only FALSE read-only-error-msg-extra read-only-slave TRUE read-rnd-buffer-size 262144 relay-log (No default value) relay-log-index (No default value) relay-log-info-file relay-log.info relay-log-info-repository FILE relay-log-purge TRUE relay-log-recovery FALSE relay-log-space-limit 0 replicate-same-server-id FALSE report-host (No default value) report-password (No default value) report-port 0 report-user (No default value) reset-seconds-behind-master TRUE rocksdb ON rocksdb-access-hint-on-compaction-start 1 rocksdb-advise-random-on-open TRUE rocksdb-allow-concurrent-memtable-write FALSE rocksdb-allow-mmap-reads FALSE rocksdb-allow-mmap-writes FALSE rocksdb-background-sync FALSE rocksdb-base-background-compactions 1 rocksdb-block-cache-size 536870912 rocksdb-block-restart-interval 16 rocksdb-block-size 4096 rocksdb-block-size-deviation 10 rocksdb-bulk-load FALSE rocksdb-bulk-load-size 1000 rocksdb-bytes-per-sync 0 rocksdb-cache-index-and-filter-blocks TRUE rocksdb-cf-options ON rocksdb-cfstats ON rocksdb-checksums-pct 100 rocksdb-collect-sst-properties TRUE rocksdb-commit-in-the-middle FALSE rocksdb-compact-cf rocksdb-compaction-readahead-size 0 rocksdb-compaction-sequential-deletes 0 rocksdb-compaction-sequential-deletes-count-sd FALSE rocksdb-compaction-sequential-deletes-file-size 0 rocksdb-compaction-sequential-deletes-window 0 rocksdb-compaction-stats ON rocksdb-create-checkpoint rocksdb-create-if-missing TRUE rocksdb-create-missing-column-families FALSE rocksdb-datadir ./.rocksdb rocksdb-db-write-buffer-size 0 rocksdb-dbstats ON rocksdb-ddl ON rocksdb-deadlock-detect FALSE rocksdb-debug-optimizer-n-rows 0 rocksdb-debug-optimizer-no-zero-cardinality TRUE rocksdb-default-cf-options rocksdb-delete-obsolete-files-period-micros 21600000000 rocksdb-disable-2pc TRUE rocksdb-disabledatasync FALSE rocksdb-enable-bulk-load-api TRUE rocksdb-enable-thread-tracking FALSE rocksdb-enable-write-thread-adaptive-yield FALSE rocksdb-error-if-exists FALSE rocksdb-flush-memtable-on-analyze TRUE rocksdb-force-flush-memtable-now FALSE rocksdb-force-index-records-in-range 0 rocksdb-global-info ON rocksdb-hash-index-allow-collision TRUE rocksdb-index-file-map ON rocksdb-index-type kBinarySearch rocksdb-info-log-level error_level rocksdb-is-fd-close-on-exec TRUE rocksdb-keep-log-file-num 1000 rocksdb-lock-scanned-rows FALSE rocksdb-lock-wait-timeout 1 rocksdb-locks ON rocksdb-log-file-time-to-roll 0 rocksdb-manifest-preallocation-size 4194304 rocksdb-max-background-compactions 1 rocksdb-max-background-flushes 1 rocksdb-max-log-file-size 0 rocksdb-max-manifest-file-size 18446744073709551615 rocksdb-max-open-files -1 rocksdb-max-row-locks 1073741824 rocksdb-max-subcompactions 1 rocksdb-max-total-wal-size 0 rocksdb-merge-buf-size 67108864 rocksdb-merge-combine-read-size 1073741824 rocksdb-new-table-reader-for-compaction-inputs FALSE rocksdb-no-block-cache FALSE rocksdb-override-cf-options rocksdb-paranoid-checks TRUE rocksdb-pause-background-work FALSE rocksdb-perf-context ON rocksdb-perf-context-global ON rocksdb-perf-context-level 0 rocksdb-persistent-cache-path rocksdb-persistent-cache-size 0 rocksdb-pin-l0-filter-and-index-blocks-in-cache TRUE rocksdb-print-snapshot-conflict-queries FALSE rocksdb-rate-limiter-bytes-per-sec 0 rocksdb-read-free-rpl-tables rocksdb-records-in-range 0 rocksdb-rpl-skip-tx-api FALSE rocksdb-seconds-between-stat-computes 3600 rocksdb-signal-drop-index-thread FALSE rocksdb-skip-bloom-filter-on-read FALSE rocksdb-skip-fill-cache FALSE rocksdb-skip-unique-check-tables .* rocksdb-stats-dump-period-sec 600 rocksdb-store-row-debug-checksums FALSE rocksdb-strict-collation-check FALSE rocksdb-strict-collation-exceptions rocksdb-table-cache-numshardbits 6 rocksdb-table-stats-sampling-pct 10 rocksdb-tmpdir rocksdb-trace-sst-api FALSE rocksdb-trx ON rocksdb-unsafe-for-binlog FALSE rocksdb-use-adaptive-mutex FALSE rocksdb-use-direct-reads FALSE rocksdb-use-direct-writes FALSE rocksdb-use-fsync FALSE rocksdb-validate-tables 1 rocksdb-verify-row-debug-checksums FALSE rocksdb-wal-bytes-per-sync 0 rocksdb-wal-dir rocksdb-wal-recovery-mode 2 rocksdb-wal-size-limit-mb 0 rocksdb-wal-ttl-seconds 0 rocksdb-whole-key-filtering TRUE rocksdb-write-disable-wal FALSE rocksdb-write-ignore-missing-column-families FALSE rocksdb-write-sync FALSE rpl-event-buffer-size 1048576 rpl-read-size 8192 rpl-receive-buffer-size 2097152 rpl-semi-sync-master ON rpl-semi-sync-master-enabled FALSE rpl-semi-sync-master-histogram-trx-wait-step-size 500us rpl-semi-sync-master-timeout 10000 rpl-semi-sync-master-trace-level 32 rpl-semi-sync-master-wait-no-slave TRUE rpl-semi-sync-slave ON rpl-semi-sync-slave-enabled FALSE rpl-semi-sync-slave-trace-level 32 rpl-send-buffer-size 2097152 rpl-stop-slave-timeout 604800 safe-user-create FALSE secure-auth TRUE secure-file-priv (No default value) select-into-file-fsync-size 0 select-into-file-fsync-timeout 0 send-error-before-closing-timed-out-connection TRUE separate-conn-handling-thread FALSE server-id 0 server-id-bits 32 session-track-gtids OFF sha256-password-private-key-path private_key.pem sha256-password-public-key-path public_key.pem show-old-temporals FALSE show-slave-auth-info FALSE simplified-binlog-gtid-recovery FALSE skip-grant-tables FALSE skip-name-resolve FALSE skip-networking FALSE skip-show-database FALSE skip-slave-start FALSE slave-allow-batching FALSE slave-checkpoint-group 512 slave-checkpoint-period 300 slave-compressed-protocol FALSE slave-exec-mode STRICT slave-gtid-info ON slave-load-tmpdir /jet/tmp/mysqld slave-max-allowed-packet 1073741824 slave-net-timeout 3600 slave-parallel-workers 0 slave-pending-jobs-size-max 16777216 slave-rows-search-algorithms TABLE_SCAN,INDEX_SCAN slave-run-triggers-for-rbr NO slave-skip-errors (No default value) slave-sql-verify-checksum TRUE slave-transaction-retries 10 slave-type-conversions slave-use-idempotent-for-recovery NO slow-launch-time 2 slow-log-if-rows-examined-exceed 0 slow-query-log FALSE slow-query-log-file /jet/log/mysqld/slow.log socket /jet/run/mysqld/mysql.sock socket-umask 0 sort-buffer-size 262144 sporadic-binlog-dump-fail FALSE sql-log-bin-triggers TRUE sql-mode ssl FALSE ssl-ca (No default value) ssl-capath (No default value) ssl-cert (No default value) ssl-cipher (No default value) ssl-crl (No default value) ssl-crlpath (No default value) ssl-key (No default value) stored-program-cache 256 super-large-pages FALSE super-read-only FALSE symbolic-links FALSE sync-binlog 0 sync-frm TRUE sync-master-info 10000 sync-relay-log 10000 sync-relay-log-info 10000 sysdate-is-now FALSE table-definition-cache 1400 table-open-cache 2000 table-open-cache-instances 8 tc-heuristic-recover COMMIT temp-pool TRUE thread-cache-size 9 thread-concurrency 10 thread-handling one-thread-per-connection thread-stack 327680 time-format %H:%i:%s timed-mutexes FALSE tmp-table-max-file-size 0 tmp-table-rpl-max-file-size 0 tmp-table-size 16777216 tmpdir /jet/tmp/mysqld transaction-alloc-block-size 8192 transaction-isolation REPEATABLE-READ transaction-prealloc-size 4096 transaction-read-only FALSE unique-check-lag-reset-threshold 2 unique-check-lag-threshold 0 updatable-views-with-limit YES use-db-uuid FALSE use-fbson-input-format FALSE use-fbson-output-format FALSE use-lock-sharding FALSE validate-user-plugins TRUE verbose TRUE wait-timeout 28800 working-duration 3600 write-query-throttling-limit 0 To see what values a running MySQL server is using, type 'mysqladmin variables' instead of 'mysqld --verbose --help'.