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.	PERFORMANCE_SCHEMA	NULL	OFF	COMPILE-TIME	OFF	GLOBAL	BOOLEAN	Enable the performance schema.	NULL	NULL	NULL	OFF,ON	YES	OPTIONAL	NULL
	3.	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
	4.	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
	5.	HAVE_RTREE_KEYS	NULL	YES	COMPILE-TIME	NULL	GLOBAL	VARCHAR	If RTREE indexes (used for spatial indexes) are available, will be set to YES, otherwise will be set to NO.	NULL	NULL	NULL	NULL	YES	NULL	NULL
	6.	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
	7.	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
	8.	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
	9.	INNODB_ENCRYPT_TEMPORARY_TABLES	NULL	OFF	COMPILE-TIME	OFF	GLOBAL	BOOLEAN	Enrypt the temporary table data.	NULL	NULL	NULL	OFF,ON	YES	OPTIONAL	NULL
	10.	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
	11.	PERFORMANCE_SCHEMA_MAX_THREAD_CLASSES	NULL	50	COMPILE-TIME	50	GLOBAL	BIGINT UNSIGNED	Maximum number of thread instruments.	0	256	1	NULL	YES	REQUIRED	NULL
	12.	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
	13.	SSL_CAPATH	NULL		COMPILE-TIME		GLOBAL	VARCHAR	CA directory (check OpenSSL docs, implies --ssl)	NULL	NULL	NULL	NULL	YES	REQUIRED	NULL
	14.	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
	15.	CORE_FILE	NULL	OFF	COMPILE-TIME	NULL	GLOBAL	BOOLEAN	write a core-file on crashes	NULL	NULL	NULL	OFF,ON	YES	NULL	NULL
	16.	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
	17.	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
	18.	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
	19.	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
	20.	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
	21.	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
	22.	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
	23.	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
	24.	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
	25.	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
	26.	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
	27.	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
	28.	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
	29.	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
	30.	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

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