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