MySqlDumper

SQL-Browser

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

Daten-Ansicht

Datensatz einfügen Tabellenstruktur bearbeiten

Tabelle `information_schema`.`SYSTEM_VARIABLES`
Datensätze 1 - 30 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
	1.	VERSION_SOURCE_REVISION	NULL	0e8fb977b00983d98c4c35e39bc1f36463095938	COMPILE-TIME	NULL	GLOBAL	VARCHAR	Source control revision id for MariaDB source code	NULL	NULL	NULL	NULL	YES	NULL	NULL
	2.	PERFORMANCE_SCHEMA	NULL	OFF	COMPILE-TIME	OFF	GLOBAL	BOOLEAN	Enable the performance schema.	NULL	NULL	NULL	OFF,ON	YES	OPTIONAL	NULL
	3.	SQL_MODE			CONFIG	STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION	SESSION	SET	Sets the sql mode	NULL	NULL	NULL	REAL_AS_FLOAT,PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE,IGNORE_BAD_TABLE_OPTIONS,ONLY_FULL_GROUP_BY,NO_UNSIGNED_SUBTRACTION,NO_DIR_IN_CREATE,POSTGRESQL,ORACLE,MSSQL,DB2,MAXDB,NO_KEY_OPTIONS,NO_TABLE_OPTIONS,NO_FIELD_OPTIONS,MYSQL323,MYSQL40,ANSI,NO_AUTO_VALUE_ON_ZERO,NO_BACKSLASH_ESCAPES,STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ALLOW_INVALID_DATES,ERROR_FOR_DIVISION_BY_ZERO,TRADITIONAL,NO_AUTO_CREATE_USER,HIGH_NOT_PRECEDENCE,NO_ENGINE_SUBSTITUTION,PAD_CHAR_TO_FULL_LENGTH,EMPTY_STRING_IS_NULL,SIMULTANEOUS_ASSIGNMENT,TIME_ROUND_FRACTIONAL	NO	REQUIRED	NULL
	4.	SYSTEM_VERSIONING_ALTER_HISTORY	ERROR	ERROR	COMPILE-TIME	ERROR	SESSION	ENUM	Versioning ALTER TABLE mode. ERROR: Fail ALTER with error; KEEP: Keep historical system rows and subject them to ALTER	NULL	NULL	NULL	ERROR,KEEP	NO	REQUIRED	NULL
	5.	QUERY_CACHE_STRIP_COMMENTS	OFF	OFF	COMPILE-TIME	OFF	SESSION	BOOLEAN	Strip all comments from a query before storing it in the query cache	NULL	NULL	NULL	OFF,ON	NO	OPTIONAL	NULL
	6.	PERFORMANCE_SCHEMA_EVENTS_WAITS_HISTORY_SIZE	NULL	-1	COMPILE-TIME	-1	GLOBAL	BIGINT	Number of rows per thread in EVENTS_WAITS_HISTORY. Use 0 to disable, -1 for automated sizing.	-1	1024	1	NULL	YES	REQUIRED	NULL
	7.	VERSION_COMPILE_MACHINE	NULL	x86_64	COMPILE-TIME	NULL	GLOBAL	VARCHAR	The machine type or architecture MariaDB was built on, for example i686.	NULL	NULL	NULL	NULL	YES	NULL	NULL
	8.	PERFORMANCE_SCHEMA_MAX_COND_CLASSES	NULL	90	COMPILE-TIME	90	GLOBAL	BIGINT UNSIGNED	Maximum number of condition instruments.	0	256	1	NULL	YES	REQUIRED	NULL
	9.	DEFAULT_TMP_STORAGE_ENGINE			COMPILE-TIME	NULL	SESSION	VARCHAR	The default storage engine for user-created temporary tables	NULL	NULL	NULL	NULL	NO	NULL	NULL
	10.	PERFORMANCE_SCHEMA_MAX_COND_INSTANCES	NULL	-1	COMPILE-TIME	-1	GLOBAL	BIGINT	Maximum number of instrumented condition objects. Use 0 to disable, -1 for automated sizing.	-1	1048576	1	NULL	YES	REQUIRED	NULL
	11.	INNODB_FLUSH_LOG_AT_TIMEOUT	NULL	1	COMPILE-TIME	1	GLOBAL	INT UNSIGNED	Write and flush logs every (n) second.	0	2700	0	NULL	NO	OPTIONAL	NULL
	12.	PERFORMANCE_SCHEMA_MAX_RWLOCK_INSTANCES	NULL	-1	COMPILE-TIME	-1	GLOBAL	BIGINT	Maximum number of instrumented RWLOCK objects. Use 0 to disable, -1 for automated sizing.	-1	104857600	1	NULL	YES	REQUIRED	NULL
	13.	INNODB_ENCRYPT_TEMPORARY_TABLES	NULL	OFF	COMPILE-TIME	OFF	GLOBAL	BOOLEAN	Enrypt the temporary table data.	NULL	NULL	NULL	OFF,ON	YES	OPTIONAL	NULL
	14.	PERFORMANCE_SCHEMA_MAX_PREPARED_STATEMENTS_INSTANCES	NULL	-1	COMPILE-TIME	-1	GLOBAL	BIGINT	Maximum number of instrumented prepared statements. Use 0 to disable, -1 for automated scaling.	-1	1048576	1	NULL	YES	REQUIRED	NULL
	15.	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
	16.	LC_MESSAGES_DIR	NULL		COMPILE-TIME		GLOBAL	VARCHAR	Directory where error messages are	NULL	NULL	NULL	NULL	YES	REQUIRED	NULL
	17.	QUERY_CACHE_WLOCK_INVALIDATE	OFF	OFF	COMPILE-TIME	OFF	SESSION	BOOLEAN	Invalidate queries in query cache on LOCK for write	NULL	NULL	NULL	OFF,ON	NO	OPTIONAL	NULL
	18.	PERFORMANCE_SCHEMA_MAX_MUTEX_INSTANCES	NULL	-1	COMPILE-TIME	-1	GLOBAL	BIGINT	Maximum number of instrumented MUTEX objects. Use 0 to disable, -1 for automated sizing.	-1	104857600	1	NULL	YES	REQUIRED	NULL
	19.	PERFORMANCE_SCHEMA_MAX_FILE_HANDLES	NULL	32768	COMPILE-TIME	32768	GLOBAL	BIGINT UNSIGNED	Maximum number of opened instrumented files.	0	1048576	1	NULL	YES	REQUIRED	NULL
	20.	KEY_CACHE_FILE_HASH_SIZE	NULL	512	COMPILE-TIME	512	GLOBAL	BIGINT UNSIGNED	Number of hash buckets for open and changed files. If you have a lot of MyISAM files open you should increase this for faster flush of changes. A good value is probably 1/10 of number of possible open MyISAM files.	128	16384	1	NULL	NO	REQUIRED	NULL
	21.	INNODB_STATS_TRANSIENT_SAMPLE_PAGES	NULL	8	COMPILE-TIME	8	GLOBAL	BIGINT UNSIGNED	The number of leaf index pages to sample when calculating transient statistics (if persistent statistics are not used, default 8)	1	18446744073709551615	0	NULL	NO	REQUIRED	NULL
	22.	WSREP_ON	OFF	OFF	COMPILE-TIME	OFF	SESSION	BOOLEAN	To enable wsrep replication	NULL	NULL	NULL	OFF,ON	NO	OPTIONAL	NULL
	23.	SLOW_LAUNCH_TIME	NULL	2	COMPILE-TIME	2	GLOBAL	BIGINT UNSIGNED	If creating the thread takes longer than this value (in seconds), the Slow_launch_threads counter will be incremented	0	31536000	1	NULL	NO	REQUIRED	NULL
	24.	PERFORMANCE_SCHEMA_MAX_RWLOCK_CLASSES	NULL	50	COMPILE-TIME	50	GLOBAL	BIGINT UNSIGNED	Maximum number of rwlock instruments.	0	256	1	NULL	YES	REQUIRED	NULL
	25.	LOG_SLOW_MAX_WARNINGS	10	10	COMPILE-TIME	10	SESSION	BIGINT UNSIGNED	Max numbers of warnings printed to slow query log per statement	0	1000	1	NULL	NO	REQUIRED	NULL
	26.	EXPIRE_LOGS_DAYS	NULL	0.000000	COMPILE-TIME	0.000000	GLOBAL	DOUBLE	If non-zero, binary logs will be purged after expire_logs_days days; It and binlog_expire_logs_seconds are linked, such that changes in one are converted into the other, presentable as a decimal value with 1/1000000 of the day precision; possible purges happen at startup and at binary log rotation	0	99	NULL	NULL	NO	REQUIRED	NULL
	27.	INNODB_ADAPTIVE_HASH_INDEX_PARTS	NULL	8	COMPILE-TIME	8	GLOBAL	BIGINT UNSIGNED	Number of InnoDB Adaptive Hash Index Partitions (default 8)	1	512	0	NULL	YES	OPTIONAL	NULL
	28.	PERFORMANCE_SCHEMA_ACCOUNTS_SIZE	NULL	-1	COMPILE-TIME	-1	GLOBAL	BIGINT	Maximum number of instrumented user@host accounts. Use 0 to disable, -1 for automated sizing.	-1	1048576	1	NULL	YES	REQUIRED	NULL
	29.	THREAD_POOL_OVERSUBSCRIBE	NULL	3	COMPILE-TIME	3	GLOBAL	INT UNSIGNED	How many additional active worker threads in a group are allowed.	1	1000	1	NULL	NO	REQUIRED	NULL
	30.	PERFORMANCE_SCHEMA_SETUP_OBJECTS_SIZE	NULL	-1	COMPILE-TIME	-1	GLOBAL	BIGINT	Maximum number of rows in SETUP_OBJECTS.	-1	1048576	1	NULL	YES	REQUIRED	NULL

Datensätze 1 - 30 von insgesamt 666 << < > >>