Drop files here

SQL upload ( 0 ) x-

Server: localhost
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 :
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
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 incrementDocumentation  1
Edit Edit auto increment offsetDocumentation  1
Edit Edit autocommitDocumentation  ON
Edit Edit automatic sp privilegesDocumentation  ON
Edit Edit back logDocumentation  80
Edit Edit basedirDocumentation  /opt/lampp
Edit Edit big tablesDocumentation  OFF
Edit Edit binlog annotate row events  OFF
Edit Edit binlog cache sizeDocumentation  32 KiB
Edit Edit binlog checksumDocumentation  NONE
Edit Edit binlog commit wait count  0
Edit Edit binlog commit wait usec  100,000
Edit Edit binlog direct non transactional updatesDocumentation  OFF
Edit Edit binlog formatDocumentation  STATEMENT
Edit Edit binlog optimize thread scheduling  ON
Edit Edit binlog row imageDocumentation  FULL
Edit Edit binlog stmt cache sizeDocumentation  32 KiB
Edit Edit bulk insert buffer sizeDocumentation  8 MiB
Edit Edit character set clientDocumentation  latin1
(Session value )  utf8mb4
Edit Edit character set connectionDocumentation  latin1
(Session value )  utf8mb4
Edit Edit character set databaseDocumentation  latin1
Edit Edit character set filesystemDocumentation  binary
Edit Edit character set resultsDocumentation  latin1
(Session value )  utf8mb4
Edit Edit character set serverDocumentation  latin1
Edit Edit character set systemDocumentation  utf8
Edit Edit character sets dirDocumentation  /opt/lampp/share/charsets/
Edit Edit collation connectionDocumentation  latin1_swedish_ci
(Session value )  utf8mb4_unicode_ci
Edit Edit collation databaseDocumentation  latin1_swedish_ci
Edit Edit collation serverDocumentation  latin1_swedish_ci
Edit Edit completion typeDocumentation  NO_CHAIN
Edit Edit concurrent insertDocumentation  AUTO
Edit Edit connect timeoutDocumentation  10
Edit Edit datadirDocumentation  /opt/lampp/var/mysql/
Edit Edit date formatDocumentation  %Y-%m-%d
Edit Edit datetime formatDocumentation  %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 engineDocumentation  InnoDB
Edit Edit default tmp storage engineDocumentation  
Edit Edit default week formatDocumentation  0
Edit Edit delay key writeDocumentation  ON
Edit Edit delayed insert limitDocumentation  100
Edit Edit delayed insert timeoutDocumentation  300
Edit Edit delayed queue sizeDocumentation  1,000
Edit Edit div precision incrementDocumentation  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 schedulerDocumentation  OFF
Edit Edit expensive subquery limit  100
Edit Edit expire logs daysDocumentation  0
Edit Edit explicit defaults for timestampDocumentation  OFF
Edit Edit extra max connections  1
Edit Edit extra port  0
Edit Edit flushDocumentation  OFF
Edit Edit flush timeDocumentation  0
Edit Edit foreign key checksDocumentation  ON
Edit Edit ft boolean syntaxDocumentation  + -><()~*:""&|
Edit Edit ft max word lenDocumentation  84
Edit Edit ft min word lenDocumentation  4
Edit Edit ft query expansion limitDocumentation  20
Edit Edit ft stopword fileDocumentation  (built-in)
Edit Edit general logDocumentation  OFF
Edit Edit general log fileDocumentation  servidor1.log
Edit Edit group concat max lenDocumentation  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 compressDocumentation  YES
Edit Edit have cryptDocumentation  YES
Edit Edit have dynamic loadingDocumentation  YES
Edit Edit have geometryDocumentation  YES
Edit Edit have opensslDocumentation  YES
Edit Edit have profilingDocumentation  YES
Edit Edit have query cacheDocumentation  YES
Edit Edit have rtree keysDocumentation  YES
Edit Edit have sslDocumentation  DISABLED
Edit Edit have symlinkDocumentation  YES
Edit Edit histogram size  0
Edit Edit histogram type  SINGLE_PREC_HB
Edit Edit host cache sizeDocumentation  279
Edit Edit hostnameDocumentation  servidor1
Edit Edit ignore builtin innodbDocumentation  OFF
Edit Edit ignore db dirsDocumentation  
Edit Edit init connectDocumentation  
Edit Edit init fileDocumentation  
Edit Edit init slaveDocumentation  
Edit Edit innodb adaptive flushingDocumentation  ON
Edit Edit innodb adaptive flushing lwmDocumentation  10
Edit Edit innodb adaptive hash indexDocumentation  ON
Edit Edit innodb adaptive hash index partitions  1
Edit Edit innodb adaptive max sleep delayDocumentation  150,000
Edit Edit innodb additional mem pool sizeDocumentation  8 MiB
Edit Edit innodb api bk commit intervalDocumentation  5
Edit Edit innodb api disable rowlockDocumentation  OFF
Edit Edit innodb api enable binlogDocumentation  OFF
Edit Edit innodb api enable mdlDocumentation  OFF
Edit Edit innodb api trx levelDocumentation  0
Edit Edit innodb autoextend incrementDocumentation  64
Edit Edit innodb autoinc lock modeDocumentation  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 shutdownDocumentation  OFF
Edit Edit innodb buffer pool dump nowDocumentation  OFF
Edit Edit innodb buffer pool dump pctDocumentation  100
Edit Edit innodb buffer pool filenameDocumentation  ib_buffer_pool
Edit Edit innodb buffer pool instancesDocumentation  8
Edit Edit innodb buffer pool load abortDocumentation  OFF
Edit Edit innodb buffer pool load at startupDocumentation  OFF
Edit Edit innodb buffer pool load nowDocumentation  OFF
Edit Edit innodb buffer pool populate  OFF
Edit Edit innodb buffer pool sizeDocumentation  128 MiB
Edit Edit innodb change buffer max sizeDocumentation  25
Edit Edit innodb change bufferingDocumentation  all
Edit Edit innodb checksum algorithmDocumentation  INNODB
Edit Edit innodb checksumsDocumentation  ON
Edit Edit innodb cleaner lsn age factor  HIGH_CHECKPOINT
Edit Edit innodb cmp per index enabledDocumentation  OFF
Edit Edit innodb commit concurrencyDocumentation  0
Edit Edit innodb compression algorithm  zlib
Edit Edit innodb compression failure threshold pctDocumentation  5
Edit Edit innodb compression levelDocumentation  6
Edit Edit innodb compression pad pct maxDocumentation  50
Edit Edit innodb concurrency ticketsDocumentation  5,000
Edit Edit innodb corrupt table action  assert
Edit Edit innodb data file pathDocumentation  ibdata1:12M:autoextend
Edit Edit innodb data home dirDocumentation  
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 cacheDocumentation  OFF
Edit Edit innodb disallow writes  OFF
Edit Edit innodb doublewriteDocumentation  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 shutdownDocumentation  1
Edit Edit innodb fatal semaphore wait threshold  600
Edit Edit innodb file formatDocumentation  Antelope
Edit Edit innodb file format checkDocumentation  ON
Edit Edit innodb file format maxDocumentation  Antelope
Edit Edit innodb file per tableDocumentation  ON
Edit Edit innodb flush log at timeoutDocumentation  1
Edit Edit innodb flush log at trx commitDocumentation  1
Edit Edit innodb flush methodDocumentation  
Edit Edit innodb flush neighborsDocumentation  1
Edit Edit innodb flushing avg loopsDocumentation  30
Edit Edit innodb force load corruptedDocumentation  OFF
Edit Edit innodb force primary key  OFF
Edit Edit innodb force recoveryDocumentation  0
Edit Edit innodb foreground preflush  EXPONENTIAL_BACKOFF
Edit Edit innodb ft aux tableDocumentation  
Edit Edit innodb ft cache sizeDocumentation  8,000,000
Edit Edit innodb ft enable diag printDocumentation  OFF
Edit Edit innodb ft enable stopwordDocumentation  ON
Edit Edit innodb ft max token sizeDocumentation  84
Edit Edit innodb ft min token sizeDocumentation  3
Edit Edit innodb ft num word optimizeDocumentation  2,000
Edit Edit innodb ft result cache limitDocumentation  2,000,000,000
Edit Edit innodb ft server stopword tableDocumentation  
Edit Edit innodb ft sort pll degreeDocumentation  2
Edit Edit innodb ft total cache sizeDocumentation  640,000,000
Edit Edit innodb ft user stopword tableDocumentation  
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 capacityDocumentation  200
Edit Edit innodb io capacity maxDocumentation  2,000
Edit Edit innodb kill idle transaction  0
Edit Edit innodb large prefixDocumentation  OFF
Edit Edit innodb lock schedule algorithm  fcfs
Edit Edit innodb lock wait timeoutDocumentation  50
Edit Edit innodb locking fake changes  ON
Edit Edit innodb locks unsafe for binlogDocumentation  OFF
Edit Edit innodb log arch dir  ./
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 sizeDocumentation  16 MiB
Edit Edit innodb log checksum algorithmDocumentation  INNODB
Edit Edit innodb log compressed pagesDocumentation  ON
Edit Edit innodb log file sizeDocumentation  48 MiB
Edit Edit innodb log files in groupDocumentation  2
Edit Edit innodb log group home dirDocumentation  ./
Edit Edit innodb lru scan depthDocumentation  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 pctDocumentation  75
Edit Edit innodb max dirty pages pct lwmDocumentation   <1
Edit Edit innodb max purge lagDocumentation  0
Edit Edit innodb max purge lag delayDocumentation  0
Edit Edit innodb mirrored log groupsDocumentation  1
Edit Edit innodb monitor disableDocumentation  
Edit Edit innodb monitor enableDocumentation  
Edit Edit innodb monitor resetDocumentation  
Edit Edit innodb monitor reset allDocumentation  
Edit Edit innodb mtflush threads  8
Edit Edit innodb old blocks pctDocumentation  37
Edit Edit innodb old blocks timeDocumentation  1,000
Edit Edit innodb online alter log max sizeDocumentation  128 MiB
Edit Edit innodb open filesDocumentation  2,000
Edit Edit innodb optimize fulltext onlyDocumentation  OFF
Edit Edit innodb page sizeDocumentation  16 KiB
Edit Edit innodb prefix index cluster optimization  OFF
Edit Edit innodb print all deadlocksDocumentation  OFF
Edit Edit innodb print lock wait timeout info  OFF
Edit Edit innodb purge batch sizeDocumentation  300
Edit Edit innodb purge threadsDocumentation  1
Edit Edit innodb random read aheadDocumentation  OFF
Edit Edit innodb read ahead thresholdDocumentation  56
Edit Edit innodb read io threadsDocumentation  4
Edit Edit innodb read onlyDocumentation  OFF
Edit Edit innodb replication delayDocumentation  0
Edit Edit innodb rollback on timeoutDocumentation  OFF
Edit Edit innodb rollback segmentsDocumentation  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 sizeDocumentation  1 MiB
Edit Edit innodb spin wait delayDocumentation  6
Edit Edit innodb stats auto recalcDocumentation  ON
Edit Edit innodb stats include delete marked  OFF
Edit Edit innodb stats methodDocumentation  nulls_equal
Edit Edit innodb stats modified counter  0
Edit Edit innodb stats on metadataDocumentation  OFF
Edit Edit innodb stats persistentDocumentation  ON
Edit Edit innodb stats persistent sample pagesDocumentation  20
Edit Edit innodb stats sample pagesDocumentation  8
Edit Edit innodb stats traditional  ON
Edit Edit innodb stats transient sample pagesDocumentation  8
Edit Edit innodb status outputDocumentation  OFF
Edit Edit innodb status output locksDocumentation  OFF
Edit Edit innodb strict modeDocumentation  OFF
Edit Edit innodb support xaDocumentation  ON
Edit Edit innodb sync array sizeDocumentation  1
Edit Edit innodb sync spin loopsDocumentation  30
Edit Edit innodb table locksDocumentation  ON
Edit Edit innodb thread concurrencyDocumentation  0
Edit Edit innodb thread sleep delayDocumentation  10,000
Edit Edit innodb tmpdir  
Edit Edit innodb track changed pages  OFF
Edit Edit innodb undo directoryDocumentation  .
Edit Edit innodb undo logsDocumentation  128
Edit Edit innodb undo tablespacesDocumentation  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 aioDocumentation  OFF
Edit Edit innodb use stacktrace  OFF
Edit Edit innodb use sys mallocDocumentation  ON
Edit Edit innodb use trim  OFF
Edit Edit innodb versionDocumentation  5.6.36-83.0
Edit Edit innodb write io threadsDocumentation  4
Edit Edit interactive timeoutDocumentation  28,800
Edit Edit join buffer sizeDocumentation  256 KiB
Edit Edit join buffer space limit  2,097,152
Edit Edit join cache level  2
Edit Edit keep files on createDocumentation  OFF
Edit Edit key buffer sizeDocumentation  128 MiB
Edit Edit key cache age thresholdDocumentation  300
Edit Edit key cache block sizeDocumentation  1 KiB
Edit Edit key cache division limitDocumentation  100
Edit Edit key cache file hash size  512
Edit Edit key cache segments  0
Edit Edit large files supportDocumentation  ON
Edit Edit large page sizeDocumentation  0 B
Edit Edit large pagesDocumentation  OFF
Edit Edit lc messagesDocumentation  en_US
Edit Edit lc messages dirDocumentation  
Edit Edit lc time namesDocumentation  en_US
Edit Edit licenseDocumentation  GPL
Edit Edit local infileDocumentation  ON
Edit Edit lock wait timeoutDocumentation  31,536,000
Edit Edit locked in memoryDocumentation  OFF
Edit Edit log binDocumentation  OFF
Edit Edit log bin basenameDocumentation  
Edit Edit log bin indexDocumentation  
Edit Edit log bin trust function creatorsDocumentation  OFF
Edit Edit log errorDocumentation  /opt/lampp/var/mysql/servidor1.err
Edit Edit log outputDocumentation  FILE
Edit Edit log queries not using indexesDocumentation  OFF
Edit Edit log slave updatesDocumentation  OFF
Edit Edit log slow admin statementsDocumentation  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 statementsDocumentation  OFF
Edit Edit log slow verbosity  
Edit Edit log tc size  24,576
Edit Edit log warningsDocumentation  1
Edit Edit long query timeDocumentation  10
Edit Edit low priority updatesDocumentation  OFF
Edit Edit lower case file systemDocumentation  OFF
Edit Edit lower case table namesDocumentation  0
Edit Edit master verify checksumDocumentation  OFF
Edit Edit max allowed packetDocumentation  4,194,304
Edit Edit max binlog cache sizeDocumentation  16 EiB
Edit Edit max binlog sizeDocumentation  1 GiB
Edit Edit max binlog stmt cache sizeDocumentation  16 EiB
Edit Edit max connect errorsDocumentation  100
Edit Edit max connectionsDocumentation  151
Edit Edit max delayed threadsDocumentation  20
Edit Edit max digest lengthDocumentation  1,024
Edit Edit max error countDocumentation  64
Edit Edit max heap table sizeDocumentation  16 MiB
Edit Edit max insert delayed threadsDocumentation  20
Edit Edit max join sizeDocumentation  18,446,744,073,709,551,616
Edit Edit max length for sort dataDocumentation  1,024
Edit Edit max long data sizeDocumentation  4,194,304
Edit Edit max prepared stmt countDocumentation  16,382
Edit Edit max relay log sizeDocumentation  1 GiB
Edit Edit max seeks for keyDocumentation  4,294,967,295
Edit Edit max session mem used  9,223,372,036,854,775,808
Edit Edit max sort lengthDocumentation  1,024
Edit Edit max sp recursion depthDocumentation  0
Edit Edit max statement time  0
Edit Edit max tmp tablesDocumentation  32
Edit Edit max user connectionsDocumentation  0
Edit Edit max write lock countDocumentation  4,294,967,295
Edit Edit metadata locks cache sizeDocumentation  1,024
Edit Edit metadata locks hash instancesDocumentation  8
Edit Edit min examined row limitDocumentation  0
Edit Edit mrr buffer size  262,144
Edit Edit multi range countDocumentation  256
Edit Edit myisam block size  1,024
Edit Edit myisam data pointer sizeDocumentation  6 B
Edit Edit myisam max sort file sizeDocumentation  8 EiB
Edit Edit myisam mmap sizeDocumentation  16 EiB
Edit Edit myisam recover optionsDocumentation  DEFAULT
Edit Edit myisam repair threadsDocumentation  1
Edit Edit myisam sort buffer sizeDocumentation  127.999 MiB
Edit Edit myisam stats methodDocumentation  NULLS_UNEQUAL
Edit Edit myisam use mmapDocumentation  OFF
Edit Edit mysql56 temporal format  ON
Edit Edit net buffer lengthDocumentation  16,384
Edit Edit net read timeoutDocumentation  30
Edit Edit net retry countDocumentation  10
Edit Edit net write timeoutDocumentation  60
Edit Edit oldDocumentation  OFF
Edit Edit old alter tableDocumentation  OFF
Edit Edit old mode  
Edit Edit old passwordsDocumentation  OFF
Edit Edit open files limitDocumentation  4,162
Edit Edit optimizer prune levelDocumentation  1
Edit Edit optimizer search depthDocumentation  62
Edit Edit optimizer selectivity sampling limit  100
Edit Edit optimizer 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 Edit optimizer use condition selectivity  1
Edit Edit performance schemaDocumentation  OFF
Edit Edit performance schema accounts sizeDocumentation  -1
Edit Edit performance schema digests sizeDocumentation  -1
Edit Edit performance schema events stages history long sizeDocumentation  -1
Edit Edit performance schema events stages history sizeDocumentation  -1
Edit Edit performance schema events statements history long sizeDocumentation  -1
Edit Edit performance schema events statements history sizeDocumentation  -1
Edit Edit performance schema events waits history long sizeDocumentation  -1
Edit Edit performance schema events waits history sizeDocumentation  -1
Edit Edit performance schema hosts sizeDocumentation  -1
Edit Edit performance schema max cond classesDocumentation  80
Edit Edit performance schema max cond instancesDocumentation  -1
Edit Edit performance schema max digest lengthDocumentation  1,024
Edit Edit performance schema max file classesDocumentation  50
Edit Edit performance schema max file handlesDocumentation  32,768
Edit Edit performance schema max file instancesDocumentation  -1
Edit Edit performance schema max mutex classesDocumentation  200
Edit Edit performance schema max mutex instancesDocumentation  -1
Edit Edit performance schema max rwlock classesDocumentation  40
Edit Edit performance schema max rwlock instancesDocumentation  -1
Edit Edit performance schema max socket classesDocumentation  10
Edit Edit performance schema max socket instancesDocumentation  -1
Edit Edit performance schema max stage classesDocumentation  150
Edit Edit performance schema max statement classesDocumentation  178
Edit Edit performance schema max table handlesDocumentation  -1
Edit Edit performance schema max table instancesDocumentation  -1
Edit Edit performance schema max thread classesDocumentation  50
Edit Edit performance schema max thread instancesDocumentation  -1
Edit Edit performance schema session connect attrs sizeDocumentation  -1
Edit Edit performance schema setup actors sizeDocumentation  100
Edit Edit performance schema setup objects sizeDocumentation  100
Edit Edit performance schema users sizeDocumentation  -1
Edit Edit pid fileDocumentation  /opt/lampp/var/mysql/servidor1.pid
Edit Edit plugin dirDocumentation  /opt/lampp/lib/mysql/plugin/
Edit Edit plugin maturity  unknown
Edit Edit portDocumentation  3,306
Edit Edit preload buffer sizeDocumentation  32 KiB
Edit Edit profilingDocumentation  OFF
Edit Edit profiling history sizeDocumentation  15
Edit Edit progress report time  5
Edit Edit protocol versionDocumentation  10
Edit Edit query alloc block sizeDocumentation  16 KiB
Edit Edit query cache limitDocumentation  1 MiB
Edit Edit query cache min res unitDocumentation  4,096
Edit Edit query cache sizeDocumentation  1 MiB
Edit Edit query cache strip comments  OFF
Edit Edit query cache typeDocumentation  OFF
Edit Edit query cache wlock invalidateDocumentation  OFF
Edit Edit query prealloc sizeDocumentation  24 KiB
Edit Edit range alloc block sizeDocumentation  4 KiB
Edit Edit read buffer sizeDocumentation  128 KiB
Edit Edit read onlyDocumentation  OFF
Edit Edit read rnd buffer sizeDocumentation  256 KiB
Edit Edit relay logDocumentation  
Edit Edit relay log basenameDocumentation  
Edit Edit relay log indexDocumentation  
Edit Edit relay log info fileDocumentation  relay-log.info
Edit Edit relay log purgeDocumentation  ON
Edit Edit relay log recoveryDocumentation  OFF
Edit Edit relay log space limitDocumentation  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 hostDocumentation  
Edit Edit report passwordDocumentation  
Edit Edit report portDocumentation  3,306
Edit Edit report userDocumentation  
Edit Edit rowid merge buff size  8,388,608
Edit Edit secure authDocumentation  ON
Edit Edit secure file privDocumentation  
Edit Edit server idDocumentation  0
Edit Edit skip external lockingDocumentation  ON
Edit Edit skip name resolveDocumentation  OFF
Edit Edit skip networkingDocumentation  OFF
Edit Edit skip show databaseDocumentation  OFF
Edit Edit slave compressed protocolDocumentation  OFF
Edit Edit slave ddl exec mode  IDEMPOTENT
Edit Edit slave domain parallel threads  0
Edit Edit slave exec modeDocumentation  STRICT
Edit Edit slave load tmpdirDocumentation  /tmp
Edit Edit slave max allowed packetDocumentation  1,073,741,824
Edit Edit slave net timeoutDocumentation  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 errorsDocumentation  OFF
Edit Edit slave sql verify checksumDocumentation  ON
Edit Edit slave transaction retriesDocumentation  10
Edit Edit slave type conversionsDocumentation  
Edit Edit slow launch timeDocumentation  2
Edit Edit slow query logDocumentation  OFF
Edit Edit slow query log fileDocumentation  servidor1-slow.log
Edit Edit socketDocumentation  /opt/lampp/var/mysql/mysql.sock
Edit Edit sort buffer sizeDocumentation  2 MiB
Edit Edit sql auto is nullDocumentation  OFF
Edit Edit sql big selectsDocumentation  ON
Edit Edit sql buffer resultDocumentation  OFF
Edit Edit sql log binDocumentation  ON
Edit Edit sql log offDocumentation  OFF
Edit Edit sql modeDocumentation  NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
Edit Edit sql notesDocumentation  ON
Edit Edit sql quote show createDocumentation  ON
Edit Edit sql safe updatesDocumentation  OFF
Edit Edit sql select limitDocumentation  18,446,744,073,709,551,616
Edit Edit sql slave skip counterDocumentation  0
Edit Edit sql warningsDocumentation  OFF
Edit Edit ssl caDocumentation  
Edit Edit ssl capathDocumentation  
Edit Edit ssl certDocumentation  
Edit Edit ssl cipherDocumentation  
Edit Edit ssl crlDocumentation  
Edit Edit ssl crlpathDocumentation  
Edit Edit ssl keyDocumentation  
Edit Edit storage engineDocumentation  InnoDB
Edit Edit stored program cacheDocumentation  256
Edit Edit strict password validation  ON
Edit Edit sync binlogDocumentation  0
Edit Edit sync frmDocumentation  ON
Edit Edit sync master infoDocumentation  10,000
Edit Edit sync relay logDocumentation  10,000
Edit Edit sync relay log infoDocumentation  10,000
Edit Edit system time zoneDocumentation  -3
Edit Edit table definition cacheDocumentation  400
Edit Edit table open cacheDocumentation  2,000
Edit Edit thread cache sizeDocumentation  0
Edit Edit thread concurrencyDocumentation  10
Edit Edit thread handlingDocumentation  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  4
Edit Edit thread pool stall limit  500
Edit Edit thread stackDocumentation  295,936
Edit Edit time formatDocumentation  %H:%i:%s
Edit Edit time zoneDocumentation  SYSTEM
Edit Edit timed mutexesDocumentation  OFF
Edit Edit tmp table sizeDocumentation  16 MiB
Edit Edit tmpdirDocumentation  /tmp
Edit Edit transaction alloc block sizeDocumentation  8 KiB
Edit Edit transaction prealloc sizeDocumentation  4 KiB
Edit Edit tx isolationDocumentation  REPEATABLE-READ
Edit Edit tx read onlyDocumentation  OFF
Edit Edit unique checksDocumentation  ON
Edit Edit updatable views with limitDocumentation  YES
Edit Edit use stat tables  NEVER
Edit Edit userstat  OFF
Edit Edit versionDocumentation  10.1.31-MariaDB
Edit Edit version commentDocumentation  Source distribution
Edit Edit version compile machineDocumentation  x86_64
Edit Edit version compile osDocumentation  Linux
Edit Edit version malloc library  system
Edit Edit version ssl library  OpenSSL 1.0.2n 7 Dec 2017
Edit Edit wait timeoutDocumentation  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  servidor1
Edit Edit wsrep notify cmd  
Edit Edit wsrep on  OFF
Edit Edit wsrep patch version  wsrep_25.21
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