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.	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
	2.	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
	3.	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
	4.	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
	5.	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
	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.	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
	8.	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
	9.	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
	10.	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
	11.	SSL_CAPATH	NULL		COMPILE-TIME		GLOBAL	VARCHAR	CA directory (check OpenSSL docs, implies --ssl)	NULL	NULL	NULL	NULL	YES	REQUIRED	NULL
	12.	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
	13.	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
	14.	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
	15.	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
	16.	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
	17.	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
	18.	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
	19.	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
	20.	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
	21.	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
	22.	MAX_SP_RECURSION_DEPTH	0	0	COMPILE-TIME	0	SESSION	BIGINT UNSIGNED	Maximum stored procedure recursion depth	0	255	1	NULL	NO	OPTIONAL	NULL
	23.	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
	24.	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
	25.	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
	26.	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
	27.	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
	28.	REPORT_HOST	NULL		COMPILE-TIME		GLOBAL	VARCHAR	Hostname or IP of the slave to be reported to the master during slave registration. Will appear in the output of SHOW SLAVE HOSTS. Leave unset if you do not want the slave to register itself with the master. Note that it is not sufficient for the master to simply read the IP of the slave off the socket once the slave connects. Due to NAT and other routing issues, that IP may not be valid for connecting to the slave from the master or other hosts	NULL	NULL	NULL	NULL	YES	REQUIRED	NULL
	29.	PERFORMANCE_SCHEMA_EVENTS_STAGES_HISTORY_SIZE	NULL	-1	COMPILE-TIME	-1	GLOBAL	BIGINT	Number of rows per thread in EVENTS_STAGES_HISTORY. Use 0 to disable, -1 for automated sizing.	-1	1024	1	NULL	YES	REQUIRED	NULL
	30.	INNODB_SORT_BUFFER_SIZE	NULL	1048576	COMPILE-TIME	1048576	GLOBAL	BIGINT UNSIGNED	Memory buffer size for index creation	65536	67108864	0	NULL	YES	REQUIRED	NULL

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