186.10.255.215:81 / localhost

Mostrar las bases de datos navegación como árbol En el panel de navegación, reemplaza el árbol de base de datos con un selector
Enlace al panel principal Enlace con el panel principal resaltando la base de datos o tabla actual.
Mostrar el logo Mostrar el logo en el panel de navegación.
URL para enlace del logo URL a la que apuntará el logo en el panel de navegación.
Logo destino del enlace Abrir la página enlazada en la ventana principal (`principal`) o en una nueva (`nueva`).
Permitir destacar Resaltar servidor bajo el cursor.
Cantidad máxima de elementos en el primer nivel El número de elementos que pueden ser mostrados en cada página en el primer nivel del árbol de navegación.
Número mínimo de elementos para mostrar la caja de filtro Define el número mínimo de elementos (tablas, vistas, rutinas y eventos) para mostrar un cuadro de filtro.
Tablas recientemente utilizadas Número máximo de tablas recientemente utilizadas; 0 para desactivar.
Tablas favoritas Cantidad máxima de tablas favoritas; 0 para desactivar.

Cantidad máxima de elementos en una rama El número de elementos que pueden ser mostrados en cada página del árbol de navegación.
Agrupar elementos en el árbol Agrupar elementos en el árbol de navegación (determinado por el separador definido abajo en las pestañas superiores de Bases de datos y Tablas).
Activar la expansión del árbol de navegación Si tendrá la posibilidad de expandir el árbol en el panel de navegación.
Mostrar tablas en árbol Si se muestran las tablas bajo base de datos en el árbol de navegación
Mostrar vistas en árbol Si se muestran vistas bajo base de datos en el árbol de navegación
Mostrar funciones en árbol Si se muestran las funciones bajo la base de datos en el árbol de navegación
Mostrar procedimientos en árbol Si se muestran los procedimientos bajo la base de datos en el árbol de navegación
Mostrar eventos en árbol Si se muestran eventos bajo la base de datos en el árbol de navegación

Número mínimo de bases de datos a mostrar en la ventana de filtro de bases de datos
Separador de árbol de base de datos Cadena que separa bases de datos en diferentes niveles de árbol.

Destino para el icono de acceso rápido
Objetivo para el segundo icono de acceso rápido
Separador de árbol de tablas Cadena que separa tablas en diferentes niveles de árbol.
Profundidad máxima del árbol de tablas

Siempre expandir mensajes de consultas
Mostrar histórico de consultas al iniciar
Mostrar consulta de navegación actual
Ejecute consultas con Enter e introduce la nueva línea con Shift + Enter. Para que esto permanezca, vea la configuración.
Cambiar al tema oscuro

Variables y parámetros del servidor

Filtros

Que contengan la palabra:

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

Acción

Variable

Valor de la sesión / Valor global

Editar

aria block size

8,192

Editar

aria checkpoint interval

Editar

aria checkpoint log activity

1,048,576

Editar

aria encrypt tables

OFF

Editar

aria force start after recovery failures

Editar

aria group commit

none

Editar

aria group commit interval

Editar

aria log file size

1,073,741,824

Editar

aria log purge type

immediate

Editar

aria max sort file size

9,223,372,036,853,727,232

Editar

aria page checksum

Editar

aria pagecache age threshold

300

Editar

aria pagecache buffer size

134,217,728

Editar

aria pagecache division limit

100

Editar

aria pagecache file hash size

512

Editar

aria recover

NORMAL

Editar

aria repair threads

Editar

aria sort buffer size

268,434,432

Editar

aria stats method

nulls_unequal

Editar

aria sync log dir

NEWFILE

Editar

aria used for temp tables

Editar

auto increment increment

Editar

auto increment offset

Editar

autocommit

Editar

automatic sp privileges

Editar

back log

Editar

basedir

/opt/lampp

Editar

big tables

OFF

Editar

binlog annotate row events

OFF

Editar

binlog cache size

32 KB

Editar

binlog checksum

NONE

Editar

binlog commit wait count

Editar

binlog commit wait usec

100,000

Editar

binlog direct non transactional updates

OFF

Editar

binlog format

STATEMENT

Editar

binlog optimize thread scheduling

Editar

binlog row image

FULL

Editar

binlog stmt cache size

32 KB

Editar

bulk insert buffer size

8 MB

Editar

