servidor.tail0b23e9.ts.net / 127.0.0.1

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 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

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	C:/xampp/mysql
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	C:\xampp\mysql\share\charsets\
Editar	collation connection	latin1_swedish_ci
	(Valor de la sesión)	utf8mb4_general_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	C:\xampp\mysql\data\
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	servidor.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	NO
Editar	have dynamic loading	YES
Editar	have geometry	YES
Editar	have openssl	NO
Editar	have profiling	YES
Editar	have query cache	YES
Editar	have rtree keys	YES
Editar	have ssl	DISABLED
Editar	have symlink	NO
Editar	histogram size	0
Editar	histogram type	SINGLE_PREC_HB
Editar	host cache size	279
Editar	hostname	servidor
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	2 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	16 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	none
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:10M:autoextend
Editar	innodb data home dir	C:\xampp\mysql\data
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 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	C:\xampp\mysql\data
Editar	innodb log arch expire sec	0
Editar	innodb log archive	OFF
Editar	innodb log block size	512
Editar	innodb log buffer size	8 MB
Editar	innodb log checksum algorithm	INNODB
Editar	innodb log compressed pages	OFF
Editar	innodb log file size	5 MB
Editar	innodb log files in group	2
Editar	innodb log group home dir	C:\xampp\mysql\data
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	134,217,728
Editar	innodb open files	2,000
Editar	innodb optimize fulltext only	OFF
Editar	innodb page size	16,384
Editar	innodb prefix index cluster optimization	OFF
Editar	innodb print all deadlocks	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 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,048,576
Editar	innodb spin wait delay	6
Editar	innodb stats auto recalc	ON
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	ON
Editar	innodb use stacktrace	OFF
Editar	innodb use sys malloc	ON
Editar	innodb use trim	OFF
Editar	innodb version	5.6.32-79.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	16 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
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	log bin	OFF
Editar	log bin basename
Editar	log bin index
Editar	log bin trust function creators	OFF
Editar	log error	.\mysql_error.log
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	ON
Editar	lower case table names	1
Editar	master verify checksum	OFF
Editar	max allowed packet	1,048,576
Editar	max binlog cache size	4 GB
Editar	max binlog size	1 GB
Editar	max binlog stmt cache size	4 GB
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	1,048,576
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 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	1.999 GB
Editar	myisam mmap size	4 GB
Editar	myisam recover options	DEFAULT
Editar	myisam repair threads	1
Editar	myisam sort buffer size	8 MB
Editar	myisam stats method	NULLS_UNEQUAL
Editar	myisam use mmap	OFF
Editar	mysql56 temporal format	ON
Editar	named pipe	OFF
Editar	net buffer length	8,192
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	6,210
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	C:\xampp\mysql\data\mysql.pid
Editar	plugin dir	C:\xampp\mysql\lib\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	256 KB
Editar	read only	OFF
Editar	read rnd buffer size	512 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	1
Editar	shared memory	OFF
Editar	shared memory base name	MYSQL
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	C:\xampp\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	servidor-slow.log
Editar	socket	C:/xampp/mysql/mysql.sock
Editar	sort buffer size	512 KB
Editar	sql auto is null	OFF
Editar	sql big selects	ON
Editar	sql buffer result	OFF
Editar	sql log bin	ON
Editar	sql log off	OFF
Editar	sql mode	NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
Editar	sql notes	ON

Acción

Variable

Valor de la sesión / Valor global

SQL upload ( 0 ) x-

Variables y parámetros del servidor