 Bearbeiten
|
activate all roles on login
|
OFF
|
|
Bearbeiten
|
admin address
|
|
|
Bearbeiten
|
admin port
|
33.062
|
|
Bearbeiten
|
auto generate certs
|
ON
|
|
Bearbeiten
|
auto increment increment
|
1
|
|
Bearbeiten
|
auto increment offset
|
1
|
|
Bearbeiten
|
autocommit
|
ON
|
|
Bearbeiten
|
automatic sp privileges
|
ON
|
|
Bearbeiten
|
avoid temporal upgrade
|
OFF
|
|
Bearbeiten
|
back log
|
151
|
|
Bearbeiten
|
basedir
|
/usr/
|
|
Bearbeiten
|
big tables
|
OFF
|
|
Bearbeiten
|
bind address
|
192.168.30.23
|
|
Bearbeiten
|
binlog cache size
|
32.768
|
|
Bearbeiten
|
binlog checksum
|
CRC32
|
|
Bearbeiten
|
binlog direct non transactional updates
|
OFF
|
|
Bearbeiten
|
binlog encryption
|
OFF
|
|
Bearbeiten
|
binlog error action
|
ABORT_SERVER
|
|
Bearbeiten
|
binlog expire logs seconds
|
2.592.000
|
|
Bearbeiten
|
binlog format
|
ROW
|
|
Bearbeiten
|
binlog group commit sync delay
|
0
|
|
Bearbeiten
|
binlog group commit sync no delay count
|
0
|
|
Bearbeiten
|
binlog gtid simple recovery
|
ON
|
|
Bearbeiten
|
binlog max flush queue time
|
0
|
|
Bearbeiten
|
binlog order commits
|
ON
|
|
Bearbeiten
|
binlog rotate encryption master key at startup
|
OFF
|
|
Bearbeiten
|
binlog row event max size
|
8.192
|
|
Bearbeiten
|
binlog row image
|
FULL
|
|
Bearbeiten
|
binlog row metadata
|
MINIMAL
|
|
Bearbeiten
|
binlog row value options
|
|
|
Bearbeiten
|
binlog rows query log events
|
OFF
|
|
Bearbeiten
|
binlog stmt cache size
|
32.768
|
|
Bearbeiten
|
binlog transaction dependency history size
|
25.000
|
|
Bearbeiten
|
binlog transaction dependency tracking
|
COMMIT_ORDER
|
|
Bearbeiten
|
block encryption mode
|
aes-128-ecb
|
|
Bearbeiten
|
bulk insert buffer size
|
8.388.608
|
|
Bearbeiten
|
caching sha2 password auto generate rsa keys
|
ON
|
|
Bearbeiten
|
caching sha2 password private key path
|
private_key.pem
|
|
Bearbeiten
|
caching sha2 password public key path
|
public_key.pem
|
|
Bearbeiten
|
character set client
|
utf8mb4
|
|
Bearbeiten
|
character set connection
|
utf8mb4
|
|
Bearbeiten
|
character set database
|
utf8mb4
|
|
Bearbeiten
|
character set filesystem
|
binary
|
|
Bearbeiten
|
character set results
|
utf8mb4
|
|
Bearbeiten
|
character set server
|
utf8mb4
|
|
Bearbeiten
|
character set system
|
utf8
|
|
Bearbeiten
|
character sets dir
|
/usr/share/mysql-8.0/charsets/
|
|
Bearbeiten
|
check proxy users
|
OFF
|
|
Bearbeiten
|
collation connection
|
utf8mb4_0900_ai_ci
|
|
collation connection (Wert für diese Sitzung) |
utf8mb4_unicode_ci |
|
Bearbeiten
|
collation database
|
utf8mb4_0900_ai_ci
|
|
Bearbeiten
|
collation server
|
utf8mb4_0900_ai_ci
|
|
Bearbeiten
|
completion type
|
NO_CHAIN
|
|
Bearbeiten
|
concurrent insert
|
AUTO
|
|
Bearbeiten
|
connect timeout
|
10
|
|
Bearbeiten
|
core file
|
OFF
|
|
Bearbeiten
|
create admin listener thread
|
OFF
|
|
Bearbeiten
|
cte max recursion depth
|
1.000
|
|
Bearbeiten
|
datadir
|
/var/lib/mysql/
|
|
Bearbeiten
|
default authentication plugin
|
mysql_native_password
|
|
Bearbeiten
|
default collation for utf8mb4
|
utf8mb4_0900_ai_ci
|
|
Bearbeiten
|
default password lifetime
|
0
|
|
Bearbeiten
|
default storage engine
|
InnoDB
|
|
Bearbeiten
|
default table encryption
|
OFF
|
|
Bearbeiten
|
default tmp storage engine
|
InnoDB
|
|
Bearbeiten
|
default week format
|
0
|
|
Bearbeiten
|
delay key write
|
ON
|
|
Bearbeiten
|
delayed insert limit
|
100
|
|
Bearbeiten
|
delayed insert timeout
|
300
|
|
Bearbeiten
|
delayed queue size
|
1.000
|
|
Bearbeiten
|
disabled storage engines
|
|
|
Bearbeiten
|
disconnect on expired password
|
ON
|
|
Bearbeiten
|
div precision increment
|
4
|
|
Bearbeiten
|
end markers in json
|
OFF
|
|
Bearbeiten
|
enforce gtid consistency
|
OFF
|
|
Bearbeiten
|
eq range index dive limit
|
200
|
|
Bearbeiten
|
event scheduler
|
ON
|
|
Bearbeiten
|
expire logs days
|
0
|
|
Bearbeiten
|
explicit defaults for timestamp
|
ON
|
|
Bearbeiten
|
flush
|
OFF
|
|
Bearbeiten
|
flush time
|
0
|
|
Bearbeiten
|
foreign key checks
|
ON
|
|
Bearbeiten
|
ft boolean syntax
|
+ -><()~*:""&|
|
|
Bearbeiten
|
ft max word len
|
84
|
|
Bearbeiten
|
ft min word len
|
4
|
|
Bearbeiten
|
ft query expansion limit
|
20
|
|
Bearbeiten
|
ft stopword file
|
(built-in)
|
|
Bearbeiten
|
general log
|
OFF
|
|
Bearbeiten
|
general log file
|
/var/lib/mysql/demo-mysql.log
|
|
Bearbeiten
|
generated random password length
|
20
|
|
Bearbeiten
|
group concat max len
|
1.024
|
|
Bearbeiten
|
group replication consistency
|
EVENTUAL
|
|
Bearbeiten
|
gtid executed
|
|
|
Bearbeiten
|
gtid executed compression period
|
1.000
|
|
Bearbeiten
|
gtid mode
|
OFF
|
|
Bearbeiten
|
gtid owned
|
|
|
Bearbeiten
|
gtid purged
|
|
|
Bearbeiten
|
have compress
|
YES
|
|
Bearbeiten
|
have dynamic loading
|
YES
|
|
Bearbeiten
|
have geometry
|
YES
|
|
Bearbeiten
|
have openssl
|
YES
|
|
Bearbeiten
|
have profiling
|
YES
|
|
Bearbeiten
|
have query cache
|
NO
|
|
Bearbeiten
|
have rtree keys
|
YES
|
|
Bearbeiten
|
have ssl
|
YES
|
|
Bearbeiten
|
have statement timeout
|
YES
|
|
Bearbeiten
|
have symlink
|
DISABLED
|
|
Bearbeiten
|
histogram generation max mem size
|
20.000.000
|
|
Bearbeiten
|
host cache size
|
279
|
|
Bearbeiten
|
hostname
|
demo-mysql
|
|
Bearbeiten
|
information schema stats expiry
|
86.400
|
|
Bearbeiten
|
init connect
|
|
|
Bearbeiten
|
init file
|
|
|
Bearbeiten
|
init slave
|
|
|
Bearbeiten
|
innodb adaptive flushing
|
ON
|
|
Bearbeiten
|
innodb adaptive flushing lwm
|
10
|
|
Bearbeiten
|
innodb adaptive hash index
|
ON
|
|
Bearbeiten
|
innodb adaptive hash index parts
|
8
|
|
Bearbeiten
|
innodb adaptive max sleep delay
|
150.000
|
|
Bearbeiten
|
innodb api bk commit interval
|
5
|
|
Bearbeiten
|
innodb api disable rowlock
|
OFF
|
|
Bearbeiten
|
innodb api enable binlog
|
OFF
|
|
Bearbeiten
|
innodb api enable mdl
|
OFF
|
|
Bearbeiten
|
innodb api trx level
|
0
|
|
Bearbeiten
|
innodb autoextend increment
|
64
|
|
Bearbeiten
|
innodb autoinc lock mode
|
2
|
|
Bearbeiten
|
innodb buffer pool chunk size
|
134.217.728
|
|
Bearbeiten
|
innodb buffer pool dump at shutdown
|
ON
|
|
Bearbeiten
|
innodb buffer pool dump now
|
OFF
|
|
Bearbeiten
|
innodb buffer pool dump pct
|
25
|
|
Bearbeiten
|
innodb buffer pool filename
|
ib_buffer_pool
|
|
Bearbeiten
|
innodb buffer pool in core file
|
ON
|
|
Bearbeiten
|
innodb buffer pool instances
|
1
|
|
Bearbeiten
|
innodb buffer pool load abort
|
OFF
|
|
Bearbeiten
|
innodb buffer pool load at startup
|
ON
|
|
Bearbeiten
|
innodb buffer pool load now
|
OFF
|
|
Bearbeiten
|
innodb buffer pool size
|
134.217.728
|
|
Bearbeiten
|
innodb change buffer max size
|
25
|
|
Bearbeiten
|
innodb change buffering
|
all
|
|
Bearbeiten
|
innodb checksum algorithm
|
crc32
|
|
Bearbeiten
|
innodb cmp per index enabled
|
OFF
|
|
Bearbeiten
|
innodb commit concurrency
|
0
|
|
Bearbeiten
|
innodb compression failure threshold pct
|
5
|
|
Bearbeiten
|
innodb compression level
|
6
|
|
Bearbeiten
|
innodb compression pad pct max
|
50
|
|
Bearbeiten
|
innodb concurrency tickets
|
5.000
|
|
Bearbeiten
|
innodb data file path
|
ibdata1:12M:autoextend
|
|
Bearbeiten
|
innodb data home dir
|
|
|
Bearbeiten
|
innodb deadlock detect
|
ON
|
|
Bearbeiten
|
innodb dedicated server
|
OFF
|
|
Bearbeiten
|
innodb default row format
|
dynamic
|
|
Bearbeiten
|
innodb directories
|
|
|
Bearbeiten
|
innodb disable sort file cache
|
OFF
|
|
Bearbeiten
|
innodb doublewrite
|
ON
|
|
Bearbeiten
|
innodb fast shutdown
|
1
|
|
Bearbeiten
|
innodb file per table
|
ON
|
|
Bearbeiten
|
innodb fill factor
|
100
|
|
Bearbeiten
|
innodb flush log at timeout
|
1
|
|
Bearbeiten
|
innodb flush log at trx commit
|
1
|
|
Bearbeiten
|
innodb flush method
|
fsync
|
|
Bearbeiten
|
innodb flush neighbors
|
0
|
|
Bearbeiten
|
innodb flush sync
|
ON
|
|
Bearbeiten
|
innodb flushing avg loops
|
30
|
|
Bearbeiten
|
innodb force load corrupted
|
OFF
|
|
Bearbeiten
|
innodb force recovery
|
0
|
|
Bearbeiten
|
innodb fsync threshold
|
0
|
|
Bearbeiten
|
innodb ft aux table
|
|
|
Bearbeiten
|
innodb ft cache size
|
8.000.000
|
|
Bearbeiten
|
innodb ft enable diag print
|
OFF
|
|
Bearbeiten
|
innodb ft enable stopword
|
ON
|
|
Bearbeiten
|
innodb ft max token size
|
84
|
|
Bearbeiten
|
innodb ft min token size
|
3
|
|
Bearbeiten
|
innodb ft num word optimize
|
2.000
|
|
Bearbeiten
|
innodb ft result cache limit
|
2.000.000.000
|
|
Bearbeiten
|
innodb ft server stopword table
|
|
|
Bearbeiten
|
innodb ft sort pll degree
|
2
|
|
Bearbeiten
|
innodb ft total cache size
|
640.000.000
|
|
Bearbeiten
|
innodb ft user stopword table
|
|
|
Bearbeiten
|
innodb idle flush pct
|
100
|
|
Bearbeiten
|
innodb io capacity
|
200
|
|
Bearbeiten
|
innodb io capacity max
|
2.000
|
|
Bearbeiten
|
innodb lock wait timeout
|
50
|
|
Bearbeiten
|
innodb log buffer size
|
16.777.216
|
|
Bearbeiten
|
innodb log checksums
|
ON
|
|
Bearbeiten
|
innodb log compressed pages
|
ON
|
|
Bearbeiten
|
innodb log file size
|
50.331.648
|
|
Bearbeiten
|
innodb log files in group
|
2
|
|
Bearbeiten
|
innodb log group home dir
|
./
|
|
Bearbeiten
|
innodb log spin cpu abs lwm
|
80
|
|
Bearbeiten
|
innodb log spin cpu pct hwm
|
50
|
|
Bearbeiten
|
innodb log wait for flush spin hwm
|
400
|
|
Bearbeiten
|
innodb log write ahead size
|
8.192
|
|
Bearbeiten
|
innodb lru scan depth
|
1.024
|
|
Bearbeiten
|
innodb max dirty pages pct
|
90
|
|
Bearbeiten
|
innodb max dirty pages pct lwm
|
10
|
|
Bearbeiten
|
innodb max purge lag
|
0
|
|
Bearbeiten
|
innodb max purge lag delay
|
0
|
|
Bearbeiten
|
innodb max undo log size
|
1.073.741.824
|
|
Bearbeiten
|
innodb monitor disable
|
|
|
Bearbeiten
|
innodb monitor enable
|
|
|
Bearbeiten
|
innodb monitor reset
|
|
|
Bearbeiten
|
innodb monitor reset all
|
|
|
Bearbeiten
|
innodb numa interleave
|
OFF
|
|
Bearbeiten
|
innodb old blocks pct
|
37
|
|
Bearbeiten
|
innodb old blocks time
|
1.000
|
|
Bearbeiten
|
innodb online alter log max size
|
134.217.728
|
|
Bearbeiten
|
innodb open files
|
4.000
|
|
Bearbeiten
|
innodb optimize fulltext only
|
OFF
|
|
Bearbeiten
|
innodb page cleaners
|
1
|
|
Bearbeiten
|
innodb page size
|
16.384
|
|
Bearbeiten
|
innodb parallel read threads
|
4
|
|
Bearbeiten
|
innodb print all deadlocks
|
OFF
|
|
Bearbeiten
|
innodb print ddl logs
|
OFF
|
|
Bearbeiten
|
innodb purge batch size
|
300
|
|
Bearbeiten
|
innodb purge rseg truncate frequency
|
128
|
|
Bearbeiten
|
innodb purge threads
|
4
|
|
Bearbeiten
|
innodb random read ahead
|
OFF
|
|
Bearbeiten
|
innodb read ahead threshold
|
56
|
|
Bearbeiten
|
innodb read io threads
|
4
|
|
Bearbeiten
|
innodb read only
|
OFF
|
|
Bearbeiten
|
innodb redo log archive dirs
|
|
|
Bearbeiten
|
innodb redo log encrypt
|
OFF
|
|
Bearbeiten
|
innodb replication delay
|
0
|
|
Bearbeiten
|
innodb rollback on timeout
|
OFF
|
|
Bearbeiten
|
innodb rollback segments
|
128
|
|
Bearbeiten
|
innodb sort buffer size
|
1.048.576
|
|
Bearbeiten
|
innodb spin wait delay
|
6
|
|
Bearbeiten
|
innodb spin wait pause multiplier
|
50
|
|
Bearbeiten
|
innodb stats auto recalc
|
ON
|
|
Bearbeiten
|
innodb stats include delete marked
|
OFF
|
|
Bearbeiten
|
innodb stats method
|
nulls_equal
|
|
Bearbeiten
|
innodb stats on metadata
|
OFF
|
|
Bearbeiten
|
innodb stats persistent
|
ON
|
|
Bearbeiten
|
innodb stats persistent sample pages
|
20
|
|
Bearbeiten
|
innodb stats transient sample pages
|
8
|
|
Bearbeiten
|
innodb status output
|
OFF
|
|
Bearbeiten
|
innodb status output locks
|
OFF
|
|
Bearbeiten
|
innodb strict mode
|
ON
|
|
Bearbeiten
|
innodb sync array size
|
1
|
|
Bearbeiten
|
innodb sync spin loops
|
30
|
|
Bearbeiten
|
innodb table locks
|
ON
|
|
Bearbeiten
|
innodb temp data file path
|
ibtmp1:12M:autoextend
|
|
Bearbeiten
|
innodb temp tablespaces dir
|
./#innodb_temp/
|
|
Bearbeiten
|
innodb thread concurrency
|
0
|
|
Bearbeiten
|
innodb thread sleep delay
|
10.000
|
|
Bearbeiten
|
innodb tmpdir
|
|
|
Bearbeiten
|
innodb undo directory
|
./
|
|
Bearbeiten
|
innodb undo log encrypt
|
OFF
|
|
Bearbeiten
|
innodb undo log truncate
|
ON
|
|
Bearbeiten
|
innodb undo tablespaces
|
2
|
|
Bearbeiten
|
innodb use native aio
|
ON
|
|
Bearbeiten
|
innodb version
|
8.0.18
|
|
Bearbeiten
|
innodb write io threads
|
4
|
|
Bearbeiten
|
interactive timeout
|
28.800
|
|
Bearbeiten
|
internal tmp mem storage engine
|
TempTable
|
|
Bearbeiten
|
join buffer size
|
262.144
|
|
Bearbeiten
|
keep files on create
|
OFF
|
|
Bearbeiten
|
key buffer size
|
8.388.608
|
|
Bearbeiten
|
key cache age threshold
|
300
|
|
Bearbeiten
|
key cache block size
|
1.024
|
|
Bearbeiten
|
key cache division limit
|
100
|
|
Bearbeiten
|
keyring operations
|
ON
|
|
Bearbeiten
|
large files support
|
ON
|
|
Bearbeiten
|
large page size
|
0
|
|
Bearbeiten
|
large pages
|
OFF
|
|
Bearbeiten
|
lc messages
|
en_US
|
|
lc messages (Wert für diese Sitzung) |
de_DE |
|
Bearbeiten
|
lc messages dir
|
/usr/share/mysql-8.0/
|
|
Bearbeiten
|
lc time names
|
en_US
|
|
Bearbeiten
|
license
|
GPL
|
|
Bearbeiten
|
local infile
|
OFF
|
|
Bearbeiten
|
lock wait timeout
|
31.536.000
|
|
Bearbeiten
|
locked in memory
|
OFF
|
|
Bearbeiten
|
log bin
|
ON
|
|
Bearbeiten
|
log bin basename
|
/var/lib/mysql/binlog
|
|
Bearbeiten
|
log bin index
|
/var/lib/mysql/binlog.index
|
|
Bearbeiten
|
log bin trust function creators
|
OFF
|
|
Bearbeiten
|
log bin use v1 row events
|
OFF
|
|
Bearbeiten
|
log error
|
/var/log/mysql/error.log
|
|
Bearbeiten
|
log error services
|
log_filter_internal; log_sink_internal
|
|
Bearbeiten
|
log error suppression list
|
|
|
Bearbeiten
|
log error verbosity
|
2
|
|
Bearbeiten
|
log output
|
FILE
|
|
Bearbeiten
|
log queries not using indexes
|
OFF
|
|
Bearbeiten
|
log slave updates
|
ON
|
|
Bearbeiten
|
log slow admin statements
|
OFF
|
|
Bearbeiten
|
log slow extra
|
OFF
|
|
Bearbeiten
|
log slow slave statements
|
OFF
|
|
Bearbeiten
|
log statements unsafe for binlog
|
ON
|
|
Bearbeiten
|
log throttle queries not using indexes
|
0
|
|
Bearbeiten
|
log timestamps
|
UTC
|
|
Bearbeiten
|
long query time
|
10
|
|
Bearbeiten
|
low priority updates
|
OFF
|
|
Bearbeiten
|
lower case file system
|
OFF
|
|
Bearbeiten
|
lower case table names
|
0
|
|
Bearbeiten
|
mandatory roles
|
|
|
Bearbeiten
|
master info repository
|
TABLE
|
|
Bearbeiten
|
master verify checksum
|
OFF
|
|
Bearbeiten
|
max allowed packet
|
67.108.864
|
|
Bearbeiten
|
max binlog cache size
|
18.446.744.073.709.547.520
|
|
Bearbeiten
|
max binlog size
|
1.073.741.824
|
|
Bearbeiten
|
max binlog stmt cache size
|
18.446.744.073.709.547.520
|
|
Bearbeiten
|
max connect errors
|
100
|
|
Bearbeiten
|
max connections
|
151
|
|
Bearbeiten
|
max delayed threads
|
20
|
|
Bearbeiten
|
max digest length
|
1.024
|
|
Bearbeiten
|
max error count
|
1.024
|
|
Bearbeiten
|
max execution time
|
0
|
|
Bearbeiten
|
max heap table size
|
16.777.216
|
|
Bearbeiten
|
max insert delayed threads
|
20
|
|
Bearbeiten
|
max join size
|
18.446.744.073.709.551.616
|
|
Bearbeiten
|
max length for sort data
|
4.096
|
|
Bearbeiten
|
max points in geometry
|
65.536
|
|
Bearbeiten
|
max prepared stmt count
|
16.382
|
|
Bearbeiten
|
max relay log size
|
0
|
|
Bearbeiten
|
max seeks for key
|
18.446.744.073.709.551.616
|
|
Bearbeiten
|
max sort length
|
1.024
|
|
Bearbeiten
|
max sp recursion depth
|
0
|
|
Bearbeiten
|
max user connections
|
0
|
|
Bearbeiten
|
max write lock count
|
18.446.744.073.709.551.616
|
|
Bearbeiten
|
min examined row limit
|
0
|
|
Bearbeiten
|
myisam data pointer size
|
6
|
|
Bearbeiten
|
myisam max sort file size
|
9.223.372.036.853.727.232
|
|
Bearbeiten
|
myisam mmap size
|
18.446.744.073.709.551.616
|
|
Bearbeiten
|
myisam recover options
|
OFF
|
|
Bearbeiten
|
myisam repair threads
|
1
|
|
Bearbeiten
|
myisam sort buffer size
|
8.388.608
|
|
Bearbeiten
|
myisam stats method
|
nulls_unequal
|
|
Bearbeiten
|
myisam use mmap
|
OFF
|
|
Bearbeiten
|
mysql native password proxy users
|
OFF
|
|
Bearbeiten
|
mysqlx bind address
|
*
|
|
Bearbeiten
|
mysqlx connect timeout
|
30
|
|
Bearbeiten
|
mysqlx document id unique prefix
|
0
|
|
Bearbeiten
|
mysqlx enable hello notice
|
ON
|
|
Bearbeiten
|
mysqlx idle worker thread timeout
|
60
|
|
Bearbeiten
|
mysqlx interactive timeout
|
28.800
|
|
Bearbeiten
|
mysqlx max allowed packet
|
67.108.864
|
|
Bearbeiten
|
mysqlx max connections
|
100
|
|
Bearbeiten
|
mysqlx min worker threads
|
2
|
|
Bearbeiten
|
mysqlx port
|
33.060
|
|
Bearbeiten
|
mysqlx port open timeout
|
0
|
|
Bearbeiten
|
mysqlx read timeout
|
30
|
|
Bearbeiten
|
mysqlx socket
|
/var/run/mysqld/mysqlx.sock
|
|
Bearbeiten
|
mysqlx ssl ca
|
|
|
Bearbeiten
|
mysqlx ssl capath
|
|
|
Bearbeiten
|
mysqlx ssl cert
|
|
|
Bearbeiten
|
mysqlx ssl cipher
|
|
|
Bearbeiten
|
mysqlx ssl crl
|
|
|
Bearbeiten
|
mysqlx ssl crlpath
|
|
|
Bearbeiten
|
mysqlx ssl key
|
|
|
Bearbeiten
|
mysqlx wait timeout
|
28.800
|
|
Bearbeiten
|
mysqlx write timeout
|
60
|
|
Bearbeiten
|
net buffer length
|
16.384
|
|
Bearbeiten
|
net read timeout
|
30
|
|
Bearbeiten
|
net retry count
|
10
|
|
Bearbeiten
|
net write timeout
|
60
|
|
Bearbeiten
|
new
|
OFF
|
|
Bearbeiten
|
ngram token size
|
2
|
|
Bearbeiten
|
offline mode
|
OFF
|
|
Bearbeiten
|
old
|
OFF
|
|
Bearbeiten
|
old alter table
|
OFF
|
|
Bearbeiten
|
open files limit
|
10.000
|
|
Bearbeiten
|
optimizer prune level
|
1
|
|
Bearbeiten
|
optimizer search depth
|
62
|
|
Bearbeiten
|
optimizer switch
|
index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,engine_condition_pushdown=on,index_condition_pushdown=on,mrr=on,mrr_cost_based=on,block_nested_loop=on,batched_key_access=off,materialization=on,semijoin=on,loosescan=on,firstmatch=on,duplicateweedout=on,subquery_materialization_cost_based=on,use_index_extensions=on,condition_fanout_filter=on,derived_merge=on,use_invisible_indexes=off,skip_scan=on,hash_join=on
|
|
Bearbeiten
|
optimizer trace
|
enabled=off,one_line=off
|
|
Bearbeiten
|
optimizer trace features
|
greedy_search=on,range_optimizer=on,dynamic_range=on,repeated_subselect=on
|
|
Bearbeiten
|
optimizer trace limit
|
1
|
|
Bearbeiten
|
optimizer trace max mem size
|
1.048.576
|
|
Bearbeiten
|
optimizer trace offset
|
-1
|
|
Bearbeiten
|
parser max mem size
|
18.446.744.073.709.551.616
|
|
Bearbeiten
|
partial revokes
|
OFF
|
|
Bearbeiten
|
password history
|
0
|
|
Bearbeiten
|
password require current
|
OFF
|
|
Bearbeiten
|
password reuse interval
|
0
|
|
Bearbeiten
|
performance schema
|
ON
|
|
Bearbeiten
|
performance schema accounts size
|
-1
|
|
Bearbeiten
|
performance schema digests size
|
10.000
|
|
Bearbeiten
|
performance schema error size
|
4.593
|
|
Bearbeiten
|
performance schema events stages history long size
|
10.000
|
|
Bearbeiten
|
performance schema events stages history size
|
10
|
|
Bearbeiten
|
performance schema events statements history long size
|
10.000
|
|
Bearbeiten
|
performance schema events statements history size
|
10
|
|
Bearbeiten
|
performance schema events transactions history long size
|
10.000
|
|
Bearbeiten
|
performance schema events transactions history size
|
10
|
|
Bearbeiten
|
performance schema events waits history long size
|
10.000
|
|
Bearbeiten
|
performance schema events waits history size
|
10
|
|
Bearbeiten
|
performance schema hosts size
|
-1
|
|
Bearbeiten
|
performance schema max cond classes
|
100
|
|
Bearbeiten
|
performance schema max cond instances
|
-1
|
|
Bearbeiten
|
performance schema max digest length
|
1.024
|
|
Bearbeiten
|
performance schema max digest sample age
|
60
|
|
Bearbeiten
|
performance schema max file classes
|
80
|
|
Bearbeiten
|
performance schema max file handles
|
32.768
|
|
Bearbeiten
|
performance schema max file instances
|
-1
|
|
Bearbeiten
|
performance schema max index stat
|
-1
|
|
Bearbeiten
|
performance schema max memory classes
|
450
|
|
Bearbeiten
|
performance schema max metadata locks
|
-1
|
|
Bearbeiten
|
performance schema max mutex classes
|
300
|
|
Bearbeiten
|
performance schema max mutex instances
|
-1
|
|
Bearbeiten
|
performance schema max prepared statements instances
|
-1
|
|
Bearbeiten
|
performance schema max program instances
|
-1
|
|
Bearbeiten
|
performance schema max rwlock classes
|
60
|
|
Bearbeiten
|
performance schema max rwlock instances
|
-1
|
|
Bearbeiten
|
performance schema max socket classes
|
10
|
|
Bearbeiten
|
performance schema max socket instances
|
-1
|
|
Bearbeiten
|
performance schema max sql text length
|
1.024
|
|
Bearbeiten
|
performance schema max stage classes
|
175
|
|
Bearbeiten
|
performance schema max statement classes
|
218
|
|
Bearbeiten
|
performance schema max statement stack
|
10
|
|
Bearbeiten
|
performance schema max table handles
|
-1
|
|
Bearbeiten
|
performance schema max table instances
|
-1
|
|
Bearbeiten
|
performance schema max table lock stat
|
-1
|
|
Bearbeiten
|
performance schema max thread classes
|
100
|
|
Bearbeiten
|
performance schema max thread instances
|
-1
|
|
Bearbeiten
|
performance schema session connect attrs size
|
512
|
|
Bearbeiten
|
performance schema setup actors size
|
-1
|
|
Bearbeiten
|
performance schema setup objects size
|
-1
|
|
Bearbeiten
|
performance schema users size
|
-1
|
|
Bearbeiten
|
persist only admin x509 subject
|
|
|
Bearbeiten
|
persisted globals load
|
ON
|
|
Bearbeiten
|
pid file
|
/var/run/mysqld/mysqld.pid
|
|
Bearbeiten
|
plugin dir
|
/usr/lib/mysql/plugin/
|
|
Bearbeiten
|
port
|
3.306
|
|
Bearbeiten
|
preload buffer size
|
32.768
|
|
Bearbeiten
|
print identified with as hex
|
OFF
|
|
Bearbeiten
|
profiling
|
OFF
|
|
Bearbeiten
|
profiling history size
|
15
|
|
Bearbeiten
|
protocol compression algorithms
|
zlib,zstd,uncompressed
|
|
Bearbeiten
|
protocol version
|
10
|
|
Bearbeiten
|
query alloc block size
|
8.192
|
|
Bearbeiten
|
query prealloc size
|
8.192
|
|
Bearbeiten
|
range alloc block size
|
4.096
|
|
Bearbeiten
|
range optimizer max mem size
|
8.388.608
|
|
Bearbeiten
|
rbr exec mode
|
STRICT
|
|
Bearbeiten
|
read buffer size
|
131.072
|
|
Bearbeiten
|
read only
|
OFF
|
|
Bearbeiten
|
read rnd buffer size
|
262.144
|
|
Bearbeiten
|
regexp stack limit
|
8.000.000
|
|
Bearbeiten
|
regexp time limit
|
32
|
|
Bearbeiten
|
relay log
|
demo-mysql-relay-bin
|
|
Bearbeiten
|
relay log basename
|
/var/lib/mysql/demo-mysql-relay-bin
|
|
Bearbeiten
|
relay log index
|
/var/lib/mysql/demo-mysql-relay-bin.index
|
|
Bearbeiten
|
relay log info file
|
relay-log.info
|
|
Bearbeiten
|
relay log info repository
|
TABLE
|
|
Bearbeiten
|
relay log purge
|
ON
|
|
Bearbeiten
|
relay log recovery
|
OFF
|
|
Bearbeiten
|
relay log space limit
|
0
|
|
Bearbeiten
|
report host
|
|
|
Bearbeiten
|
report password
|
|
|
Bearbeiten
|
report port
|
3.306
|
|
Bearbeiten
|
report user
|
|
|
Bearbeiten
|
require secure transport
|
OFF
|
|
Bearbeiten
|
rpl read size
|
8.192
|
|
Bearbeiten
|
rpl stop slave timeout
|
31.536.000
|
|
Bearbeiten
|
schema definition cache
|
256
|
|
Bearbeiten
|
secondary engine cost threshold
|
100.000
|
|
Bearbeiten
|
secure file priv
|
/var/lib/mysql-files/
|
|
Bearbeiten
|
server id
|
1
|
|
Bearbeiten
|
server id bits
|
32
|
|
Bearbeiten
|
server uuid
|
e2de1825-fb1e-11e9-b58c-525400cd7f1c
|
|
Bearbeiten
|
session track gtids
|
OFF
|
|
Bearbeiten
|
session track schema
|
ON
|
|
Bearbeiten
|
session track state change
|
OFF
|
|
Bearbeiten
|
session track system variables
|
time_zone,autocommit,character_set_client,character_set_results,character_set_connection
|
|
Bearbeiten
|
session track transaction info
|
OFF
|
|
Bearbeiten
|
sha256 password auto generate rsa keys
|
ON
|
|
Bearbeiten
|
sha256 password private key path
|
private_key.pem
|
|
Bearbeiten
|
sha256 password proxy users
|
OFF
|
|
Bearbeiten
|
sha256 password public key path
|
public_key.pem
|
|
Bearbeiten
|
show create table verbosity
|
OFF
|
|
Bearbeiten
|
show old temporals
|
OFF
|
|
Bearbeiten
|
skip external locking
|
ON
|
|
Bearbeiten
|
skip name resolve
|
OFF
|
|
Bearbeiten
|
skip networking
|
OFF
|
|
Bearbeiten
|
skip show database
|
OFF
|
|
Bearbeiten
|
slave allow batching
|
OFF
|
|
Bearbeiten
|
slave checkpoint group
|
512
|
|
Bearbeiten
|
slave checkpoint period
|
300
|
|
Bearbeiten
|
slave compressed protocol
|
OFF
|
|
Bearbeiten
|
slave exec mode
|
STRICT
|
|
Bearbeiten
|
slave load tmpdir
|
/tmp
|
|
Bearbeiten
|
slave max allowed packet
|
1.073.741.824
|
|
Bearbeiten
|
slave net timeout
|
60
|
|
Bearbeiten
|
slave parallel type
|
DATABASE
|
|
Bearbeiten
|
slave parallel workers
|
0
|
|
Bearbeiten
|
slave pending jobs size max
|
134.217.728
|
|
Bearbeiten
|
slave preserve commit order
|
OFF
|
|
Bearbeiten
|
slave rows search algorithms
|
INDEX_SCAN,HASH_SCAN
|
|
Bearbeiten
|
slave skip errors
|
OFF
|
|
Bearbeiten
|
slave sql verify checksum
|
ON
|
|
Bearbeiten
|
slave transaction retries
|
10
|
|
Bearbeiten
|
slave type conversions
|
|
|
Bearbeiten
|
slow launch time
|
2
|
|
Bearbeiten
|
slow query log
|
OFF
|
|
Bearbeiten
|
slow query log file
|
/var/lib/mysql/demo-mysql-slow.log
|
|
Bearbeiten
|
socket
|
/var/run/mysqld/mysqld.sock
|
|
Bearbeiten
|
sort buffer size
|
262.144
|
|
Bearbeiten
|
sql auto is null
|
OFF
|
|
Bearbeiten
|
sql big selects
|
ON
|
|
Bearbeiten
|
sql buffer result
|
OFF
|
|
Bearbeiten
|
sql log off
|
OFF
|
|
Bearbeiten
|
sql mode
|
ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
|
|
Bearbeiten
|
sql notes
|
ON
|
|
Bearbeiten
|
sql quote show create
|
ON
|
|
Bearbeiten
|
sql require primary key
|
OFF
|
|
Bearbeiten
|
sql safe updates
|
OFF
|
|
Bearbeiten
|
sql select limit
|
18.446.744.073.709.551.616
|
|
Bearbeiten
|
sql slave skip counter
|
0
|
|
Bearbeiten
|
sql warnings
|
OFF
|
|
Bearbeiten
|
ssl ca
|
ca.pem
|
|
Bearbeiten
|
ssl capath
|
|
|
Bearbeiten
|
ssl cert
|
server-cert.pem
|
|
Bearbeiten
|
ssl cipher
|
|
|
Bearbeiten
|
ssl crl
|
|
|
Bearbeiten
|
ssl crlpath
|
|
|
Bearbeiten
|
ssl fips mode
|
OFF
|
|
Bearbeiten
|
ssl key
|
server-key.pem
|
|
Bearbeiten
|
stored program cache
|
256
|
|
Bearbeiten
|
stored program definition cache
|
256
|
|
Bearbeiten
|
super read only
|
OFF
|
|
Bearbeiten
|
sync binlog
|
1
|
|
Bearbeiten
|
sync master info
|
10.000
|
|
Bearbeiten
|
sync relay log
|
10.000
|
|
Bearbeiten
|
sync relay log info
|
10.000
|
|
Bearbeiten
|
system time zone
|
CET
|
|
Bearbeiten
|
table definition cache
|
2.000
|
|
Bearbeiten
|
table encryption privilege check
|
OFF
|
|
Bearbeiten
|
table open cache
|
4.000
|
|
Bearbeiten
|
table open cache instances
|
16
|
|
Bearbeiten
|
tablespace definition cache
|
256
|
|
Bearbeiten
|
temptable max ram
|
1.073.741.824
|
|
Bearbeiten
|
temptable use mmap
|
ON
|
|
Bearbeiten
|
thread cache size
|
9
|
|
Bearbeiten
|
thread handling
|
one-thread-per-connection
|
|
Bearbeiten
|
thread stack
|
286.720
|
|
Bearbeiten
|
time zone
|
SYSTEM
|
|
Bearbeiten
|
tls ciphersuites
|
|
|
Bearbeiten
|
tls version
|
TLSv1,TLSv1.1,TLSv1.2
|
|
Bearbeiten
|
tmp table size
|
16.777.216
|
|
Bearbeiten
|
tmpdir
|
/tmp
|
|
Bearbeiten
|
transaction alloc block size
|
8.192
|
|
Bearbeiten
|
transaction isolation
|
REPEATABLE-READ
|
|
Bearbeiten
|
transaction prealloc size
|
4.096
|
|
Bearbeiten
|
transaction read only
|
OFF
|
|
Bearbeiten
|
transaction write set extraction
|
XXHASH64
|
|
Bearbeiten
|
unique checks
|
ON
|
|
Bearbeiten
|
updatable views with limit
|
YES
|
|
Bearbeiten
|
version
|
8.0.18
|
|
Bearbeiten
|
version comment
|
MySQL Community Server - GPL
|
|
Bearbeiten
|
version compile machine
|
x86_64
|
|
Bearbeiten
|
version compile os
|
Linux
|
|
Bearbeiten
|
version compile zlib
|
1.2.11
|
|
Bearbeiten
|
wait timeout
|
28.800
|
|
Bearbeiten
|
windowing use high precision
|
ON
|