character set client

latin1

(Valor de la sesión )

utf8mb4

Editar

character set connection

latin1

(Valor de la sesión )

utf8mb4

Editar

character set database

latin1

Editar

character set filesystem

binary

Editar

character set results

latin1

(Valor de la sesión )

utf8mb4

Editar

character set server

latin1

Editar

character set system

utf8

Editar

character sets dir

/opt/lampp/share/charsets/

Editar

collation connection

latin1_swedish_ci

(Valor de la sesión )

utf8mb4_unicode_ci

Editar

collation database

latin1_swedish_ci

Editar

collation server

latin1_swedish_ci

Editar

completion type

NO_CHAIN

Editar

concurrent insert

AUTO

Editar

connect timeout

Editar

datadir

/opt/lampp/var/mysql/

Editar

date format

%Y-%m-%d

Editar

datetime format

%Y-%m-%d %H:%i:%s

Editar

deadlock search depth long

Editar

deadlock search depth short

Editar

deadlock timeout long

50,000,000

Editar

deadlock timeout short

10,000

Editar

debug no thread alarm

OFF

Editar

default regex flags

Editar

default storage engine

InnoDB

Editar

default tmp storage engine

Editar

default week format

Editar

delay key write

Editar

delayed insert limit

100

Editar

delayed insert timeout

300

Editar

delayed queue size

1,000

Editar

div precision increment

Editar

encrypt binlog

OFF

Editar

encrypt tmp disk tables

OFF

Editar

encrypt tmp files

OFF

Editar

enforce storage engine

Editar

event scheduler

OFF

Editar

expensive subquery limit

100

Editar

expire logs days

Editar

explicit defaults for timestamp

OFF

Editar

extra max connections

Editar

extra port

Editar

flush

OFF

Editar

flush time

Editar

foreign key checks

Editar

ft boolean syntax

+ -><()~*:""&|

Editar

ft max word len

Editar

ft min word len

Editar

ft query expansion limit

Editar

ft stopword file

(built-in)

Editar

general log

OFF

Editar

general log file

servidor1.log

Editar

group concat max len

1,024

Editar

gtid binlog pos

Editar

gtid binlog state

Editar

gtid current pos

Editar

gtid domain id

Editar

gtid ignore duplicates

OFF

Editar

gtid slave pos

Editar

gtid strict mode

OFF

Editar

have compress

YES

Editar

have crypt

YES

Editar

have dynamic loading

YES

Editar

have geometry

YES

Editar

have openssl

YES

Editar

have profiling

YES

Editar

have query cache

YES

Editar

have rtree keys

YES

Editar

have ssl

DISABLED

Editar

have symlink

YES

Editar

histogram size

Editar

histogram type

SINGLE_PREC_HB

Editar

host cache size

279

Editar

hostname

servidor1

Editar

ignore builtin innodb

OFF

Editar

ignore db dirs

Editar

init connect

Editar

init file

Editar

init slave

Editar

innodb adaptive flushing

Editar

innodb adaptive flushing lwm

Editar

innodb adaptive hash index

Editar

innodb adaptive hash index partitions

Editar

innodb adaptive max sleep delay

150,000

Editar

innodb additional mem pool size

8 MB

Editar

innodb api bk commit interval

Editar

innodb api disable rowlock

OFF

Editar

innodb api enable binlog

OFF

Editar

innodb api enable mdl

OFF

Editar

innodb api trx level

Editar

innodb autoextend increment

Editar

innodb autoinc lock mode

Editar

innodb background scrub data check interval

3,600

Editar

innodb background scrub data compressed

OFF

Editar

innodb background scrub data interval

604,800

Editar

innodb background scrub data uncompressed

OFF

Editar

innodb buf dump status frequency

Editar

innodb buffer pool dump at shutdown

OFF

Editar

innodb buffer pool dump now

OFF

Editar

innodb buffer pool dump pct

100

Editar

innodb buffer pool filename

ib_buffer_pool

Editar

innodb buffer pool instances

Editar

innodb buffer pool load abort

OFF

Editar

innodb buffer pool load at startup

OFF

Editar

innodb buffer pool load now

OFF

Editar

innodb buffer pool populate

OFF

Editar

innodb buffer pool size

128 MB

Editar

innodb change buffer max size

Editar

innodb change buffering

all

