schloemer.biz / rdbms.strato.de

Datenbanknavigation als Baum anzeigen Im Navigationsbereich den Datenbankbaum durch ein Auswahlmenü ersetzen
Mit Hauptpanel verknüpfen Verknüpfen Sie mit Hauptbereich durch die Hervorhebung der aktuellen Datenbank oder Tabelle.
Logo anzeigen Logo im Navigationspanel anzeigen.
URL für Logo-Link URL, auf die das Logo im Navigationspanel zeigt.
Ziel für Logo-Link Öffne Links im aktuellen Fenster(`main`) oder in einem neuen Fenster (`new`).
Hervorhebung ermöglichen Server unter Mauscursor hervorheben.
Maximale Elemente auf erster Ebene Anzahl der Elemente, die pro Seite auf der ersten Ebene im Navigationsbaum angezeigt werden können.
Minimale Anzahl Elemente, ab denen Filter-Feld angezeigt wird Legt die minimale Anzahl Elemente fest (Tabellen, Ansichten, Routinen und Ereignisse), ab denen ein Filter-Feld angezeigt wird.
Kürzlich verwendete Tabellen Maximale Anzahl der kürzlichen verwendeten Tabellen, auf 0 setzen zum deaktivieren.
Favoriten-Tabellen Maximale Anzahl der bevorzugten Tabellen, auf 0 setzen zum deaktivieren.
Navigationspanelbreite Auf 0 setzen, um das Navigations-Panel zu verstecken.

Maximale Elemente in Zweig Anzahl der Elemente, die pro Seite im Navigationsbaum angezeigt werden können.
Elemente im Baum gruppieren Elemente im Navigationsbaum gruppieren (wie vom im obigen „Datenbanken und Tabellen“-Reiter definierten Trennzeichen bestimmt).
Erweiterung des Navigationsbaumes aktivieren Wird die Möglichkeit der Baumerweiterung im Navigationsbereich angeboten oder nicht.
Tabellen-Liste im Baum anzeigen Ob die Tabellen unterhalb der Datenbanken im Navigationsbaum angezeigt werden
Views im Navigationsbaum anzeigen Ob Views unterhalb der Datenbanken im Navigationsbaum angezeigt werden
Funktionsfelder im Navigationsbaum anzeigen Ob Funktionsfelder unterhalb der Datenbanken im Navigationsbaum angezeigt werden
Prozeduren im Navigationsbaum anzeigen Ob Prozeduren unterhalb der Datenbanken im Navigationsbaum angezeigt werden
Events im Navigationsbaum anzeigen Ob Events unterhalb der Datenbanken im Navigationsbaum angezeigt werden

Server-Auswahl anzeigen Serverauswahl oben im Navigationspanel anzeigen.
Server als Liste anzeigen Server als Liste statt Dropdownfeld anzeigen.

Minimale Anzahl der Datenbanken, die im Datenbank-Filterfeld angezeigt werden
Trennzeichen für Datenbank-Baum Zeichenkette, die Datenbanken in unterschiedliche Baum-Abschnitte unterteilt.

Ziel für Schnellzugriff-Icon
Ziel für zweites Schnellzugriff-Icon
Trennzeichen für Tabellen-Baum Zeichenkette, die Tabellen in unterschiedliche Baum-Abschnitte unterteilt.
Maximale Tiefe des Tabellen-Baumes

Abfragenachrichten immer aufklappen
Abfrageverlauf beim Start anzeigen
Aktuelle Abfrage anzeigen
Abfragen mit Enter ausgeführen und neue Zeilen mit Shift + Enter eingefügen. Um dies dauerhaft zu speichern, siehe Einstellungen.
Zum dunklen Motiv wechseln

Servervariablen und -einstellungen

Filter

Beinhalten das Wort:

