Recent
Favorites

Drop files here

SQL upload ( 0 ) x-

Server: rdbms.strato.de
Page-related settingsClick on the bar to scroll to top of page
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse Expand Show trace Hide trace Count Time taken
Options
Set default





Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database Queried time

Server variables and settings Documentation

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