Editar

innodb checksum algorithm

INNODB

Editar

innodb checksums

Editar

innodb cleaner lsn age factor

HIGH_CHECKPOINT

Editar

innodb cmp per index enabled

OFF

Editar

innodb commit concurrency

Editar

innodb compression algorithm

zlib

Editar

innodb compression failure threshold pct

Editar

innodb compression level

Editar

innodb compression pad pct max

Editar

innodb concurrency tickets

5,000

Editar

innodb corrupt table action

assert

Editar

innodb data file path

ibdata1:12M:autoextend

Editar

innodb data home dir

Editar

innodb default encryption key id

Editar

innodb defragment

OFF

Editar

innodb defragment fill factor

Editar

innodb defragment fill factor n recs

Editar

innodb defragment frequency

Editar

innodb defragment n pages

Editar

innodb defragment stats accuracy

Editar

innodb disable sort file cache

OFF

Editar

innodb disallow writes

OFF

Editar

innodb doublewrite

Editar

innodb empty free list algorithm

LEGACY

Editar

innodb encrypt log

OFF

Editar

innodb encrypt tables

OFF

Editar

innodb encryption rotate key age

Editar

innodb encryption rotation iops

100

Editar

innodb encryption threads

Editar

innodb fake changes

OFF

Editar

innodb fast shutdown

Editar

innodb fatal semaphore wait threshold

600

Editar

innodb file format

Antelope

Editar

innodb file format check

Editar

innodb file format max

Antelope

Editar

innodb file per table

Editar

innodb flush log at timeout

Editar

innodb flush log at trx commit

Editar

innodb flush method

Editar

innodb flush neighbors

Editar

innodb flushing avg loops

Editar

innodb force load corrupted

OFF

Editar

innodb force primary key

OFF

Editar

innodb force recovery

Editar

innodb foreground preflush

EXPONENTIAL_BACKOFF

Editar

innodb ft aux table

Editar

innodb ft cache size

8,000,000

Editar

innodb ft enable diag print

OFF

Editar

innodb ft enable stopword

Editar

innodb ft max token size

Editar

innodb ft min token size

Editar

innodb ft num word optimize

2,000

Editar

innodb ft result cache limit

2,000,000,000

Editar

innodb ft server stopword table

Editar

innodb ft sort pll degree

Editar

innodb ft total cache size

640,000,000

Editar

innodb ft user stopword table

Editar

innodb idle flush pct

100

Editar

innodb immediate scrub data uncompressed

OFF

Editar

innodb instrument semaphores

OFF

Editar

innodb io capacity

200

Editar

innodb io capacity max

2,000

Editar

innodb kill idle transaction

Editar

innodb large prefix

OFF

Editar

innodb lock schedule algorithm

fcfs

Editar

innodb lock wait timeout

Editar

innodb locking fake changes

Editar

innodb locks unsafe for binlog

OFF

Editar

innodb log arch dir

Editar

innodb log arch expire sec

Editar

innodb log archive

OFF

Editar

innodb log block size

512

Editar

innodb log buffer size

16 MB

Editar

innodb log checksum algorithm

INNODB

Editar

innodb log compressed pages

Editar

innodb log file size

48 MB

Editar

innodb log files in group

Editar

innodb log group home dir

Editar

innodb lru scan depth

1,024

Editar

innodb max bitmap file size

104,857,600

Editar

innodb max changed pages

1,000,000

Editar

innodb max dirty pages pct

Editar

innodb max dirty pages pct lwm

Editar

innodb max purge lag

Editar

innodb max purge lag delay

Editar

innodb mirrored log groups

Editar

innodb monitor disable

Editar

innodb monitor enable

Editar

innodb monitor reset

Editar

innodb monitor reset all

Editar

innodb mtflush threads

Editar

innodb old blocks pct

Editar

innodb old blocks time

1,000

Editar

innodb online alter log max size

128 MB

Editar

innodb open files

2,000

Editar

innodb optimize fulltext only

OFF

Editar

innodb page size

16 KB

Editar

innodb prefix index cluster optimization

OFF

Editar

innodb print all deadlocks

OFF

Editar

innodb print lock wait timeout info

OFF

Editar

innodb purge batch size

300

Editar

innodb purge threads

Editar

innodb random read ahead

OFF

Editar

innodb read ahead threshold