Aktion	Variable	Wert
	auto generate certs	ON
	auto increment increment	1
	auto increment offset	1
	autocommit	ON
	automatic sp privileges	ON
	avoid temporal upgrade	OFF
	back log	650
	basedir	/opt/mysql-5.7.42/
	big tables	OFF
	bind address	0.0.0.0
	binlog cache size	4,000 MiB
	binlog checksum	CRC32
	binlog direct non transactional updates	OFF
	binlog error action	ABORT_SERVER
	binlog format	ROW
	binlog group commit sync delay	0
	binlog group commit sync no delay count	0
	binlog gtid simple recovery	ON
	binlog max flush queue time	0
	binlog order commits	ON
	binlog row image	FULL
	binlog rows query log events	OFF
	binlog stmt cache size	1,000 MiB
	binlog transaction dependency history size	25.000
	binlog transaction dependency tracking	COMMIT_ORDER
	block encryption mode	aes-128-ecb
	bulk insert buffer size	8,000 MiB
	character set client	utf8
	(Wert für diese Sitzung)	utf8mb4
	character set connection	utf8
	(Wert für diese Sitzung)	utf8mb4
	character set database	utf8
	character set filesystem	binary
	character set results	utf8
	(Wert für diese Sitzung)	utf8mb4
	character set server	utf8
	character set system	utf8
	character sets dir	/opt/mysql-5.7.42/share/charsets/
	check proxy users	ON
	collation connection	utf8_general_ci
	(Wert für diese Sitzung)	utf8mb4_unicode_ci
	collation database	utf8_general_ci
	collation server	utf8_general_ci
	completion type	NO_CHAIN
	concurrent insert	AUTO
	connect timeout	10
	core file	OFF
	datadir	/DBDATA/rdbng/data/
	date format	%Y-%m-%d
	datetime format	%Y-%m-%d %H:%i:%s
	default authentication plugin	mysql_native_password
	default password lifetime	0
	default storage engine	InnoDB
	default tmp storage engine	InnoDB
	default week format	1
	delay key write	ON
	delayed insert limit	100
	delayed insert timeout	300
	delayed queue size	1.000
	disabled storage engines
	disconnect on expired password	ON
	div precision increment	4
	end markers in json	OFF
	enforce gtid consistency	OFF
	eq range index dive limit	200
	event scheduler	OFF
	expire logs days	1
	explicit defaults for timestamp	OFF
	flush	OFF
	flush time	0
	foreign key checks	ON
	ft boolean syntax	+ -><()~*:""&\|
	ft max word len	84
	ft min word len	4
	ft query expansion limit	20
	ft stopword file	(built-in)
	general log	OFF
	general log file	/DBDATA/rdbng/log/mysql-general.log
	group concat max len	1.024
	gtid executed
	gtid executed compression period	1.000
	gtid mode	OFF
	gtid owned
	gtid purged
	have compress	YES
	have crypt	YES
	have dynamic loading	YES
	have geometry	YES
	have openssl	YES
	have profiling	YES
	have query cache	YES
	have rtree keys	YES
	have ssl	YES
	have statement timeout	YES
	have symlink	DISABLED
	host cache size	753
	hostname	dba-rdb4658b
	ignore builtin innodb	OFF
	ignore db dirs
	init connect
	init file
	init slave
	innodb adaptive flushing	ON
	innodb adaptive flushing lwm	10
	innodb adaptive hash index	ON
	innodb adaptive hash index parts	8
	innodb adaptive max sleep delay	150.000
	innodb api bk commit interval	5
	innodb api disable rowlock	OFF
	innodb api enable binlog	OFF
	innodb api enable mdl	OFF
	innodb api trx level	0
	innodb autoextend increment	256
	innodb autoinc lock mode	1
	innodb buffer pool chunk size	128,000 MiB
	innodb buffer pool dump at shutdown	ON
	innodb buffer pool dump now	OFF
	innodb buffer pool dump pct	25
	innodb buffer pool filename	ib_buffer_pool
	innodb buffer pool instances	1
	innodb buffer pool load abort	OFF
	innodb buffer pool load at startup	ON
	innodb buffer pool load now	OFF
	innodb buffer pool size	12,000 GiB
	innodb change buffer max size	25
	innodb change buffering	all
	innodb checksum algorithm	crc32
	innodb checksums	ON
	innodb cmp per index enabled	OFF
	innodb commit concurrency	0
	innodb compression failure threshold pct	5
	innodb compression level	6
	innodb compression pad pct max	50
	innodb concurrency tickets	5.000
	innodb data file path	ibdata1:128M:autoextend
	innodb data home dir	/DBDATA/rdbng/data
	innodb deadlock detect	ON
	innodb default row format	dynamic
	innodb disable sort file cache	OFF
	innodb doublewrite	ON
	innodb fast shutdown	1
	innodb file format	Barracuda
	innodb file format check	ON
	innodb file format max	Barracuda
	innodb file per table	ON
	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	ON
	innodb flushing avg loops	30
	innodb force load corrupted	OFF
	innodb force recovery	0
	innodb ft aux table
	innodb ft cache size	8.000.000
	innodb ft enable diag print	OFF
	innodb ft enable stopword	ON
	innodb ft max token size	84
	innodb ft min token size	3
	innodb ft num word optimize	2.000
	innodb ft result cache limit	2.000.000.000
	innodb ft server stopword table
	innodb ft sort pll degree	2
	innodb ft total cache size	640.000.000
	innodb ft user stopword table
	innodb io capacity	200
	innodb io capacity max	2.000
	innodb large prefix	ON
	innodb lock wait timeout	50
	innodb locks unsafe for binlog	OFF
	innodb log buffer size	16,000 MiB
	innodb log checksums	ON
	innodb log compressed pages	ON
	innodb log file size	512,000 MiB
	innodb log files in group	3
	innodb log group home dir	/DBDATA/rdbng/data
	innodb log write ahead size	8,000 KiB
	innodb lru scan depth	256
	innodb max dirty pages pct	10
	innodb max dirty pages pct lwm	0
	innodb max purge lag	0
	innodb max purge lag delay	0
	innodb max undo log size	1,000 GiB
	innodb monitor disable
	innodb monitor enable
	innodb monitor reset
	innodb monitor reset all
	innodb numa interleave	OFF
	innodb old blocks pct	37
	innodb old blocks time	1.000
	innodb online alter log max size	128,000 MiB
	innodb open files	6.000
	innodb optimize fulltext only	OFF
	innodb page cleaners	1
	innodb page size	16,000 KiB
	innodb print all deadlocks	OFF
	innodb purge batch size	300
	innodb purge rseg truncate frequency	128
	innodb purge threads	1
	innodb random read ahead	OFF
	innodb read ahead threshold	56
	innodb read io threads	8
	innodb read only	OFF
	innodb replication delay	0
	innodb rollback on timeout	OFF
	innodb rollback segments	128
	innodb sort buffer size	1,000 MiB
	innodb spin wait delay	6
	innodb stats auto recalc	ON
	innodb stats include delete marked	OFF
	innodb stats method	nulls_equal
	innodb stats on metadata	OFF
	innodb stats persistent	ON
	innodb stats persistent sample pages	20
	innodb stats sample pages	16
	innodb stats transient sample pages	16
	innodb status output	OFF
	innodb status output locks	OFF
	innodb strict mode	OFF
	innodb support xa	ON
	innodb sync array size	1
	innodb sync spin loops	30
	innodb table locks	ON
	innodb temp data file path	ibtmp1:12M:autoextend:max:512M
	innodb thread concurrency	0
	innodb thread sleep delay	10.000
	innodb tmpdir
	innodb undo directory	./
	innodb undo log truncate	OFF
	innodb undo logs	128
	innodb undo tablespaces	0
	innodb use native aio	ON
	innodb version	5.7.42
	innodb write io threads	8
	interactive timeout	28.800
	internal tmp disk storage engine	MyISAM
	join buffer size	128,000 KiB
	keep files on create	OFF
	key buffer size	64,000 MiB
	key cache age threshold	300
	key cache block size	1,000 KiB
	key cache division limit	100
	keyring operations	ON
	large files support	ON
	large page size	0 B
	large pages	OFF
	lc messages	en_US
	(Wert für diese Sitzung)	de_DE
	lc messages dir	/opt/mysql-5.7.42/share/
	lc time names	en_US
	license	GPL
	local infile	ON
	lock wait timeout	31.536.000
	locked in memory	OFF
	log bin	ON
	log bin basename	/DBDATA/rdbng/log/mysql-bin
	log bin index	/DBDATA/rdbng/log/mysql-bin.index
	log bin trust function creators	ON
	log bin use v1 row events	OFF
	log builtin as identified by password	OFF
	log error	/DBDATA/rdbng/log/mysql-error.log
	log error verbosity	3
	log output	FILE
	log queries not using indexes	OFF
	log slave updates	OFF
	log slow admin statements	ON
	log slow slave statements	OFF
	log statements unsafe for binlog	ON
	log syslog	OFF
	log syslog facility	daemon
	log syslog include pid	ON
	log syslog tag
	log throttle queries not using indexes	0
	log timestamps	UTC
	log warnings	2
	long query time	5
	low priority updates	OFF
	lower case file system	OFF
	lower case table names	0
	master info repository	TABLE
	master verify checksum	OFF
	max allowed packet	67.108.864
	max binlog cache size	16,000 EiB
	max binlog size	1,000 GiB
	max binlog stmt cache size	16,000 EiB
	max connect errors	100.000
	max connections	3.000
	max delayed threads	20
	max digest length	1.024
	max error count	64
	max execution time	0
	max heap table size	16,000 MiB
	max insert delayed threads	20
	max join size	18.446.744.073.709.551.616
	max length for sort data	1.024
	max points in geometry	65.536
	max prepared stmt count	16.382
	max relay log size	0 B
	max seeks for key	18.446.744.073.709.551.616
	max sort length	1.024
	max sp recursion depth	0
	max tmp tables	32
	max user connections	20
	max write lock count	18.446.744.073.709.551.616
	metadata locks cache size	1.024
	metadata locks hash instances	8
	min examined row limit	0
	multi range count	256
	myisam data pointer size	6 B
	myisam max sort file size	8,000 EiB
	myisam mmap size	16,000 EiB
	myisam recover options	BACKUP,FORCE
	myisam sort buffer size	64,000 MiB
	myisam stats method	nulls_unequal
	myisam use mmap	OFF
	mysql native password proxy users	ON
	net buffer length	16.384
	net read timeout	3.600
	net retry count	10
	net write timeout	7.200
	new	OFF
	ngram token size	2
	offline mode	OFF
	old	OFF
	old alter table	OFF
	old passwords	0
	open files limit	1.000.000
	optimizer prune level	1
	optimizer search depth	62
	optimizer switch	index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,engine_condition_pushdown=on,index_condition_pushdown=on,mrr=on,mrr_cost_based=on,block_nested_loop=on,batched_key_access=off,materialization=on,semijoin=on,loosescan=on,firstmatch=on,duplicateweedout=on,subquery_materialization_cost_based=on,use_index_extensions=on,condition_fanout_filter=on,derived_merge=on,prefer_ordering_index=on
	optimizer trace	enabled=off,one_line=off
	optimizer trace features	greedy_search=on,range_optimizer=on,dynamic_range=on,repeated_subselect=on
	optimizer trace limit	1
	optimizer trace max mem size	16.384
	optimizer trace offset	-1
	parser max mem size	18.446.744.073.709.551.616
	performance schema	ON
	performance schema accounts size	-1
	performance schema digests size	10.000
	performance schema events stages history long size	10.000
	performance schema events stages history size	10
	performance schema events statements history long size	10.000
	performance schema events statements history size	10
	performance schema events transactions history long size	10.000
	performance schema events transactions history size	10
	performance schema events waits history long size	10.000
	performance schema events waits history size	10
	performance schema hosts size	-1
	performance schema max cond classes	80
	performance schema max cond instances	-1
	performance schema max digest length	1.024
	performance schema max file classes	80
	performance schema max file handles	32.768
	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	1.024
	performance schema max stage classes	150
	performance schema max statement classes	193
	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 show processlist	OFF
	performance schema users size	-1
	pid file	/DBDATA/rdbng/data/dba-rdb4658b.pid
	plugin dir	/opt/mysql/lib/plugin/
	port	3.306
	preload buffer size	32,000 KiB
	profiling	OFF
	profiling history size	15
	protocol version	10
	query alloc block size	8,000 KiB
	query cache limit	1,000 MiB
	query cache min res unit	4.096
	query cache size	0 B
	query cache type	OFF
	query cache wlock invalidate	OFF
	query prealloc size	8,000 KiB
	range alloc block size	4,000 KiB
	range optimizer max mem size	8.388.608
	rbr exec mode	STRICT
	read buffer size	128,000 KiB
	read only	OFF
	read rnd buffer size	256,000 KiB
	relay log	/DBDATA/rdbng/log/relay-bin
	relay log basename	/DBDATA/rdbng/log/relay-bin
	relay log index	/DBDATA/rdbng/log/relay-bin.index
	relay log info file	/DBDATA/rdbng/log/relay-log.info
	relay log info repository	TABLE
	relay log purge	ON
	relay log recovery	ON
	relay log space limit	0
	replication optimize for static plugin config	OFF
	replication sender observe commit only	OFF
	report host	dba-rdb4658b.db.server.lan
	report password
	report port	3.306
	report user	repl
	require secure transport	OFF
	rpl stop slave timeout	31.536.000
	secure auth	ON
	secure file priv	NULL
	server id	183.841.808
	server id bits	32
	server uuid	c720d85d-6825-11ef-a50f-001a4a151b4e
	session track gtids	OFF
	session track schema	ON
	session track state change	OFF
	session track system variables	time_zone,autocommit,character_set_client,character_set_results,character_set_connection
	session track transaction info	OFF
	sha256 password auto generate rsa keys	ON
	sha256 password private key path	private_key.pem
	sha256 password proxy users	OFF
	sha256 password public key path	public_key.pem
	show compatibility 56	OFF
	show create table verbosity	OFF
	show old temporals	OFF
	skip external locking	ON
	skip name resolve	OFF
	skip networking	OFF
	skip show database	OFF
	slave allow batching	OFF
	slave checkpoint group	512
	slave checkpoint period	300
	slave compressed protocol	ON
	slave exec mode	STRICT
	slave load tmpdir	/DBDATA/rdbng/tmp
	slave max allowed packet	1.073.741.824
	slave net timeout	60
	slave parallel type	DATABASE
	slave parallel workers	0
	slave pending jobs size max	16,000 MiB
	slave preserve commit order	OFF
	slave rows search algorithms	INDEX_SCAN,HASH_SCAN
	slave skip errors	OFF
	slave sql verify checksum	ON
	slave transaction retries	100
	slave type conversions
	slow launch time	2
	slow query log	ON
	slow query log file	/DBDATA/rdbng/log/mysql-slow.log
	socket	/tmp/mysql-3306.sock
	sort buffer size	256,000 KiB
	sql auto is null	OFF
	sql big selects	ON
	sql buffer result	OFF
	sql log off	OFF
	sql mode
	sql notes	ON
	sql quote show create	ON
	sql safe updates	OFF
	sql select limit	18.446.744.073.709.551.616
	sql slave skip counter	0
	sql warnings	OFF
	ssl ca	/etc/ssl/dba/pukiautomatedissuingca2022rsa-chain.pem
	ssl capath
	ssl cert	/etc/ssl/dba/dba.pem
	ssl cipher
	ssl crl
	ssl crlpath
	ssl key	/etc/ssl/dba/dba_pkcs1.key
	stored program cache	256
	super read only	OFF
	sync binlog	1
	sync frm	ON
	sync master info	1
	sync relay log	10.000
	sync relay log info	1
	system time zone	CEST
	table definition cache	3.400
	table open cache	6.000
	table open cache instances	16
	thread cache size	100
	thread handling	one-thread-per-connection
	thread stack	262.144
	time format	%H:%i:%s
	time zone	SYSTEM
	tls version	TLSv1,TLSv1.1,TLSv1.2
	tmp table size	16,000 MiB
	tmpdir	/DBDATA/rdbng/tmp
	transaction alloc block size	8,000 KiB
	transaction isolation	REPEATABLE-READ
	transaction prealloc size	4,000 KiB
	transaction read only	OFF

