Variable	Session value	Global value
back log	50	50
basedir	/usr/	/usr/
bdb cache size	8388600	8388600
bdb log buffer size	0	0
bdb home
bdb max lock	10000	10000
bdb logdir
bdb shared data	OFF	OFF
bdb tmpdir
bdb version	Sleepycat Software: Berkeley DB 3.2.9a: (March 5, 2005)	Sleepycat Software: Berkeley DB 3.2.9a: (March 5, 2005)
binlog cache size	32768	32768
bulk insert buffer size	8388608	8388608
character set	latin1	latin1
character sets	latin1 big5 cp1251 cp1257 croat czech danish dec8 dos estonia euc_kr gb2312 gbk german1 greek hebrew hp8 hungarian koi8_ru koi8_ukr latin1_de latin2 latin5 sjis swe7 tis620 ujis usa7 win1250 win1251ukr win1251	latin1 big5 cp1251 cp1257 croat czech danish dec8 dos estonia euc_kr gb2312 gbk german1 greek hebrew hp8 hungarian koi8_ru koi8_ukr latin1_de latin2 latin5 sjis swe7 tis620 ujis usa7 win1250 win1251ukr win1251
concurrent insert	ON	ON
connect timeout	5	5
convert character set
datadir	/var/lib/mysql/	/var/lib/mysql/
default week format	0	0
delay key write	ON	ON
delayed insert limit	100	100
delayed insert timeout	300	300
delayed queue size	1000	1000
flush	OFF	OFF
flush time	0	0
ft boolean syntax	+ -><()~*:""&|	+ -><()~*:""&|
ft min word len	4	4
ft max word len	254	254
ft max word len for sort	20	20
ft stopword file	(built-in)	(built-in)
have bdb	DISABLED	DISABLED
have crypt	YES	YES
have innodb	YES	YES
have isam	YES	YES
have raid	YES	YES
have symlink	YES	YES
have openssl	NO	NO
have query cache	YES	YES
init file
innodb additional mem pool size	1048576	1048576
innodb autoextend increment	8	8
innodb buffer pool size	8388608	8388608
innodb data file path	ibdata1:10M:autoextend	ibdata1:10M:autoextend
innodb data home dir
innodb file io threads	4	4
innodb force recovery	0	0
innodb thread concurrency	8	8
innodb flush log at trx commit	1	1
innodb fast shutdown	ON	ON
innodb flush method
innodb lock wait timeout	50	50
innodb log arch dir	./	./
innodb log archive	OFF	OFF
innodb log buffer size	1048576	1048576
innodb log file size	5242880	5242880
innodb log files in group	2	2
innodb log group home dir	./	./
innodb mirrored log groups	1	1
innodb max dirty pages pct	90	90
innodb max purge lag	0	0
innodb table locks	ON	ON
interactive timeout	28800	28800
join buffer size	131072	131072
key buffer size	16777216	16777216
language	/usr/share/mysql/english/	/usr/share/mysql/english/
large files support	ON	ON
license	GPL	GPL
local infile	ON	ON
locked in memory	OFF	OFF
log	OFF	OFF
log update	OFF	OFF
log bin	ON	ON
log slave updates	OFF	OFF
log slow queries	ON	ON
log warnings	1	1
long query time	10	10
low priority updates	OFF	OFF
lower case file system	OFF	OFF
lower case table names	0	0
max allowed packet	16776192	16776192
max binlog cache size	4294967295	4294967295
max binlog size	104857600	104857600
max connections	100	100
max connect errors	10	10
max delayed threads	20	20
max insert delayed threads	20	20
max heap table size	16777216	16777216
max join size	4294967295	4294967295
max relay log size	0	0
max seeks for key	4294967295	4294967295
max sort length	1024	1024
max user connections	0	0
max tmp tables	32	32
max write lock count	4294967295	4294967295
myisam max extra sort file size	268435456	268435456
myisam max sort file size	2147483647	2147483647
myisam repair threads	1	1
myisam recover options	OFF	OFF
myisam sort buffer size	8388608	8388608
net buffer length	16384	16384
net read timeout	30	30
net retry count	10	10
net write timeout	60	60
new	OFF	OFF
open files limit	1024	1024
pid file	/var/run/mysqld/mysqld.pid	/var/run/mysqld/mysqld.pid
log error
port	3306	3306
protocol version	10	10
query alloc block size	8192	8192
query cache limit	1048576	1048576
query cache size	16777216	16777216
query cache type	ON	ON
query cache wlock invalidate	OFF	OFF
query prealloc size	8192	8192
range alloc block size	2048	2048
read buffer size	131072	131072
read only	OFF	OFF
read rnd buffer size	262144	262144
rpl recovery rank	0	0
server id	1	1
slave net timeout	3600	3600
skip external locking	ON	ON
skip networking	OFF	OFF
skip show database	OFF	OFF
slow launch time	2	2
socket	/var/run/mysqld/mysqld.sock	/var/run/mysqld/mysqld.sock
sort buffer size	2097144	2097144
sql mode	0	0
table cache	64	64
table type	MYISAM	MYISAM
thread cache size	0	0
thread stack	131072	131072
tx isolation	REPEATABLE-READ	REPEATABLE-READ
timezone	EET	EET
tmp table size	33554432	33554432
tmpdir	/tmp/	/tmp/
transaction alloc block size	8192	8192
transaction prealloc size	4096	4096
version	4.0.24_Debian-10-log	4.0.24_Debian-10-log
version comment	Source distribution	Source distribution
version compile os	pc-linux-gnu	pc-linux-gnu
wait timeout	28800	28800