phpMyAdmin demo - MySQL

Server variables and settings Documentation

Variable Session value / Global value Documentation
auto increment increment 1 Documentation
auto increment offset 1 Documentation
autocommit ON Documentation
automatic sp privileges ON Documentation
back log 50 Documentation
basedir /usr Documentation
big tables OFF Documentation
binlog cache size 32 KiB Documentation
binlog direct non transactional updates OFF Documentation
binlog format STATEMENT Documentation
binlog stmt cache size 32 KiB Documentation
bulk insert buffer size 8 MiB Documentation
character set client latin1 Documentation
(Session value) utf8
character set connection latin1 Documentation
(Session value) utf8
character set database latin1 Documentation
character set filesystem binary Documentation
character set results latin1 Documentation
(Session value) utf8
character set server latin1 Documentation
character set system utf8 Documentation
character sets dir /usr/share/mysql/charsets/ Documentation
collation connection latin1_swedish_ci Documentation
(Session value) utf8_general_ci
collation database latin1_swedish_ci Documentation
collation server latin1_swedish_ci Documentation
completion type NO_CHAIN Documentation
concurrent insert AUTO Documentation
connect timeout 10 Documentation
datadir /var/lib/mysql/ Documentation
date format %Y-%m-%d Documentation
datetime format %Y-%m-%d %H:%i:%s Documentation
default storage engine InnoDB Documentation
default week format 0 Documentation
delay key write ON Documentation
delayed insert limit 100 Documentation
delayed insert timeout 300 Documentation
delayed queue size 1,000 Documentation
div precision increment 4 Documentation
engine condition pushdown ON Documentation
event scheduler OFF Documentation
expire logs days 10 Documentation
flush OFF Documentation
flush time 0 Documentation
foreign key checks ON Documentation
ft boolean syntax + -><()~*:""&| Documentation
ft max word len 84 Documentation
ft min word len 4 Documentation
ft query expansion limit 20 Documentation
ft stopword file (built-in) Documentation
general log OFF Documentation
general log file /var/lib/mysql/pmademo.log Documentation
group concat max len 1,024 Documentation
have compress YES Documentation
have crypt YES Documentation
have csv YES Documentation
have dynamic loading YES Documentation
have geometry YES Documentation
have innodb YES Documentation
have ndbcluster NO
have openssl DISABLED Documentation
have partitioning YES Documentation
have profiling YES Documentation
have query cache YES Documentation
have rtree keys YES Documentation
have ssl DISABLED Documentation
have symlink YES Documentation
hostname pmademo Documentation
ignore builtin innodb OFF Documentation
init connect Documentation
init file Documentation
init slave Documentation
innodb adaptive flushing ON Documentation
innodb adaptive hash index ON Documentation
innodb additional mem pool size 8 MiB Documentation
innodb autoextend increment 8 Documentation
innodb autoinc lock mode 1 Documentation
innodb buffer pool instances 1 Documentation
innodb buffer pool size 128 MiB Documentation
innodb change buffering all Documentation
innodb checksums ON Documentation
innodb commit concurrency 0 Documentation
innodb concurrency tickets 500 Documentation
innodb data file path ibdata1:10M:autoextend Documentation
innodb data home dir Documentation
innodb doublewrite ON Documentation
innodb fast shutdown 1 Documentation
innodb file format Antelope Documentation
innodb file format check ON Documentation
innodb file format max Antelope Documentation
innodb file per table OFF Documentation
innodb flush log at trx commit 1 Documentation
innodb flush method Documentation
innodb force load corrupted OFF
innodb force recovery 0 Documentation
innodb io capacity 200 Documentation
innodb large prefix OFF
innodb lock wait timeout 50 Documentation
innodb locks unsafe for binlog OFF Documentation
innodb log buffer size 8 MiB Documentation
innodb log file size 5 MiB Documentation
innodb log files in group 2 Documentation
innodb log group home dir ./ Documentation
innodb max dirty pages pct 75 Documentation
innodb max purge lag 0 Documentation
innodb mirrored log groups 1 Documentation
innodb old blocks pct 37 Documentation
innodb old blocks time 0 Documentation
innodb open files 300 Documentation
innodb purge batch size 20 Documentation
innodb purge threads 0 Documentation
innodb random read ahead OFF
innodb read ahead threshold 56 Documentation
innodb read io threads 4 Documentation
innodb replication delay 0 Documentation
innodb rollback on timeout OFF Documentation
innodb rollback segments 128
innodb spin wait delay 6 Documentation
innodb stats method nulls_equal
innodb stats on metadata ON Documentation
innodb stats sample pages 8 Documentation
innodb strict mode OFF Documentation
innodb support xa ON Documentation
innodb sync spin loops 30 Documentation
innodb table locks ON Documentation
innodb thread concurrency 0 Documentation
innodb thread sleep delay 10,000 Documentation
innodb use native aio ON Documentation
innodb use sys malloc ON Documentation
innodb version 1.1.8 Documentation
innodb write io threads 4 Documentation
interactive timeout 28,800 Documentation
join buffer size 128 KiB Documentation
keep files on create OFF Documentation
key buffer size 16 MiB Documentation
key cache age threshold 300 Documentation
key cache block size 1 KiB Documentation
key cache division limit 100 Documentation
large files support ON Documentation
large page size 0 B Documentation
large pages OFF Documentation
lc messages en_US Documentation
lc messages dir /usr/share/mysql/ Documentation
lc time names en_US Documentation
license GPL Documentation
local infile ON Documentation
lock wait timeout 31,536,000 Documentation
locked in memory OFF Documentation
log OFF Documentation
log bin OFF Documentation
log bin trust function creators OFF Documentation
log error Documentation
log output FILE Documentation
log queries not using indexes OFF Documentation
log slave updates OFF Documentation
log slow queries OFF Documentation
log warnings 1 Documentation
long query time 10 Documentation
low priority updates OFF Documentation
lower case file system OFF Documentation
lower case table names 0 Documentation
max allowed packet 16,777,216 Documentation
max binlog cache size 16 EiB Documentation
max binlog size 100 MiB Documentation
max binlog stmt cache size 16 EiB Documentation
max connect errors 10 Documentation
max connections 151 Documentation
max delayed threads 20 Documentation
max error count 64 Documentation
max heap table size 16 MiB Documentation
max insert delayed threads 20 Documentation
max join size 18,446,744,073,709,551,616 Documentation
max length for sort data 1,024 Documentation
max long data size 16,777,216
max prepared stmt count 16,382 Documentation
max relay log size 0 B Documentation
max seeks for key 18,446,744,073,709,551,616 Documentation
max sort length 1,024 Documentation
max sp recursion depth 0 Documentation
max tmp tables 32 Documentation
max user connections 0 Documentation
max write lock count 18,446,744,073,709,551,616 Documentation
metadata locks cache size 1,024
min examined row limit 0 Documentation
multi range count 256
myisam data pointer size 6 B Documentation
myisam max sort file size 8 EiB Documentation
myisam mmap size 16 EiB Documentation
myisam recover options BACKUP Documentation
myisam repair threads 1 Documentation
myisam sort buffer size 8 MiB Documentation
myisam stats method nulls_unequal Documentation
myisam use mmap OFF Documentation
net buffer length 16,384 Documentation
net read timeout 30 Documentation
net retry count 10 Documentation
net write timeout 60 Documentation
new OFF Documentation
old OFF Documentation
old alter table OFF Documentation
old passwords OFF Documentation
open files limit 1,024 Documentation
optimizer prune level 1 Documentation
optimizer search depth 62 Documentation
optimizer switch index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,engine_condition_pushdown=on Documentation
performance schema OFF Documentation
performance schema events waits history long size 10,000 Documentation
performance schema events waits history size 10 Documentation
performance schema max cond classes 80 Documentation
performance schema max cond instances 1,000 Documentation
performance schema max file classes 50 Documentation
performance schema max file handles 32,768 Documentation
performance schema max file instances 10,000 Documentation
performance schema max mutex classes 200 Documentation
performance schema max mutex instances 1,000,000 Documentation
performance schema max rwlock classes 30 Documentation
performance schema max rwlock instances 1,000,000 Documentation
performance schema max table handles 100,000 Documentation
performance schema max table instances 50,000 Documentation
performance schema max thread classes 50 Documentation
performance schema max thread instances 1,000 Documentation
pid file /run/mysqld/mysqld.pid Documentation
plugin dir /usr/lib/mysql/plugin/ Documentation
port 3,306 Documentation
preload buffer size 32 KiB Documentation
profiling OFF Documentation
profiling history size 15 Documentation
protocol version 10 Documentation
query alloc block size 8 KiB Documentation
query cache limit 1 MiB Documentation
query cache min res unit 4,096 Documentation
query cache size 16 MiB Documentation
query cache type ON Documentation
query cache wlock invalidate OFF Documentation
query prealloc size 8 KiB Documentation
range alloc block size 4 KiB Documentation
read buffer size 128 KiB Documentation
read only OFF Documentation
read rnd buffer size 256 KiB Documentation
relay log
relay log index Documentation
relay log info file relay-log.info Documentation
relay log purge ON Documentation
relay log recovery OFF Documentation
relay log space limit 0 Documentation
report host Documentation
report password Documentation
report port 3,306 Documentation
report user Documentation
rpl recovery rank 0 Documentation
secure auth OFF Documentation
secure file priv Documentation
server id 0 Documentation
skip external locking ON Documentation
skip name resolve OFF Documentation
skip networking OFF Documentation
skip show database OFF Documentation
slave compressed protocol OFF Documentation
slave exec mode STRICT Documentation
slave load tmpdir /tmp Documentation
slave net timeout 3,600 Documentation
slave skip errors OFF Documentation
slave transaction retries 10 Documentation
slave type conversions Documentation
slow launch time 2 Documentation
slow query log OFF Documentation
slow query log file /var/lib/mysql/pmademo-slow.log Documentation
socket /run/mysqld/mysqld.sock Documentation
sort buffer size 2 MiB Documentation
sql auto is null OFF Documentation
sql big selects ON Documentation
sql big tables OFF Documentation
sql buffer result OFF Documentation
sql log bin ON Documentation
sql log off OFF Documentation
sql low priority updates OFF Documentation
sql max join size 18,446,744,073,709,551,616 Documentation
sql mode Documentation
sql notes ON Documentation
sql quote show create ON Documentation
sql safe updates OFF Documentation
sql select limit 18,446,744,073,709,551,616 Documentation
sql slave skip counter 0 Documentation
sql warnings OFF Documentation
ssl ca Documentation
ssl capath Documentation
ssl cert Documentation
ssl cipher Documentation
ssl key Documentation
storage engine InnoDB Documentation
stored program cache 256
sync binlog 0 Documentation
sync frm ON Documentation
sync master info 0 Documentation
sync relay log 0 Documentation
sync relay log info 0 Documentation
system time zone CEST Documentation
table definition cache 400 Documentation
table open cache 400 Documentation
thread cache size 8 Documentation
thread concurrency 10 Documentation
thread handling one-thread-per-connection Documentation
thread stack 196,608 Documentation
time format %H:%i:%s Documentation
time zone SYSTEM Documentation
timed mutexes OFF Documentation
tmp table size 16 MiB Documentation
tmpdir /tmp Documentation
transaction alloc block size 8 KiB Documentation
transaction prealloc size 4 KiB Documentation
tx isolation REPEATABLE-READ Documentation
unique checks ON Documentation
updatable views with limit YES Documentation
version 5.5.23-2 Documentation
version comment (Debian) Documentation
version compile machine x86_64 Documentation
version compile os debian-linux-gnu Documentation
wait timeout 28,800 Documentation
phpMyAdmin demo server, currently running Git revision RELEASE_3_5_1-4462-geb16216 from master branch.