Editar

innodb read io threads

Editar

innodb read only

OFF

Editar

innodb replication delay

Editar

innodb rollback on timeout

OFF

Editar

innodb rollback segments

128

Editar

innodb sched priority cleaner

Editar

innodb scrub log

OFF

Editar

innodb scrub log speed

256

Editar

innodb show locks held

Editar

innodb show verbose locks

Editar

innodb simulate comp failures

Editar

innodb sort buffer size

1 MB

Editar

innodb spin wait delay

Editar

innodb stats auto recalc

Editar

innodb stats include delete marked

OFF

Editar

innodb stats method

nulls_equal

Editar

innodb stats modified counter

Editar

innodb stats on metadata

OFF

Editar

innodb stats persistent

Editar

innodb stats persistent sample pages

Editar

innodb stats sample pages

Editar

innodb stats traditional

Editar

innodb stats transient sample pages

Editar

innodb status output

OFF

Editar

innodb status output locks

OFF

Editar

innodb strict mode

OFF

Editar

innodb support xa

Editar

innodb sync array size

Editar

innodb sync spin loops

Editar

innodb table locks

Editar

innodb thread concurrency

Editar

innodb thread sleep delay

10,000

Editar

innodb tmpdir

Editar

innodb track changed pages

OFF

Editar

innodb undo directory

Editar

innodb undo logs

128

Editar

innodb undo tablespaces

Editar

innodb use atomic writes

OFF

Editar

innodb use fallocate

OFF

Editar

innodb use global flush log at trx commit

Editar

innodb use mtflush

OFF

Editar

innodb use native aio

OFF

Editar

innodb use stacktrace

OFF

Editar

innodb use sys malloc

Editar

innodb use trim

OFF

Editar

innodb version

5.6.36-83.0

Editar

innodb write io threads

Editar

interactive timeout

28,800

Editar

join buffer size

256 KB

Editar

join buffer space limit

2,097,152

Editar

join cache level

Editar

keep files on create

OFF

Editar

key buffer size

128 MB

Editar

key cache age threshold

300

Editar

key cache block size

1 KB

Editar

key cache division limit

100

Editar

key cache file hash size

512

Editar

key cache segments

Editar

large files support

Editar

large page size

0 B

Editar

large pages

OFF

Editar

lc messages

en_US

(Valor de la sesión )

es_ES

Editar

lc messages dir

Editar

lc time names

en_US

Editar

license

GPL

Editar

local infile

Editar

lock wait timeout

31,536,000

Editar

locked in memory

OFF

Editar

log bin

OFF

Editar

log bin basename

Editar

log bin index

Editar

log bin trust function creators

OFF

Editar

log error

/opt/lampp/var/mysql/servidor1.err

Editar

log output

FILE

Editar

log queries not using indexes

OFF

Editar

log slave updates

OFF

Editar

log slow admin statements

OFF

Editar

log slow filter

admin,filesort,filesort_on_disk,full_join,full_scan,query_cache,query_cache_miss,tmp_table,tmp_table_on_disk

Editar

log slow rate limit

Editar

log slow slave statements

OFF

Editar

log slow verbosity

Editar

log tc size

24,576

Editar

log warnings

Editar

long query time

Editar

low priority updates

OFF

Editar

lower case file system

OFF

Editar

lower case table names

Editar

master verify checksum

OFF

Editar

max allowed packet

4,194,304

Editar

max binlog cache size

16 EB

Editar

max binlog size

1 GB

Editar

max binlog stmt cache size

16 EB

Editar

max connect errors

100

Editar

max connections

151

Editar

max delayed threads

Editar

max digest length

1,024

Editar

max error count

Editar

max heap table size

16 MB

Editar

max insert delayed threads

Editar

max join size

18,446,744,073,709,551,616

Editar

max length for sort data

1,024

Editar

max long data size

4,194,304

Editar

max prepared stmt count

16,382

Editar

max relay log size

1 GB

Editar

max seeks for key

4,294,967,295

Editar

max session mem used

9,223,372,036,854,775,808

Editar

max sort length

1,024

Editar

max sp recursion depth

Editar

max statement time

Editar

max tmp tables

Editar

max user connections

Editar

max write lock count

4,294,967,295

Editar

metadata locks cache size

1,024

Editar

metadata locks hash instances

Editar