Aktion

Variable

Wert

auto generate certs

auto increment increment

auto increment offset

autocommit

automatic sp privileges

avoid temporal upgrade

OFF

back log

650

basedir

/opt/mysql-5.7.42/

big tables

OFF

bind address

0.0.0.0

binlog cache size

4,000 MiB

binlog checksum

CRC32

binlog direct non transactional updates

OFF

binlog error action

ABORT_SERVER

binlog format

ROW

binlog group commit sync delay

binlog group commit sync no delay count

binlog gtid simple recovery

binlog max flush queue time

binlog order commits

binlog row image

FULL

binlog rows query log events

OFF

binlog stmt cache size

1,000 MiB

binlog transaction dependency history size

25.000

binlog transaction dependency tracking

COMMIT_ORDER

block encryption mode

aes-128-ecb

bulk insert buffer size

8,000 MiB

character set client

utf8

(Wert für diese Sitzung)

utf8mb4

character set connection

utf8

(Wert für diese Sitzung)

utf8mb4

character set database

utf8

character set filesystem

binary

character set results

utf8

(Wert für diese Sitzung)

utf8mb4

character set server

utf8

character set system

utf8

character sets dir

/opt/mysql-5.7.42/share/charsets/

check proxy users

collation connection

utf8_general_ci

