Texte vergleichen

Finden Sie den Unterschied zwischen zwei Textdateien

Real-time diff

Unified diff

Collapse lines

Highlight change

Syntax highlighting

Onlinewerkzeuge

Diffchecker Desktop The most secure way to run Diffchecker. Get the Diffchecker Desktop app: your diffs never leave your computer!Get Desktop

my.cnf

Created 4 years agoDiff never expires

371 lines

allow-suspicious-udfs FALSE

alter-algorithm DEFAULT

analyze-sample-percentage 100

aria-block-size 8192

aria-checkpoint-interval 0

aria-checkpoint-log-activity 1048576

aria-encrypt-tables FALSE

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-pagecache-file-hash-size 512

aria-recover-options

aria-repair-threads 1

aria-sort-buffer-size 268434432

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 110

back-log 70

basedir /usr

big-tables FALSE

bind-address 127.0.0.1

bind-address (No default value)

binlog-annotate-row-events TRUE

binlog-cache-size 32768

binlog-checksum CRC32

binlog-commit-wait-count 0

binlog-commit-wait-usec 100000

binlog-direct-non-transactional-updates FALSE

binlog-file-cache-size 16384

binlog-format MIXED

binlog-optimize-thread-scheduling TRUE

binlog-row-event-max-size 8192

binlog-row-image FULL

binlog-row-metadata NO_LOG

binlog-stmt-cache-size 32768

bulk-insert-buffer-size 8388608

bulk-insert-buffer-size 16777216

character-set-client-handshake TRUE

character-set-filesystem binary

character-set-server utf8mb4

character-sets-dir /usr/share/mysql/charsets/

chroot (No default value)

collation-server utf8mb4_general_ci

column-compression-threshold 100

column-compression-zlib-level 6

column-compression-zlib-strategy DEFAULT_STRATEGY

column-compression-zlib-wrap FALSE

completion-type NO_CHAIN

concurrent-insert AUTO

concurrent-insert ALWAYS

connect-timeout 10

connect-timeout 5

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

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-password-lifetime 0

default-regex-flags

default-storage-engine InnoDB

default-time-zone (No default value)

default-tmp-storage-engine (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)

disconnect-on-expired-password FALSE

div-precision-increment 4

encrypt-binlog FALSE

encrypt-tmp-disk-tables FALSE

encrypt-tmp-files FALSE

enforce-storage-engine (No default value)

eq-range-index-dive-limit 200

event-scheduler OFF

expensive-subquery-limit 100

expire-logs-days 10

explicit-defaults-for-timestamp FALSE

external-locking FALSE

extra-max-connections 1

extra-port 0

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

flashback FALSE

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 eco-portal.log

general-log-file de35b2c2796f.log

getopt-prefix-matching TRUE

group-concat-max-len 1048576

gtid-cleanup-batch-size 64

gtid-domain-id 0

gtid-ignore-duplicates FALSE

gtid-pos-auto-engines

gtid-strict-mode FALSE

help TRUE

histogram-size 254

histogram-type DOUBLE_PREC_HB

host-cache-size 428

host-cache-size 228

idle-readonly-transaction-timeout 0

idle-transaction-timeout 0

idle-write-transaction-timeout 0

ignore-builtin-innodb FALSE

ignore-db-dirs

in-predicate-conversion-threshold 1000

init-connect

init-file (No default value)

init-rpl-role MASTER

init-slave

innodb ON

innodb-adaptive-flushing TRUE

innodb-adaptive-flushing-lwm 10

innodb-adaptive-hash-index FALSE

innodb-adaptive-hash-index-parts 8

innodb-adaptive-max-sleep-delay 0

innodb-autoextend-increment 64

innodb-autoinc-lock-mode 1

innodb-background-scrub-data-check-interval 0

innodb-background-scrub-data-compressed FALSE

innodb-background-scrub-data-interval 0

innodb-background-scrub-data-uncompressed FALSE

innodb-buf-dump-status-frequency 0

innodb-buffer-page ON

innodb-buffer-page-lru ON

innodb-buffer-pool-chunk-size 134217728

innodb-buffer-pool-dump-at-shutdown TRUE

innodb-buffer-pool-dump-now FALSE

innodb-buffer-pool-dump-pct 25

innodb-buffer-pool-filename ib_buffer_pool

innodb-buffer-pool-instances 8

innodb-buffer-pool-instances 0

innodb-buffer-pool-load-abort FALSE

innodb-buffer-pool-load-at-startup TRUE

innodb-buffer-pool-load-now FALSE

innodb-buffer-pool-size 17179869184

innodb-buffer-pool-size 268435456

innodb-buffer-pool-stats ON

innodb-change-buffer-max-size 25

innodb-change-buffering all

innodb-checksum-algorithm full_crc32

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

innodb-compression-default FALSE

innodb-compression-failure-threshold-pct 5

innodb-compression-level 6

innodb-compression-pad-pct-max 50

innodb-concurrency-tickets 0

innodb-data-file-path ibdata1:12M:autoextend

innodb-data-home-dir (No default value)

innodb-deadlock-detect TRUE

innodb-default-encryption-key-id 1

innodb-default-row-format dynamic

innodb-defragment FALSE

innodb-defragment-fill-factor 0.9

innodb-defragment-fill-factor-n-recs 20

innodb-defragment-frequency 40

innodb-defragment-n-pages 7

innodb-defragment-stats-accuracy 0

innodb-disable-sort-file-cache FALSE

innodb-doublewrite TRUE

innodb-encrypt-log FALSE

innodb-encrypt-tables OFF

innodb-encrypt-temporary-tables FALSE

innodb-encryption-rotate-key-age 1

innodb-encryption-rotation-iops 100

innodb-encryption-threads 0

innodb-fast-shutdown 1

innodb-fatal-semaphore-wait-threshold 600

innodb-file-format (No default value)

innodb-file-per-table TRUE

innodb-fill-factor 100

innodb-flush-log-at-timeout 1

innodb-flush-log-at-trx-commit 1

innodb-flush-method fsync

innodb-flush-method O_DIRECT

innodb-flush-neighbors 1

innodb-flush-sync TRUE

innodb-flushing-avg-loops 30

innodb-force-load-corrupted FALSE

innodb-force-primary-key FALSE

innodb-force-recovery 0

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-immediate-scrub-data-uncompressed FALSE

innodb-instant-alter-column-allowed add_drop_reorder

innodb-io-capacity 400

innodb-io-capacity-max 18446744073709551615

innodb-large-prefix (No default value)

innodb-lock-schedule-algorithm fcfs

innodb-lock-wait-timeout 50

innodb-lock-waits ON

innodb-locks ON

innodb-log-buffer-size 16777216

innodb-log-buffer-size 8388608

innodb-log-checksums TRUE

innodb-log-compressed-pages TRUE

innodb-log-file-size 4294967296

innodb-log-file-size 100663296

innodb-log-files-in-group 1

innodb-log-group-home-dir (No default value)

innodb-log-optimize-ddl FALSE

innodb-log-write-ahead-size 8192

innodb-lru-flush-size 32

innodb-lru-scan-depth 1536

innodb-max-dirty-pages-pct 90

innodb-max-dirty-pages-pct-lwm 0

innodb-max-purge-lag 0

innodb-max-purge-lag-delay 0

innodb-max-purge-lag-wait 4294967295

innodb-max-undo-log-size 10485760

innodb-metrics ON

innodb-monitor-disable (No default value)

innodb-monitor-enable (No default value)

innodb-monitor-reset (No default value)

innodb-monitor-reset-all (No default value)

innodb-mutexes ON

innodb-old-blocks-pct 37

innodb-old-blocks-time 1000

innodb-online-alter-log-max-size 134217728

innodb-open-files 400

