Comparer le texte

Encuentra la diferencia entre dos archivos de texto

Real-time diff

Unified diff

Collapse lines

Highlight change

Syntax highlighting

Outils

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

Lines
Total
Removed

Words
Total
Removed

To continue using this feature, upgrade to Diffchecker Pro View Pricing

371 lines

Lines
Total
Added

Words
Total
Added

To continue using this feature, upgrade to Diffchecker Pro View Pricing

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

Les différences enregistrées

Texte d'origine

Ouvrir un fichier

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

Texte modifié

Ouvrir un fichier

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