Server: localhost:3306

Server variables and settings Documentation

Filters
Variable
Session value / Global value
auto increment increment
 1
auto increment offset
 1
autocommit
 ON
automatic sp privileges
 ON
back log
 50
basedir
 D:/xampp/mysql
big tables
 OFF
binlog cache size
 32 KiB
binlog direct non transactional updates
 OFF
binlog format
 STATEMENT
binlog stmt cache size
 32 KiB
bulk insert buffer size
 8 MiB
character set client
 latin1
(Session value)
 utf8
character set connection
 latin1
(Session value)
 utf8
character set database
 latin1
character set filesystem
 binary
character set results
 latin1
(Session value)
 utf8
character set server
 latin1
character set system
 utf8
character sets dir
 D:\xampp\mysql\share\charsets\
collation connection
 latin1_swedish_ci
(Session value)
 utf8_general_ci
collation database
 latin1_swedish_ci
collation server
 latin1_swedish_ci
completion type
 NO_CHAIN
concurrent insert
 AUTO
connect timeout
 10
datadir
 D:\xampp\mysql\data\
date format
 %Y-%m-%d
datetime format
 %Y-%m-%d %H:%i:%s
default storage engine
 MyISAM
default week format
 0
delay key write
 ON
delayed insert limit
 100
delayed insert timeout
 300
delayed queue size
 1,000
div precision increment
 4
engine condition pushdown
 ON
event scheduler
 OFF
expire logs days
 0
flush
 OFF
flush time
 1,800
foreign key checks
 ON
ft boolean syntax
 + -><()~*:""&|
ft max word len
 84
ft min word len
 4
ft query expansion limit
 20
ft stopword file
 (built-in)
general log
 OFF
general log file
 D:\xampp\mysql\data\SKY-20180312XPJ.log
group concat max len
 1,024
have compress
 YES
have crypt
 NO
have csv
 YES
have dynamic loading
 YES
have geometry
 YES
have innodb
 DISABLED
have ndbcluster
 NO
have openssl
 DISABLED
have partitioning
 YES
have profiling
 YES
have query cache
 YES
have rtree keys
 YES
have ssl
 DISABLED
have symlink
 YES
hostname
 SKY-20180312XPJ
ignore builtin innodb
 OFF
init connect
 
init file
 
init slave
 
interactive timeout
 28,800
join buffer size
 128 KiB
keep files on create
 OFF
key buffer size
 16 MiB
key cache age threshold
 300
key cache block size
 1 KiB
key cache division limit
 100
large files support
 ON
large page size
 0 B
large pages
 OFF
lc messages
 en_US
lc messages dir
 D:\xampp\mysql\share\
lc time names
 en_US
license
 GPL
local infile
 ON
lock wait timeout
 31,536,000
log
 OFF
log bin
 OFF
log bin trust function creators
 OFF
log error
 .\mysql_error.err
log output
 FILE
log queries not using indexes
 OFF
log slave updates
 OFF
log slow queries
 OFF
log warnings
 1
long query time
 10
low priority updates
 OFF
lower case file system
 ON
lower case table names
 1
max allowed packet
 1,048,576
max binlog cache size
 16 EiB
max binlog size
 1 GiB
max binlog stmt cache size
 16 EiB
max connect errors
 10
max connections
 151
max delayed threads
 20
max error count
 64
max heap table size
 16 MiB
max insert delayed threads
 20
max join size
 18,446,744,073,709,551,616
max length for sort data
 1,024
max long data size
 1,048,576
max prepared stmt count
 16,382
max relay log size
 0 B
max seeks for key
 4,294,967,295
max sort length
 1,024
max sp recursion depth
 0
max tmp tables
 32
max user connections
 0
max write lock count
 4,294,967,295
metadata locks cache size
 1,024
min examined row limit
 0
multi range count
 256
myisam data pointer size
 6 B
myisam max sort file size
 1.999 GiB
myisam mmap size
 4 GiB
myisam recover options
 OFF
myisam repair threads
 1