(Wert für diese Sitzung)

utf8mb4_unicode_ci

collation database

utf8_general_ci

collation server

utf8_general_ci

completion type

NO_CHAIN

concurrent insert

AUTO

connect timeout

core file

OFF

datadir

/DBDATA/rdbng/data/

date format

%Y-%m-%d

datetime format

%Y-%m-%d %H:%i:%s

default authentication plugin

mysql_native_password

default password lifetime

default storage engine

InnoDB

default tmp storage engine

InnoDB

default week format

delay key write

delayed insert limit

100

delayed insert timeout

300

delayed queue size

1.000

disabled storage engines

disconnect on expired password

div precision increment

end markers in json

OFF

enforce gtid consistency

OFF

eq range index dive limit

200

event scheduler

OFF

expire logs days

explicit defaults for timestamp

OFF

flush

OFF

flush time

foreign key checks

ft boolean syntax

+ -><()~*:""&|

ft max word len

ft min word len

ft query expansion limit

ft stopword file

(built-in)

general log

OFF

general log file

/DBDATA/rdbng/log/mysql-general.log

group concat max len

1.024

gtid executed

gtid executed compression period

1.000

gtid mode

OFF

gtid owned

gtid purged

have compress

YES

have crypt

YES

have dynamic loading

YES

have geometry

