Edit
|
aria block size
|
8,192
|
Edit
|
aria checkpoint interval
|
30
|
Edit
|
aria checkpoint log activity
|
1,048,576
|
Edit
|
aria encrypt tables
|
OFF
|
Edit
|
aria force start after recovery failures
|
0
|
Edit
|
aria group commit
|
none
|
Edit
|
aria group commit interval
|
0
|
Edit
|
aria log file size
|
1,073,741,824
|
Edit
|
aria log purge type
|
immediate
|
Edit
|
aria max sort file size
|
9,223,372,036,853,727,232
|
Edit
|
aria page checksum
|
ON
|
Edit
|
aria pagecache age threshold
|
300
|
Edit
|
aria pagecache buffer size
|
134,217,728
|
Edit
|
aria pagecache division limit
|
100
|
Edit
|
aria pagecache file hash size
|
512
|
Edit
|
aria recover
|
NORMAL
|
Edit
|
aria repair threads
|
1
|
Edit
|
aria sort buffer size
|
268,434,432
|
Edit
|
aria stats method
|
nulls_unequal
|
Edit
|
aria sync log dir
|
NEWFILE
|
Edit
|
aria used for temp tables
|
ON
|
Edit
|
auto increment increment
|
1
|
Edit
|
auto increment offset
|
1
|
Edit
|
autocommit
|
ON
|
Edit
|
automatic sp privileges
|
ON
|
Edit
|
back log
|
80
|
Edit
|
basedir
|
C:/xampp/mysql
|
Edit
|
big tables
|
OFF
|
Edit
|
binlog annotate row events
|
OFF
|
Edit
|
binlog cache size
|
32 KiB
|
Edit
|
binlog checksum
|
NONE
|
Edit
|
binlog commit wait count
|
0
|
Edit
|
binlog commit wait usec
|
100,000
|
Edit
|
binlog direct non transactional updates
|
OFF
|
Edit
|
binlog format
|
STATEMENT
|
Edit
|
binlog optimize thread scheduling
|
ON
|
Edit
|
binlog row image
|
FULL
|
Edit
|
binlog stmt cache size
|
32 KiB
|
Edit
|
bulk insert buffer size
|
8 MiB
|
Edit
|
character set client
|
latin1
|
|
(Session value) |
utf8mb4 |
Edit
|
character set connection
|
latin1
|
|
(Session value) |
utf8mb4 |
Edit
|
character set database
|
latin1
|
Edit
|
character set filesystem
|
binary
|
Edit
|
character set results
|
latin1
|
|
(Session value) |
utf8mb4 |
Edit
|
character set server
|
latin1
|
Edit
|
character set system
|
utf8
|
Edit
|
character sets dir
|
C:\xampp\mysql\share\charsets\
|
Edit
|
collation connection
|
latin1_swedish_ci
|
|
(Session value) |
utf8mb4_unicode_ci |
Edit
|
collation database
|
latin1_swedish_ci
|
Edit
|
collation server
|
latin1_swedish_ci
|
Edit
|
completion type
|
NO_CHAIN
|
Edit
|
concurrent insert
|
AUTO
|
Edit
|
connect timeout
|
10
|
Edit
|
core file
|
OFF
|
Edit
|
datadir
|
C:\xampp\mysql\data\
|
Edit
|
date format
|
%Y-%m-%d
|
Edit
|
datetime format
|
%Y-%m-%d %H:%i:%s
|
Edit
|
deadlock search depth long
|
15
|
Edit
|
deadlock search depth short
|
4
|
Edit
|
deadlock timeout long
|
50,000,000
|
Edit
|
deadlock timeout short
|
10,000
|
Edit
|
debug no thread alarm
|
OFF
|
Edit
|
default regex flags
|
|
Edit
|
default storage engine
|
InnoDB
|
Edit
|
default tmp storage engine
|
|
Edit
|
default week format
|
0
|
Edit
|
delay key write
|
ON
|
Edit
|
delayed insert limit
|
100
|
Edit
|
delayed insert timeout
|
300
|
Edit
|
delayed queue size
|
1,000
|
Edit
|
div precision increment
|
4
|
Edit
|
encrypt binlog
|
OFF
|
Edit
|
encrypt tmp disk tables
|
OFF
|
Edit
|
encrypt tmp files
|
OFF
|
Edit
|
enforce storage engine
|
|
Edit
|
event scheduler
|
OFF
|
Edit
|
expensive subquery limit
|
100
|
Edit
|
expire logs days
|
0
|
Edit
|
explicit defaults for timestamp
|
OFF
|
Edit
|
extra max connections
|
1
|
Edit
|
extra port
|
0
|
Edit
|
flush
|
OFF
|
Edit
|
flush time
|
0
|
Edit
|
foreign key checks
|
ON
|
Edit
|
ft boolean syntax
|
+ -><()~*:""&|
|
Edit
|
ft max word len
|
84
|
Edit
|
ft min word len
|
4
|
Edit
|
ft query expansion limit
|
20
|
Edit
|
ft stopword file
|
(built-in)
|
Edit
|
general log
|
OFF
|
Edit
|
general log file
|
Manikandan-SAMS.log
|
Edit
|
group concat max len
|
1,024
|
Edit
|
gtid binlog pos
|
0-2-96767971
|
Edit
|
gtid binlog state
|
0-34550-46867343,0-2-96767971
|
Edit
|
gtid current pos
|
0-2-96767971
|
Edit
|
gtid domain id
|
0
|
Edit
|
gtid ignore duplicates
|
OFF
|
Edit
|
gtid slave pos
|
0-34550-96691701
|
Edit
|
gtid strict mode
|
OFF
|
Edit
|
have compress
|
YES
|
Edit
|
have crypt
|
NO
|
Edit
|
have dynamic loading
|
YES
|
Edit
|
have geometry
|
YES
|
Edit
|
have openssl
|
NO
|
Edit
|
have profiling
|
YES
|
Edit
|
have query cache
|
YES
|
Edit
|
have rtree keys
|
YES
|
Edit
|
have ssl
|
DISABLED
|
Edit
|
have symlink
|
NO
|
Edit
|
histogram size
|
0
|
Edit
|
histogram type
|
SINGLE_PREC_HB
|
Edit
|
host cache size
|
279
|
Edit
|
hostname
|
Manikandan-SAMS
|
Edit
|
ignore builtin innodb
|
OFF
|
Edit
|
ignore db dirs
|
|
Edit
|
init connect
|
|
Edit
|
init file
|
|
Edit
|
init slave
|
|
Edit
|
innodb adaptive flushing
|
ON
|
Edit
|
innodb adaptive flushing lwm
|
10
|
Edit
|
innodb adaptive hash index
|
ON
|
Edit
|
innodb adaptive hash index partitions
|
1
|
Edit
|
innodb adaptive max sleep delay
|
150,000
|
Edit
|
innodb additional mem pool size
|
2 MiB
|
Edit
|
innodb api bk commit interval
|
5
|
Edit
|
innodb api disable rowlock
|
OFF
|
Edit
|
innodb api enable binlog
|
OFF
|
Edit
|
innodb api enable mdl
|
OFF
|
Edit
|
innodb api trx level
|
0
|
Edit
|
innodb autoextend increment
|
64
|
Edit
|
innodb autoinc lock mode
|
1
|
Edit
|
innodb background scrub data check interval
|
3,600
|
Edit
|
innodb background scrub data compressed
|
OFF
|
Edit
|
innodb background scrub data interval
|
604,800
|
Edit
|
innodb background scrub data uncompressed
|
OFF
|
Edit
|
innodb buf dump status frequency
|
0
|
Edit
|
innodb buffer pool dump at shutdown
|
OFF
|
Edit
|
innodb buffer pool dump now
|
OFF
|
Edit
|
innodb buffer pool dump pct
|
100
|
Edit
|
innodb buffer pool filename
|
ib_buffer_pool
|
Edit
|
innodb buffer pool instances
|
8
|
Edit
|
innodb buffer pool load abort
|
OFF
|
Edit
|
innodb buffer pool load at startup
|
OFF
|
Edit
|
innodb buffer pool load now
|
OFF
|
Edit
|
innodb buffer pool populate
|
OFF
|
Edit
|
innodb buffer pool size
|
16 MiB
|
Edit
|
innodb change buffer max size
|
25
|
Edit
|
innodb change buffering
|
all
|
Edit
|
innodb checksum algorithm
|
INNODB
|
Edit
|
innodb checksums
|
ON
|
Edit
|
innodb cleaner lsn age factor
|
HIGH_CHECKPOINT
|
Edit
|
innodb cmp per index enabled
|
OFF
|
Edit
|
innodb commit concurrency
|
0
|
Edit
|
innodb compression algorithm
|
zlib
|
Edit
|
innodb compression failure threshold pct
|
5
|
Edit
|
innodb compression level
|
6
|
Edit
|
innodb compression pad pct max
|
50
|
Edit
|
innodb concurrency tickets
|
5,000
|
Edit
|
innodb corrupt table action
|
assert
|
Edit
|
innodb data file path
|
ibdata1:10M:autoextend
|
Edit
|
innodb data home dir
|
C:\xampp\mysql\data
|
Edit
|
innodb default encryption key id
|
1
|
Edit
|
innodb default row format
|
compact
|
Edit
|
innodb defragment
|
OFF
|
Edit
|
innodb defragment fill factor
|
1
|
Edit
|
innodb defragment fill factor n recs
|
20
|
Edit
|
innodb defragment frequency
|
40
|
Edit
|
innodb defragment n pages
|
7
|
Edit
|
innodb defragment stats accuracy
|
0
|
Edit
|
innodb disable sort file cache
|
OFF
|
Edit
|
innodb doublewrite
|
ON
|
Edit
|
innodb empty free list algorithm
|
LEGACY
|
Edit
|
innodb encrypt log
|
OFF
|
Edit
|
innodb encrypt tables
|
OFF
|
Edit
|
innodb encryption rotate key age
|
1
|
Edit
|
innodb encryption rotation iops
|
100
|
Edit
|
innodb encryption threads
|
0
|
Edit
|
innodb fake changes
|
OFF
|
Edit
|
innodb fast shutdown
|
1
|
Edit
|
innodb fatal semaphore wait threshold
|
600
|
Edit
|
innodb file format
|
Antelope
|
Edit
|
innodb file format check
|
ON
|
Edit
|
innodb file format max
|
Antelope
|
Edit
|
innodb file per table
|
ON
|
Edit
|
innodb flush log at timeout
|
1
|
Edit
|
innodb flush log at trx commit
|
1
|
Edit
|
innodb flush method
|
|
Edit
|
innodb flush neighbors
|
1
|
Edit
|
innodb flushing avg loops
|
30
|
Edit
|
innodb force load corrupted
|
OFF
|
Edit
|
innodb force primary key
|
OFF
|
Edit
|
innodb force recovery
|
0
|
Edit
|
innodb foreground preflush
|
EXPONENTIAL_BACKOFF
|
Edit
|
innodb ft aux table
|
|
Edit
|
innodb ft cache size
|
8,000,000
|
Edit
|
innodb ft enable diag print
|
OFF
|
Edit
|
innodb ft enable stopword
|
ON
|
Edit
|
innodb ft max token size
|
84
|
Edit
|
innodb ft min token size
|
3
|
Edit
|
innodb ft num word optimize
|
2,000
|
Edit
|
innodb ft result cache limit
|
2,000,000,000
|
Edit
|
innodb ft server stopword table
|
|
Edit
|
innodb ft sort pll degree
|
2
|
Edit
|
innodb ft total cache size
|
640,000,000
|
Edit
|
innodb ft user stopword table
|
|
Edit
|
innodb idle flush pct
|
100
|
Edit
|
innodb immediate scrub data uncompressed
|
OFF
|
Edit
|
innodb instrument semaphores
|
OFF
|
Edit
|
innodb io capacity
|
200
|
Edit
|
innodb io capacity max
|
2,000
|
Edit
|
innodb kill idle transaction
|
0
|
Edit
|
innodb large prefix
|
OFF
|
Edit
|
innodb lock schedule algorithm
|
fcfs
|
Edit
|
innodb lock wait timeout
|
50
|
Edit
|
innodb locking fake changes
|
ON
|
Edit
|
innodb locks unsafe for binlog
|
OFF
|
Edit
|
innodb log arch dir
|
C:\xampp\mysql\data
|
Edit
|
innodb log arch expire sec
|
0
|
Edit
|
innodb log archive
|
OFF
|
Edit
|
innodb log block size
|
512
|
Edit
|
innodb log buffer size
|
8 MiB
|
Edit
|
innodb log checksum algorithm
|
INNODB
|
Edit
|
innodb log compressed pages
|
ON
|
Edit
|
innodb log file size
|
5 MiB
|
Edit
|
innodb log files in group
|
2
|
Edit
|
innodb log group home dir
|
C:\xampp\mysql\data
|
Edit
|
innodb lru scan depth
|
1,024
|
Edit
|
innodb max bitmap file size
|
104,857,600
|
Edit
|
innodb max changed pages
|
1,000,000
|
Edit
|
innodb max dirty pages pct
|
75
|
Edit
|
innodb max dirty pages pct lwm
|
<1
|
Edit
|
innodb max purge lag
|
0
|
Edit
|
innodb max purge lag delay
|
0
|
Edit
|
innodb mirrored log groups
|
1
|
Edit
|
innodb monitor disable
|
|
Edit
|
innodb monitor enable
|
|
Edit
|
innodb monitor reset
|
|
Edit
|
innodb monitor reset all
|
|
Edit
|
innodb mtflush threads
|
8
|
Edit
|
innodb old blocks pct
|
37
|
Edit
|
innodb old blocks time
|
1,000
|
Edit
|
innodb online alter log max size
|
128 MiB
|
Edit
|
innodb open files
|
2,000
|
Edit
|
innodb optimize fulltext only
|
OFF
|
Edit
|
innodb page size
|
16 KiB
|
Edit
|
innodb prefix index cluster optimization
|
OFF
|
Edit
|
innodb print all deadlocks
|
OFF
|
Edit
|
innodb print lock wait timeout info
|
OFF
|
Edit
|
innodb purge batch size
|
300
|
Edit
|
innodb purge threads
|
1
|
Edit
|
innodb random read ahead
|
OFF
|
Edit
|
innodb read ahead threshold
|
56
|
Edit
|
innodb read io threads
|
4
|
Edit
|
innodb read only
|
OFF
|
Edit
|
innodb replication delay
|
0
|
Edit
|
innodb rollback on timeout
|
OFF
|
Edit
|
innodb rollback segments
|
128
|
Edit
|
innodb scrub log
|
OFF
|
Edit
|
innodb scrub log speed
|
256
|
Edit
|
innodb show locks held
|
10
|
Edit
|
innodb show verbose locks
|
0
|
Edit
|
innodb simulate comp failures
|
0
|
Edit
|
innodb sort buffer size
|
1 MiB
|
Edit
|
innodb spin wait delay
|
6
|
Edit
|
innodb stats auto recalc
|
ON
|
Edit
|
innodb stats include delete marked
|
OFF
|
Edit
|
innodb stats method
|
nulls_equal
|
Edit
|
innodb stats modified counter
|
0
|
Edit
|
innodb stats on metadata
|
OFF
|
Edit
|
innodb stats persistent
|
ON
|
Edit
|
innodb stats persistent sample pages
|
20
|
Edit
|
innodb stats sample pages
|
8
|
Edit
|
innodb stats traditional
|
ON
|
Edit
|
innodb stats transient sample pages
|
8
|
Edit
|
innodb status output
|
OFF
|
Edit
|
innodb status output locks
|
OFF
|
Edit
|
innodb strict mode
|
OFF
|
Edit
|
innodb support xa
|
ON
|
Edit
|
innodb sync array size
|
1
|
Edit
|
innodb sync spin loops
|
30
|
Edit
|
innodb table locks
|
ON
|
Edit
|
innodb thread concurrency
|
0
|
Edit
|
innodb thread sleep delay
|
10,000
|
Edit
|
innodb tmpdir
|
|
Edit
|
innodb track changed pages
|
OFF
|
Edit
|
innodb undo directory
|
.
|
Edit
|
innodb undo logs
|
128
|
Edit
|
innodb undo tablespaces
|
0
|
Edit
|
innodb use atomic writes
|
OFF
|
Edit
|
innodb use fallocate
|
OFF
|
Edit
|
innodb use global flush log at trx commit
|
ON
|
Edit
|
innodb use mtflush
|
OFF
|
Edit
|
innodb use native aio
|
ON
|
Edit
|
innodb use stacktrace
|
OFF
|
Edit
|
innodb use sys malloc
|
ON
|
Edit
|
innodb use trim
|
OFF
|
Edit
|
innodb version
|
5.6.41-84.1
|
Edit
|
innodb write io threads
|
4
|
Edit
|
interactive timeout
|
28,800
|
Edit
|
join buffer size
|
256 KiB
|
Edit
|
join buffer space limit
|
2,097,152
|
Edit
|
join cache level
|
2
|
Edit
|
keep files on create
|
OFF
|
Edit
|
key buffer size
|
16 MiB
|
Edit
|
key cache age threshold
|
300
|
Edit
|
key cache block size
|
1 KiB
|
Edit
|
key cache division limit
|
100
|
Edit
|
key cache file hash size
|
512
|
Edit
|
key cache segments
|
0
|
Edit
|
large files support
|
ON
|
Edit
|
large page size
|
0 B
|
Edit
|
large pages
|
OFF
|
Edit
|
lc messages
|
en_US
|
Edit
|
lc messages dir
|
|
Edit
|
lc time names
|
en_US
|
Edit
|
license
|
GPL
|
Edit
|
local infile
|
ON
|
Edit
|
lock wait timeout
|
31,536,000
|
Edit
|
log bin
|
ON
|
Edit
|
log bin basename
|
C:\xampp\mysql\data\mysql-bin
|
Edit
|
log bin index
|
C:\xampp\mysql\data\mysql-bin.index
|
Edit
|
log bin trust function creators
|
OFF
|
Edit
|
log error
|
.\mysql_error.log
|
Edit
|
log output
|
FILE
|
Edit
|
log queries not using indexes
|
OFF
|
Edit
|
log slave updates
|
OFF
|
Edit
|
log slow admin statements
|
OFF
|
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
|
log slow rate limit
|
1
|
Edit
|
log slow slave statements
|
OFF
|
Edit
|
log slow verbosity
|
|
Edit
|
log tc size
|
24,576
|
Edit
|
log warnings
|
1
|
Edit
|
long query time
|
10
|
Edit
|
low priority updates
|
OFF
|
Edit
|
lower case file system
|
ON
|
Edit
|
lower case table names
|
1
|
Edit
|
master verify checksum
|
OFF
|
Edit
|
max allowed packet
|
1,048,576
|
Edit
|
max binlog cache size
|
4 GiB
|
Edit
|
max binlog size
|
1 GiB
|
Edit
|
max binlog stmt cache size
|
4 GiB
|
Edit
|
max connect errors
|
100
|
Edit
|
max connections
|
151
|
Edit
|
max delayed threads
|
20
|
Edit
|
max digest length
|
1,024
|
Edit
|
max error count
|
64
|
Edit
|
max heap table size
|
16 MiB
|
Edit
|
max insert delayed threads
|
20
|
Edit
|
max join size
|
18,446,744,073,709,551,616
|
Edit
|
max length for sort data
|
1,024
|
Edit
|
max long data size
|
1,048,576
|
Edit
|
max prepared stmt count
|
16,382
|
Edit
|
max relay log size
|
1 GiB
|
Edit
|
max seeks for key
|
4,294,967,295
|
Edit
|
max session mem used
|
9,223,372,036,854,775,808
|
Edit
|
max sort length
|
1,024
|
Edit
|
max sp recursion depth
|
0
|
Edit
|
max statement time
|
0
|
Edit
|
max tmp tables
|
32
|
Edit
|
max user connections
|
0
|
Edit
|
max write lock count
|
4,294,967,295
|
Edit
|
metadata locks cache size
|
1,024
|
Edit
|
metadata locks hash instances
|
8
|
Edit
|
min examined row limit
|
0
|
Edit
|
mrr buffer size
|
262,144
|
Edit
|
multi range count
|
256
|
Edit
|
myisam block size
|
1,024
|
Edit
|
myisam data pointer size
|
6 B
|
Edit
|
myisam max sort file size
|
1.999 GiB
|
Edit
|
myisam mmap size
|
4 GiB
|
Edit
|
myisam recover options
|
DEFAULT
|
Edit
|
myisam repair threads
|
1
|
Edit
|
myisam sort buffer size
|
8 MiB
|
Edit
|
myisam stats method
|
NULLS_UNEQUAL
|
Edit
|
myisam use mmap
|
OFF
|
Edit
|
mysql56 temporal format
|
ON
|
Edit
|
named pipe
|
OFF
|
Edit
|
net buffer length
|
8,192
|
Edit
|
net read timeout
|
30
|
Edit
|
net retry count
|
10
|
Edit
|
net write timeout
|
60
|
Edit
|
old
|
OFF
|
Edit
|
old alter table
|
OFF
|
Edit
|
old mode
|
|
Edit
|
old passwords
|
OFF
|
Edit
|
open files limit
|
6,230
|
Edit
|
optimizer prune level
|
1
|
Edit
|
optimizer search depth
|
62
|
Edit
|
optimizer selectivity sampling limit
|
100
|
Edit
|
optimizer switch
|
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
|
optimizer use condition selectivity
|
1
|
Edit
|
performance schema
|
OFF
|
Edit
|
performance schema accounts size
|
-1
|
Edit
|
performance schema digests size
|
-1
|
Edit
|
performance schema events stages history long size
|
-1
|
Edit
|
performance schema events stages history size
|
-1
|
Edit
|
performance schema events statements history long size
|
-1
|
Edit
|
performance schema events statements history size
|
-1
|
Edit
|
performance schema events waits history long size
|
-1
|
Edit
|
performance schema events waits history size
|
-1
|
Edit
|
performance schema hosts size
|
-1
|
Edit
|
performance schema max cond classes
|
80
|
Edit
|
performance schema max cond instances
|
-1
|
Edit
|
performance schema max digest length
|
1,024
|
Edit
|
performance schema max file classes
|
50
|
Edit
|
performance schema max file handles
|
32,768
|
Edit
|
performance schema max file instances
|
-1
|
Edit
|
performance schema max mutex classes
|
200
|
Edit
|
performance schema max mutex instances
|
-1
|
Edit
|
performance schema max rwlock classes
|
40
|
Edit
|
performance schema max rwlock instances
|
-1
|
Edit
|
performance schema max socket classes
|
10
|
Edit
|
performance schema max socket instances
|
-1
|
Edit
|
performance schema max stage classes
|
150
|
Edit
|
performance schema max statement classes
|
178
|
Edit
|
performance schema max table handles
|
-1
|
Edit
|
performance schema max table instances
|
-1
|
Edit
|
performance schema max thread classes
|
50
|
Edit
|
performance schema max thread instances
|
-1
|
Edit
|
performance schema session connect attrs size
|
-1
|
Edit
|
performance schema setup actors size
|
100
|
Edit
|
performance schema setup objects size
|
100
|
Edit
|
performance schema users size
|
-1
|
Edit
|
pid file
|
C:\xampp\mysql\data\mysql.pid
|
Edit
|
plugin dir
|
C:\xampp\mysql\lib\plugin\
|
Edit
|
plugin maturity
|
unknown
|
Edit
|
port
|
3,306
|
Edit
|
preload buffer size
|
32 KiB
|
Edit
|
profiling
|
OFF
|
Edit
|
profiling history size
|
15
|
Edit
|
progress report time
|
5
|
Edit
|
protocol version
|
10
|
Edit
|
query alloc block size
|
16 KiB
|
Edit
|
query cache limit
|
1 MiB
|
Edit
|
query cache min res unit
|
4,096
|
Edit
|
query cache size
|
1 MiB
|
Edit
|
query cache strip comments
|
OFF
|
Edit
|
query cache type
|
OFF
|
Edit
|
query cache wlock invalidate
|
OFF
|
Edit
|
query prealloc size
|
24 KiB
|
Edit
|
range alloc block size
|
4 KiB
|
Edit
|
read buffer size
|
256 KiB
|
Edit
|
read only
|
OFF
|
Edit
|
read rnd buffer size
|
512 KiB
|
Edit
|
relay log
|
mysql-relay-bin
|
Edit
|
relay log basename
|
C:\xampp\mysql\data\mysql-relay-bin
|
Edit
|
relay log index
|
C:\xampp\mysql\data\mysql-relay-bin.index
|
Edit
|
relay log info file
|
relay-log.info
|
Edit
|
relay log purge
|
ON
|
Edit
|
relay log recovery
|
OFF
|
Edit
|
relay log space limit
|
0
|
Edit
|
replicate annotate row events
|
OFF
|
Edit
|
replicate do db
|
sams
|
Edit
|
replicate do table
|
|
Edit
|
replicate events marked for skip
|
REPLICATE
|
Edit
|
replicate ignore db
|
|
Edit
|
replicate ignore table
|
|
Edit
|
replicate wild do table
|
|
Edit
|
replicate wild ignore table
|
|
Edit
|
report host
|
|
Edit
|
report password
|
|
Edit
|
report port
|
3,306
|
Edit
|
report user
|
|
Edit
|
rowid merge buff size
|
8,388,608
|
Edit
|
secure auth
|
ON
|
Edit
|
secure file priv
|
|
Edit
|
server id
|
2
|
Edit
|
shared memory
|
OFF
|
Edit
|
shared memory base name
|
MYSQL
|
Edit
|
skip external locking
|
ON
|
Edit
|
skip name resolve
|
OFF
|
Edit
|
skip networking
|
OFF
|
Edit
|
skip show database
|
OFF
|
Edit
|
slave compressed protocol
|
OFF
|
Edit
|
slave ddl exec mode
|
IDEMPOTENT
|
Edit
|
slave domain parallel threads
|
0
|
Edit
|
slave exec mode
|
STRICT
|
Edit
|
slave load tmpdir
|
C:\xampp\tmp
|
Edit
|
slave max allowed packet
|
1,073,741,824
|
Edit
|
slave net timeout
|
3,600
|
Edit
|
slave parallel max queued
|
131,072
|
Edit
|
slave parallel mode
|
conservative
|
Edit
|
slave parallel threads
|
0
|
Edit
|
slave run triggers for rbr
|
NO
|
Edit
|
slave skip errors
|
1,062
|
Edit
|
slave sql verify checksum
|
ON
|
Edit
|
slave transaction retries
|
10
|
Edit
|
slave type conversions
|
|
Edit
|
slow launch time
|
2
|
Edit
|
slow query log
|
OFF
|
Edit
|
slow query log file
|
Manikandan-SAMS-slow.log
|
Edit
|
socket
|
C:/xampp/mysql/mysql.sock
|
Edit
|
sort buffer size
|
512 KiB
|
Edit
|
sql auto is null
|
OFF
|
Edit
|
sql big selects
|
ON
|
Edit
|
sql buffer result
|
OFF
|
Edit
|
sql log bin
|
ON
|
Edit
|
sql log off
|
OFF
|
Edit
|
sql mode
|
NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
|
Edit
|
sql notes
|
ON
|
Edit
|
sql quote show create
|
ON
|
Edit
|
sql safe updates
|
OFF
|
Edit
|
sql select limit
|
18,446,744,073,709,551,616
|
Edit
|
sql slave skip counter
|
0
|
Edit
|
sql warnings
|
OFF
|
Edit
|
ssl ca
|
|
Edit
|
ssl capath
|
|
Edit
|
ssl cert
|
|
Edit
|
ssl cipher
|
|
Edit
|
ssl crl
|
|
Edit
|
ssl crlpath
|
|
Edit
|
ssl key
|
|
Edit
|
storage engine
|
InnoDB
|
Edit
|
stored program cache
|
256
|
Edit
|
strict password validation
|
ON
|
Edit
|
sync binlog
|
0
|
Edit
|
sync frm
|
ON
|
Edit
|
sync master info
|
10,000
|
Edit
|
sync relay log
|
10,000
|
Edit
|
sync relay log info
|
10,000
|
Edit
|
system time zone
|
India Standard Time
|
Edit
|
table definition cache
|
400
|
Edit
|
table open cache
|
2,000
|
Edit
|
thread cache size
|
0
|
Edit
|
thread concurrency
|
10
|
Edit
|
thread handling
|
pool-of-threads
|
Edit
|
thread pool max threads
|
1,000
|
Edit
|
thread pool min threads
|
1
|
Edit
|
thread stack
|
295,936
|
Edit
|
time format
|
%H:%i:%s
|
Edit
|
time zone
|
SYSTEM
|
Edit
|
timed mutexes
|
OFF
|
Edit
|
tmp table size
|
16 MiB
|
Edit
|
tmpdir
|
C:/xampp/tmp
|
Edit
|
transaction alloc block size
|
8 KiB
|
Edit
|
transaction prealloc size
|
4 KiB
|
Edit
|
tx isolation
|
REPEATABLE-READ
|
Edit
|
tx read only
|
OFF
|
Edit
|
unique checks
|
ON
|
Edit
|
updatable views with limit
|
YES
|
Edit
|
use stat tables
|
NEVER
|
Edit
|
userstat
|
OFF
|
Edit
|
version
|
10.1.37-MariaDB
|
Edit
|
version comment
|
mariadb.org binary distribution
|
Edit
|
version compile machine
|
32
|
Edit
|
version compile os
|
Win32
|
Edit
|
version malloc library
|
system
|
Edit
|
version ssl library
|
YaSSL 2.4.4
|
Edit
|
wait timeout
|
28,800
|