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 Press Enter to execute query
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

Filters
Action Variable Session value / Global value
Edit Edit aria block size  8,192
Edit Edit aria checkpoint interval  30
Edit Edit aria checkpoint log activity  1,048,576
Edit Edit aria encrypt tables  OFF
Edit Edit aria force start after recovery failures  0
Edit Edit aria group commit  none
Edit Edit aria group commit interval  0
Edit Edit aria log file size  1,073,741,824
Edit Edit aria log purge type  immediate
Edit Edit aria max sort file size  9,223,372,036,853,727,232
Edit Edit aria page checksum  ON
Edit Edit aria pagecache age threshold  300
Edit Edit aria pagecache buffer size  134,217,728
Edit Edit aria pagecache division limit  100
Edit Edit aria pagecache file hash size  512
Edit Edit aria recover  NORMAL
Edit Edit aria repair threads  1
Edit Edit aria sort buffer size  268,434,432
Edit Edit aria stats method  nulls_unequal
Edit Edit aria sync log dir  NEWFILE
Edit Edit aria used for temp tables  ON
Edit Edit auto increment increment  1
Edit Edit auto increment offset  1
Edit Edit autocommit  ON
Edit Edit automatic sp privileges  ON
Edit Edit back log  80
Edit Edit basedir  /opt/lampp
Edit Edit big tables  OFF
Edit Edit binlog annotate row events  OFF
Edit Edit binlog cache size  32 KiB
Edit Edit binlog checksum  NONE
Edit Edit binlog commit wait count  0
Edit Edit binlog commit wait usec  100,000
Edit Edit binlog direct non transactional updates  OFF
Edit Edit binlog format  STATEMENT
Edit Edit binlog optimize thread scheduling  ON
Edit Edit binlog row image  FULL
Edit Edit binlog stmt cache size  32 KiB
Edit Edit bulk insert buffer size  8 MiB
Edit Edit character set client  latin1
(Session value )  utf8mb4
Edit Edit character set connection  latin1
(Session value )  utf8mb4
Edit Edit character set database  latin1
Edit Edit character set filesystem  binary
Edit Edit character set results  latin1
(Session value )  utf8mb4
Edit Edit character set server  latin1
Edit Edit character set system  utf8
Edit Edit character sets dir  /opt/lampp/share/charsets/
Edit Edit collation connection  latin1_swedish_ci
(Session value )  utf8mb4_unicode_ci
Edit Edit collation database  latin1_swedish_ci
Edit Edit collation server  latin1_swedish_ci
Edit Edit completion type  NO_CHAIN
Edit Edit concurrent insert  AUTO
Edit Edit connect timeout  10
Edit Edit datadir  /opt/lampp/var/mysql/
Edit Edit date format  %Y-%m-%d
Edit Edit datetime format  %Y-%m-%d %H:%i:%s
Edit Edit deadlock search depth long  15
Edit Edit deadlock search depth short  4
Edit Edit deadlock timeout long  50,000,000
Edit Edit deadlock timeout short  10,000
Edit Edit debug no thread alarm  OFF
Edit Edit default regex flags  
Edit Edit default storage engine  InnoDB
Edit Edit default tmp storage engine  
Edit Edit default week format  0
Edit Edit delay key write  ON
Edit Edit delayed insert limit  100
Edit Edit delayed insert timeout  300
Edit Edit delayed queue size  1,000
Edit Edit div precision increment  4
Edit Edit encrypt binlog  OFF
Edit Edit encrypt tmp disk tables  OFF
Edit Edit encrypt tmp files  OFF
Edit Edit enforce storage engine  
Edit Edit event scheduler  OFF
Edit Edit expensive subquery limit  100
Edit Edit expire logs days  0
Edit Edit explicit defaults for timestamp  OFF
Edit Edit extra max connections  1
Edit Edit extra port  0
Edit Edit flush  OFF
Edit Edit flush time  0
Edit Edit foreign key checks  ON
Edit Edit ft boolean syntax  + -><()~*:""&|
Edit Edit ft max word len  84
Edit Edit ft min word len  4
Edit Edit ft query expansion limit  20
Edit Edit ft stopword file  (built-in)
Edit Edit general log  ON
Edit Edit general log file  xserver.log
Edit Edit group concat max len  1,024
Edit Edit gtid binlog pos  
Edit Edit gtid binlog state  
Edit Edit gtid current pos  
Edit Edit gtid domain id  0
Edit Edit gtid ignore duplicates  OFF
Edit Edit gtid slave pos  
Edit Edit gtid strict mode  OFF
Edit Edit have compress  YES
Edit Edit have crypt  YES
Edit Edit have dynamic loading  YES
Edit Edit have geometry  YES
Edit Edit have openssl  YES
Edit Edit have profiling  YES
Edit Edit have query cache  YES
Edit Edit have rtree keys  YES
Edit Edit have ssl  DISABLED
Edit Edit have symlink  YES
Edit Edit histogram size  0
Edit Edit histogram type  SINGLE_PREC_HB
Edit Edit host cache size  279
Edit Edit hostname  xserver
Edit Edit ignore builtin innodb  OFF
Edit Edit ignore db dirs  
Edit Edit init connect  
Edit Edit init file  
Edit Edit init slave  
Edit Edit innodb adaptive flushing  ON
Edit Edit innodb adaptive flushing lwm  10
Edit Edit innodb adaptive hash index  ON
Edit Edit innodb adaptive hash index partitions  1
Edit Edit innodb adaptive max sleep delay  150,000
Edit Edit innodb additional mem pool size  8 MiB
Edit Edit innodb api bk commit interval  5
Edit Edit innodb api disable rowlock  OFF
Edit Edit innodb api enable binlog  OFF
Edit Edit innodb api enable mdl  OFF
Edit Edit innodb api trx level  0
Edit Edit innodb autoextend increment  64
Edit Edit innodb autoinc lock mode  1
Edit Edit innodb background scrub data check interval  3,600
Edit Edit innodb background scrub data compressed  OFF
Edit Edit innodb background scrub data interval  604,800
Edit Edit innodb background scrub data uncompressed  OFF
Edit Edit innodb buf dump status frequency  0
Edit Edit innodb buffer pool dump at shutdown  OFF
Edit Edit innodb buffer pool dump now  OFF
Edit Edit innodb buffer pool dump pct  100
Edit Edit innodb buffer pool filename  ib_buffer_pool
Edit Edit innodb buffer pool instances  8
Edit Edit innodb buffer pool load abort  OFF
Edit Edit innodb buffer pool load at startup  OFF
Edit Edit innodb buffer pool load now  OFF
Edit Edit innodb buffer pool populate  OFF
Edit Edit innodb buffer pool size  16 MiB
Edit Edit innodb change buffer max size  25
Edit Edit innodb change buffering  all
Edit Edit innodb checksum algorithm  INNODB
Edit Edit innodb checksums  ON
Edit Edit innodb cleaner lsn age factor  HIGH_CHECKPOINT
Edit Edit innodb cmp per index enabled  OFF
Edit Edit innodb commit concurrency  0
Edit Edit innodb compression algorithm  zlib
Edit Edit innodb compression failure threshold pct  5
Edit Edit innodb compression level  6
Edit Edit innodb compression pad pct max  50
Edit Edit innodb concurrency tickets  5,000
Edit Edit innodb corrupt table action  assert
Edit Edit innodb data file path  ibdata1:10M:autoextend
Edit Edit innodb data home dir  /opt/lampp/var/mysql/
Edit Edit innodb default encryption key id  1
Edit Edit innodb defragment  OFF
Edit Edit innodb defragment fill factor  1
Edit Edit innodb defragment fill factor n recs  20
Edit Edit innodb defragment frequency  40
Edit Edit innodb defragment n pages  7
Edit Edit innodb defragment stats accuracy  0
Edit Edit innodb disable sort file cache  OFF
Edit Edit innodb disallow writes  OFF
Edit Edit innodb doublewrite  ON
Edit Edit innodb empty free list algorithm  LEGACY
Edit Edit innodb encrypt log  OFF
Edit Edit innodb encrypt tables  OFF
Edit Edit innodb encryption rotate key age  1
Edit Edit innodb encryption rotation iops  100
Edit Edit innodb encryption threads  0
Edit Edit innodb fake changes  OFF
Edit Edit innodb fast shutdown  1
Edit Edit innodb fatal semaphore wait threshold  600
Edit Edit innodb file format  Antelope
Edit Edit innodb file format check  ON
Edit Edit innodb file format max  Antelope
Edit Edit innodb file per table  ON
Edit Edit innodb flush log at timeout  1
Edit Edit innodb flush log at trx commit  1
Edit Edit innodb flush method  
Edit Edit innodb flush neighbors  1
Edit Edit innodb flushing avg loops  30
Edit Edit innodb force load corrupted  OFF
Edit Edit innodb force primary key  OFF
Edit Edit innodb force recovery  0
Edit Edit innodb foreground preflush  EXPONENTIAL_BACKOFF
Edit Edit innodb ft aux table  
Edit Edit innodb ft cache size  8,000,000
Edit Edit innodb ft enable diag print  OFF
Edit Edit innodb ft enable stopword  ON
Edit Edit innodb ft max token size  84
Edit Edit innodb ft min token size  3
Edit Edit innodb ft num word optimize  2,000
Edit Edit innodb ft result cache limit  2,000,000,000
Edit Edit innodb ft server stopword table  
Edit Edit innodb ft sort pll degree  2
Edit Edit innodb ft total cache size  640,000,000
Edit Edit innodb ft user stopword table  
Edit Edit innodb idle flush pct  100
Edit Edit innodb immediate scrub data uncompressed  OFF
Edit Edit innodb instrument semaphores  OFF
Edit Edit innodb io capacity  200
Edit Edit innodb io capacity max  2,000
Edit Edit innodb kill idle transaction  0
Edit Edit innodb large prefix  OFF
Edit Edit innodb lock schedule algorithm  fcfs
Edit Edit innodb lock wait timeout  50
Edit Edit innodb locking fake changes  ON
Edit Edit innodb locks unsafe for binlog  OFF
Edit Edit innodb log arch dir  /opt/lampp/var/mysql/
Edit Edit innodb log arch expire sec  0
Edit Edit innodb log archive  OFF
Edit Edit innodb log block size  512
Edit Edit innodb log buffer size  8 MiB
Edit Edit innodb log checksum algorithm  INNODB
Edit Edit innodb log compressed pages  OFF
Edit Edit innodb log file size  5 MiB
Edit Edit innodb log files in group  2
Edit Edit innodb log group home dir  /opt/lampp/var/mysql/
Edit Edit innodb lru scan depth  1,024
Edit Edit innodb max bitmap file size  104,857,600
Edit Edit innodb max changed pages  1,000,000
Edit Edit innodb max dirty pages pct  75
Edit Edit innodb max dirty pages pct lwm   <1
Edit Edit innodb max purge lag  0
Edit Edit innodb max purge lag delay  0
Edit Edit innodb mirrored log groups  1
Edit Edit innodb monitor disable  
Edit Edit innodb monitor enable  
Edit Edit innodb monitor reset  
Edit Edit innodb monitor reset all  
Edit Edit innodb mtflush threads  8
Edit Edit innodb old blocks pct  37
Edit Edit innodb old blocks time  1,000
Edit Edit innodb online alter log max size  128 MiB
Edit Edit innodb open files  300
Edit Edit innodb optimize fulltext only  OFF
Edit Edit innodb page size  16 KiB
Edit Edit innodb prefix index cluster optimization  OFF
Edit Edit innodb print all deadlocks  OFF
Edit Edit innodb purge batch size  300
Edit Edit innodb purge threads  1
Edit Edit innodb random read ahead  OFF
Edit Edit innodb read ahead threshold  56
Edit Edit innodb read io threads  4
Edit Edit innodb read only  OFF
Edit Edit innodb replication delay  0
Edit Edit innodb rollback on timeout  OFF
Edit Edit innodb rollback segments  128
Edit Edit innodb sched priority cleaner  19
Edit Edit innodb scrub log  OFF
Edit Edit innodb scrub log speed  256
Edit Edit innodb show locks held  10
Edit Edit innodb show verbose locks  0
Edit Edit innodb simulate comp failures  0
Edit Edit innodb sort buffer size  1 MiB
Edit Edit innodb spin wait delay  6
Edit Edit innodb stats auto recalc  ON
Edit Edit innodb stats include delete marked  OFF
Edit Edit innodb stats method  nulls_equal
Edit Edit innodb stats modified counter  0
Edit Edit innodb stats on metadata  OFF
Edit Edit innodb stats persistent  ON
Edit Edit innodb stats persistent sample pages  20
Edit Edit innodb stats sample pages  8
Edit Edit innodb stats traditional  ON
Edit Edit innodb stats transient sample pages  8
Edit Edit innodb status output  OFF
Edit Edit innodb status output locks  OFF
Edit Edit innodb strict mode  OFF
Edit Edit innodb support xa  ON
Edit Edit innodb sync array size  1
Edit Edit innodb sync spin loops  30
Edit Edit innodb table locks  ON
Edit Edit innodb thread concurrency  0
Edit Edit innodb thread sleep delay  10,000
Edit Edit innodb tmpdir  
Edit Edit innodb track changed pages  OFF
Edit Edit innodb undo directory  .
Edit Edit innodb undo logs  128
Edit Edit innodb undo tablespaces  0
Edit Edit innodb use atomic writes  OFF
Edit Edit innodb use fallocate  OFF
Edit Edit innodb use global flush log at trx commit  ON
Edit Edit innodb use mtflush  OFF
Edit Edit innodb use native aio  OFF
Edit Edit innodb use stacktrace  OFF
Edit Edit innodb use sys malloc  ON
Edit Edit innodb use trim  OFF
Edit Edit innodb version  5.6.35-80.0
Edit Edit innodb write io threads  4
Edit Edit interactive timeout  28,800
Edit Edit join buffer size  256 KiB
Edit Edit join buffer space limit  2,097,152
Edit Edit join cache level  2
Edit Edit keep files on create  OFF
Edit Edit key buffer size  16 MiB
Edit Edit key cache age threshold  300
Edit Edit key cache block size  1 KiB
Edit Edit key cache division limit  100
Edit Edit key cache file hash size  512
Edit Edit key cache segments  0
Edit Edit large files support  ON
Edit Edit large page size  0 B
Edit Edit large pages  OFF
Edit Edit lc messages  en_US
Edit Edit lc messages dir  
Edit Edit lc time names  en_US
Edit Edit license  GPL
Edit Edit local infile  ON
Edit Edit lock wait timeout  31,536,000
Edit Edit locked in memory  OFF
Edit Edit log bin  OFF
Edit Edit log bin basename  
Edit Edit log bin index  
Edit Edit log bin trust function creators  OFF
Edit Edit log error  /opt/lampp/var/mysql/xserver.err
Edit Edit log output  FILE
Edit Edit log queries not using indexes  OFF
Edit Edit log slave updates  OFF
Edit Edit log slow admin statements  OFF
Edit Edit log slow filter  admin,filesort,filesort_on_disk,full_join,full_scan,query_cache,query_cache_miss,tmp_table,tmp_table_on_disk
Edit Edit log slow rate limit  1
Edit Edit log slow slave statements  OFF
Edit Edit log slow verbosity  
Edit Edit log tc size  24,576
Edit Edit log warnings  1
Edit Edit long query time  10
Edit Edit low priority updates  OFF
Edit Edit lower case file system  OFF
Edit Edit lower case table names  0
Edit Edit master verify checksum  OFF
Edit Edit max allowed packet  1,048,576
Edit Edit max binlog cache size  16 EiB
Edit Edit max binlog size  1 GiB
Edit Edit max binlog stmt cache size  16 EiB
Edit Edit max connect errors  100
Edit Edit max connections  151
Edit Edit max delayed threads  20
Edit Edit max digest length  1,024
Edit Edit max error count  64
Edit Edit max heap table size  16 MiB
Edit Edit max insert delayed threads  20
Edit Edit max join size  18,446,744,073,709,551,616
Edit Edit max length for sort data  1,024
Edit Edit max long data size  1,048,576
Edit Edit max prepared stmt count  16,382
Edit Edit max relay log size  1 GiB
Edit Edit max seeks for key  4,294,967,295
Edit Edit max session mem used  9,223,372,036,854,775,808
Edit Edit max sort length  1,024
Edit Edit max sp recursion depth  0
Edit Edit max statement time  0
Edit Edit max tmp tables  32
Edit Edit max user connections  0
Edit Edit max write lock count  4,294,967,295
Edit Edit metadata locks cache size  1,024
Edit Edit metadata locks hash instances  8
Edit Edit min examined row limit  0
Edit Edit mrr buffer size  262,144
Edit Edit multi range count  256
Edit Edit myisam block size  1,024
Edit Edit myisam data pointer size  6 B
Edit Edit myisam max sort file size  8 EiB
Edit Edit myisam mmap size  16 EiB
Edit Edit myisam recover options  DEFAULT
Edit Edit myisam repair threads  1
Edit Edit myisam sort buffer size  8 MiB
Edit Edit myisam stats method  NULLS_UNEQUAL
Edit Edit myisam use mmap  OFF
Edit Edit mysql56 temporal format  ON
Edit Edit net buffer length  8,192
Edit Edit net read timeout  30
Edit Edit net retry count  10
Edit Edit net write timeout  60
Edit Edit old  OFF
Edit Edit old alter table  OFF
Edit Edit old mode  
Edit Edit old passwords  OFF
Edit Edit open files limit  1,024
Edit Edit optimizer prune level  1
Edit Edit optimizer search depth  62
Edit Edit optimizer selectivity sampling limit  100
Edit Edit optimizer switch  index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=off,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=off
Edit Edit optimizer use condition selectivity  1
Edit Edit performance schema  OFF
Edit Edit performance schema accounts size  -1
Edit Edit performance schema digests size  -1
Edit Edit performance schema events stages history long size  -1
Edit Edit performance schema events stages history size  -1
Edit Edit performance schema events statements history long size  -1
Edit Edit performance schema events statements history size  -1
Edit Edit performance schema events waits history long size  -1
Edit Edit performance schema events waits history size  -1
Edit Edit performance schema hosts size  -1
Edit Edit performance schema max cond classes  80
Edit Edit performance schema max cond instances  -1
Edit Edit performance schema max digest length  1,024
Edit Edit performance schema max file classes  50
Edit Edit performance schema max file handles  32,768
Edit Edit performance schema max file instances  -1
Edit Edit performance schema max mutex classes  200
Edit Edit performance schema max mutex instances  -1
Edit Edit performance schema max rwlock classes  40
Edit Edit performance schema max rwlock instances  -1
Edit Edit performance schema max socket classes  10
Edit Edit performance schema max socket instances  -1
Edit Edit performance schema max stage classes  150
Edit Edit performance schema max statement classes  178
Edit Edit performance schema max table handles  -1
Edit Edit performance schema max table instances  -1
Edit Edit performance schema max thread classes  50
Edit Edit performance schema max thread instances  -1
Edit Edit performance schema session connect attrs size  -1
Edit Edit performance schema setup actors size  100
Edit Edit performance schema setup objects size  100
Edit Edit performance schema users size  -1
Edit Edit pid file  /opt/lampp/var/mysql/xserver.pid
Edit Edit plugin dir  /opt/lampp/lib/mysql/plugin/
Edit Edit plugin maturity  unknown
Edit Edit port  3,306
Edit Edit preload buffer size  32 KiB
Edit Edit profiling  OFF
Edit Edit profiling history size  15
Edit Edit progress report time  5
Edit Edit protocol version  10
Edit Edit query alloc block size  16 KiB
Edit Edit query cache limit  1 MiB
Edit Edit query cache min res unit  4,096
Edit Edit query cache size  1 MiB
Edit Edit query cache strip comments  OFF
Edit Edit query cache type  OFF
Edit Edit query cache wlock invalidate  OFF
Edit Edit query prealloc size  24 KiB
Edit Edit range alloc block size  4 KiB
Edit Edit read buffer size  256 KiB
Edit Edit read only  OFF
Edit Edit read rnd buffer size  512 KiB
Edit Edit relay log  
Edit Edit relay log basename  
Edit Edit relay log index  
Edit Edit relay log info file  relay-log.info
Edit Edit relay log purge  ON
Edit Edit relay log recovery  OFF
Edit Edit relay log space limit  0
Edit Edit replicate annotate row events  OFF
Edit Edit replicate do db  
Edit Edit replicate do table  
Edit Edit replicate events marked for skip  REPLICATE
Edit Edit replicate ignore db  
Edit Edit replicate ignore table  
Edit Edit replicate wild do table  
Edit Edit replicate wild ignore table  
Edit Edit report host  
Edit Edit report password  
Edit Edit report port  3,306
Edit Edit report user  
Edit Edit rowid merge buff size  8,388,608
Edit Edit secure auth  ON
Edit Edit secure file priv  
Edit Edit server id  1
Edit Edit skip external locking  ON
Edit Edit skip name resolve  OFF
Edit Edit skip networking  OFF
Edit Edit skip show database  OFF
Edit Edit slave compressed protocol  OFF
Edit Edit slave ddl exec mode  IDEMPOTENT
Edit Edit slave domain parallel threads  0
Edit Edit slave exec mode  STRICT
Edit Edit slave load tmpdir  /tmp
Edit Edit slave max allowed packet  1,073,741,824
Edit Edit slave net timeout  3,600
Edit Edit slave parallel max queued  131,072
Edit Edit slave parallel mode  conservative
Edit Edit slave parallel threads  0
Edit Edit slave run triggers for rbr  NO
Edit Edit slave skip errors  OFF
Edit Edit slave sql verify checksum  ON
Edit Edit slave transaction retries  10
Edit Edit slave type conversions  
Edit Edit slow launch time  2
Edit Edit slow query log  ON
Edit Edit slow query log file  xserver-slow.log
Edit Edit socket  /opt/lampp/var/mysql/mysql.sock
Edit Edit sort buffer size  512 KiB
Edit Edit sql auto is null  OFF
Edit Edit sql big selects  ON
Edit Edit sql buffer result  OFF
Edit Edit sql log bin  ON
Edit Edit sql log off  OFF
Edit Edit sql mode  NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
Edit Edit sql notes  ON
Edit Edit sql quote show create  ON
Edit Edit sql safe updates  OFF
Edit Edit sql select limit  18,446,744,073,709,551,616
Edit Edit sql slave skip counter  0
Edit Edit sql warnings  OFF
Edit Edit ssl ca  
Edit Edit ssl capath  
Edit Edit ssl cert  
Edit Edit ssl cipher  
Edit Edit ssl crl  
Edit Edit ssl crlpath  
Edit Edit ssl key  
Edit Edit storage engine  InnoDB
Edit Edit stored program cache  256
Edit Edit strict password validation  ON
Edit Edit sync binlog  0
Edit Edit sync frm  ON
Edit Edit sync master info  10,000
Edit Edit sync relay log  10,000
Edit Edit sync relay log info  10,000
Edit Edit system time zone  UTC
Edit Edit table definition cache  400
Edit Edit table open cache  64
Edit Edit thread cache size  0
Edit Edit thread concurrency  10
Edit Edit thread handling  one-thread-per-connection
Edit Edit thread pool idle timeout  60
Edit Edit thread pool max threads  1,000
Edit Edit thread pool oversubscribe  3
Edit Edit thread pool size  1
Edit Edit thread pool stall limit  500
Edit Edit thread stack  295,936
Edit Edit time format  %H:%i:%s
Edit Edit time zone  SYSTEM
Edit Edit timed mutexes  OFF
Edit Edit tmp table size  16 MiB
Edit Edit tmpdir  /tmp
Edit Edit transaction alloc block size  8 KiB
Edit Edit transaction prealloc size  4 KiB
Edit Edit tx isolation  REPEATABLE-READ
Edit Edit tx read only  OFF
Edit Edit unique checks  ON
Edit Edit updatable views with limit  YES
Edit Edit use stat tables  NEVER
Edit Edit userstat  OFF
Edit Edit version  10.1.22-MariaDB
Edit Edit version comment  Source distribution
Edit Edit version compile machine  x86_64
Edit Edit version compile os  Linux
Edit Edit version malloc library  system
Edit Edit version ssl library  OpenSSL 1.0.2j 26 Sep 2016
Edit Edit wait timeout  28,800
Edit Edit wsrep osu method  TOI
Edit Edit wsrep auto increment control  ON
Edit Edit wsrep causal reads  OFF
Edit Edit wsrep certify nonpk  ON
Edit Edit wsrep cluster address  
Edit Edit wsrep cluster name  my_wsrep_cluster
Edit Edit wsrep convert lock to trx  OFF
Edit Edit wsrep data home dir  /opt/lampp/var/mysql/
Edit Edit wsrep dbug option  
Edit Edit wsrep debug  OFF
Edit Edit wsrep desync  OFF
Edit Edit wsrep dirty reads  OFF
Edit Edit wsrep drupal 282555 workaround  OFF
Edit Edit wsrep forced binlog format  NONE
Edit Edit wsrep gtid domain id  0
Edit Edit wsrep gtid mode  OFF
Edit Edit wsrep load data splitting  ON
Edit Edit wsrep log conflicts  OFF
Edit Edit wsrep max ws rows  0
Edit Edit wsrep max ws size  2,147,483,647
Edit Edit wsrep mysql replication bundle  0
Edit Edit wsrep node address  
Edit Edit wsrep node incoming address  AUTO
Edit Edit wsrep node name  xserver
Edit Edit wsrep notify cmd  
Edit Edit wsrep on  OFF
Edit Edit wsrep patch version  wsrep_25.16
Edit Edit wsrep provider  none
Edit Edit wsrep provider options  
Edit Edit wsrep recover  OFF
Edit Edit wsrep replicate myisam  OFF
Edit Edit wsrep restart slave  OFF
Edit Edit wsrep retry autocommit  1
Edit Edit wsrep slave fk checks  ON
Edit Edit wsrep slave uk checks  OFF
Edit Edit wsrep slave threads  1
Edit Edit wsrep sst auth  
Edit Edit wsrep sst donor  
Edit Edit wsrep sst donor rejects queries  OFF
Edit Edit wsrep sst method  rsync
Edit Edit wsrep sst receive address  AUTO
Edit Edit wsrep start position  00000000-0000-0000-0000-000000000000:-1
Edit Edit wsrep sync wait  0