min examined row limit

Editar

mrr buffer size

262,144

Editar

multi range count

256

Editar

myisam block size

1,024

Editar

myisam data pointer size

6 B

Editar

myisam max sort file size

8 EB

Editar

myisam mmap size

16 EB

Editar

myisam recover options

DEFAULT

Editar

myisam repair threads

Editar

myisam sort buffer size

127.999 MB

Editar

myisam stats method

NULLS_UNEQUAL

Editar

myisam use mmap

OFF

Editar

mysql56 temporal format

Editar

net buffer length

16,384

Editar

net read timeout

Editar

net retry count

Editar

net write timeout

Editar

old

OFF

Editar

old alter table

OFF

Editar

old mode

Editar

old passwords

OFF

Editar

open files limit

4,162

Editar

optimizer prune level

Editar

optimizer search depth

Editar

optimizer selectivity sampling limit

100

Editar

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

Editar

optimizer use condition selectivity

Editar

performance schema

OFF

Editar

performance schema accounts size

-1

Editar

performance schema digests size

-1

Editar

performance schema events stages history long size

-1

Editar

performance schema events stages history size

-1

Editar

performance schema events statements history long size

-1

Editar

performance schema events statements history size

-1

Editar

performance schema events waits history long size

-1

Editar

performance schema events waits history size

-1

Editar

performance schema hosts size

-1

Editar

performance schema max cond classes

Editar

performance schema max cond instances

-1

Editar

performance schema max digest length

1,024

Editar

performance schema max file classes

Editar

performance schema max file handles

32,768

Editar

performance schema max file instances

-1

Editar

performance schema max mutex classes

200

Editar

performance schema max mutex instances

-1

Editar

performance schema max rwlock classes

Editar

performance schema max rwlock instances

-1

Editar

performance schema max socket classes

Editar

performance schema max socket instances

-1

Editar

performance schema max stage classes

150

Editar

performance schema max statement classes

178

Editar

performance schema max table handles

-1

Editar

performance schema max table instances

-1

Editar

performance schema max thread classes

Editar

performance schema max thread instances

-1

Editar

performance schema session connect attrs size

-1

Editar

performance schema setup actors size

100

Editar

performance schema setup objects size

100

Editar

performance schema users size

-1

Editar

pid file

/opt/lampp/var/mysql/servidor1.pid

Editar

plugin dir

/opt/lampp/lib/mysql/plugin/

Editar

plugin maturity

unknown

Editar

port

3,306

Editar

preload buffer size

32 KB

Editar

profiling

OFF

Editar

profiling history size

Editar

progress report time

Editar

protocol version

Editar

query alloc block size

16 KB

Editar

query cache limit

1 MB

Editar

query cache min res unit

4,096

Editar

query cache size

1 MB

Editar

query cache strip comments

OFF

Editar

query cache type

OFF

Editar

query cache wlock invalidate

OFF

Editar

query prealloc size

24 KB

Editar

range alloc block size

4 KB

Editar

read buffer size

128 KB

Editar

read only

OFF

Editar

read rnd buffer size

256 KB

Editar

relay log

Editar

relay log basename

Editar

relay log index

Editar

relay log info file

relay-log.info

Editar

relay log purge

Editar

relay log recovery

OFF

Editar

relay log space limit

Editar

replicate annotate row events

OFF

Editar

replicate do db

Editar

replicate do table

Editar

replicate events marked for skip

REPLICATE

Editar

replicate ignore db

Editar

replicate ignore table

Editar

replicate wild do table

Editar

replicate wild ignore table

Editar

report host

Editar

report password

Editar

report port

3,306

Editar

report user

Editar

rowid merge buff size

8,388,608

Editar

secure auth

Editar

secure file priv

Editar

server id

Editar

skip external locking

Editar

skip name resolve

OFF

Editar

skip networking

OFF

Editar

skip show database

OFF

Editar

slave compressed protocol

OFF

Editar

slave ddl exec mode

IDEMPOTENT

Editar

slave domain parallel threads

Editar

slave exec mode

STRICT

Editar

slave load tmpdir

/tmp

Editar

slave max allowed packet

1,073,741,824

Editar

slave net timeout

3,600

Editar

slave parallel max queued

131,072

Editar

slave parallel mode

conservative

Editar

slave parallel threads

Editar