innodb-optimize-fulltext-only FALSE

innodb-page-cleaners 0

innodb-page-size 16384

innodb-prefix-index-cluster-optimization FALSE

innodb-print-all-deadlocks FALSE

innodb-purge-batch-size 300

innodb-purge-rseg-truncate-frequency 128

innodb-purge-threads 4

innodb-random-read-ahead FALSE

innodb-read-ahead-threshold 56

innodb-read-io-threads 4

innodb-read-only FALSE

innodb-replication-delay 0

innodb-rollback-on-timeout FALSE

innodb-scrub-log FALSE

innodb-scrub-log-speed 256

innodb-sort-buffer-size 1048576

innodb-spin-wait-delay 4

innodb-stats-auto-recalc TRUE

innodb-stats-include-delete-marked FALSE

innodb-stats-method nulls_equal

innodb-stats-modified-counter 0

innodb-stats-on-metadata FALSE

innodb-stats-persistent TRUE

innodb-stats-persistent-sample-pages 20

innodb-stats-traditional TRUE

innodb-stats-transient-sample-pages 8

innodb-status-file FALSE

innodb-status-output FALSE

innodb-status-output-locks FALSE

innodb-strict-mode TRUE

innodb-sync-array-size 1

innodb-sync-spin-loops 30

innodb-sys-columns ON

innodb-sys-datafiles ON

innodb-sys-fields ON

innodb-sys-foreign ON

innodb-sys-foreign-cols ON

innodb-sys-indexes ON

innodb-sys-semaphore-waits ON

innodb-sys-tables ON

innodb-sys-tablespaces ON

innodb-sys-tablestats ON

innodb-sys-virtual ON

innodb-table-locks TRUE

innodb-tablespaces-encryption ON

innodb-temp-data-file-path ibtmp1:12M:autoextend

innodb-thread-concurrency 0

innodb-thread-sleep-delay 0

innodb-tmpdir (No default value)

innodb-trx ON

innodb-undo-directory (No default value)

innodb-undo-log-truncate FALSE

innodb-undo-logs 128

innodb-undo-tablespaces 0

innodb-use-atomic-writes TRUE

innodb-use-native-aio TRUE

innodb-write-io-threads 4

interactive-timeout 500

interactive-timeout 28800

join-buffer-size 4194304

join-buffer-size 262144

join-buffer-space-limit 2097152

join-cache-level 2

keep-files-on-create FALSE

key-buffer-size 134217728

key-cache-age-threshold 300

key-cache-block-size 1024

key-cache-division-limit 100

key-cache-file-hash-size 512

key-cache-segments 0

large-files-support TRUE

large-pages FALSE

lc-messages en_US

lc-messages-dir /usr/share/mysql

lc-time-names en_US

local-infile TRUE

lock-wait-timeout 86400

log-basename eco-portal

log-basename de35b2c2796f

log-bin 0

log-bin (No default value)

log-bin-compress FALSE

log-bin-compress-min-len 256

log-bin-index (No default value)

log-bin-trust-function-creators FALSE

log-disabled-statements sp

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 TRUE

log-slow-disabled-statements sp

log-slow-filter admin,filesort,filesort_on_disk,filesort_priority_queue,full_join,full_scan,query_cache,query_cache_miss,tmp_table,tmp_table_on_disk

log-slow-rate-limit 1

log-slow-slave-statements TRUE

log-slow-verbosity

log-tc tc.log

log-tc-size 24576

log-warnings 2

long-query-time 10

low-priority-updates FALSE

lower-case-file-system FALSE

lower-case-table-names 0

master-info-file master.info

master-retry-count

master-retr

Gespeicherten Diffs

Original text

Datei öffnen