YES

have openssl

YES

have profiling

YES

have query cache

YES

have rtree keys

YES

have ssl

YES

have statement timeout

YES

have symlink

DISABLED

host cache size

753

hostname

dba-rdb4658b

ignore builtin innodb

OFF

ignore db dirs

init connect

init file

init slave

innodb adaptive flushing

innodb adaptive flushing lwm

innodb adaptive hash index

innodb adaptive hash index parts

innodb adaptive max sleep delay

150.000

innodb api bk commit interval

innodb api disable rowlock

OFF

innodb api enable binlog

OFF

innodb api enable mdl

OFF

innodb api trx level

innodb autoextend increment

256

innodb autoinc lock mode

innodb buffer pool chunk size

128,000 MiB

innodb buffer pool dump at shutdown

innodb buffer pool dump now

OFF

innodb buffer pool dump pct

innodb buffer pool filename

ib_buffer_pool

innodb buffer pool instances

innodb buffer pool load abort

OFF

innodb buffer pool load at startup

innodb buffer pool load now

OFF

innodb buffer pool size

12,000 GiB

innodb change buffer max size

innodb change buffering

all

innodb checksum algorithm

crc32

innodb checksums

innodb cmp per index enabled

OFF

innodb commit concurrency

innodb compression failure threshold pct