myisam sort buffer size
 8 MiB
myisam stats method
 nulls_unequal
myisam use mmap
 OFF
named pipe
 OFF
net buffer length
 8,192
net read timeout
 30
net retry count
 10
net write timeout
 60
new
 OFF
old
 OFF
old alter table
 OFF
old passwords
 OFF
open files limit
 2,803
optimizer prune level
 1
optimizer search depth
 62
optimizer switch
 index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,engine_condition_pushdown=on
performance schema
 OFF
performance schema events waits history long size
 10,000
performance schema events waits history size
 10
performance schema max cond classes
 80
performance schema max cond instances
 1,000
performance schema max file classes
 50
performance schema max file handles
 32,768
performance schema max file instances
 10,000
performance schema max mutex classes
 200
performance schema max mutex instances
 1,000,000
performance schema max rwlock classes
 30
performance schema max rwlock instances
 1,000,000
performance schema max table handles
 100,000
performance schema max table instances
 50,000
performance schema max thread classes
 50
performance schema max thread instances
 1,000
pid file
 mysql.pid
plugin dir
 D:\xampp\mysql\data\lib\plugin\
port
 3,306
preload buffer size
 32 KiB
profiling
 OFF
profiling history size
 15
protocol version
 10
query alloc block size
 8 KiB
query cache limit
 1 MiB
query cache min res unit
 4,096
query cache size
 0 B
query cache type
 ON
query cache wlock invalidate
 OFF
query prealloc size
 8 KiB
range alloc block size
 4 KiB
read buffer size
 256 KiB
read only
 OFF
read rnd buffer size
 512 KiB
relay log
 
relay log index
 
relay log info file
 relay-log.info
relay log purge
 ON
relay log recovery
 OFF
relay log space limit
 0
report host
 
report password
 
report port
 3,306
report user
 
rpl recovery rank
 0
secure auth
 OFF
secure file priv
 
server id
 1
shared memory
 OFF
shared memory base name
 MYSQL
skip external locking
 ON
skip name resolve
 OFF
skip networking
 OFF
skip show database
 OFF
slave compressed protocol
 OFF
slave exec mode
 STRICT
slave load tmpdir
 D:\xampp\tmp
slave max allowed packet
 1,073,741,824
slave net timeout
 3,600
slave skip errors
 OFF
slave transaction retries
 10
slave type conversions
 
slow launch time
 2
slow query log
 OFF
slow query log file
 D:\xampp\mysql\data\SKY-20180312XPJ-slow.log
socket
 D:/xampp/mysql/mysql.sock
sort buffer size
 512 KiB
sql auto is null
 OFF
sql big selects
 ON
sql big tables
 OFF
sql buffer result
 OFF
sql log bin
 ON
sql log off
 OFF
sql low priority updates
 OFF
sql max join size
 18,446,744,073,709,551,616
sql mode
 
sql notes
 ON
sql quote show create
 ON
sql safe updates
 OFF
sql select limit
 18,446,744,073,709,551,616
sql slave skip counter
 0
sql warnings
 OFF
ssl ca
 
ssl capath
 
ssl cert
 
ssl cipher
 
ssl key
 
storage engine
 MyISAM
stored program cache
 256
sync binlog
 0
sync frm
 ON
sync master info
 0
sync relay log
 0
sync relay log info
 0
system time zone
 
table definition cache
 400
table open cache
 64
thread cache size
 0
thread concurrency
 10
thread handling
 one-thread-per-connection
thread stack
 196,608
time format
 %H:%i:%s
time zone
 SYSTEM
timed mutexes
 OFF
tmp table size
 16 MiB
tmpdir
 D:/xampp/tmp
transaction alloc block size
 8 KiB
transaction prealloc size
 4 KiB
tx isolation
 REPEATABLE-READ
unique checks
 ON
updatable views with limit
 YES
version
 5.5.32
version comment
 MySQL Community Server (GPL)
version compile machine
 x86
version compile os
 Win32
wait timeout
 28,800