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.	INNODB_LOG_CHECKSUMS	NULL	ON	COMPILE-TIME	ON	GLOBAL	BOOLEAN	Deprecated parameter with no effect.	NULL	NULL	NULL	OFF,ON	NO	REQUIRED	NULL
	2.	SQL_MODE	NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION	NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION	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
	3.	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
	4.	UNIQUE_CHECKS	ON	ON	COMPILE-TIME	ON	SESSION	BOOLEAN	If set to 1, the default, secondary indexes in InnoDB tables are performed. If set to 0, storage engines can (but are not required to) assume that duplicate keys are not present in input data. Set to 0 to speed up imports of large tables to InnoDB. The storage engine will still issue a duplicate key error if it detects one, even if set to 0.	NULL	NULL	NULL	OFF,ON	NO	NULL	NULL
	5.	MAX_RELAY_LOG_SIZE	1073741824	1073741824	AUTO	1073741824	SESSION	BIGINT UNSIGNED	relay log will be rotated automatically when the size exceeds this value. If 0 at startup, it's set to max_binlog_size	4096	1073741824	4096	NULL	NO	REQUIRED	NULL
	6.	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
	7.	RPL_SEMI_SYNC_SLAVE_TRACE_LEVEL	NULL	32	COMPILE-TIME	32	GLOBAL	BIGINT UNSIGNED	The tracing level for semi-sync replication.	0	18446744073709551615	1	NULL	NO	REQUIRED	NULL
	8.	EVENT_SCHEDULER	NULL	OFF	COMPILE-TIME	OFF	GLOBAL	ENUM	Enable the event scheduler. Possible values are ON, OFF, and DISABLED (keep the event scheduler completely deactivated, it cannot be activated run-time)	NULL	NULL	NULL	OFF,ON,DISABLED,ORIGINAL	NO	OPTIONAL	NULL
	9.	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
	10.	GTID_IGNORE_DUPLICATES	NULL	OFF	COMPILE-TIME	OFF	GLOBAL	BOOLEAN	When set, different master connections in multi-source replication are allowed to receive and process event groups with the same GTID (when using GTID mode). Only one will be applied, any others will be ignored. Within a given replication domain, just the sequence number will be used to decide whether a given GTID has been already applied; this means it is the responsibility of the user to ensure that GTID sequence numbers are strictly increasing.	NULL	NULL	NULL	OFF,ON	NO	OPTIONAL	NULL
	11.	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
	12.	OPTIMIZER_SELECTIVITY_SAMPLING_LIMIT	100	100	COMPILE-TIME	100	SESSION	BIGINT UNSIGNED	Controls number of record samples to check condition selectivity	10	4294967295	1	NULL	NO	REQUIRED	NULL
	13.	RPL_SEMI_SYNC_SLAVE_KILL_CONN_TIMEOUT	NULL	5	COMPILE-TIME	5	GLOBAL	INT UNSIGNED	Timeout for the mysql connection used to kill the slave io_thread's connection on master. This timeout comes into play when stop slave is executed.	0	4294967295	1	NULL	NO	OPTIONAL	NULL
	14.	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
	15.	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
	16.	MAX_SP_RECURSION_DEPTH	0	0	COMPILE-TIME	0	SESSION	BIGINT UNSIGNED	Maximum stored procedure recursion depth	0	255	1	NULL	NO	OPTIONAL	NULL
	17.	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
	18.	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
	19.	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
	20.	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
	21.	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
	22.	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
	23.	DEFAULT_STORAGE_ENGINE	InnoDB	InnoDB	COMPILE-TIME	InnoDB	SESSION	VARCHAR	The default storage engine for new tables	NULL	NULL	NULL	NULL	NO	NULL	NULL
	24.	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
	25.	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
	26.	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
	27.	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
	28.	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
	29.	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
	30.	INNODB_TMPDIR			COMPILE-TIME		SESSION	VARCHAR	Directory for temporary non-tablespace files.	NULL	NULL	NULL	NULL	NO	OPTIONAL	NULL

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