Server: localhost:3307

Server variables and settings Documentation

Filters
Variable
Session value / Global value
 /opt/lampp
binlog checksum
 CRC32
 STATEMENT
binlog max flush queue time
 0
binlog order commits
 ON
binlog row image
 FULL
binlog rows query log events
 OFF
(Session value)
 utf8mb4
(Session value)
 utf8mb4
(Session value)
 utf8mb4
 /opt/lampp/share/charsets/
 latin1_swedish_ci
(Session value)
 utf8mb4_general_ci
 latin1_swedish_ci
 latin1_swedish_ci
 NO_CHAIN
core file
 OFF
 /opt/lampp/var/mysql/
 %Y-%m-%d
 %Y-%m-%d %H:%i:%s
default tmp storage engine
 InnoDB
disconnect on expired password
 ON
end markers in json
 OFF
enforce gtid consistency
 OFF
eq range index dive limit
 10
explicit defaults for timestamp
 OFF
 OFF
 + -><()~*:""&|
 (built-in)
 /opt/lampp/var/mysql/RAT1.log
gtid executed
 
gtid mode
 OFF
gtid owned
 
gtid purged
 
 DISABLED
 DISABLED
host cache size
 279
 RAT1
ignore db dirs
 
innodb adaptive flushing lwm
 10
innodb adaptive max sleep delay
 150,000
innodb api bk commit interval
 5
innodb api disable rowlock
 OFF
innodb api enable binlog
 OFF
innodb api enable mdl
 OFF
innodb api trx level
 0
innodb buffer pool dump at shutdown
 OFF
innodb buffer pool dump now
 OFF
innodb buffer pool filename
 ib_buffer_pool
innodb buffer pool load abort
 OFF
innodb buffer pool load at startup
 OFF
innodb buffer pool load now
 OFF
innodb change buffer max size
 25
innodb checksum algorithm
 innodb
innodb cmp per index enabled
 OFF
innodb compression failure threshold pct
 5
innodb compression level
 6
innodb compression pad pct max
 50
 ibdata1:10M:autoextend
 /opt/lampp/var/mysql/
innodb disable sort file cache
 OFF
innodb flush log at timeout
 1
innodb flush neighbors
 1
innodb flushing avg loops
 30
innodb force load corrupted
 OFF
innodb ft aux table
 
innodb ft cache size
 8,000,000
innodb ft enable diag print
 OFF
innodb ft enable stopword
 ON
innodb ft max token size
 84
innodb ft min token size
 3
innodb ft num word optimize
 2,000
innodb ft result cache limit
 2,000,000,000
innodb ft server stopword table
 
innodb ft sort pll degree
 2
innodb ft total cache size
 640,000,000
innodb ft user stopword table
 
innodb io capacity max
 2,000
innodb large prefix
 OFF
innodb log compressed pages
 ON
 /opt/lampp/var/mysql/
innodb lru scan depth
 1,024
innodb max dirty pages pct lwm
 0
innodb max purge lag delay
 0
innodb monitor disable
 
innodb monitor enable
 
innodb monitor reset
 
innodb monitor reset all
 
innodb online alter log max size
 134,217,728
innodb optimize fulltext only
 OFF
innodb page size
 16,384
innodb print all deadlocks
 OFF
innodb random read ahead
 OFF
innodb read only
 OFF
innodb rollback segments
 128
innodb sort buffer size
 1,048,576
innodb stats auto recalc
 ON
innodb stats method
 nulls_equal
innodb stats persistent
 ON
innodb stats persistent sample pages
 20
innodb stats transient sample pages
 8
innodb status output
 OFF
innodb status output locks
 OFF
innodb sync array size
 1
innodb undo directory
 .
innodb undo logs
 128
innodb undo tablespaces
 0
 /opt/lampp/share/
 GPL
 31,536,000
 OFF
log bin basename
 
log bin index
 
log bin use v1 row events
 OFF
 /opt/lampp/var/mysql/RAT1.err
log slow admin statements
 OFF
log slow slave statements
 OFF
log throttle queries not using indexes
 0
master info repository
 FILE
master verify checksum
 OFF
 18,446,744,073,709,551,616
 18,446,744,073,709,551,616
 18,446,744,073,709,551,616
metadata locks cache size
 1,024
metadata locks hash instances
 8
multi range count
 256
 nulls_unequal
 OFF
 OFF
 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,subquery_materialization_cost_based=on,use_index_extensions=on
optimizer trace
 enabled=off,one_line=off
optimizer trace features
 greedy_search=on,range_optimizer=on,dynamic_range=on,repeated_subselect=on
optimizer trace limit
 1
optimizer trace max mem size
 16,384
optimizer trace offset
 -1
performance schema accounts size
 100
performance schema digests size
 5,000
performance schema events stages history long size
 1,000
performance schema events stages history size
 10
performance schema events statements history long size
 1,000
performance schema events statements history size
 10
performance schema hosts size
 100
performance schema max socket classes
 10
performance schema max socket instances
 230
performance schema max stage classes
 150
performance schema max statement classes
 168
performance schema session connect attrs size
 512
performance schema setup actors size
 100
performance schema setup objects size
 100
performance schema users size
 100
 /opt/lampp/var/mysql/RAT1.pid
 /opt/lampp/lib/mysql/plugin/
 3,306
relay log
 
relay log basename
 
 relay-log.info
relay log info repository
 FILE
rpl stop slave timeout
 31,536,000
server id bits
 32
server uuid
 6749ef6d-1232-11ed-aed8-00163e6bc2e2
sha256 password private key path
 private_key.pem
sha256 password public key path
 public_key.pem
slave allow batching
 OFF
slave checkpoint group
 512
slave checkpoint period
 300
slave max allowed packet
 1,073,741,824
slave parallel workers
 0
slave pending jobs size max
 16,777,216
slave rows search algorithms
 TABLE_SCAN,INDEX_SCAN
slave sql verify checksum
 ON
 /opt/lampp/var/mysql/RAT1-slow.log
 /opt/lampp/var/mysql/mysql.sock
 NO_ENGINE_SUBSTITUTION
 18,446,744,073,709,551,616
ssl crl
 
ssl crlpath
 
stored program cache
 256
table open cache instances
 1
 one-thread-per-connection
 262,144
 %H:%i:%s
 SYSTEM
 /tmp
 REPEATABLE-READ
tx read only
 OFF
 5.6.16
 Source distribution
 28,800