innodb compression level

innodb compression pad pct max

innodb concurrency tickets

5.000

innodb data file path

ibdata1:128M:autoextend

innodb data home dir

/DBDATA/rdbng/data

innodb deadlock detect

innodb default row format

dynamic

innodb disable sort file cache

OFF

innodb doublewrite

innodb fast shutdown

innodb file format

Barracuda

innodb file format check

innodb file format max

Barracuda

innodb file per table

innodb fill factor

100

innodb flush log at timeout

innodb flush log at trx commit

innodb flush method

O_DIRECT

innodb flush neighbors

innodb flush sync

innodb flushing avg loops

innodb force load corrupted

OFF

innodb force recovery

innodb ft aux table

innodb ft cache size

8.000.000

innodb ft enable diag print

OFF

innodb ft enable stopword

innodb ft max token size

innodb ft min token size

innodb ft num word optimize

2.000

innodb ft result cache limit

2.000.000.000

innodb ft server stopword table

innodb ft sort pll degree

innodb ft total cache size

640.000.000

innodb ft user stopword table

innodb io capacity

200

innodb io capacity max

2.000

innodb large prefix

innodb lock wait timeout

innodb locks unsafe for binlog

OFF

innodb log buffer size

16,000 MiB

innodb log checksums

innodb log compressed pages

innodb log file size

512,000 MiB

innodb log files in group

innodb log group home dir

/DBDATA/rdbng/data

innodb log write ahead size

8,000 KiB

innodb lru scan depth

256

innodb max dirty pages pct

innodb max dirty pages pct lwm

innodb max purge lag

innodb max purge lag delay

innodb max undo log size

1,000 GiB

innodb monitor disable

innodb monitor enable

innodb monitor reset

innodb monitor reset all

innodb numa interleave

