Drop files here

SQL upload ( 0 ) x-

Server: localhost
Page-related settingsClick on the bar to scroll to top of page
Press Ctrl+Enter to execute query
x
 
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:
Bookmarks
Refresh
Add
No bookmarks
Add bookmark
xxxxxxxxxx
 
Options
Set default





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

Server variables and settings Documentation

Filters
ActionVariableSession value / Global value
Edit Editaria block size 8,192
Edit Editaria checkpoint interval 30
Edit Editaria checkpoint log activity 1,048,576
Edit Editaria encrypt tables OFF
Edit Editaria force start after recovery failures 0
Edit Editaria group commit none
Edit Editaria group commit interval 0
Edit Editaria log file size 1,073,741,824
Edit Editaria log purge type immediate
Edit Editaria max sort file size 9,223,372,036,853,727,232
Edit Editaria page checksum ON
Edit Editaria pagecache age threshold 300
Edit Editaria pagecache buffer size 134,217,728
Edit Editaria pagecache division limit 100
Edit Editaria pagecache file hash size 512
Edit Editaria recover NORMAL
Edit Editaria repair threads 1
Edit Editaria sort buffer size 268,434,432
Edit Editaria stats method nulls_unequal
Edit Editaria sync log dir NEWFILE
Edit Editaria used for temp tables ON
Edit Editauto increment incrementDocumentation 1
Edit Editauto increment offsetDocumentation 1
Edit EditautocommitDocumentation ON
Edit Editautomatic sp privilegesDocumentation ON
Edit Editback logDocumentation 80
Edit EditbasedirDocumentation /opt/lampp
Edit Editbig tablesDocumentation OFF
Edit Editbinlog annotate row events OFF
Edit Editbinlog cache sizeDocumentation 32 KiB
Edit Editbinlog checksumDocumentation NONE
Edit Editbinlog commit wait count 0
Edit Editbinlog commit wait usec 100,000
Edit Editbinlog direct non transactional updatesDocumentation OFF
Edit Editbinlog formatDocumentation STATEMENT
Edit Editbinlog optimize thread scheduling ON
Edit Editbinlog row imageDocumentation FULL
Edit Editbinlog stmt cache sizeDocumentation 32 KiB
Edit Editbulk insert buffer sizeDocumentation 8 MiB
Edit Editcharacter set clientDocumentation latin1
(Session value) utf8mb4
Edit Editcharacter set connectionDocumentation latin1
(Session value) utf8mb4
Edit Editcharacter set databaseDocumentation latin1
Edit Editcharacter set filesystemDocumentation binary
Edit Editcharacter set resultsDocumentation latin1
(Session value) utf8mb4
Edit Editcharacter set serverDocumentation latin1
Edit Editcharacter set systemDocumentation utf8
Edit Editcharacter sets dirDocumentation /opt/lampp/share/charsets/
Edit Editcollation connectionDocumentation latin1_swedish_ci
(Session value) utf8mb4_general_ci
Edit Editcollation databaseDocumentation latin1_swedish_ci
Edit Editcollation serverDocumentation latin1_swedish_ci
Edit Editcompletion typeDocumentation NO_CHAIN
Edit Editconcurrent insertDocumentation AUTO
Edit Editconnect timeoutDocumentation 10
Edit EditdatadirDocumentation /opt/lampp/var/mysql/
Edit Editdate formatDocumentation %Y-%m-%d
Edit Editdatetime formatDocumentation %Y-%m-%d %H:%i:%s
Edit Editdeadlock search depth long 15
Edit Editdeadlock search depth short 4
Edit Editdeadlock timeout long 50,000,000
Edit Editdeadlock timeout short 10,000
Edit Editdebug no thread alarm OFF
Edit Editdefault regex flags 
Edit Editdefault storage engineDocumentation InnoDB
Edit Editdefault tmp storage engineDocumentation 
Edit Editdefault week formatDocumentation 0
Edit Editdelay key writeDocumentation ON
Edit Editdelayed insert limitDocumentation 100
Edit Editdelayed insert timeoutDocumentation 300
Edit Editdelayed queue sizeDocumentation 1,000
Edit Editdiv precision incrementDocumentation 4
Edit Editencrypt binlog OFF
Edit Editencrypt tmp disk tables OFF
Edit Editencrypt tmp files OFF
Edit Editenforce storage engine 
Edit Editevent schedulerDocumentation OFF
Edit Editexpensive subquery limit 100
Edit Editexpire logs daysDocumentation 0
Edit Editexplicit defaults for timestampDocumentation OFF
Edit Editextra max connections 1
Edit Editextra port 0
Edit EditflushDocumentation OFF
Edit Editflush timeDocumentation 0
Edit Editforeign key checksDocumentation ON
Edit Editft boolean syntaxDocumentation + -><()~*:""&|
Edit Editft max word lenDocumentation 84
Edit Editft min word lenDocumentation 4
Edit Editft query expansion limitDocumentation 20
Edit Editft stopword fileDocumentation (built-in)
Edit Editgeneral logDocumentation OFF
Edit Editgeneral log fileDocumentation ubuntu-s-1vcpu-2gb-blr1-01.log
Edit Editgroup concat max lenDocumentation 1,024
Edit Editgtid binlog pos 
Edit Editgtid binlog state 
Edit Editgtid current pos 
Edit Editgtid domain id 0
Edit Editgtid ignore duplicates OFF
Edit Editgtid slave pos 
Edit Editgtid strict mode OFF
Edit Edithave compressDocumentation YES
Edit Edithave cryptDocumentation YES
Edit Edithave dynamic loadingDocumentation YES
Edit Edithave geometryDocumentation YES
Edit Edithave opensslDocumentation YES
Edit Edithave profilingDocumentation YES
Edit Edithave query cacheDocumentation YES
Edit Edithave rtree keysDocumentation YES
Edit Edithave sslDocumentation DISABLED
Edit Edithave symlinkDocumentation YES
Edit Edithistogram size 0
Edit Edithistogram type SINGLE_PREC_HB
Edit Edithost cache sizeDocumentation 279
Edit EdithostnameDocumentation ubuntu-s-1vcpu-2gb-blr1-01
Edit Editignore builtin innodbDocumentation OFF
Edit Editignore db dirsDocumentation 
Edit Editinit connectDocumentation 
Edit Editinit fileDocumentation 
Edit Editinit slaveDocumentation 
Edit Editinnodb adaptive flushingDocumentation ON
Edit Editinnodb adaptive flushing lwmDocumentation 10
Edit Editinnodb adaptive hash indexDocumentation ON
Edit Editinnodb adaptive hash index partitions 1
Edit Editinnodb adaptive max sleep delayDocumentation 150,000
Edit Editinnodb additional mem pool sizeDocumentation 8 MiB
Edit Editinnodb api bk commit intervalDocumentation 5
Edit Editinnodb api disable rowlockDocumentation OFF
Edit Editinnodb api enable binlogDocumentation OFF
Edit Editinnodb api enable mdlDocumentation OFF
Edit Editinnodb api trx levelDocumentation 0
Edit Editinnodb autoextend incrementDocumentation 64
Edit Editinnodb autoinc lock modeDocumentation 1
Edit Editinnodb background scrub data check interval 3,600
Edit Editinnodb background scrub data compressed OFF
Edit Editinnodb background scrub data interval 604,800
Edit Editinnodb background scrub data uncompressed OFF
Edit Editinnodb buf dump status frequency 0
Edit Editinnodb buffer pool dump at shutdownDocumentation OFF
Edit Editinnodb buffer pool dump nowDocumentation OFF
Edit Editinnodb buffer pool dump pct 100
Edit Editinnodb buffer pool filenameDocumentation ib_buffer_pool
Edit Editinnodb buffer pool instancesDocumentation 8
Edit Editinnodb buffer pool load abortDocumentation OFF
Edit Editinnodb buffer pool load at startupDocumentation OFF
Edit Editinnodb buffer pool load nowDocumentation OFF
Edit Editinnodb buffer pool populate OFF
Edit Editinnodb buffer pool sizeDocumentation 512 MiB
Edit Editinnodb change buffer max sizeDocumentation 25
Edit Editinnodb change bufferingDocumentation all
Edit Editinnodb checksum algorithmDocumentation INNODB
Edit Editinnodb checksumsDocumentation ON
Edit Editinnodb cleaner lsn age factor HIGH_CHECKPOINT
Edit Editinnodb cmp per index enabledDocumentation OFF
Edit Editinnodb commit concurrencyDocumentation 0
Edit Editinnodb compression algorithm none
Edit Editinnodb compression failure threshold pctDocumentation 5
Edit Editinnodb compression levelDocumentation 6
Edit Editinnodb compression pad pct maxDocumentation 50
Edit Editinnodb concurrency ticketsDocumentation 5,000
Edit Editinnodb corrupt table action assert
Edit Editinnodb data file pathDocumentation ibdata1:10M:autoextend
Edit Editinnodb data home dirDocumentation /opt/lampp/var/mysql/
Edit Editinnodb default encryption key id 1
Edit Editinnodb defragment OFF
Edit Editinnodb defragment fill factor 1
Edit Editinnodb defragment fill factor n recs 20
Edit Editinnodb defragment frequency 40
Edit Editinnodb defragment n pages 7
Edit Editinnodb defragment stats accuracy 0
Edit Editinnodb disable sort file cacheDocumentation OFF
Edit Editinnodb disallow writes OFF
Edit Editinnodb doublewriteDocumentation ON
Edit Editinnodb empty free list algorithm BACKOFF
Edit Editinnodb encrypt log OFF
Edit Editinnodb encrypt tables OFF
Edit Editinnodb encryption rotate key age 1
Edit Editinnodb encryption rotation iops 100
Edit Editinnodb encryption threads 0
Edit Editinnodb fake changes OFF
Edit Editinnodb fast shutdownDocumentation 1
Edit Editinnodb fatal semaphore wait threshold 600
Edit Editinnodb file formatDocumentation Antelope
Edit Editinnodb file format checkDocumentation ON
Edit Editinnodb file format maxDocumentation Antelope
Edit Editinnodb file per tableDocumentation ON
Edit Editinnodb flush log at timeoutDocumentation 1
Edit Editinnodb flush log at trx commitDocumentation 1
Edit Editinnodb flush methodDocumentation 
Edit Editinnodb flush neighborsDocumentation 1
Edit Editinnodb flushing avg loopsDocumentation 30
Edit Editinnodb force load corruptedDocumentation OFF
Edit Editinnodb force primary key OFF
Edit Editinnodb force recoveryDocumentation 0
Edit Editinnodb foreground preflush EXPONENTIAL_BACKOFF
Edit Editinnodb ft aux tableDocumentation 
Edit Editinnodb ft cache sizeDocumentation 8,000,000
Edit Editinnodb ft enable diag printDocumentation OFF
Edit Editinnodb ft enable stopwordDocumentation ON
Edit Editinnodb ft max token sizeDocumentation 84
Edit Editinnodb ft min token sizeDocumentation 3
Edit Editinnodb ft num word optimizeDocumentation 2,000
Edit Editinnodb ft result cache limitDocumentation 2,000,000,000
Edit Editinnodb ft server stopword tableDocumentation 
Edit Editinnodb ft sort pll degreeDocumentation 2
Edit Editinnodb ft total cache sizeDocumentation 640,000,000
Edit Editinnodb ft user stopword tableDocumentation 
Edit Editinnodb idle flush pct 100
Edit Editinnodb immediate scrub data uncompressed OFF
Edit Editinnodb instrument semaphores OFF
Edit Editinnodb io capacityDocumentation 200
Edit Editinnodb io capacity maxDocumentation 2,000
Edit Editinnodb kill idle transaction 0
Edit Editinnodb large prefixDocumentation OFF
Edit Editinnodb lock schedule algorithm fcfs
Edit Editinnodb lock wait timeoutDocumentation 50
Edit Editinnodb locking fake changes ON
Edit Editinnodb locks unsafe for binlogDocumentation OFF
Edit Editinnodb log arch dir /opt/lampp/var/mysql/
Edit Editinnodb log arch expire sec 0
Edit Editinnodb log archive OFF
Edit Editinnodb log block size 512
Edit Editinnodb log buffer sizeDocumentation 8 MiB
Edit Editinnodb log checksum algorithm INNODB
Edit Editinnodb log compressed pagesDocumentation OFF
Edit Editinnodb log file sizeDocumentation 5 MiB
Edit Editinnodb log files in groupDocumentation 2
Edit Editinnodb log group home dirDocumentation /opt/lampp/var/mysql/
Edit Editinnodb lru scan depthDocumentation 1,024
Edit Editinnodb max bitmap file size 104,857,600
Edit Editinnodb max changed pages 1,000,000
Edit Editinnodb max dirty pages pctDocumentation 75
Edit Editinnodb max dirty pages pct lwmDocumentation  <1
Edit Editinnodb max purge lagDocumentation 0
Edit Editinnodb max purge lag delayDocumentation 0
Edit Editinnodb mirrored log groupsDocumentation 1
Edit Editinnodb monitor disableDocumentation 
Edit Editinnodb monitor enableDocumentation 
Edit Editinnodb monitor resetDocumentation 
Edit Editinnodb monitor reset allDocumentation 
Edit Editinnodb mtflush threads 8
Edit Editinnodb old blocks pctDocumentation 37
Edit Editinnodb old blocks timeDocumentation 1,000
Edit Editinnodb online alter log max sizeDocumentation 134,217,728
Edit Editinnodb open filesDocumentation 300
Edit Editinnodb optimize fulltext onlyDocumentation OFF
Edit Editinnodb page sizeDocumentation 16,384
Edit Editinnodb prefix index cluster optimization OFF
Edit Editinnodb print all deadlocksDocumentation OFF
Edit Editinnodb purge batch sizeDocumentation 300
Edit Editinnodb purge threadsDocumentation 1
Edit Editinnodb random read aheadDocumentation OFF
Edit Editinnodb read ahead thresholdDocumentation 56
Edit Editinnodb read io threadsDocumentation 4
Edit Editinnodb read onlyDocumentation OFF
Edit Editinnodb replication delayDocumentation 0
Edit Editinnodb rollback on timeoutDocumentation OFF
Edit Editinnodb rollback segmentsDocumentation 128
Edit Editinnodb sched priority cleaner 19
Edit Editinnodb scrub log OFF
Edit Editinnodb scrub log speed 256
Edit Editinnodb show locks held 10
Edit Editinnodb show verbose locks 0
Edit Editinnodb simulate comp failures 0
Edit Editinnodb sort buffer sizeDocumentation 1,048,576
Edit Editinnodb spin wait delayDocumentation 6
Edit Editinnodb stats auto recalcDocumentation ON
Edit Editinnodb stats methodDocumentation nulls_equal
Edit Editinnodb stats modified counter 0
Edit Editinnodb stats on metadataDocumentation OFF
Edit Editinnodb stats persistentDocumentation ON
Edit Editinnodb stats persistent sample pagesDocumentation 20
Edit Editinnodb stats sample pagesDocumentation 8
Edit Editinnodb stats traditional ON
Edit Editinnodb stats transient sample pagesDocumentation 8
Edit Editinnodb status outputDocumentation OFF
Edit Editinnodb status output locksDocumentation OFF
Edit Editinnodb strict modeDocumentation OFF
Edit Editinnodb support xaDocumentation ON
Edit Editinnodb sync array sizeDocumentation 1
Edit Editinnodb sync spin loopsDocumentation 30
Edit Editinnodb table locksDocumentation ON
Edit Editinnodb thread concurrencyDocumentation 0
Edit Editinnodb thread sleep delayDocumentation 10,000
Edit Editinnodb tmpdir 
Edit Editinnodb track changed pages OFF
Edit Editinnodb undo directoryDocumentation .
Edit Editinnodb undo logsDocumentation 128
Edit Editinnodb undo tablespacesDocumentation 0
Edit Editinnodb use atomic writes OFF
Edit Editinnodb use fallocate OFF
Edit Editinnodb use global flush log at trx commit ON
Edit Editinnodb use mtflush OFF
Edit Editinnodb use native aioDocumentation OFF
Edit Editinnodb use stacktrace OFF
Edit Editinnodb use sys mallocDocumentation ON
Edit Editinnodb use trim OFF
Edit Editinnodb versionDocumentation 5.6.32-79.0
Edit Editinnodb write io threadsDocumentation 4
Edit Editinteractive timeoutDocumentation 28,800
Edit Editjoin buffer sizeDocumentation 256 KiB
Edit Editjoin buffer space limit 2,097,152
Edit Editjoin cache level 2
Edit Editkeep files on createDocumentation OFF
Edit Editkey buffer sizeDocumentation 16 MiB
Edit Editkey cache age thresholdDocumentation 300
Edit Editkey cache block sizeDocumentation 1 KiB
Edit Editkey cache division limitDocumentation 100
Edit Editkey cache file hash size 512
Edit Editkey cache segments 0
Edit Editlarge files supportDocumentation ON
Edit Editlarge page sizeDocumentation 0 B
Edit Editlarge pagesDocumentation OFF
Edit Editlc messagesDocumentation en_US
Edit Editlc messages dirDocumentation 
Edit Editlc time namesDocumentation en_US
Edit EditlicenseDocumentation GPL
Edit Editlocal infileDocumentation ON
Edit Editlock wait timeoutDocumentation 31,536,000
Edit Editlocked in memoryDocumentation OFF
Edit Editlog binDocumentation OFF
Edit Editlog bin basenameDocumentation 
Edit Editlog bin indexDocumentation 
Edit Editlog bin trust function creatorsDocumentation OFF
Edit Editlog errorDocumentation /opt/lampp/var/mysql/ubuntu-s-1vcpu-2gb-blr1-01.err
Edit Editlog outputDocumentation FILE
Edit Editlog queries not using indexesDocumentation OFF
Edit Editlog slave updatesDocumentation OFF
Edit Editlog slow admin statementsDocumentation OFF
Edit Editlog slow filter admin,filesort,filesort_on_disk,full_join,full_scan,query_cache,query_cache_miss,tmp_table,tmp_table_on_disk
Edit Editlog slow rate limit 1
Edit Editlog slow slave statementsDocumentation OFF
Edit Editlog slow verbosity 
Edit Editlog tc size 24,576
Edit Editlog warningsDocumentation 1
Edit Editlong query timeDocumentation 10
Edit Editlow priority updatesDocumentation OFF
Edit Editlower case file systemDocumentation OFF
Edit Editlower case table namesDocumentation 0
Edit Editmaster verify checksumDocumentation OFF
Edit Editmax allowed packetDocumentation 1,048,576
Edit Editmax binlog cache sizeDocumentation 16 EiB
Edit Editmax binlog sizeDocumentation 1 GiB
Edit Editmax binlog stmt cache sizeDocumentation 16 EiB
Edit Editmax connect errorsDocumentation 100
Edit Editmax connectionsDocumentation 151
Edit Editmax delayed threadsDocumentation 20
Edit Editmax digest length 1,024
Edit Editmax error countDocumentation 64
Edit Editmax heap table sizeDocumentation 16 MiB
Edit Editmax insert delayed threadsDocumentation 20
Edit Editmax join sizeDocumentation 18,446,744,073,709,551,616
Edit Editmax length for sort dataDocumentation 1,024
Edit Editmax long data sizeDocumentation 1,048,576
Edit Editmax prepared stmt countDocumentation 16,382
Edit Editmax relay log sizeDocumentation 1 GiB
Edit Editmax seeks for keyDocumentation 4,294,967,295
Edit Editmax sort lengthDocumentation 1,024
Edit Editmax sp recursion depthDocumentation 0
Edit Editmax statement time 0
Edit Editmax tmp tablesDocumentation 32
Edit Editmax user connectionsDocumentation 0
Edit Editmax write lock countDocumentation 4,294,967,295
Edit Editmetadata locks cache sizeDocumentation 1,024
Edit Editmetadata locks hash instancesDocumentation 8
Edit Editmin examined row limitDocumentation 0
Edit Editmrr buffer size 262,144
Edit Editmulti range countDocumentation 256
Edit Editmyisam block size 1,024
Edit Editmyisam data pointer sizeDocumentation 6 B
Edit Editmyisam max sort file sizeDocumentation 8 EiB
Edit Editmyisam mmap sizeDocumentation 16 EiB
Edit Editmyisam recover optionsDocumentation DEFAULT
Edit Editmyisam repair threadsDocumentation 1
Edit Editmyisam sort buffer sizeDocumentation 8 MiB
Edit Editmyisam stats methodDocumentation NULLS_UNEQUAL
Edit Editmyisam use mmapDocumentation OFF
Edit Editmysql56 temporal format ON
Edit Editnet buffer lengthDocumentation 8,192
Edit Editnet read timeoutDocumentation 30
Edit Editnet retry countDocumentation 10
Edit Editnet write timeoutDocumentation 60
Edit EditoldDocumentation OFF
Edit Editold alter tableDocumentation OFF
Edit Editold mode 
Edit Editold passwordsDocumentation OFF
Edit Editopen files limitDocumentation 1,024
Edit Editoptimizer prune levelDocumentation 1
Edit Editoptimizer search depthDocumentation 62
Edit Editoptimizer selectivity sampling limit 100
Edit Editoptimizer switchDocumentation 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=off,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=off
Edit Editoptimizer use condition selectivity 1
Edit Editperformance schemaDocumentation OFF
Edit Editperformance schema accounts sizeDocumentation -1
Edit Editperformance schema digests sizeDocumentation -1
Edit Editperformance schema events stages history long sizeDocumentation -1
Edit Editperformance schema events stages history sizeDocumentation -1
Edit Editperformance schema events statements history long sizeDocumentation -1
Edit Editperformance schema events statements history sizeDocumentation -1
Edit Editperformance schema events waits history long sizeDocumentation -1
Edit Editperformance schema events waits history sizeDocumentation -1
Edit Editperformance schema hosts sizeDocumentation -1
Edit Editperformance schema max cond classesDocumentation 80
Edit Editperformance schema max cond instancesDocumentation -1
Edit Editperformance schema max digest length 1,024
Edit Editperformance schema max file classesDocumentation 50
Edit Editperformance schema max file handlesDocumentation 32,768
Edit Editperformance schema max file instancesDocumentation -1
Edit Editperformance schema max mutex classesDocumentation 200
Edit Editperformance schema max mutex instancesDocumentation -1
Edit Editperformance schema max rwlock classesDocumentation 40
Edit Editperformance schema max rwlock instancesDocumentation -1
Edit Editperformance schema max socket classesDocumentation 10
Edit Editperformance schema max socket instancesDocumentation -1
Edit Editperformance schema max stage classesDocumentation 150
Edit Editperformance schema max statement classesDocumentation 178
Edit Editperformance schema max table handlesDocumentation -1
Edit Editperformance schema max table instancesDocumentation -1
Edit Editperformance schema max thread classesDocumentation 50
Edit Editperformance schema max thread instancesDocumentation -1
Edit Editperformance schema session connect attrs sizeDocumentation -1
Edit Editperformance schema setup actors sizeDocumentation 100
Edit Editperformance schema setup objects sizeDocumentation 100
Edit Editperformance schema users sizeDocumentation -1
Edit Editpid fileDocumentation /opt/lampp/var/mysql/ubuntu-s-1vcpu-2gb-blr1-01.pid
Edit Editplugin dirDocumentation /opt/lampp/lib/mysql/plugin/
Edit Editplugin maturity unknown
Edit EditportDocumentation 3,306
Edit Editpreload buffer sizeDocumentation 32 KiB
Edit EditprofilingDocumentation OFF
Edit Editprofiling history sizeDocumentation 15
Edit Editprogress report time 5
Edit Editprotocol versionDocumentation 10
Edit Editquery alloc block sizeDocumentation 16 KiB
Edit Editquery cache limitDocumentation 1 MiB
Edit Editquery cache min res unitDocumentation 4,096
Edit Editquery cache sizeDocumentation 1 MiB
Edit Editquery cache strip comments OFF
Edit Editquery cache typeDocumentation OFF
Edit Editquery cache wlock invalidateDocumentation OFF
Edit Editquery prealloc sizeDocumentation 24 KiB
Edit Editrange alloc block sizeDocumentation 4 KiB
Edit Editread buffer sizeDocumentation 256 KiB
Edit Editread onlyDocumentation OFF
Edit Editread rnd buffer sizeDocumentation 512 KiB
Edit Editrelay logDocumentation 
Edit Editrelay log basenameDocumentation 
Edit Editrelay log indexDocumentation 
Edit Editrelay log info fileDocumentation relay-log.info
Edit Editrelay log purgeDocumentation ON
Edit Editrelay log recoveryDocumentation OFF
Edit Editrelay log space limitDocumentation 0
Edit Editreplicate annotate row events OFF
Edit Editreplicate do db 
Edit Editreplicate do table 
Edit Editreplicate events marked for skip REPLICATE
Edit Editreplicate ignore db 
Edit Editreplicate ignore table 
Edit Editreplicate wild do table 
Edit Editreplicate wild ignore table 
Edit Editreport hostDocumentation 
Edit Editreport passwordDocumentation 
Edit Editreport portDocumentation 3,306
Edit Editreport userDocumentation 
Edit Editrowid merge buff size 8,388,608
Edit Editsecure authDocumentation ON
Edit Editsecure file privDocumentation 
Edit Editserver idDocumentation 1
Edit Editskip external lockingDocumentation ON
Edit Editskip name resolveDocumentation OFF
Edit Editskip networkingDocumentation OFF
Edit Editskip show databaseDocumentation OFF
Edit Editslave compressed protocolDocumentation OFF
Edit Editslave ddl exec mode IDEMPOTENT
Edit Editslave domain parallel threads 0
Edit Editslave exec modeDocumentation STRICT
Edit Editslave load tmpdirDocumentation /tmp
Edit Editslave max allowed packetDocumentation 1,073,741,824
Edit Editslave net timeoutDocumentation 3,600
Edit Editslave parallel max queued 131,072
Edit Editslave parallel mode conservative
Edit Editslave parallel threads 0
Edit Editslave run triggers for rbr NO
Edit Editslave skip errorsDocumentation OFF
Edit Editslave sql verify checksumDocumentation ON
Edit Editslave transaction retriesDocumentation 10
Edit Editslave type conversionsDocumentation 
Edit Editslow launch timeDocumentation 2
Edit Editslow query logDocumentation OFF
Edit Editslow query log fileDocumentation ubuntu-s-1vcpu-2gb-blr1-01-slow.log
Edit EditsocketDocumentation /opt/lampp/var/mysql/mysql.sock
Edit Editsort buffer sizeDocumentation 512 KiB
Edit Editsql auto is nullDocumentation OFF
Edit Editsql big selectsDocumentation ON
Edit Editsql buffer resultDocumentation OFF
Edit Editsql log binDocumentation ON
Edit Editsql log offDocumentation OFF
Edit Editsql modeDocumentation NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
Edit Editsql notesDocumentation ON
Edit Editsql quote show createDocumentation ON
Edit Editsql safe updatesDocumentation OFF
Edit Editsql select limitDocumentation 18,446,744,073,709,551,616
Edit Editsql slave skip counterDocumentation 0
Edit Editsql warningsDocumentation OFF
Edit Editssl caDocumentation 
Edit Editssl capathDocumentation 
Edit Editssl certDocumentation 
Edit Editssl cipherDocumentation 
Edit Editssl crlDocumentation 
Edit Editssl crlpathDocumentation 
Edit Editssl keyDocumentation 
Edit Editstorage engineDocumentation InnoDB
Edit Editstored program cacheDocumentation 256
Edit Editstrict password validation ON
Edit Editsync binlogDocumentation 0
Edit Editsync frmDocumentation ON
Edit Editsync master infoDocumentation 10,000
Edit Editsync relay logDocumentation 10,000
Edit Editsync relay log infoDocumentation 10,000
Edit Editsystem time zoneDocumentation UTC
Edit Edittable definition cacheDocumentation 400
Edit Edittable open cacheDocumentation 64
Edit Editthread cache sizeDocumentation 0
Edit Editthread concurrencyDocumentation 10
Edit Editthread handlingDocumentation one-thread-per-connection
Edit Editthread pool idle timeout 60
Edit Editthread pool max threads 1,000
Edit Editthread pool oversubscribe 3
Edit Editthread pool size 1
Edit Editthread pool stall limit 500
Edit Editthread stackDocumentation 295,936
Edit Edittime formatDocumentation %H:%i:%s
Edit Edittime zoneDocumentation SYSTEM
Edit Edittimed mutexesDocumentation OFF
Edit Edittmp table sizeDocumentation 16 MiB
Edit EdittmpdirDocumentation /tmp
Edit Edittransaction alloc block sizeDocumentation 8 KiB
Edit Edittransaction prealloc sizeDocumentation 4 KiB
Edit Edittx isolationDocumentation REPEATABLE-READ
Edit Edittx read onlyDocumentation OFF
Edit Editunique checksDocumentation ON
Edit Editupdatable views with limitDocumentation YES
Edit Edituse stat tables NEVER
Edit Edituserstat OFF
Edit EditversionDocumentation 10.1.19-MariaDB
Edit Editversion commentDocumentation Source distribution
Edit Editversion compile machineDocumentation x86_64
Edit Editversion compile osDocumentation Linux
Edit Editversion malloc library system
Edit Editversion ssl library OpenSSL 1.0.2j 26 Sep 2016
Edit Editwait timeoutDocumentation 28,800
Edit Editwsrep osu method TOI
Edit Editwsrep auto increment control ON
Edit Editwsrep causal reads OFF
Edit Editwsrep certify nonpk ON
Edit Editwsrep cluster address 
Edit Editwsrep cluster name my_wsrep_cluster
Edit Editwsrep convert lock to trx OFF
Edit Editwsrep data home dir /opt/lampp/var/mysql/
Edit Editwsrep dbug option 
Edit Editwsrep debug OFF
Edit Editwsrep desync OFF
Edit Editwsrep drupal 282555 workaround OFF
Edit Editwsrep forced binlog format NONE
Edit Editwsrep gtid domain id 0
Edit Editwsrep gtid mode OFF
Edit Editwsrep load data splitting ON
Edit Editwsrep log conflicts OFF
Edit Editwsrep max ws rows 0
Edit Editwsrep max ws size 2,147,483,647
Edit Editwsrep mysql replication bundle 0
Edit Editwsrep node address 
Edit Editwsrep node incoming address AUTO
Edit Editwsrep node name ubuntu-s-1vcpu-2gb-blr1-01
Edit Editwsrep notify cmd 
Edit Editwsrep on OFF
Edit Editwsrep patch version wsrep_25.16
Edit Editwsrep provider none
Edit Editwsrep provider options 
Edit Editwsrep recover OFF
Edit Editwsrep replicate myisam OFF
Edit Editwsrep restart slave OFF
Edit Editwsrep retry autocommit 1
Edit Editwsrep slave fk checks ON
Edit Editwsrep slave uk checks OFF
Edit Editwsrep slave threads 1
Edit Editwsrep sst auth 
Edit Editwsrep sst donor 
Edit Editwsrep sst donor rejects queries OFF
Edit Editwsrep sst method rsync
Edit Editwsrep sst receive address AUTO
Edit Editwsrep start position 00000000-0000-0000-0000-000000000000:-1
Edit Editwsrep sync wait 0