c:/wamp/bin/mysql/mysql5.6.17
binlog max flush queue time
0
binlog rows query log events
OFF
block encryption mode
aes-128-ecb
c:\wamp\bin\mysql\mysql5.6.17\share\charsets\
(Session value)
utf8mb4_general_ci
c:\wamp\bin\mysql\mysql5.6.17\data\
default tmp storage engine
InnoDB
disconnect on expired password
ON
enforce gtid consistency
OFF
eq range index dive limit
10
explicit defaults for timestamp
ON
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 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
innodb disable sort file cache
OFF
innodb flush log at timeout
1
innodb flushing avg loops
30
innodb force load corrupted
OFF
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 log compressed pages
ON
innodb lru scan depth
1,024
innodb max dirty pages pct lwm
0
innodb max purge lag delay
0
innodb online alter log max size
134,217,728
innodb optimize fulltext only
OFF
innodb print all deadlocks
OFF
innodb random read ahead
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 locks
OFF
innodb undo tablespaces
0
c:\wamp\bin\mysql\mysql5.6.17\share\
log bin use v1 row events
OFF
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
metadata locks cache size
1,024
metadata locks hash instances
8
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 max mem size
16,384
optimizer trace offset
-1
performance schema accounts size
100
performance schema digests size
10,000
performance schema events stages history long size
10,000
performance schema events stages history size
10
performance schema events statements history long size
10,000
performance schema events statements history size
10
performance schema hosts size
100
performance schema max socket classes
10
performance schema max socket instances
322
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
c:\wamp\bin\mysql\mysql5.6.17\data\Server.pid
c:\wamp\bin\mysql\mysql5.6.17\lib\plugin\
relay log info repository
FILE
rpl stop slave timeout
31,536,000
server uuid
70e812d8-5850-11ec-b2bc-00215a18ebcd
slave checkpoint group
512
slave checkpoint period
300
slave max allowed packet
1,073,741,824
slave pending jobs size max
16,777,216
slave rows search algorithms
TABLE_SCAN,INDEX_SCAN
slave sql verify checksum
ON
c:\wamp\bin\mysql\mysql5.6.17\data\Server-slow.log
18,446,744,073,709,551,616
table open cache instances
1
one-thread-per-connection
MySQL Community Server (GPL)