allow-suspicious-udfs                                        FALSE
alter-algorithm                                              DEFAULT
analyze-sample-percentage                                    100
aria-block-size                                              8192
aria-checkpoint-interval                                     0
aria-checkpoint-log-activity                                 1048576
aria-encrypt-tables                                          FALSE
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-pagecache-file-hash-size                                512
aria-recover-options                                         
aria-repair-threads                                          1
aria-sort-buffer-size                                        268434432
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                                                     110
basedir                                                      /usr
big-tables                                                   FALSE
bind-address                                                 127.0.0.1
binlog-annotate-row-events                                   TRUE
binlog-cache-size                                            32768
binlog-checksum                                              CRC32
binlog-commit-wait-count                                     0
binlog-commit-wait-usec                                      100000
binlog-direct-non-transactional-updates                      FALSE
binlog-file-cache-size                                       16384
binlog-format                                                MIXED
binlog-optimize-thread-scheduling                            TRUE
binlog-row-event-max-size                                    8192
binlog-row-image                                             FULL
binlog-row-metadata                                          NO_LOG
binlog-stmt-cache-size                                       32768
bulk-insert-buffer-size                                      8388608
character-set-client-handshake                               TRUE
character-set-filesystem                                     binary
character-set-server                                         utf8mb4
character-sets-dir                                           /usr/share/mysql/charsets/
chroot                                                       (No default value)
collation-server                                             utf8mb4_general_ci
column-compression-threshold                                 100
column-compression-zlib-level                                6
column-compression-zlib-strategy                             DEFAULT_STRATEGY
column-compression-zlib-wrap                                 FALSE
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                                                        
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-password-lifetime                                    0
default-regex-flags                                          
default-storage-engine                                       InnoDB
default-time-zone                                            (No default value)
default-tmp-storage-engine                                   (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)
disconnect-on-expired-password                               FALSE
div-precision-increment                                      4
encrypt-binlog                                               FALSE
encrypt-tmp-disk-tables                                      FALSE
encrypt-tmp-files                                            FALSE
enforce-storage-engine                                       (No default value)
eq-range-index-dive-limit                                    200
event-scheduler                                              OFF
expensive-subquery-limit                                     100
expire-logs-days                                             10
explicit-defaults-for-timestamp                              FALSE
external-locking                                             FALSE
extra-max-connections                                        1
extra-port                                                   0
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                                           
flashback                                                    FALSE
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                                             eco-portal.log
getopt-prefix-matching                                       TRUE
group-concat-max-len                                         1048576
gtid-cleanup-batch-size                                      64
gtid-domain-id                                               0
gtid-ignore-duplicates                                       FALSE
gtid-pos-auto-engines                                        
gtid-strict-mode                                             FALSE
help                                                         TRUE
histogram-size                                               254
histogram-type                                               DOUBLE_PREC_HB
host-cache-size                                              428
idle-readonly-transaction-timeout                            0
idle-transaction-timeout                                     0
idle-write-transaction-timeout                               0
ignore-builtin-innodb                                        FALSE
ignore-db-dirs                                               
in-predicate-conversion-threshold                            1000
init-connect                                                 
init-file                                                    (No default value)
init-rpl-role                                                MASTER
init-slave                                                   
innodb                                                       ON
innodb-adaptive-flushing                                     TRUE
innodb-adaptive-flushing-lwm                                 10
innodb-adaptive-hash-index                                   FALSE
innodb-adaptive-hash-index-parts                             8
innodb-adaptive-max-sleep-delay                              0
innodb-autoextend-increment                                  64
innodb-autoinc-lock-mode                                     1
innodb-background-scrub-data-check-interval                  0
innodb-background-scrub-data-compressed                      FALSE
innodb-background-scrub-data-interval                        0
innodb-background-scrub-data-uncompressed                    FALSE
innodb-buf-dump-status-frequency                             0
innodb-buffer-page                                           ON
innodb-buffer-page-lru                                       ON
innodb-buffer-pool-chunk-size                                134217728
innodb-buffer-pool-dump-at-shutdown                          TRUE
innodb-buffer-pool-dump-now                                  FALSE
innodb-buffer-pool-dump-pct                                  25
innodb-buffer-pool-filename                                  ib_buffer_pool
innodb-buffer-pool-instances                                 8
innodb-buffer-pool-load-abort                                FALSE
innodb-buffer-pool-load-at-startup                           TRUE
innodb-buffer-pool-load-now                                  FALSE
innodb-buffer-pool-size                                      17179869184
innodb-buffer-pool-stats                                     ON
innodb-change-buffer-max-size                                25
innodb-change-buffering                                      all
innodb-checksum-algorithm                                    full_crc32
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-algorithm                                 zlib
innodb-compression-default                                   FALSE
innodb-compression-failure-threshold-pct                     5
innodb-compression-level                                     6
innodb-compression-pad-pct-max                               50
innodb-concurrency-tickets                                   0
innodb-data-file-path                                        ibdata1:12M:autoextend
innodb-data-home-dir                                         (No default value)
innodb-deadlock-detect                                       TRUE
innodb-default-encryption-key-id                             1
innodb-default-row-format                                    dynamic
innodb-defragment                                            FALSE
innodb-defragment-fill-factor                                0.9
innodb-defragment-fill-factor-n-recs                         20
innodb-defragment-frequency                                  40
innodb-defragment-n-pages                                    7
innodb-defragment-stats-accuracy                             0
innodb-disable-sort-file-cache                               FALSE
innodb-doublewrite                                           TRUE
innodb-encrypt-log                                           FALSE
innodb-encrypt-tables                                        OFF
innodb-encrypt-temporary-tables                              FALSE
innodb-encryption-rotate-key-age                             1
innodb-encryption-rotation-iops                              100
innodb-encryption-threads                                    0
innodb-fast-shutdown                                         1
innodb-fatal-semaphore-wait-threshold                        600
innodb-file-format                                           (No default value)
innodb-file-per-table                                        TRUE
innodb-fill-factor                                           100
innodb-flush-log-at-timeout                                  1
innodb-flush-log-at-trx-commit                               1
innodb-flush-method                                          fsync
innodb-flush-neighbors                                       1
innodb-flush-sync                                            TRUE
innodb-flushing-avg-loops                                    30
innodb-force-load-corrupted                                  FALSE
innodb-force-primary-key                                     FALSE
innodb-force-recovery                                        0
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-immediate-scrub-data-uncompressed                     FALSE
innodb-instant-alter-column-allowed                          add_drop_reorder
innodb-io-capacity                                           400
innodb-io-capacity-max                                       18446744073709551615
innodb-large-prefix                                          (No default value)
innodb-lock-schedule-algorithm                               fcfs
innodb-lock-wait-timeout                                     50
innodb-lock-waits                                            ON
innodb-locks                                                 ON
innodb-log-buffer-size                                       16777216
innodb-log-checksums                                         TRUE
innodb-log-compressed-pages                                  TRUE
innodb-log-file-size                                         4294967296
innodb-log-files-in-group                                    1
innodb-log-group-home-dir                                    (No default value)
innodb-log-optimize-ddl                                      FALSE
innodb-log-write-ahead-size                                  8192
innodb-lru-flush-size                                        32
innodb-lru-scan-depth                                        1536
innodb-max-dirty-pages-pct                                   90
innodb-max-dirty-pages-pct-lwm                               0
innodb-max-purge-lag                                         0
innodb-max-purge-lag-delay                                   0
innodb-max-purge-lag-wait                                    4294967295
innodb-max-undo-log-size                                     10485760
innodb-metrics                                               ON
innodb-monitor-disable                                       (No default value)
innodb-monitor-enable                                        (No default value)
innodb-monitor-reset                                         (No default value)
innodb-monitor-reset-all                                     (No default value)
innodb-mutexes                                               ON
innodb-old-blocks-pct                                        37
innodb-old-blocks-time                                       1000
innodb-online-alter-log-max-size                             134217728
innodb-open-files                                            400
innodb-optimize-fulltext-only                                FALSE
innodb-page-cleaners                                         0
innodb-page-size                                             16384
innodb-prefix-index-cluster-optimization                     FALSE
innodb-print-all-deadlocks                                   FALSE
innodb-purge-batch-size                                      300
innodb-purge-rseg-truncate-frequency                         128
innodb-purge-threads                                         4
innodb-random-read-ahead                                     FALSE
innodb-read-ahead-threshold                                  56
innodb-read-io-threads                                       4
innodb-read-only                                             FALSE
innodb-replication-delay                                     0
innodb-rollback-on-timeout                                   FALSE
innodb-scrub-log                                             FALSE
innodb-scrub-log-speed                                       256
innodb-sort-buffer-size                                      1048576
innodb-spin-wait-delay                                       4
innodb-stats-auto-recalc                                     TRUE
innodb-stats-include-delete-marked                           FALSE
innodb-stats-method                                          nulls_equal
innodb-stats-modified-counter                                0
innodb-stats-on-metadata                                     FALSE
innodb-stats-persistent                                      TRUE
innodb-stats-persistent-sample-pages                         20
innodb-stats-traditional                                     TRUE
innodb-stats-transient-sample-pages                          8
innodb-status-file                                           FALSE
innodb-status-output                                         FALSE
innodb-status-output-locks                                   FALSE
innodb-strict-mode                                           TRUE
innodb-sync-array-size                                       1
innodb-sync-spin-loops                                       30
innodb-sys-columns                                           ON
innodb-sys-datafiles                                         ON
innodb-sys-fields                                            ON
innodb-sys-foreign                                           ON
innodb-sys-foreign-cols                                      ON
innodb-sys-indexes                                           ON
innodb-sys-semaphore-waits                                   ON
innodb-sys-tables                                            ON
innodb-sys-tablespaces                                       ON
innodb-sys-tablestats                                        ON
innodb-sys-virtual                                           ON
innodb-table-locks                                           TRUE
innodb-tablespaces-encryption                                ON
innodb-temp-data-file-path                                   ibtmp1:12M:autoextend
innodb-thread-concurrency                                    0
innodb-thread-sleep-delay                                    0
innodb-tmpdir                                                (No default value)
innodb-trx                                                   ON
innodb-undo-directory                                        (No default value)
innodb-undo-log-truncate                                     FALSE
innodb-undo-logs                                             128
innodb-undo-tablespaces                                      0
innodb-use-atomic-writes                                     TRUE
innodb-use-native-aio                                        TRUE
innodb-write-io-threads                                      4
interactive-timeout                                          500
join-buffer-size                                             4194304
join-buffer-space-limit                                      2097152
join-cache-level                                             2
keep-files-on-create                                         FALSE
key-buffer-size                                              134217728
key-cache-age-threshold                                      300
key-cache-block-size                                         1024
key-cache-division-limit                                     100
key-cache-file-hash-size                                     512
key-cache-segments                                           0
large-files-support                                          TRUE
large-pages                                                  FALSE
lc-messages                                                  en_US
lc-messages-dir                                              /usr/share/mysql
lc-time-names                                                en_US
local-infile                                                 TRUE
lock-wait-timeout                                            86400
log-basename                                                 eco-portal
log-bin                                                      0
log-bin-compress                                             FALSE
log-bin-compress-min-len                                     256
log-bin-index                                                (No default value)
log-bin-trust-function-creators                              FALSE
log-disabled-statements                                      sp
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                                    TRUE
log-slow-disabled-statements                                 sp
log-slow-filter                                              admin,filesort,filesort_on_disk,filesort_priority_queue,full_join,full_scan,query_cache,query_cache_miss,tmp_table,tmp_table_on_disk
log-slow-rate-limit                                          1
log-slow-slave-statements                                    TRUE
log-slow-verbosity                                           
log-tc                                                       tc.log
log-tc-size                                                  24576
log-warnings                                                 2
long-query-time                                              10
low-priority-updates                                         FALSE
lower-case-file-system                                       FALSE
lower-case-table-names                                       0
master-info-file                                             master.info
master-retry-count                                           86400
master-verify-checksum                                       FALSE
max-allowed-packet                                           16777216
max-binlog-cache-size                                        18446744073709547520
max-binlog-size                                              1073741824
max-binlog-stmt-cache-size                                   18446744073709547520
max-connect-errors                                           100
max-connections                                              300
max-delayed-threads                                          20
max-digest-length                                            1024
max-error-count                                              64
max-heap-table-size                                          268435456
max-join-size                                                18446744073709551615
max-length-for-sort-data                                     1024
max-password-errors                                          4294967295
max-prepared-stmt-count                                      16382
max-recursive-iterations                                     4294967295
max-relay-log-size                                           1073741824
max-rowid-filter-size                                        131072
max-seeks-for-key                                            4294967295
max-session-mem-used                                         9223372036854775807
max-sort-length                                              1024
max-sp-recursion-depth                                       0
max-statement-time                                           0
max-tmp-tables                                               32
max-user-connections                                         0
max-write-lock-count                                         4294967295
memlock                                                      FALSE
metadata-locks-cache-size                                    1024
metadata-locks-hash-instances                                8
min-examined-row-limit                                       0
mrr-buffer-size                                              262144
myisam-block-size                                            1024
myisam-data-pointer-size                                     6
myisam-max-sort-file-size                                    9223372036853727232
myisam-mmap-size                                             18446744073709551615
myisam-recover-options                                       BACKUP,QUICK
myisam-repair-threads                                        1
myisam-sort-buffer-size                                      134216704
myisam-stats-method                                          NULLS_UNEQUAL
myisam-use-mmap                                              FALSE
mysql56-temporal-format                                      TRUE
net-buffer-length                                            16384
net-read-timeout                                             30
net-retry-count                                              10
net-write-timeout                                            60
old                                                          FALSE
old-alter-table                                              DEFAULT
old-mode                                                     
old-passwords                                                FALSE
old-style-user-limits                                        FALSE
open-files-limit                                             32335
optimizer-max-sel-arg-weight                                 32000
optimizer-prune-level                                        1
optimizer-search-depth                                       62
optimizer-selectivity-sampling-limit                         100
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=on,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=on,condition_pushdown_for_derived=on,split_materialized=on,condition_pushdown_for_subquery=on,rowid_filter=on,condition_pushdown_from_having=on
optimizer-trace                                              
optimizer-trace-max-mem-size                                 1048576
optimizer-use-condition-selectivity                          4
partition                                                    ON
performance-schema                                           TRUE
performance-schema-accounts-size                             -1
performance-schema-consumer-events-stages-current            FALSE
performance-schema-consumer-events-stages-history            FALSE
performance-schema-consumer-events-stages-history-long       FALSE
performance-schema-consumer-events-statements-current        FALSE
performance-schema-consumer-events-statements-history        FALSE
performance-schema-consumer-events-statements-history-long   FALSE
performance-schema-consumer-events-transactions-current      FALSE
performance-schema-consumer-events-transactions-history      FALSE
performance-schema-consumer-events-transactions-history-long FALSE
performance-schema-consumer-events-waits-current             FALSE
performance-schema-consumer-events-waits-history             FALSE
performance-schema-consumer-events-waits-history-long        FALSE
performance-schema-consumer-global-instrumentation           TRUE
performance-schema-consumer-statements-digest                TRUE
performance-schema-consumer-thread-instrumentation           TRUE
performance-schema-digests-size                              5000
performance-schema-events-stages-history-long-size           1000
performance-schema-events-stages-history-size                10
performance-schema-events-statements-history-long-size       1000
performance-schema-events-statements-history-size            10
performance-schema-events-transactions-history-long-size     1000
performance-schema-events-transactions-history-size          10
performance-schema-events-waits-history-long-size            1000
performance-schema-events-waits-history-size                 10
performance-schema-hosts-size                                -1
performance-schema-instrument                                
performance-schema-max-cond-classes                          90
performance-schema-max-cond-instances                        -1
performance-schema-max-digest-length                         1024
performance-schema-max-file-classes                          80
performance-schema-max-file-handles                          32768
performance-schema-max-file-instances                        -1
performance-schema-max-index-stat                            -1
performance-schema-max-memory-classes                        320
performance-schema-max-metadata-locks                        -1
performance-schema-max-mutex-classes                         210
performance-schema-max-mutex-instances                       -1
performance-schema-max-prepared-statements-instances         -1
performance-schema-max-program-instances                     -1
performance-schema-max-rwlock-classes                        50
performance-schema-max-rwlock-instances                      -1
performance-schema-max-socket-classes                        10
performance-schema-max-socket-instances                      -1
performance-schema-max-sql-text-length                       1024
performance-schema-max-stage-classes                         160
performance-schema-max-statement-classes                     222
performance-schema-max-statement-stack                       10
performance-schema-max-table-handles                         -1
performance-schema-max-table-instances                       -1
performance-schema-max-table-lock-stat                       -1
performance-schema-max-thread-classes                        50
performance-schema-max-thread-instances                      -1
performance-schema-session-connect-attrs-size                512
performance-schema-setup-actors-size                         -1
performance-schema-setup-objects-size                        -1
performance-schema-users-size                                -1
pid-file                                                     /run/mysqld/mysqld.pid
plugin-dir                                                   /usr/lib/mysql/plugin/
plugin-maturity                                              gamma
port                                                         3306
port-open-timeout                                            0
preload-buffer-size                                          32768
profiling-history-size                                       15
progress-report-time                                         5
protocol-version                                             10
proxy-protocol-networks                                      
query-alloc-block-size                                       16384
query-cache-limit                                            1048576
query-cache-min-res-unit                                     4096
query-cache-size                                             0
query-cache-strip-comments                                   FALSE
query-cache-type                                             OFF
query-cache-wlock-invalidate                                 FALSE
query-prealloc-size                                          24576
range-alloc-block-size                                       4096
read-binlog-speed-limit                                      0
read-buffer-size                                             1048576
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                                TRUE
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)
require-secure-transport                                     FALSE
rowid-merge-buff-size                                        8388608
rpl-semi-sync-master-enabled                                 FALSE
rpl-semi-sync-master-timeout                                 10000
rpl-semi-sync-master-trace-level                             32
rpl-semi-sync-master-wait-no-slave                           TRUE
rpl-semi-sync-master-wait-point                              AFTER_COMMIT
rpl-semi-sync-slave-delay-master                             FALSE
rpl-semi-sync-slave-enabled                                  FALSE
rpl-semi-sync-slave-kill-conn-timeout                        5
rpl-semi-sync-slave-trace-level                              32
safe-user-create                                             FALSE
secure-auth                                                  TRUE
secure-file-priv                                             (No default value)
secure-timestamp                                             NO
sequence                                                     ON
server-id                                                    1
session-track-schema                                         TRUE
session-track-state-change                                   FALSE
session-track-system-variables                               autocommit,character_set_client,character_set_connection,character_set_results,time_zone
session-track-transaction-info                               OFF
show-slave-auth-info                                         FALSE
silent-startup                                               FALSE
skip-grant-tables                                            FALSE
skip-name-resolve                                            TRUE
skip-networking                                              FALSE
skip-show-database                                           FALSE
skip-slave-start                                             FALSE
slave-compressed-protocol                                    FALSE
slave-ddl-exec-mode                                          IDEMPOTENT
slave-domain-parallel-threads                                0
slave-exec-mode                                              STRICT
slave-load-tmpdir                                            /tmp
slave-max-allowed-packet                                     1073741824
slave-net-timeout                                            60
slave-parallel-max-queued                                    131072
slave-parallel-mode                                          conservative
slave-parallel-threads                                       0
slave-parallel-workers                                       0
slave-run-triggers-for-rbr                                   NO
slave-skip-errors                                            OFF
slave-sql-verify-checksum                                    TRUE
slave-transaction-retries                                    10
slave-transaction-retry-errors                               1158,1159,1160,1161,1205,1213,1429,2013,12701
slave-transaction-retry-interval                             0
slave-type-conversions                                       
slow-launch-time                                             2
slow-query-log                                               FALSE
slow-query-log-file                                          eco-portal-slow.log
socket                                                       /run/mysqld/mysqld.sock
sort-buffer-size                                             1048576
sql-mode                                                     STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
sql-safe-updates                                             FALSE
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)
stack-trace                                                  TRUE
standard-compliant-cte                                       TRUE
stored-program-cache                                         256
strict-password-validation                                   TRUE
symbolic-links                                               TRUE
sync-binlog                                                  0
sync-frm                                                     TRUE
sync-master-info                                             10000
sync-relay-log                                               10000
sync-relay-log-info                                          10000
sysdate-is-now                                               FALSE
system-time-zone                                             EDT
system-versioning-alter-history                              ERROR
table-cache                                                  2000
table-definition-cache                                       3000
table-open-cache                                             2000
table-open-cache-instances                                   8
tc-heuristic-recover                                         OFF
tcp-keepalive-interval                                       0
tcp-keepalive-probes                                         0
tcp-keepalive-time                                           0
tcp-nodelay                                                  TRUE
temp-pool                                                    FALSE
thread-cache-size                                            256
thread-handling                                              one-thread-per-connection
thread-pool-dedicated-listener                               FALSE
thread-pool-exact-stats                                      FALSE
thread-pool-groups                                           ON
thread-pool-idle-timeout                                     60
thread-pool-max-threads                                      65536
thread-pool-oversubscribe                                    3
thread-pool-prio-kickup-timer                                1000
thread-pool-priority                                         auto
thread-pool-queues                                           ON
thread-pool-size                                             4
thread-pool-stall-limit                                      500
thread-pool-stats                                            ON
thread-pool-waits                                            ON
thread-stack                                                 299008
time-format                                                  %H:%i:%s
tls-version                                                  TLSv1.1,TLSv1.2,TLSv1.3
tmp-disk-table-size                                          18446744073709551615
tmp-memory-table-size                                        268435456
tmp-table-size                                               268435456
tmpdir                                                       /tmp
transaction-alloc-block-size                                 8192
transaction-isolation                                        REPEATABLE-READ
transaction-prealloc-size                                    4096
transaction-read-only                                        FALSE
unix-socket                                                  ON
updatable-views-with-limit                                   YES
use-stat-tables                                              PREFERABLY_FOR_QUERIES
user-variables                                               ON
userstat                                                     FALSE
verbose                                                      TRUE
version                                                      10.5.12-MariaDB-1:10.5.12+maria~focal
version-comment                                              mariadb.org binary distribution
version-compile-machine                                      x86_64
version-compile-os                                           debian-linux-gnu
version-malloc-library                                       system
version-source-revision                                      b5569b62408375f35e2fe851158a7ff17e378ed1
version-ssl-library                                          OpenSSL 1.1.1f  31 Mar 2020
wait-timeout                                                 500
wsrep-OSU-method                                             TOI
wsrep-SR-store                                               table
wsrep-auto-increment-control                                 TRUE
wsrep-causal-reads                                           FALSE
wsrep-certification-rules                                    strict
wsrep-certify-nonPK                                          TRUE
wsrep-cluster-address                                        
wsrep-cluster-name                                           my_wsrep_cluster
wsrep-convert-LOCK-to-trx                                    FALSE
wsrep-data-home-dir                                          /var/lib/mysql/
wsrep-dbug-option                                            
wsrep-debug                                                  NONE
wsrep-desync                                                 FALSE
wsrep-dirty-reads                                            FALSE
wsrep-drupal-282555-workaround                               FALSE
wsrep-forced-binlog-format                                   NONE
wsrep-gtid-domain-id                                         0
wsrep-gtid-mode                                              FALSE
wsrep-ignore-apply-errors                                    7
wsrep-load-data-splitting                                    FALSE
wsrep-log-conflicts                                          FALSE
wsrep-max-ws-rows                                            0
wsrep-max-ws-size                                            2147483647
wsrep-mysql-replication-bundle                               0
wsrep-new-cluster                                            FALSE
wsrep-node-address                                           
wsrep-node-incoming-address                                  AUTO
wsrep-node-name                                              eco-portal
wsrep-notify-cmd                                             
wsrep-on                                                     FALSE
wsrep-patch-version                                          wsrep_26.22
wsrep-provider                                               none
wsrep-provider-options                                       
wsrep-recover                                                FALSE
wsrep-reject-queries                                         NONE
wsrep-replicate-myisam                                       FALSE
wsrep-restart-slave                                          FALSE
wsrep-retry-autocommit                                       1
wsrep-slave-FK-checks                                        TRUE
wsrep-slave-UK-checks                                        FALSE
wsrep-slave-threads                                          1
wsrep-sst-auth                                               (No default value)
wsrep-sst-donor                                              
wsrep-sst-donor-rejects-queries                              FALSE
wsrep-sst-method                                             rsync
wsrep-sst-receive-address                                    AUTO
wsrep-start-position                                         00000000-0000-0000-0000-000000000000:-1
wsrep-strict-ddl                                             FALSE
wsrep-sync-wait                                              0
wsrep-trx-fragment-size                                      0
wsrep-trx-fragment-unit                                      bytes

