Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- allow-suspicious-udfs FALSE
- archive ON
- aria ON
- aria-block-size 8192
- aria-checkpoint-interval 30
- aria-checkpoint-log-activity 1048576
- aria-force-start-after-recovery-failures 0
- aria-group-commit none
- aria-group-commit-interval 0
- aria-log-dir-path /var/lib/mysql/
- aria-log-file-size 1073741824
- aria-log-purge-type immediate
- aria-max-sort-file-size 9223372036853727232
- aria-page-checksum TRUE
- aria-pagecache-age-threshold 300
- aria-pagecache-buffer-size 134217728
- aria-pagecache-division-limit 100
- aria-recover NORMAL
- aria-repair-threads 1
- aria-sort-buffer-size 134217728
- aria-stats-method nulls_unequal
- aria-sync-log-dir NEWFILE
- auto-increment-increment 1
- auto-increment-offset 1
- autocommit TRUE
- automatic-sp-privileges TRUE
- back-log 50
- basedir /usr/
- big-tables FALSE
- bind-address ::ffff:127.0.0.1
- binlog-annotate-row-events FALSE
- binlog-cache-size 32768
- binlog-checksum NONE
- binlog-direct-non-transactional-updates FALSE
- binlog-format STATEMENT
- binlog-optimize-thread-scheduling TRUE
- binlog-row-event-max-size 1024
- binlog-stmt-cache-size 32768
- blackhole ON
- bulk-insert-buffer-size 8388608
- character-set-client-handshake TRUE
- character-set-filesystem binary
- character-set-server latin1
- character-sets-dir /usr/share/mysql/charsets/
- chroot (No default value)
- collation-server latin1_swedish_ci
- completion-type NO_CHAIN
- concurrent-insert AUTO
- connect-timeout 10
- console FALSE
- datadir /var/lib/mysql/
- date-format %Y-%m-%d
- datetime-format %Y-%m-%d %H:%i:%s
- deadlock-search-depth-long 15
- deadlock-search-depth-short 4
- deadlock-timeout-long 50000000
- deadlock-timeout-short 10000
- debug disabled
- debug-abort-slave-event-count 0
- debug-disconnect-slave-event-count 0
- debug-gdb FALSE
- debug-max-binlog-dump-events 0
- debug-no-sync FALSE
- debug-no-thread-alarm FALSE
- debug-sporadic-binlog-dump-fail FALSE
- default-storage-engine InnoDB
- default-time-zone (No default value)
- 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)
- div-precision-increment 4
- engine-condition-pushdown FALSE
- event-scheduler OFF
- expensive-subquery-limit 100
- expire-logs-days 0
- external-locking FALSE
- extra-max-connections 1
- extra-port 0
- federated ON
- feedback ON
- feedback-http-proxy (No default value)
- feedback-send-retry-wait 60
- feedback-send-timeout 60
- feedback-url https://mariadb.org/feedback_plugin/post
- feedback-user-info
- 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)
- gdb FALSE
- general-log FALSE
- general-log-file mysql.log
- group-concat-max-len 1024
- help TRUE
- ignore-builtin-innodb FALSE
- ignore-db-dirs
- init-connect
- init-file (No default value)
- init-rpl-role MASTER
- init-slave
- innodb ON
- innodb-adaptive-flushing TRUE
- innodb-adaptive-flushing-method estimate
- innodb-adaptive-hash-index TRUE
- innodb-adaptive-hash-index-partitions 1
- innodb-additional-mem-pool-size 8388608
- innodb-autoextend-increment 8
- innodb-autoinc-lock-mode 1
- innodb-blocking-buffer-pool-restore FALSE
- innodb-buffer-page ON
- innodb-buffer-page-lru ON
- innodb-buffer-pool-instances 1
- innodb-buffer-pool-pages ON
- innodb-buffer-pool-pages-blob ON
- innodb-buffer-pool-pages-index ON
- innodb-buffer-pool-populate FALSE
- innodb-buffer-pool-restore-at-startup 0
- innodb-buffer-pool-shm-checksum TRUE
- innodb-buffer-pool-shm-key 0
- innodb-buffer-pool-size 134217728
- innodb-buffer-pool-stats ON
- innodb-change-buffering all
- innodb-changed-pages ON
- innodb-checkpoint-age-target 0
- innodb-checksums TRUE
- innodb-cmp ON
- innodb-cmp-reset ON
- innodb-cmpmem ON
- innodb-cmpmem-reset ON
- innodb-commit-concurrency 0
- innodb-concurrency-tickets 500
- innodb-corrupt-table-action assert
- innodb-data-file-path (No default value)
- innodb-data-home-dir (No default value)
- innodb-dict-size-limit 0
- innodb-doublewrite TRUE
- innodb-doublewrite-file (No default value)
- innodb-fake-changes FALSE
- innodb-fast-checksum FALSE
- 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 FALSE
- innodb-flush-log-at-trx-commit 1
- innodb-flush-method (No default value)
- innodb-flush-neighbor-pages area
- innodb-force-load-corrupted FALSE
- innodb-force-recovery 0
- innodb-ibuf-accel-rate 100
- innodb-ibuf-active-contract 1
- innodb-ibuf-max-size 9223372036854775807
- innodb-import-table-from-xtrabackup 0
- innodb-index-stats ON
- innodb-io-capacity 200
- innodb-kill-idle-transaction 0
- innodb-large-prefix FALSE
- innodb-lazy-drop-table 0
- innodb-lock-wait-timeout 50
- innodb-lock-waits ON
- innodb-locking-fake-changes TRUE
- innodb-locks ON
- innodb-locks-unsafe-for-binlog FALSE
- innodb-log-block-size 512
- innodb-log-buffer-size 8388608
- innodb-log-file-size 5242880
- innodb-log-files-in-group 2
- innodb-log-group-home-dir (No default value)
- innodb-max-bitmap-file-size 104857600
- innodb-max-changed-pages 1000000
- innodb-max-dirty-pages-pct 75
- innodb-max-purge-lag 0
- innodb-merge-sort-block-size 1048576
- innodb-mirrored-log-groups 1
- innodb-old-blocks-pct 37
- innodb-old-blocks-time 0
- innodb-open-files 300
- innodb-page-size 16384
- innodb-print-all-deadlocks FALSE
- innodb-purge-batch-size 20
- innodb-purge-threads 1
- innodb-random-read-ahead FALSE
- innodb-read-ahead linear
- innodb-read-ahead-threshold 56
- innodb-read-io-threads 4
- innodb-recovery-stats FALSE
- innodb-recovery-update-relay-log FALSE
- innodb-replication-delay 0
- innodb-rollback-on-timeout FALSE
- innodb-rollback-segments 128
- innodb-rseg ON
- innodb-show-locks-held 10
- innodb-show-verbose-locks 0
- innodb-simulate-comp-failures 0
- innodb-spin-wait-delay 6
- innodb-stats-auto-update 1
- innodb-stats-method nulls_equal
- innodb-stats-modified-counter 0
- innodb-stats-on-metadata TRUE
- innodb-stats-sample-pages 8
- innodb-stats-traditional TRUE
- innodb-stats-update-need-lock 1
- innodb-status-file FALSE
- innodb-strict-mode FALSE
- innodb-support-xa TRUE
- innodb-sync-spin-loops 30
- innodb-sys-columns ON
- innodb-sys-fields ON
- innodb-sys-foreign ON
- innodb-sys-foreign-cols ON
- innodb-sys-indexes ON
- innodb-sys-stats ON
- innodb-sys-tables ON
- innodb-sys-tablestats ON
- innodb-table-locks TRUE
- innodb-table-stats ON
- innodb-thread-concurrency 0
- innodb-thread-concurrency-timer-based FALSE
- innodb-thread-sleep-delay 10000
- innodb-track-changed-pages FALSE
- innodb-trx ON
- innodb-undo-logs ON
- innodb-use-atomic-writes FALSE
- innodb-use-fallocate FALSE
- innodb-use-global-flush-log-at-trx-commit TRUE
- innodb-use-native-aio TRUE
- innodb-use-stacktrace FALSE
- innodb-use-sys-malloc TRUE
- innodb-use-sys-stats-table FALSE
- innodb-write-io-threads 4
- interactive-timeout 28800
- join-buffer-size 131072
- join-buffer-space-limit 2097152
- join-cache-level 2
- keep-files-on-create FALSE
- key-buffer-size 4294967296
- key-cache-age-threshold 300
- key-cache-block-size 1024
- key-cache-division-limit 100
- key-cache-segments 0
- large-pages FALSE
- lc-messages en_US
- lc-messages-dir (No default value)
- lc-time-names en_US
- local-infile FALSE
- lock-wait-timeout 31536000
- log mysql.log
- log-basename DELETED
- log-bin (No default value)
- log-bin-index (No default value)
- log-bin-trust-function-creators FALSE
- log-error
- log-isam myisam.log
- log-output FILE
- log-queries-not-using-indexes FALSE
- log-short-format FALSE
- log-slave-updates FALSE
- log-slow-admin-statements FALSE
- log-slow-filter admin,filesort,filesort_on_disk,full_join,full_scan,query_cache,query_cache_miss,tmp_table,tmp_table_on_disk
- log-slow-queries slow.log
- log-slow-rate-limit 1
- log-slow-slave-statements FALSE
- log-slow-verbosity
- log-tc tc.log
- log-tc-size 24576
- log-warnings 1
- long-query-time 10
- low-priority-updates FALSE
- lower-case-table-names 0
- master-info-file master.info
- master-retry-count 86400
- master-verify-checksum FALSE
- max-allowed-packet 1048576
- max-binlog-cache-size 18446744073709547520
- max-binlog-size 1073741824
- max-binlog-stmt-cache-size 18446744073709547520
- max-connect-errors 10
- max-connections 151
- max-delayed-threads 20
- max-error-count 64
- max-heap-table-size 16777216
- max-join-size 18446744073709551615
- max-length-for-sort-data 1024
- max-long-data-size 1048576
- max-prepared-stmt-count 16382
- max-relay-log-size 0
- max-seeks-for-key 4294967295
- max-sort-length 1024
- max-sp-recursion-depth 0
- max-tmp-tables 32
- max-user-connections 0
- max-write-lock-count 4294967295
- memlock FALSE
- metadata-locks-cache-size 1024
- min-examined-row-limit 0
- mrr-buffer-size 262144
- 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 DEFAULT
- myisam-repair-threads 1
- myisam-sort-buffer-size 8388608
- myisam-stats-method nulls_unequal
- myisam-use-mmap FALSE
- net-buffer-length 16384
- net-read-timeout 30
- net-retry-count 10
- net-write-timeout 60
- old FALSE
- old-alter-table FALSE
- old-mode
- old-passwords FALSE
- old-style-user-limits FALSE
- open-files-limit 962
- 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,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=off,table_elimination=on
- partition ON
- performance-schema FALSE
- performance-schema-events-waits-history-long-size 10000
- performance-schema-events-waits-history-size 10
- performance-schema-max-cond-classes 80
- performance-schema-max-cond-instances 1000
- performance-schema-max-file-classes 50
- performance-schema-max-file-handles 32768
- performance-schema-max-file-instances 10000
- performance-schema-max-mutex-classes 200
- performance-schema-max-mutex-instances 1000000
- performance-schema-max-rwlock-classes 30
- performance-schema-max-rwlock-instances 1000000
- performance-schema-max-table-handles 100000
- performance-schema-max-table-instances 50000
- performance-schema-max-thread-classes 50
- performance-schema-max-thread-instances 1000
- pid-file /var/lib/mysql/mysql.pid
- plugin-dir /usr/lib64/mysql/plugin/
- plugin-load (No default value)
- plugin-maturity unknown
- port 3306
- port-open-timeout 0
- preload-buffer-size 32768
- profiling-history-size 15
- progress-report-time 5
- query-alloc-block-size 8192
- query-cache-limit 1048576
- query-cache-min-res-unit 4096
- query-cache-size 0
- query-cache-strip-comments FALSE
- query-cache-type ON
- query-cache-wlock-invalidate FALSE
- query-prealloc-size 8192
- range-alloc-block-size 4096
- read-buffer-size 131072
- read-only FALSE
- 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-purge TRUE
- relay-log-recovery FALSE
- relay-log-space-limit 0
- replicate-annotate-row-events FALSE
- replicate-events-marked-for-skip replicate
- replicate-same-server-id FALSE
- report-host (No default value)
- report-password (No default value)
- report-port 0
- report-user (No default value)
- rowid-merge-buff-size 8388608
- rpl-recovery-rank 0
- safe-user-create FALSE
- secure-auth FALSE
- secure-file-priv (No default value)
- server-id 0
- show-slave-auth-info FALSE
- skip-grant-tables FALSE
- skip-name-resolve FALSE
- skip-networking FALSE
- skip-show-database FALSE
- skip-slave-start FALSE
- slave-compressed-protocol FALSE
- slave-exec-mode STRICT
- slave-load-tmpdir /var/tmp
- slave-max-allowed-packet 1073741824
- slave-net-timeout 3600
- slave-skip-errors (No default value)
- slave-sql-verify-checksum TRUE
- slave-transaction-retries 10
- slave-type-conversions
- slow-launch-time 2
- slow-query-log FALSE
- slow-query-log-file slow.log
- socket /var/lib/mysql/mysql.sock
- sort-buffer-size 2097152
- 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-key (No default value)
- stack-trace TRUE
- stored-program-cache 256
- super-large-pages FALSE
- symbolic-links FALSE
- sync-binlog 0
- sync-frm TRUE
- sync-master-info 0
- sync-relay-log 0
- sync-relay-log-info 0
- sysdate-is-now FALSE
- table-cache 400
- table-definition-cache 400
- table-open-cache 400
- tc-heuristic-recover OFF
- temp-pool TRUE
- thread-cache-size 0
- thread-concurrency 10
- thread-handling one-thread-per-connection
- thread-pool-idle-timeout 60
- thread-pool-max-threads 500
- thread-pool-oversubscribe 3
- thread-pool-size 2
- thread-pool-stall-limit 500
- thread-stack 294912
- time-format %H:%i:%s
- timed-mutexes FALSE
- tmp-table-size 16777216
- tmpdir /var/tmp
- transaction-alloc-block-size 8192
- transaction-isolation REPEATABLE-READ
- transaction-prealloc-size 4096
- updatable-views-with-limit YES
- userstat FALSE
- verbose TRUE
- wait-timeout 28800
- xtradb-admin-command ON
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement