 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
|
/opt/lampp |
|
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
|
/opt/lampp/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
|
datadir
|
/opt/lampp/var/mysql/ |
|
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
|
servidor1.log |
|
Edit
|
group concat max len
|
1,024 |
|
Edit
|
gtid binlog pos |
|
|
Edit
|
gtid binlog state |
|
|
Edit
|
gtid current pos |
|
|
Edit
|
gtid domain id |
0 |
|
Edit
|
gtid ignore duplicates |
OFF |
|
Edit
|
gtid slave pos |
|
|
Edit
|
gtid strict mode |
OFF |
|
Edit
|
have compress
|
YES |
|
Edit
|
have crypt
|
YES |
|
Edit
|
have dynamic loading
|
YES |
|
Edit
|
have geometry
|
YES |
|
Edit
|
have openssl
|
YES |
|
Edit
|
have profiling
|
YES |
|
Edit
|
have query cache
|
YES |
|
Edit
|
have rtree keys
|
YES |
|
Edit
|
have ssl
|
DISABLED |
|
Edit
|
have symlink
|
YES |
|
Edit
|
histogram size |
0 |
|
Edit
|
histogram type |
SINGLE_PREC_HB |
|
Edit
|
host cache size
|
279 |
|
Edit
|
hostname
|
servidor1 |
|
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
|
8 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
|
128 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:12M:autoextend |
|
Edit
|
innodb data home dir
|
|
|
Edit
|
innodb default encryption key id |
1 |
|
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 disallow writes |
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 |
./ |
|
Edit
|
innodb log arch expire sec |
0 |
|
Edit
|
innodb log archive |
OFF |
|
Edit
|
innodb log block size |
512 |
|
Edit
|
innodb log buffer size
|
16 MiB |
|
Edit
|
innodb log checksum algorithm
|
INNODB |
|
Edit
|
innodb log compressed pages
|
ON |
|
Edit
|
innodb log file size
|
48 MiB |
|
Edit
|
innodb log files in group
|
2 |
|
Edit
|
innodb log group home dir
|
./ |
|
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 sched priority cleaner |
19 |
|
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
|
OFF |
|
Edit
|
innodb use stacktrace |
OFF |
|
Edit
|
innodb use sys malloc
|
ON |
|
Edit
|
innodb use trim |
OFF |
|
Edit
|
innodb version
|
5.6.36-83.0 |
|
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
|
128 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
|
locked in memory
|
OFF |
|
Edit
|
log bin
|
OFF |
|
Edit
|
log bin basename
|
|
|
Edit
|
log bin index
|
|
|
Edit
|
log bin trust function creators
|
OFF |
|
Edit
|
log error
|
/opt/lampp/var/mysql/servidor1.err |
|
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
|
OFF |
|
Edit
|
lower case table names
|
0 |
|
Edit
|
master verify checksum
|
OFF |
|
Edit
|
max allowed packet
|
4,194,304 |
|
Edit
|
max binlog cache size
|
16 EiB |
|
Edit
|
max binlog size
|
1 GiB |
|
Edit
|
max binlog stmt cache size
|
16 EiB |
|
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
|
4,194,304 |
|
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
|
8 EiB |
|
Edit
|
myisam mmap size
|
16 EiB |
|
Edit
|
myisam recover options
|
DEFAULT |
|
Edit
|
myisam repair threads
|
1 |
|
Edit
|
myisam sort buffer size
|
127.999 MiB |
|
Edit
|
myisam stats method
|
NULLS_UNEQUAL |
|
Edit
|
myisam use mmap
|
OFF |
|
Edit
|
mysql56 temporal format |
ON |
|
Edit
|
net buffer length
|
16,384 |
|
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
|
4,162 |
|
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
|
/opt/lampp/var/mysql/servidor1.pid |
|
Edit
|
plugin dir
|
/opt/lampp/lib/mysql/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
|
128 KiB |
|
Edit
|
read only
|
OFF |
|
Edit
|
read rnd buffer size
|
256 KiB |
|
Edit
|
relay log
|
|
|
Edit
|
relay log basename
|
|
|
Edit
|
relay log 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 |
|
|
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
|
0 |
|
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
|
/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
|
OFF |
|
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
|
servidor1-slow.log |
|
Edit
|
socket
|
/opt/lampp/var/mysql/mysql.sock |
|
Edit
|
sort buffer size
|
2 MiB |
|
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
|
-3 |
|
Edit
|
table definition cache
|
400 |
|
Edit
|
table open cache
|
2,000 |
|
Edit
|
thread cache size
|
0 |
|
Edit
|
thread concurrency
|
10 |
|
Edit
|
thread handling
|
one-thread-per-connection |
|
Edit
|
thread pool idle timeout |
60 |
|
Edit
|
thread pool max threads |
1,000 |
|
Edit
|
thread pool oversubscribe |
3 |
|
Edit
|
thread pool size |
4 |
|
Edit
|
thread pool stall limit |
500 |
|
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
|
/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.31-MariaDB |
|
Edit
|
version comment
|
Source distribution |
|
Edit
|
version compile machine
|
x86_64 |
|
Edit
|
version compile os
|
Linux |
|
Edit
|
version malloc library |
system |
|
Edit
|
version ssl library |
OpenSSL 1.0.2n 7 Dec 2017 |
|
Edit
|
wait timeout
|
28,800 |
|
Edit
|
wsrep osu method |
TOI |
|
Edit
|
wsrep auto increment control |
ON |
|
Edit
|
wsrep causal reads |
OFF |
|
Edit
|
wsrep certify nonpk |
ON |
|
Edit
|
wsrep cluster address |
|
|
Edit
|
wsrep cluster name |
my_wsrep_cluster |
|
Edit
|
wsrep convert lock to trx |
OFF |
|
Edit
|
wsrep data home dir |
/opt/lampp/var/mysql/ |
|
Edit
|
wsrep dbug option |
|
|
Edit
|
wsrep debug |
OFF |
|
Edit
|
wsrep desync |
OFF |
|
Edit
|
wsrep dirty reads |
OFF |
|
Edit
|
wsrep drupal 282555 workaround |
OFF |
|
Edit
|
wsrep forced binlog format |
NONE |
|
Edit
|
wsrep gtid domain id |
0 |
|
Edit
|
wsrep gtid mode |
OFF |
|
Edit
|
wsrep load data splitting |
ON |
|
Edit
|
wsrep log conflicts |
OFF |
|
Edit
|
wsrep max ws rows |
0 |
|
Edit
|
wsrep max ws size |
2,147,483,647 |
|
Edit
|
wsrep mysql replication bundle |
0 |
|
Edit
|
wsrep node address |
|
|
Edit
|
wsrep node incoming address |
AUTO |
|
Edit
|
wsrep node name |
servidor1 |
|
Edit
|
wsrep notify cmd |
|
|
Edit
|
wsrep on |
OFF |
|
Edit
|
wsrep patch version |
wsrep_25.21 |
|
Edit
|
wsrep provider |
none |
|
Edit
|
wsrep provider options |
|
|
Edit
|
wsrep recover |
OFF |
|
Edit
|
wsrep replicate myisam |
OFF |
|
Edit
|
wsrep restart slave |
OFF |
|
Edit
|
wsrep retry autocommit |
1 |
|
Edit
|
wsrep slave fk checks |
ON |
|
Edit
|
wsrep slave uk checks |
OFF |
|
Edit
|
wsrep slave threads |
1 |
|
Edit
|
wsrep sst auth |
|
|
Edit
|
wsrep sst donor |
|
|
Edit
|
wsrep sst donor rejects queries |
OFF |
|
Edit
|
wsrep sst method |
rsync |
|
Edit
|
wsrep sst receive address |
AUTO |
|
Edit
|
wsrep start position |
00000000-0000-0000-0000-000000000000:-1 |
|
Edit
|
wsrep sync wait |
0 |