Geänderter text

Datei öffnen

allow-suspicious-udfs                                        FALSE
alter-algorithm                                              DEFAULT
analyze-sample-percentage                                    100
aria-block-size                                              8192
aria-checkpoint-interval                                     0
aria-checkpoint-log-activity                                 1048576
aria-encrypt-tables                                          FALSE
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-pagecache-file-hash-size                                512
aria-recover-options                                         
aria-repair-threads                                          1
aria-sort-buffer-size                                        268434432
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                                                     70
basedir                                                      /usr
big-tables                                                   FALSE
bind-address                                                 (No default value)
binlog-annotate-row-events                                   TRUE
binlog-cache-size                                            32768
binlog-checksum                                              CRC32
binlog-commit-wait-count                                     0
binlog-commit-wait-usec                                      100000
binlog-direct-non-transactional-updates                      FALSE
binlog-file-cache-size                                       16384
binlog-format                                                MIXED
binlog-optimize-thread-scheduling                            TRUE
binlog-row-event-max-size                                    8192
binlog-row-image                                             FULL
binlog-row-metadata                                          NO_LOG
binlog-stmt-cache-size                                       32768
bulk-insert-buffer-size                                      16777216
character-set-client-handshake                               TRUE
character-set-filesystem                                     binary
character-set-server                                         utf8mb4
character-sets-dir                                           /usr/share/mysql/charsets/
chroot                                                       (No default value)
collation-server                                             utf8mb4_general_ci
column-compression-threshold                                 100
column-compression-zlib-level                                6
column-compression-zlib-strategy                             DEFAULT_STRATEGY
column-compression-zlib-wrap                                 FALSE
completion-type                                              NO_CHAIN
concurrent-insert                                            ALWAYS
connect-timeout                                              5
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                                                        
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-password-lifetime                                    0
default-regex-flags                                          
default-storage-engine                                       InnoDB
default-time-zone                                            (No default value)
default-tmp-storage-engine                                   (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)
disconnect-on-expired-password                               FALSE
div-precision-increment                                      4
encrypt-binlog                                               FALSE
encrypt-tmp-disk-tables                                      FALSE
encrypt-tmp-files                                            FALSE
enforce-storage-engine                                       (No default value)
eq-range-index-dive-limit                                    200
event-scheduler                                              OFF
expensive-subquery-limit                                     100
expire-logs-days                                             10
explicit-defaults-for-timestamp                              FALSE
external-locking                                             FALSE
extra-max-connections                                        1
extra-port                                                   0
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                                           
flashback                                                    FALSE
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                                             de35b2c2796f.log
getopt-prefix-matching                                       TRUE
group-concat-max-len                                         1048576
gtid-cleanup-batch-size                                      64
gtid-domain-id                                               0
gtid-ignore-duplicates                                       FALSE
gtid-pos-auto-engines                                        
gtid-strict-mode                                             FALSE
help                                                         TRUE
histogram-size                                               254
histogram-type                                               DOUBLE_PREC_HB
host-cache-size                                              228
idle-readonly-transaction-timeout                            0
idle-transaction-timeout                                     0
idle-write-transaction-timeout                               0
ignore-builtin-innodb                                        FALSE
ignore-db-dirs                                               
in-predicate-conversion-threshold                            1000
init-connect                                                 
init-file                                                    (No default value)
init-rpl-role                                                MASTER
init-slave                                                   
innodb                                                       ON
innodb-adaptive-flushing                                     TRUE
innodb-adaptive-flushing-lwm                                 10
innodb-adaptive-hash-index                                   FALSE
innodb-adaptive-hash-index-parts                             8
innodb-adaptive-max-sleep-delay                              0
innodb-autoextend-increment                                  64
innodb-autoinc-lock-mode                                     1
innodb-background-scrub-data-check-interval                  0
innodb-background-scrub-data-compressed                      FALSE
innodb-background-scrub-data-interval                        0
innodb-background-scrub-data-uncompressed                    FALSE
innodb-buf-dump-status-frequency                             0
innodb-buffer-page                                           ON
innodb-buffer-page-lru                                       ON
innodb-buffer-pool-chunk-size                                134217728
innodb-buffer-pool-dump-at-shutdown                          TRUE
innodb-buffer-pool-dump-now                                  FALSE
innodb-buffer-pool-dump-pct                                  25
innodb-buffer-pool-filename                                  ib_buffer_pool
innodb-buffer-pool-instances                                 0
innodb-buffer-pool-load-abort                                FALSE
innodb-buffer-pool-load-at-startup                           TRUE
innodb-buffer-pool-load-now                                  FALSE
innodb-buffer-pool-size                                      268435456
innodb-buffer-pool-stats                                     ON
innodb-change-buffer-max-size                                25
innodb-change-buffering                                      all
innodb-checksum-algorithm                                    full_crc32
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-algorithm                                 zlib
innodb-compression-default                                   FALSE
innodb-compression-failure-threshold-pct                     5
innodb-compression-level                                     6
innodb-compression-pad-pct-max                               50
innodb-concurrency-tickets                                   0
innodb-data-file-path                                        ibdata1:12M:autoextend
innodb-data-home-dir                                         (No default value)
innodb-deadlock-detect                                       TRUE
innodb-default-encryption-key-id                             1
innodb-default-row-format                                    dynamic
innodb-defragment                                            FALSE
innodb-defragment-fill-factor                                0.9
innodb-defragment-fill-factor-n-recs                         20
innodb-defragment-frequency                                  40
innodb-defragment-n-pages                                    7
innodb-defragment-stats-accuracy                             0
innodb-disable-sort-file-cache                               FALSE
innodb-doublewrite                                           TRUE
innodb-encrypt-log                                           FALSE
innodb-encrypt-tables                                        OFF
innodb-encrypt-temporary-tables                              FALSE
innodb-encryption-rotate-key-age                             1
innodb-encryption-rotation-iops                              100
innodb-encryption-threads                                    0
innodb-fast-shutdown                                         1
innodb-fatal-semaphore-wait-threshold                        600
innodb-file-format                                           (No default value)
innodb-file-per-table                                        TRUE
innodb-fill-factor                                           100
innodb-flush-log-at-timeout                                  1
innodb-flush-log-at-trx-commit                               1
innodb-flush-method                                          O_DIRECT
innodb-flush-neighbors                                       1
innodb-flush-sync                                            TRUE
innodb-flushing-avg-loops                                    30
innodb-force-load-corrupted                                  FALSE
innodb-force-primary-key                                     FALSE
innodb-force-recovery                                        0
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-immediate-scrub-data-uncompressed                     FALSE
innodb-instant-alter-column-allowed                          add_drop_reorder
innodb-io-capacity                                           400
innodb-io-capacity-max                                       18446744073709551615
innodb-large-prefix                                          (No default value)
innodb-lock-schedule-algorithm                               fcfs
innodb-lock-wait-timeout                                     50
innodb-lock-waits                                            ON
innodb-locks                                                 ON
innodb-log-buffer-size                                       8388608
innodb-log-checksums                                         TRUE
innodb-log-compressed-pages                                  TRUE
innodb-log-file-size                                         100663296
innodb-log-files-in-group                                    1
innodb-log-group-home-dir                                    (No default value)
innodb-log-optimize-ddl                                      FALSE
innodb-log-write-ahead-size                                  8192
innodb-lru-flush-size                                        32
innodb-lru-scan-depth                                        1536
innodb-max-dirty-pages-pct                                   90
innodb-max-dirty-pages-pct-lwm                               0
innodb-max-purge-lag                                         0
innodb-max-purge-lag-delay                                   0
innodb-max-purge-lag-wait                                    4294967295
innodb-max-undo-log-size                                     10485760
innodb-metrics                                               ON
innodb-monitor-disable                                       (No default value)
innodb-monitor-enable                                        (No default value)
innodb-monitor-reset                                         (No default value)
innodb-monitor-reset-all                                     (No default value)
innodb-mutexes                                               ON
innodb-old-blocks-pct                                        37
innodb-old-blocks-time                                       1000
innodb-online-alter-log-max-size                             134217728
innodb-open-files                                            400
innodb-optimize-fulltext-only                                FALSE
innodb-page-cleaners                                         0
innodb-page-size                                             16384
innodb-prefix-index-cluster-optimization                     FALSE
innodb-print-all-deadlocks                                   FALSE
innodb-purge-batch-size                                      300
innodb-purge-rseg-truncate-frequency                         128
innodb-purge-threads                                         4
innodb-random-read-ahead                                     FALSE
innodb-read-ahead-threshold                                  56
innodb-read-io-threads                                       4
innodb-read-only                                             FALSE
innodb-replication-delay                                     0
innodb-rollback-on-timeout                                   FALSE
innodb-scrub-log                                             FALSE
innodb-scrub-log-speed                                       256
innodb-sort-buffer-size                                      1048576
innodb-spin-wait-delay                                       4
innodb-stats-auto-recalc                                     TRUE
innodb-stats-include-delete-marked                           FALSE
innodb-stats-method                                          nulls_equal
innodb-stats-modified-counter                                0
innodb-stats-on-metadata                                     FALSE
innodb-stats-persistent                                      TRUE
innodb-stats-persistent-sample-pages                         20
innodb-stats-traditional                                     TRUE
innodb-stats-transient-sample-pages                          8
innodb-status-file                                           FALSE
innodb-status-output                                         FALSE
innodb-status-output-locks                                   FALSE
innodb-strict-mode                                           TRUE
innodb-sync-array-size                                       1
innodb-sync-spin-loops                                       30
innodb-sys-columns                                           ON
innodb-sys-datafiles                                         ON
innodb-sys-fields                                            ON
innodb-sys-foreign                                           ON
innodb-sys-foreign-cols                                      ON
innodb-sys-indexes                                           ON
innodb-sys-semaphore-waits                                   ON
innodb-sys-tables                                            ON
innodb-sys-tablespaces                                       ON
innodb-sys-tablestats                                        ON
innodb-sys-virtual                                           ON
innodb-table-locks                                           TRUE
innodb-tablespaces-encryption                                ON
innodb-temp-data-file-path                                   ibtmp1:12M:autoextend
innodb-thread-concurrency                                    0
innodb-thread-sleep-delay                                    0
innodb-tmpdir                                                (No default value)
innodb-trx                                                   ON
innodb-undo-directory                                        (No default value)
innodb-undo-log-truncate                                     FALSE
innodb-undo-logs                                             128
innodb-undo-tablespaces                                      0
innodb-use-atomic-writes                                     TRUE
innodb-use-native-aio                                        TRUE
innodb-write-io-threads                                      4
interactive-timeout                                          28800
join-buffer-size                                             262144
join-buffer-space-limit                                      2097152
join-cache-level                                             2
keep-files-on-create                                         FALSE
key-buffer-size                                              134217728
key-cache-age-threshold                                      300
key-cache-block-size                                         1024
key-cache-division-limit                                     100
key-cache-file-hash-size                                     512
key-cache-segments                                           0
large-files-support                                          TRUE
large-pages                                                  FALSE
lc-messages                                                  en_US
lc-messages-dir                                              /usr/share/mysql
lc-time-names                                                en_US
local-infile                                                 TRUE
lock-wait-timeout                                            86400
log-basename                                                 de35b2c2796f
log-bin                                                      (No default value)
log-bin-compress                                             FALSE
log-bin-compress-min-len                                     256
log-bin-index                                                (No default value)
log-bin-trust-function-creators                              FALSE
log-disabled-statements                                      sp
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                                    TRUE
log-slow-disabled-statements                                 sp
log-slow-filter                                              admin,filesort,filesort_on_disk,filesort_priority_queue,full_join,full_scan,query_cache,query_cache_miss,tmp_table,tmp_table_on_disk
log-slow-rate-limit                                          1
log-slow-slave-statements                                    TRUE
log-slow-verbosity                                           
log-tc                                                       tc.log
log-tc-size                                                  24576
log-warnings                                                 2
long-query-time                                              10
low-priority-updates                                         FALSE
lower-case-file-system                                       FALSE
lower-case-table-names                                       0
master-info-file                                             master.info
master-retry-count                                           86400
master-verify-checksum                                       FALSE
max-allowed-packet                                           536870912
max-binlog-cache-size                                        18446744073709547520
max-binlog-size                                              104857600
max-binlog-stmt-cache-size                                   18446744073709547520
max-connect-errors                                           100
max-connections                                              100
max-delayed-threads                                          20
max-digest-length                                            1024
max-error-count                                              64
max-heap-table-size                                          33554432
max-join-size                                                18446744073709551615
max-length-for-sort-data                                     1024
max-password-errors                                          4294967295
max-prepared-stmt-count                                      16382
max-recursive-iterations                                     4294967295
max-relay-log-size                                           104857600
max-rowid-filter-size                                        131072
max-seeks-for-key                                            4294967295
max-session-mem-used                                         9223372036854775807
max-sort-length                                              1024
max-sp-recursion-depth                                       0
max-statement-time                                           0
max-tmp-tables                                               32
max-user-connections                                         0
max-write-lock-count                                         4294967295
memlock                                                      FALSE
metadata-locks-cache-size                                    1024
metadata-locks-hash-instances                                8
min-examined-row-limit                                       0
mrr-buffer-size                                              262144
myisam-block-size                                            1024
myisam-data-pointer-size                                     6
myisam-max-sort-file-size                                    9223372036853727232
myisam-mmap-size                                             18446744073709551615
myisam-recover-options                                       BACKUP
myisam-repair-threads                                        1
myisam-sort-buffer-size                                      536870912
myisam-stats-method                                          NULLS_UNEQUAL
myisam-use-mmap                                              FALSE
mysql56-temporal-format                                      TRUE
net-buffer-length                                            16384
net-read-timeout                                             30
net-retry-count                                              10
net-write-timeout                                            60
old                                                          FALSE
old-alter-table                                              DEFAULT
old-mode                                                     
old-passwords                                                FALSE
old-style-user-limits                                        FALSE
open-files-limit                                             6547
optimizer-max-sel-arg-weight                                 32000
optimizer-prune-level                                        1
optimizer-search-depth                                       62
optimizer-selectivity-sampling-limit                         100
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=on,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=on,condition_pushdown_for_derived=on,split_materialized=on,condition_pushdown_for_subquery=on,rowid_filter=on,condition_pushdown_from_having=on
optimizer-trace                                              
optimizer-trace-max-mem-size                                 1048576
optimizer-use-condition-selectivity                          4
partition                                                    ON
performance-schema                                           FALSE
performance-schema-accounts-size                             -1
performance-schema-consumer-events-stages-current            FALSE
performance-schema-consumer-events-stages-history            FALSE
performance-schema-consumer-events-stages-history-long       FALSE
performance-schema-consumer-events-statements-current        FALSE
performance-schema-consumer-events-statements-history        FALSE
performance-schema-consumer-events-statements-history-long   FALSE
performance-schema-consumer-events-transactions-current      FALSE
performance-schema-consumer-events-transactions-history      FALSE
performance-schema-consumer-events-transactions-history-long FALSE
performance-schema-consumer-events-waits-current             FALSE
performance-schema-consumer-events-waits-history             FALSE
performance-schema-consumer-events-waits-history-long        FALSE
performance-schema-consumer-global-instrumentation           TRUE
performance-schema-consumer-statements-digest                TRUE
performance-schema-consumer-thread-instrumentation           TRUE
performance-schema-digests-size                              -1
performance-schema-events-stages-history-long-size           -1
performance-schema-events-stages-history-size                -1
performance-schema-events-statements-history-long-size       -1
performance-schema-events-statements-history-size            -1
performance-schema-events-transactions-history-long-size     -1
performance-schema-events-transactions-history-size          -1
performance-schema-events-waits-history-long-size            -1
performance-schema-events-waits-history-size                 -1
performance-schema-hosts-size                                -1
performance-schema-instrument                                
performance-schema-max-cond-classes                          90
performance-schema-max-cond-instances                        -1
performance-schema-max-digest-length                         1024
performance-schema-max-file-classes                          80
performance-schema-max-file-handles                          32768
performance-schema-max-file-instances                        -1
performance-schema-max-index-stat                            -1
performance-schema-max-memory-classes                        320
performance-schema-max-metadata-locks                        -1
performance-schema-max-mutex-classes                         210
performance-schema-max-mutex-instances                       -1
performance-schema-max-prepared-statements-instances         -1
performance-schema-max-program-instances                     -1
performance-schema-max-rwlock-classes                        50
performance-schema-max-rwlock-instances                      -1
performance-schema-max-socket-classes                        10
performance-schema-max-socket-instances                      -1
performance-schema-max-sql-text-length                       1024
performance-schema-max-stage-classes                         160
performance-schema-max-statement-classes                     222
performance-schema-max-statement-stack                       10
performance-schema-max-table-handles                         -1
performance-schema-max-table-instances                       -1
performance-schema-max-table-lock-stat                       -1
performance-schema-max-thread-classes                        50
performance-schema-max-thread-instances                      -1
performance-schema-session-connect-attrs-size                -1
performance-schema-setup-actors-size                         -1
performance-schema-setup-objects-size                        -1
performance-schema-users-size                                -1
pid-file                                                     /var/run/mysqld/mysqld.pid
plugin-dir                                                   /usr/lib/mysql/plugin/
plugin-maturity                                              gamma
port                                                         3306
port-open-timeout                                            0
preload-buffer-size                                          32768
profiling-history-size                                       15
progress-report-time                                         5
protocol-version                                             10
proxy-protocol-networks                                      
query-alloc-block-size                                       16384
query-cache-limit                                            131072
query-cache-min-res-unit                                     4096
query-cache-size                                             67108864
query-cache-strip-comments                                   FALSE
query-cache-type                                             ON
query-cache-wlock-invalidate                                 FALSE
query-prealloc-size                                          24576
range-alloc-block-size                                       4096
read-binlog-speed-limit                                      0
read-buffer-size                                             2097152
read-only                                                    FALSE
read-rnd-buffer-size                                         1048576
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                                TRUE
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)
require-secure-transport                                     FALSE
rowid-merge-buff-size                                        8388608
rpl-semi-sync-master-enabled                                 FALSE
rpl-semi-sync-master-timeout                                 10000
rpl-semi-sync-master-trace-level                             32
rpl-semi-sync-master-wait-no-slave                           TRUE
rpl-semi-sync-master-wait-point                              AFTER_COMMIT
rpl-semi-sync-slave-delay-master                             FALSE
rpl-semi-sync-slave-enabled                                  FALSE
rpl-semi-sync-slave-kill-conn-timeout                        5
rpl-semi-sync-slave-trace-level                              32
safe-user-create                                             FALSE
secure-auth                                                  TRUE
secure-file-priv                                             (No default value)
secure-timestamp                                             NO
sequence                                                     ON
server-id                                                    1
session-track-schema                                         TRUE
session-track-state-change                                   FALSE
session-track-system-variables                               autocommit,character_set_client,character_set_connection,character_set_results,time_zone
session-track-transaction-info                               OFF
show-slave-auth-info                                         FALSE
silent-startup                                               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-ddl-exec-mode                                          IDEMPOTENT
slave-domain-parallel-threads                                0
slave-exec-mode                                              STRICT
slave-load-tmpdir                                            /tmp
slave-max-allowed-packet                                     1073741824
slave-net-timeout                                            60
slave-parallel-max-queued                                    131072
slave-parallel-mode                                          conservative
slave-parallel-threads                                       0
slave-parallel-workers                                       0
slave-run-triggers-for-rbr                                   NO
slave-skip-errors                                            OFF
slave-sql-verify-checksum                                    TRUE
slave-transaction-retries                                    10
slave-transaction-retry-errors                               1158,1159,1160,1161,1205,1213,1429,2013,12701
slave-transaction-retry-interval                             0
slave-type-conversions                                       
slow-launch-time                                             2
slow-query-log                                               FALSE
slow-query-log-file                                          /var/log/mysql/mariadb-slow.log
socket                                                       /var/run/mysqld/mysqld.sock
sort-buffer-size                                             4194304
sql-mode                                                     STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
sql-safe-updates                                             FALSE
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)
stack-trace                                                  TRUE
standard-compliant-cte                                       TRUE
stored-program-cache                                         256
strict-password-validation                                   TRUE
symbolic-links                                               TRUE
sync-binlog                                                  0
sync-frm                                                     TRUE
sync-master-info                                             10000
sync-relay-log                                               10000
sync-relay-log-info                                          10000
sysdate-is-now                                               FALSE
system-time-zone                                             UTC
system-versioning-alter-history                              ERROR
table-cache                                                  400
table-definition-cache                                       400
table-open-cache                                             400
table-open-cache-instances                                   8
tc-heuristic-recover                                         OFF
tcp-keepalive-interval                                       0
tcp-keepalive-probes                                         0
tcp-keepalive-time                                           0
tcp-nodelay                                                  TRUE
temp-pool                                                    FALSE
thread-cache-size                                            100
thread-handling                                              one-thread-per-connection
thread-pool-dedicated-listener                               FALSE
thread-pool-exact-stats                                      FALSE
thread-pool-groups                                           ON
thread-pool-idle-timeout                                     60
thread-pool-max-threads                                      65536
thread-pool-oversubscribe                                    3
thread-pool-prio-kickup-timer                                1000
thread-pool-priority                                         auto
thread-pool-queues                                           ON
thread-pool-size                                             16
thread-pool-stall-limit                                      500
thread-pool-stats                                            ON
thread-pool-waits                                            ON
thread-stack                                                 299008
time-format                                                  %H:%i:%s
tls-version                                                  TLSv1.1,TLSv1.2,TLSv1.3
tmp-disk-table-size                                          18446744073709551615
tmp-memory-table-size                                        33554432
tmp-table-size                                               33554432
tmpdir                                                       /tmp
transaction-alloc-block-size                                 8192
transaction-isolation                                        REPEATABLE-READ
transaction-prealloc-size                                    4096
transaction-read-only                                        FALSE
unix-socket                                                  ON
updatable-views-with-limit                                   YES
use-stat-tables                                              PREFERABLY_FOR_QUERIES
user-variables                                               ON
userstat                                                     FALSE
verbose                                                      TRUE
version                                                      10.5.12-MariaDB-1:10.5.12+maria~focal
version-comment                                              mariadb.org binary distribution
version-compile-machine                                      x86_64
version-compile-os                                           debian-linux-gnu
version-malloc-library                                       system
version-source-revision                                      b5569b62408375f35e2fe851158a7ff17e378ed1
version-ssl-library                                          OpenSSL 1.1.1f  31 Mar 2020
wait-timeout                                                 600
wsrep-OSU-method                                             TOI
wsrep-SR-store                                               table
wsrep-auto-increment-control                                 TRUE
wsrep-causal-reads                                           FALSE
wsrep-certification-rules                                    strict
wsrep-certify-nonPK                                          TRUE
wsrep-cluster-address                                        
wsrep-cluster-name                                           my_wsrep_cluster
wsrep-convert-LOCK-to-trx                                    FALSE
wsrep-data-home-dir                                          /var/lib/mysql/
wsrep-dbug-option                                            
wsrep-debug                                                  NONE
wsrep-desync                                                 FALSE
wsrep-dirty-reads                                            FALSE
wsrep-drupal-282555-workaround                               FALSE
wsrep-forced-binlog-format                                   NONE
wsrep-gtid-domain-id                                         0
wsrep-gtid-mode                                              FALSE
wsrep-ignore-apply-errors                                    7
wsrep-load-data-splitting                                    FALSE
wsrep-log-conflicts                                          FALSE
wsrep-max-ws-rows                                            0
wsrep-max-ws-size                                            2147483647
wsrep-mysql-replication-bundle                               0
wsrep-new-cluster                                            FALSE
wsrep-node-address                                           
wsrep-node-incoming-address                                  AUTO
wsrep-node-name                                              de35b2c2796f
wsrep-notify-cmd                                             
wsrep-on                                                     FALSE
wsrep-patch-version                                          wsrep_26.22
wsrep-provider                                               none
wsrep-provider-options                                       
wsrep-recover                                                FALSE
wsrep-reject-queries                                         NONE
wsrep-replicate-myisam                                       FALSE
wsrep-restart-slave                                          FALSE
wsrep-retry-autocommit                                       1
wsrep-slave-FK-checks                                        TRUE
wsrep-slave-UK-checks                                        FALSE
wsrep-slave-threads                                          1
wsrep-sst-auth                                               (No default value)
wsrep-sst-donor                                              
wsrep-sst-donor-rejects-queries                              FALSE
wsrep-sst-method                                             rsync
wsrep-sst-receive-address                                    AUTO
wsrep-start-position                                         00000000-0000-0000-0000-000000000000:-1
wsrep-strict-ddl                                             FALSE
wsrep-sync-wait                                              0
wsrep-trx-fragment-size                                      0
wsrep-trx-fragment-unit                                      bytes

Words removed	17
Total words	777
Words removed (%)	2.19

Words added	21
Total words	781
Words added (%)	2.69