OFF

innodb old blocks pct

innodb old blocks time

1.000

innodb online alter log max size

128,000 MiB

innodb open files

6.000

innodb optimize fulltext only

OFF

innodb page cleaners

innodb page size

16,000 KiB

innodb print all deadlocks

OFF

innodb purge batch size

300

innodb purge rseg truncate frequency

128

innodb purge threads

innodb random read ahead

OFF

innodb read ahead threshold

innodb read io threads

innodb read only

OFF

innodb replication delay

innodb rollback on timeout

OFF

innodb rollback segments

128

innodb sort buffer size

1,000 MiB

innodb spin wait delay

innodb stats auto recalc

innodb stats include delete marked

OFF

innodb stats method

nulls_equal

innodb stats on metadata

OFF

innodb stats persistent

innodb stats persistent sample pages

innodb stats sample pages

innodb stats transient sample pages

innodb status output

OFF

innodb status output locks

OFF

innodb strict mode

OFF

innodb support xa

innodb sync array size

innodb sync spin loops

innodb table locks

innodb temp data file path

ibtmp1:12M:autoextend:max:512M

innodb thread concurrency

innodb thread sleep delay

10.000

innodb tmpdir

innodb undo directory

innodb undo log truncate

OFF

innodb undo logs

128

innodb undo tablespaces

innodb use native aio

innodb version

5.7.42

innodb write io threads

interactive timeout

28.800

internal tmp disk storage engine

MyISAM

join buffer size

128,000 KiB

keep files on create

OFF

key buffer size

64,000 MiB

key cache age threshold

300

key cache block size

1,000 KiB

key cache division limit

100

keyring operations

large files support

large page size

0 B

large pages

OFF

lc messages

en_US

(Wert für diese Sitzung)

de_DE

lc messages dir

/opt/mysql-5.7.42/share/

lc time names

en_US

license

GPL

local infile

lock wait timeout

31.536.000

locked in memory

OFF

log bin

log bin basename

/DBDATA/rdbng/log/mysql-bin

log bin index

/DBDATA/rdbng/log/mysql-bin.index

log bin trust function creators

log bin use v1 row events

OFF

log builtin as identified by password

OFF

log error

/DBDATA/rdbng/log/mysql-error.log

log error verbosity

log output

FILE

log queries not using indexes

OFF

log slave updates

OFF

log slow admin statements

log slow slave statements

OFF

log statements unsafe for binlog

log syslog

OFF

log syslog facility

daemon

log syslog include pid

log syslog tag

log throttle queries not using indexes

log timestamps

UTC

log warnings

long query time

low priority updates

OFF

lower case file system

OFF

lower case table names

master info repository

TABLE

master verify checksum

OFF

max allowed packet

67.108.864

max binlog cache size

16,000 EiB

max binlog size

1,000 GiB

max binlog stmt cache size

16,000 EiB

max connect errors

100.000

max connections

3.000

max delayed threads

max digest length

1.024

max error count

max execution time

max heap table size

16,000 MiB

max insert delayed threads

max join size

18.446.744.073.709.551.616

max length for sort data

1.024

max points in geometry

65.536

max prepared stmt count

16.382

max relay log size

0 B

max seeks for key

18.446.744.073.709.551.616

max sort length

1.024

max sp recursion depth

max tmp tables

max user connections

max write lock count

18.446.744.073.709.551.616

metadata locks cache size

1.024

metadata locks hash instances

min examined row limit

multi range count

256

myisam data pointer size

6 B

myisam max sort file size

8,000 EiB

myisam mmap size

16,000 EiB

myisam recover options

BACKUP,FORCE

myisam sort buffer size

64,000 MiB

myisam stats method

nulls_unequal

myisam use mmap

OFF

mysql native password proxy users

net buffer length

16.384

net read timeout

3.600

net retry count

net write timeout

7.200

new

OFF

ngram token size

offline mode

OFF

old

OFF

old alter table

OFF

old passwords

open files limit

1.000.000

optimizer prune level

optimizer search depth

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,prefer_ordering_index=on

optimizer trace

enabled=off,one_line=off

optimizer trace features

greedy_search=on,range_optimizer=on,dynamic_range=on,repeated_subselect=on

optimizer trace limit

optimizer trace max mem size

16.384

optimizer trace offset

-1

parser max mem size

18.446.744.073.709.551.616

performance schema