MySqlDumper

SQL-Browser

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

Daten-Ansicht

Datensatz einfügen Tabellenstruktur bearbeiten

Tabelle `information_schema`.`SYSTEM_VARIABLES`
Datensätze 61 - 90 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
	61.	INNODB_ENCRYPTION_THREADS	NULL	0	COMPILE-TIME	0	GLOBAL	INT UNSIGNED	Number of threads performing background key rotation	0	255	0	NULL	NO	REQUIRED	NULL
	62.	LC_MESSAGES_DIR	NULL		COMPILE-TIME		GLOBAL	VARCHAR	Directory where error messages are	NULL	NULL	NULL	NULL	YES	REQUIRED	NULL
	63.	MYISAM_RECOVER_OPTIONS	NULL	BACKUP,QUICK	COMPILE-TIME	BACKUP,QUICK	GLOBAL	SET	Specifies how corrupted tables should be automatically repaired	NULL	NULL	NULL	DEFAULT,BACKUP,FORCE,QUICK,BACKUP_ALL,OFF	YES	OPTIONAL	NULL
	64.	COLUMN_COMPRESSION_ZLIB_LEVEL	6	6	COMPILE-TIME	6	SESSION	INT UNSIGNED	zlib compression level (1 gives best speed, 9 gives best compression)	0	9	1	NULL	NO	REQUIRED	NULL
	65.	RPL_SEMI_SYNC_MASTER_TIMEOUT	NULL	10000	COMPILE-TIME	10000	GLOBAL	BIGINT UNSIGNED	The timeout value (in ms) for semi-synchronous replication in the master	0	18446744073709551615	1	NULL	NO	REQUIRED	NULL
	66.	PERFORMANCE_SCHEMA_EVENTS_STAGES_HISTORY_LONG_SIZE	NULL	-1	COMPILE-TIME	-1	GLOBAL	BIGINT	Number of rows in EVENTS_STAGES_HISTORY_LONG. Use 0 to disable, -1 for automated sizing.	-1	1048576	1	NULL	YES	REQUIRED	NULL
	67.	LOW_PRIORITY_UPDATES	OFF	OFF	COMPILE-TIME	OFF	SESSION	BOOLEAN	INSERT/DELETE/UPDATE has lower priority than selects	NULL	NULL	NULL	OFF,ON	NO	OPTIONAL	NULL
	68.	CHARACTER_SET_RESULTS	utf8	latin1	COMPILE-TIME	latin1	SESSION	ENUM	The character set used for returning query results to the client	NULL	NULL	NULL	NULL	NO	NULL	NULL
	69.	REPORT_PASSWORD	NULL		COMPILE-TIME		GLOBAL	VARCHAR	The account password of the slave to be reported to the master during slave registration	NULL	NULL	NULL	NULL	YES	REQUIRED	NULL
	70.	ARIA_FORCE_START_AFTER_RECOVERY_FAILURES	NULL	0	COMPILE-TIME	0	GLOBAL	BIGINT UNSIGNED	Number of consecutive log recovery failures after which logs will be automatically deleted to cure the problem; 0 (the default) disables the feature.	0	255	1	NULL	YES	REQUIRED	NULL
	71.	WSREP_DBUG_OPTION	NULL		COMPILE-TIME		GLOBAL	VARCHAR	DBUG options to provider library	NULL	NULL	NULL	NULL	NO	REQUIRED	NULL
	72.	CHARACTER_SET_CONNECTION	utf8	latin1	COMPILE-TIME	latin1	SESSION	ENUM	The character set used for literals that do not have a character set introducer and for number-to-string conversion	NULL	NULL	NULL	NULL	NO	NULL	NULL
	73.	SQL_BIG_SELECTS	ON	ON	COMPILE-TIME	OFF	SESSION	BOOLEAN	If set to 0, MariaDB will not perform large SELECTs. See max_join_size for details. If max_join_size is set to anything but DEFAULT, sql_big_selects is automatically set to 0. If sql_big_selects is again set, max_join_size will be ignored.	NULL	NULL	NULL	OFF,ON	NO	NULL	NULL
	74.	JOIN_BUFFER_SIZE	8388608	8388608	CONFIG	262144	SESSION	BIGINT UNSIGNED	The size of the buffer that is used for joins	128	18446744073709551615	128	NULL	NO	REQUIRED	NULL
	75.	TRANSACTION_ALLOC_BLOCK_SIZE	8192	8192	COMPILE-TIME	8192	SESSION	BIGINT UNSIGNED	Allocation block size for transactions to be stored in binary log	1024	134217728	1024	NULL	NO	REQUIRED	NULL
	76.	OPTIMIZER_PRUNE_LEVEL	1	1	COMPILE-TIME	1	SESSION	BIGINT UNSIGNED	Controls the heuristic(s) applied during query optimization to prune less-promising partial plans from the optimizer search space. Meaning: 0 - do not apply any heuristic, thus perform exhaustive search; 1 - prune plans based on number of retrieved rows	0	1	1	NULL	NO	REQUIRED	NULL
	77.	INNODB_FLUSHING_AVG_LOOPS	NULL	30	COMPILE-TIME	30	GLOBAL	BIGINT UNSIGNED	Number of iterations over which the background flushing is averaged.	1	1000	0	NULL	NO	REQUIRED	NULL
	78.	EXPLICIT_DEFAULTS_FOR_TIMESTAMP	OFF	OFF	COMPILE-TIME	OFF	SESSION	BOOLEAN	This option causes CREATE TABLE to create all TIMESTAMP columns as NULL with DEFAULT NULL attribute, Without this option, TIMESTAMP columns are NOT NULL and have implicit DEFAULT clauses.	NULL	NULL	NULL	OFF,ON	NO	OPTIONAL	NULL
	79.	SYNC_FRM	NULL	ON	COMPILE-TIME	ON	GLOBAL	BOOLEAN	Sync .frm files to disk on creation	NULL	NULL	NULL	OFF,ON	NO	OPTIONAL	NULL
	80.	COMPLETION_TYPE	NO_CHAIN	NO_CHAIN	COMPILE-TIME	NO_CHAIN	SESSION	ENUM	The transaction completion type	NULL	NULL	NULL	NO_CHAIN,CHAIN,RELEASE	NO	REQUIRED	NULL
	81.	BINLOG_ROW_METADATA	NULL	NO_LOG	COMPILE-TIME	NO_LOG	GLOBAL	ENUM	Controls whether metadata is logged using FULL , MINIMAL format and NO_LOG.FULL causes all metadata to be logged; MINIMAL means that only metadata actually required by slave is logged; NO_LOG NO metadata will be logged.Default: NO_LOG.	NULL	NULL	NULL	NO_LOG,MINIMAL,FULL	NO	REQUIRED	NULL
	82.	DATADIR	NULL	/users/_sql/mysql/	COMMAND-LINE	/users/_sql/mysql/	GLOBAL	VARCHAR	Path to the database root directory	NULL	NULL	NULL	NULL	YES	REQUIRED	NULL
	83.	INNODB_SCRUB_LOG	NULL	OFF	COMPILE-TIME	OFF	GLOBAL	BOOLEAN	Deprecated parameter with no effect.	NULL	NULL	NULL	OFF,ON	YES	OPTIONAL	NULL
	84.	KEY_CACHE_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 key cache	100	4294967295	100	NULL	NO	REQUIRED	NULL
	85.	INNODB_IO_CAPACITY_MAX	NULL	2000	COMPILE-TIME	18446744073709551615	GLOBAL	BIGINT UNSIGNED	Limit to which innodb_io_capacity can be inflated.	100	18446744073709551615	0	NULL	NO	REQUIRED	NULL
	86.	CHECK_CONSTRAINT_CHECKS	ON	ON	COMPILE-TIME	ON	SESSION	BOOLEAN	check_constraint_checks	NULL	NULL	NULL	OFF,ON	NO	NULL	NULL
	87.	INNODB_IO_CAPACITY	NULL	200	COMPILE-TIME	200	GLOBAL	BIGINT UNSIGNED	Number of IOPs the server can do. Tunes the background IO rate	100	18446744073709551615	0	NULL	NO	REQUIRED	NULL
	88.	PERFORMANCE_SCHEMA_EVENTS_TRANSACTIONS_HISTORY_LONG_SIZE	NULL	-1	COMPILE-TIME	-1	GLOBAL	BIGINT	Number of rows in EVENTS_TRANSACTIONS_HISTORY_LONG. Use 0 to disable, -1 for automated sizing.	-1	1048576	1	NULL	YES	REQUIRED	NULL
	89.	WSREP_CLUSTER_ADDRESS	NULL		COMPILE-TIME		GLOBAL	VARCHAR	Address to initially connect to cluster	NULL	NULL	NULL	NULL	NO	REQUIRED	NULL
	90.	LOG_BIN_COMPRESS_MIN_LEN	NULL	256	COMPILE-TIME	256	GLOBAL	INT UNSIGNED	Minimum length of sql statement(in statement mode) or record(in row mode)that can be compressed.	10	1024	1	NULL	NO	OPTIONAL	NULL

Datensätze 61 - 90 von insgesamt 666 << < > >>