MyOOS [Dumper]

SQL-Browser

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

Daten-Ansicht

Datensatz einfügen Tabellenstruktur bearbeiten

Tabelle `fhem`.`SYSTEM_VARIABLES`
Datensätze 1 - 30 von insgesamt 642 << < > >>

	#	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	READ_ONLY	COMMAND_LINE_ARGUMENT
Ansicht: kompakt Die Abfrage enthält 14 Spalten
	1.	ARIA_PAGECACHE_AGE_THRESHOLD	NULL	300	COMPILE-TIME	300	GLOBAL	INT 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	4294967295	100	NULL	NO	REQUIRED
	2.	PERFORMANCE_SCHEMA	NULL	OFF	COMPILE-TIME	OFF	GLOBAL	BOOLEAN	Enable the performance schema.	NULL	NULL	NULL	OFF,ON	YES	OPTIONAL
	3.	SQL_MODE	STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION	STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION	COMPILE-TIME	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	NO	REQUIRED
	4.	PERFORMANCE_SCHEMA_EVENTS_WAITS_HISTORY_LONG_SIZE	NULL	-1	COMPILE-TIME	-1	GLOBAL	INT	Number of rows in EVENTS_WAITS_HISTORY_LONG. Use 0 to disable, -1 for automated sizing.	-1	1048576	1	NULL	YES	REQUIRED
	5.	PERFORMANCE_SCHEMA_MAX_TABLE_INSTANCES	NULL	-1	COMPILE-TIME	-1	GLOBAL	INT	Maximum number of instrumented tables. Use 0 to disable, -1 for automated sizing.	-1	1048576	1	NULL	YES	REQUIRED
	6.	PERFORMANCE_SCHEMA_MAX_COND_CLASSES	NULL	80	COMPILE-TIME	80	GLOBAL	INT UNSIGNED	Maximum number of condition instruments.	0	256	1	NULL	YES	REQUIRED
	7.	PERFORMANCE_SCHEMA_EVENTS_STAGES_HISTORY_LONG_SIZE	NULL	-1	COMPILE-TIME	-1	GLOBAL	INT	Number of rows in EVENTS_STAGES_HISTORY_LONG. Use 0 to disable, -1 for automated sizing.	-1	1048576	1	NULL	YES	REQUIRED
	8.	PERFORMANCE_SCHEMA_MAX_COND_INSTANCES	NULL	-1	COMPILE-TIME	-1	GLOBAL	INT	Maximum number of instrumented condition objects. Use 0 to disable, -1 for automated sizing.	-1	1048576	1	NULL	YES	REQUIRED
	9.	EXTERNAL_USER		NULL	COMPILE-TIME	NULL	SESSION ONLY	VARCHAR	The external user account used when logging in	NULL	NULL	NULL	NULL	YES	NULL
	10.	PERFORMANCE_SCHEMA_MAX_RWLOCK_CLASSES	NULL	40	COMPILE-TIME	40	GLOBAL	INT UNSIGNED	Maximum number of rwlock instruments.	0	256	1	NULL	YES	REQUIRED
	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
	12.	SLAVE_PARALLEL_THREADS	NULL	0	COMPILE-TIME	0	GLOBAL	INT UNSIGNED	If non-zero, number of threads to spawn to apply in parallel events on the slave that were group-committed on the master or were logged with GTID in different replication domains. Note that these threads are in addition to the IO and SQL threads, which are always created by a replication slave	0	16383	1	NULL	NO	REQUIRED
	13.	INNODB_ENCRYPT_TEMPORARY_TABLES	NULL	OFF	COMPILE-TIME	OFF	GLOBAL	BOOLEAN	Enrypt the temporary table data.	NULL	NULL	NULL	OFF,ON	YES	OPTIONAL
	14.	USE_STAT_TABLES	NEVER	NEVER	COMPILE-TIME	NEVER	SESSION	ENUM	Specifies how to use system statistics tables	NULL	NULL	NULL	NEVER,COMPLEMENTARY,PREFERABLY	NO	REQUIRED
	15.	SLAVE_EXEC_MODE	NULL	STRICT	COMPILE-TIME	STRICT	GLOBAL	ENUM	How replication events should be executed. Legal values are STRICT (default) and IDEMPOTENT. In IDEMPOTENT mode, replication will not stop for operations that are idempotent. For example, in row based replication attempts to delete rows that doesn't exist will be ignored. In STRICT mode, replication will stop on any unexpected difference between the master and the slave.	NULL	NULL	NULL	STRICT,IDEMPOTENT	NO	REQUIRED
	16.	PERFORMANCE_SCHEMA_MAX_MUTEX_INSTANCES	NULL	-1	COMPILE-TIME	-1	GLOBAL	INT	Maximum number of instrumented MUTEX objects. Use 0 to disable, -1 for automated sizing.	-1	104857600	1	NULL	YES	REQUIRED
	17.	INNODB_DEFRAGMENT	NULL	OFF	COMPILE-TIME	OFF	GLOBAL	BOOLEAN	Enable/disable InnoDB defragmentation (default FALSE). When set to FALSE, all existing defragmentation will be paused. And new defragmentation command will fail.Paused defragmentation commands will resume when this variable is set to true again.	NULL	NULL	NULL	OFF,ON	NO	REQUIRED
	18.	PERFORMANCE_SCHEMA_MAX_RWLOCK_INSTANCES	NULL	-1	COMPILE-TIME	-1	GLOBAL	INT	Maximum number of instrumented RWLOCK objects. Use 0 to disable, -1 for automated sizing.	-1	104857600	1	NULL	YES	REQUIRED
	19.	FT_MIN_WORD_LEN	NULL	4	COMPILE-TIME	4	GLOBAL	INT UNSIGNED	The minimum length of the word to be included in a FULLTEXT index. Note: FULLTEXT indexes must be rebuilt after changing this variable	1	84	1	NULL	YES	REQUIRED
	20.	PERFORMANCE_SCHEMA_MAX_MUTEX_CLASSES	NULL	200	COMPILE-TIME	200	GLOBAL	INT UNSIGNED	Maximum number of mutex instruments.	0	256	1	NULL	YES	REQUIRED
	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
	22.	PERFORMANCE_SCHEMA_EVENTS_STATEMENTS_HISTORY_SIZE	NULL	-1	COMPILE-TIME	-1	GLOBAL	INT	Number of rows per thread in EVENTS_STATEMENTS_HISTORY. Use 0 to disable, -1 for automated sizing.	-1	1024	1	NULL	YES	REQUIRED
	23.	SLOW_LAUNCH_TIME	NULL	2	COMPILE-TIME	2	GLOBAL	INT 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
	24.	PERFORMANCE_SCHEMA_ACCOUNTS_SIZE	NULL	-1	COMPILE-TIME	-1	GLOBAL	INT	Maximum number of instrumented user@host accounts. Use 0 to disable, -1 for automated sizing.	-1	1048576	1	NULL	YES	REQUIRED
	25.	PERFORMANCE_SCHEMA_HOSTS_SIZE	NULL	-1	COMPILE-TIME	-1	GLOBAL	INT	Maximum number of instrumented hosts. Use 0 to disable, -1 for automated sizing.	-1	1048576	1	NULL	YES	REQUIRED
	26.	MAX_STATEMENT_TIME	0.000000	0.000000	COMPILE-TIME	0.000000	SESSION	DOUBLE	A query that has taken more than max_statement_time seconds will be aborted. The argument will be treated as a decimal value with microsecond precision. A value of 0 (default) means no timeout	0	31536000	NULL	NULL	NO	REQUIRED
	27.	INNODB_ADAPTIVE_HASH_INDEX_PARTS	NULL	8	COMPILE-TIME	8	GLOBAL	INT UNSIGNED	Number of InnoDB Adaptive Hash Index Partitions (default 8)	1	512	0	NULL	YES	OPTIONAL
	28.	TX_ISOLATION	REPEATABLE-READ	REPEATABLE-READ	COMPILE-TIME	REPEATABLE-READ	SESSION	ENUM	Default transaction isolation level	NULL	NULL	NULL	READ-UNCOMMITTED,READ-COMMITTED,REPEATABLE-READ,SERIALIZABLE	NO	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
	30.	PERFORMANCE_SCHEMA_EVENTS_WAITS_HISTORY_SIZE	NULL	-1	COMPILE-TIME	-1	GLOBAL	INT	Number of rows per thread in EVENTS_WAITS_HISTORY. Use 0 to disable, -1 for automated sizing.	-1	1024	1	NULL	YES	REQUIRED

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