MySqlDumper

SQL-Browser

[Tools] Datenbank: `information_schema` Tabelle: `SYSTEM_VARIABLES`

Daten-Ansicht

Datensatz einfügen Tabellenstruktur bearbeiten

Tabelle `information_schema`.`SYSTEM_VARIABLES`
Datensätze 31 - 60 von insgesamt 666 << < > >>

	#	VARIABLE_NAME	SESSION_VALUE	GLOBAL_VALUE	GLOBAL_VALUE_ORIGIN	DEFAULT_VALUE	VARIABLE_SCOPE	VARIABLE_TYPE	VARIABLE_COMMENT	NUMERIC_MIN_VALUE	NUMERIC_MAX_VALUE	NUMERIC_BLOCK_SIZE	ENUM_VALUE_LIST [BB]	READ_ONLY	COMMAND_LINE_ARGUMENT	GLOBAL_VALUE_PATH
Ansicht: kompakt Die Abfrage enthält 15 Spalten
	31.	ARIA_RECOVER_OPTIONS	NULL	BACKUP,QUICK	COMPILE-TIME	BACKUP,QUICK	GLOBAL	SET	Specifies how corrupted tables should be automatically repaired	NULL	NULL	NULL	NORMAL,BACKUP,FORCE,QUICK,OFF	NO	OPTIONAL	NULL
	32.	MAX_SP_RECURSION_DEPTH	0	0	COMPILE-TIME	0	SESSION	BIGINT UNSIGNED	Maximum stored procedure recursion depth	0	255	1	NULL	NO	OPTIONAL	NULL
	33.	INNODB_FT_NUM_WORD_OPTIMIZE	NULL	2000	COMPILE-TIME	2000	GLOBAL	BIGINT UNSIGNED	InnoDB Fulltext search number of words to optimize for each optimize table call	1000	10000	0	NULL	NO	OPTIONAL	NULL
	34.	PERFORMANCE_SCHEMA_MAX_INDEX_STAT	NULL	-1	COMPILE-TIME	-1	GLOBAL	BIGINT	Maximum number of index statistics for instrumented tables. Use 0 to disable, -1 for automated scaling.	-1	1048576	1	NULL	YES	REQUIRED	NULL
	35.	WSREP_DRUPAL_282555_WORKAROUND	NULL	OFF	COMPILE-TIME	OFF	GLOBAL	BOOLEAN	Enable a workaround to handle the cases where inserting a DEFAULT value into an auto-increment column could fail with duplicate key error	NULL	NULL	NULL	OFF,ON	NO	OPTIONAL	NULL
	36.	PERFORMANCE_SCHEMA_MAX_MUTEX_CLASSES	NULL	210	COMPILE-TIME	210	GLOBAL	BIGINT UNSIGNED	Maximum number of mutex instruments.	0	256	1	NULL	YES	REQUIRED	NULL
	37.	TMP_MEMORY_TABLE_SIZE	33554432	33554432	COMPILE-TIME	16777216	SESSION	BIGINT UNSIGNED	If an internal in-memory temporary table exceeds this size, MariaDB will automatically convert it to an on-disk MyISAM or Aria table. Same as tmp_table_size.	0	18446744073709551615	1	NULL	NO	REQUIRED	NULL
	38.	MAX_LENGTH_FOR_SORT_DATA	1024	1024	COMPILE-TIME	1024	SESSION	BIGINT UNSIGNED	Max number of bytes in sorted records	4	8388608	1	NULL	NO	REQUIRED	NULL
	39.	REPORT_HOST	NULL		COMPILE-TIME		GLOBAL	VARCHAR	Hostname or IP of the slave to be reported to the master during slave registration. Will appear in the output of SHOW SLAVE HOSTS. Leave unset if you do not want the slave to register itself with the master. Note that it is not sufficient for the master to simply read the IP of the slave off the socket once the slave connects. Due to NAT and other routing issues, that IP may not be valid for connecting to the slave from the master or other hosts	NULL	NULL	NULL	NULL	YES	REQUIRED	NULL
	40.	PERFORMANCE_SCHEMA_EVENTS_STAGES_HISTORY_SIZE	NULL	-1	COMPILE-TIME	-1	GLOBAL	BIGINT	Number of rows per thread in EVENTS_STAGES_HISTORY. Use 0 to disable, -1 for automated sizing.	-1	1024	1	NULL	YES	REQUIRED	NULL
	41.	INNODB_SORT_BUFFER_SIZE	NULL	1048576	COMPILE-TIME	1048576	GLOBAL	BIGINT UNSIGNED	Memory buffer size for index creation	65536	67108864	0	NULL	YES	REQUIRED	NULL
	42.	PERFORMANCE_SCHEMA_MAX_STAGE_CLASSES	NULL	160	COMPILE-TIME	160	GLOBAL	BIGINT UNSIGNED	Maximum number of stage instruments.	0	256	1	NULL	YES	REQUIRED	NULL
	43.	PERFORMANCE_SCHEMA_EVENTS_STATEMENTS_HISTORY_SIZE	NULL	-1	COMPILE-TIME	-1	GLOBAL	BIGINT	Number of rows per thread in EVENTS_STATEMENTS_HISTORY. Use 0 to disable, -1 for automated sizing.	-1	1024	1	NULL	YES	REQUIRED	NULL
	44.	SLAVE_TRANSACTION_RETRY_ERRORS	NULL	1158,1159,1160,1161,1205,1213,1429,2013,12701	COMPILE-TIME		GLOBAL	VARCHAR	Tells the slave thread to retry transaction for replication when a query event returns an error from the provided list. Deadlock error, elapsed lock wait timeout, net read error, net read timeout, net write error, net write timeout, connect error and 2 types of lost connection error are automatically added to this list	NULL	NULL	NULL	NULL	YES	REQUIRED	NULL
	45.	LARGE_FILES_SUPPORT	NULL	ON	COMPILE-TIME	NULL	GLOBAL	BOOLEAN	Whether mysqld was compiled with options for large file support	NULL	NULL	NULL	OFF,ON	YES	NULL	NULL
	46.	PERFORMANCE_SCHEMA_SETUP_ACTORS_SIZE	NULL	-1	COMPILE-TIME	-1	GLOBAL	BIGINT	Maximum number of rows in SETUP_ACTORS.	-1	1024	1	NULL	YES	REQUIRED	NULL
	47.	ARIA_PAGECACHE_AGE_THRESHOLD	NULL	300	COMPILE-TIME	300	GLOBAL	BIGINT UNSIGNED	This characterizes the number of hits a hot block has to be untouched until it is considered aged enough to be downgraded to a warm block. This specifies the percentage ratio of that number of hits to the total number of blocks in the page cache.	100	18446744073709551615	100	NULL	NO	REQUIRED	NULL
	48.	PERFORMANCE_SCHEMA_SESSION_CONNECT_ATTRS_SIZE	NULL	-1	COMPILE-TIME	-1	GLOBAL	BIGINT	Size of session attribute string buffer per thread. Use 0 to disable, -1 for automated sizing.	-1	1048576	1	NULL	YES	REQUIRED	NULL
	49.	WSREP_AUTO_INCREMENT_CONTROL	NULL	ON	COMPILE-TIME	ON	GLOBAL	BOOLEAN	To automatically control the assignment of autoincrement variables	NULL	NULL	NULL	OFF,ON	NO	OPTIONAL	NULL
	50.	DEFAULT_STORAGE_ENGINE	InnoDB	InnoDB	COMPILE-TIME	InnoDB	SESSION	VARCHAR	The default storage engine for new tables	NULL	NULL	NULL	NULL	NO	NULL	NULL
	51.	INNODB_BACKGROUND_SCRUB_DATA_COMPRESSED	NULL	OFF	COMPILE-TIME	OFF	GLOBAL	BOOLEAN	Deprecated parameter with no effect.	NULL	NULL	NULL	OFF,ON	NO	OPTIONAL	NULL
	52.	DELAYED_INSERT_LIMIT	NULL	10	CONFIG	100	GLOBAL	BIGINT UNSIGNED	After inserting delayed_insert_limit rows, the INSERT DELAYED handler will check if there are any SELECT statements pending. If so, it allows these to execute before continuing.	1	4294967295	1	NULL	NO	REQUIRED	NULL
	53.	GROUP_CONCAT_MAX_LEN	1048576	1048576	COMPILE-TIME	1048576	SESSION	INT UNSIGNED	The maximum length of the result of function GROUP_CONCAT()	4	4294967295	1	NULL	NO	REQUIRED	NULL
	54.	BINLOG_FILE_CACHE_SIZE	NULL	16384	COMPILE-TIME	16384	GLOBAL	BIGINT UNSIGNED	The size of file cache for the binary log	8192	18446744073709551615	4096	NULL	NO	REQUIRED	NULL
	55.	RANGE_ALLOC_BLOCK_SIZE	4096	4096	COMPILE-TIME	4096	SESSION	BIGINT UNSIGNED	Allocation block size for storing ranges during optimization	4096	4294967295	1024	NULL	NO	REQUIRED	NULL
	56.	SLOW_QUERY_LOG	OFF	OFF	COMPILE-TIME	OFF	SESSION	BOOLEAN	Log slow queries to a table or log file. Defaults logging to a file 'hostname'-slow.log or a table mysql.slow_log if --log-output=TABLE is used. Must be enabled to activate other slow log options.	NULL	NULL	NULL	OFF,ON	NO	OPTIONAL	NULL
	57.	VERSION_COMMENT	NULL	Debian 11	COMPILE-TIME	NULL	GLOBAL	VARCHAR	Value of the COMPILATION_COMMENT option specified by CMake when building MariaDB, for example mariadb.org binary distribution.	NULL	NULL	NULL	NULL	YES	NULL	NULL
	58.	BIND_ADDRESS	NULL		COMPILE-TIME		GLOBAL	VARCHAR	IP address to bind to.	NULL	NULL	NULL	NULL	YES	REQUIRED	NULL
	59.	INNODB_TMPDIR			COMPILE-TIME		SESSION	VARCHAR	Directory for temporary non-tablespace files.	NULL	NULL	NULL	NULL	NO	OPTIONAL	NULL
	60.	PERFORMANCE_SCHEMA_EVENTS_TRANSACTIONS_HISTORY_SIZE	NULL	-1	COMPILE-TIME	-1	GLOBAL	BIGINT	Number of rows per thread in EVENTS_TRANSACTIONS_HISTORY. Use 0 to disable, -1 for automated sizing.	-1	1024	1	NULL	YES	REQUIRED	NULL

Datensätze 31 - 60 von insgesamt 666 << < > >>