slave run triggers for rbr

Editar

slave skip errors

OFF

Editar

slave sql verify checksum

Editar

slave transaction retries

Editar

slave type conversions

Editar

slow launch time

Editar

slow query log

OFF

Editar

slow query log file

servidor1-slow.log

Editar

socket

/opt/lampp/var/mysql/mysql.sock

Editar

sort buffer size

2 MB

Editar

sql auto is null

OFF

Editar

sql big selects

Editar

sql buffer result

OFF

Editar

sql log bin

Editar

sql log off

OFF

Editar

sql mode

NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

Editar

sql notes

Editar

sql quote show create

Editar

sql safe updates

OFF

Editar

sql select limit

18,446,744,073,709,551,616

Editar

sql slave skip counter

Editar

sql warnings

OFF

Editar

ssl ca

Editar

ssl capath

Editar

ssl cert

Editar

ssl cipher

Editar

ssl crl

Editar

ssl crlpath

Editar

ssl key

Editar

storage engine

InnoDB

Editar

stored program cache

256

Editar

strict password validation

Editar

sync binlog

Editar

sync frm

Editar

sync master info

10,000

Editar

sync relay log

10,000

Editar

sync relay log info

10,000

Editar

system time zone

-3

Editar

table definition cache

400

Editar

table open cache

2,000

Editar

thread cache size

Editar

thread concurrency

Editar

thread handling

one-thread-per-connection

Editar

thread pool idle timeout

Editar

thread pool max threads

1,000

Editar

thread pool oversubscribe

Editar

thread pool size

Editar

thread pool stall limit

500

Editar

thread stack

295,936

Editar

time format

%H:%i:%s

Editar

time zone

SYSTEM

Editar

timed mutexes

OFF

Editar

tmp table size

16 MB

Editar

tmpdir

/tmp

Editar

transaction alloc block size

8 KB

Editar

transaction prealloc size

4 KB

Editar

tx isolation

REPEATABLE-READ

Editar

tx read only

OFF

Editar

unique checks

Editar

updatable views with limit

YES

Editar

use stat tables

NEVER

Editar

userstat

OFF

Editar

version

10.1.31-MariaDB

Editar

version comment

Source distribution

Editar

version compile machine

x86_64

Editar

version compile os

Linux

Editar

version malloc library

system

Editar

version ssl library

OpenSSL 1.0.2n 7 Dec 2017

Editar

wait timeout

28,800

Editar

wsrep osu method

TOI

Editar

wsrep auto increment control

Editar

wsrep causal reads

OFF

Editar

wsrep certify nonpk

Editar

wsrep cluster address

Editar

wsrep cluster name

my_wsrep_cluster

Editar

wsrep convert lock to trx

OFF

Editar

wsrep data home dir

/opt/lampp/var/mysql/

Editar

wsrep dbug option

Editar

wsrep debug

OFF

Editar

wsrep desync

OFF

Editar

wsrep dirty reads

OFF

Editar

wsrep drupal 282555 workaround

OFF

Editar

wsrep forced binlog format

NONE

Editar

wsrep gtid domain id

Editar

wsrep gtid mode

OFF

Editar

wsrep load data splitting

Editar

wsrep log conflicts

OFF

Editar

wsrep max ws rows

Editar

wsrep max ws size

2,147,483,647

Editar

wsrep mysql replication bundle

Editar

wsrep node address

Editar

wsrep node incoming address

AUTO

Editar

wsrep node name

servidor1

Editar

wsrep notify cmd

Editar

wsrep on

OFF

Editar

wsrep patch version

wsrep_25.21

Editar

wsrep provider

none

Editar

wsrep provider options

Editar

wsrep recover

OFF

Editar

wsrep replicate myisam

OFF

Editar

wsrep restart slave

OFF

Editar

wsrep retry autocommit

Editar

wsrep slave fk checks

Editar

wsrep slave uk checks

OFF

Editar

wsrep slave threads

Editar

wsrep sst auth

Editar

wsrep sst donor

Editar

wsrep sst donor rejects queries

OFF

Editar

wsrep sst method

rsync

Editar

wsrep sst receive address

AUTO

Editar

wsrep start position

00000000-0000-0000-0000-000000000000:-1

Editar

wsrep sync wait

SQL upload ( 0 ) x-

Variables y parámetros del servidor