MySqlDumper

SQL-Browser

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

Daten-Ansicht

Datensatz einfügen Tabellenstruktur bearbeiten

Tabelle `information_schema`.`SYSTEM_VARIABLES`
Datensätze 637 - 666 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
	637.	IN_TRANSACTION	0	NULL	COMPILE-TIME	NULL	SESSION ONLY	BIGINT UNSIGNED	Whether there is an active transaction	0	1	1	NULL	YES	NULL	NULL
	638.	TCP_KEEPALIVE_PROBES	NULL	0	COMPILE-TIME	0	GLOBAL	INT	The number of unacknowledged probes to send before considering the connection dead and notifying the application layer.If set to 0, system dependent default is used.	0	2147483	1	NULL	NO	REQUIRED	NULL
	639.	ARIA_LOG_FILE_SIZE	NULL	1073741824	COMPILE-TIME	1073741824	GLOBAL	BIGINT UNSIGNED	Limit for transaction log size	8388608	4294967295	8192	NULL	NO	REQUIRED	NULL
	640.	ARIA_GROUP_COMMIT	NULL	none	COMPILE-TIME	none	GLOBAL	ENUM	Specifies Aria group commit mode. Possible values are "none" (no group commit), "hard" (with waiting to actual commit), "soft" (no wait for commit (DANGEROUS!!!))	NULL	NULL	NULL	none,hard,soft	NO	REQUIRED	NULL
	641.	OPTIMIZER_SEARCH_DEPTH	62	62	COMPILE-TIME	62	SESSION	BIGINT UNSIGNED	Maximum depth of search performed by the query optimizer. Values larger than the number of relations in a query result in better query plans, but take longer to compile a query. Values smaller than the number of tables in a relation result in faster optimization, but may produce very bad query plans. If set to 0, the system will automatically pick a reasonable value.	0	62	1	NULL	NO	REQUIRED	NULL
	642.	MAX_ALLOWED_PACKET	268435456	268435456	CONFIG	16777216	SESSION	BIGINT UNSIGNED	Max packet length to send to or receive from the server	1024	1073741824	1024	NULL	NO	REQUIRED	NULL
	643.	TCP_KEEPALIVE_TIME	NULL	0	COMPILE-TIME	0	GLOBAL	INT	Timeout, in seconds, with no activity until the first TCP keep-alive packet is sent.If set to 0, system dependent default is used.	0	2147483	1	NULL	NO	REQUIRED	NULL
	644.	RELAY_LOG_RECOVERY	NULL	OFF	COMPILE-TIME	OFF	GLOBAL	BOOLEAN	Enables automatic relay log recovery right after the database startup, which means that the IO Thread starts re-fetching from the master right after the last transaction processed.	NULL	NULL	NULL	OFF,ON	NO	OPTIONAL	NULL
	645.	READ_ONLY	NULL	OFF	COMPILE-TIME	OFF	GLOBAL	BOOLEAN	Make all non-temporary tables read-only, with the exception for replication (slave) threads and users with the SUPER privilege	NULL	NULL	NULL	OFF,ON	NO	OPTIONAL	NULL
	646.	INNODB_VERSION	NULL	10.5.19	COMPILE-TIME	NULL	GLOBAL	VARCHAR	InnoDB version	NULL	NULL	NULL	NULL	YES	NULL	NULL
	647.	SESSION_TRACK_SYSTEM_VARIABLES	autocommit,character_set_client,character_set_connection,character_set_results,time_zone	autocommit,character_set_client,character_set_connection,character_set_results,time_zone	COMPILE-TIME	autocommit,character_set_client,character_set_connection,character_set_results,time_zone	SESSION	VARCHAR	Track changes in registered system variables.	NULL	NULL	NULL	NULL	NO	REQUIRED	NULL
	648.	INNODB_TABLE_LOCKS	ON	ON	COMPILE-TIME	ON	SESSION	BOOLEAN	Enable InnoDB locking in LOCK TABLES	NULL	NULL	NULL	OFF,ON	NO	OPTIONAL	NULL
	649.	INNODB_ADAPTIVE_MAX_SLEEP_DELAY	NULL	0	COMPILE-TIME	0	GLOBAL	INT UNSIGNED	Deprecated parameter with no effect.	0	1000000	0	NULL	NO	REQUIRED	NULL
	650.	INNODB_FORCE_PRIMARY_KEY	NULL	OFF	COMPILE-TIME	OFF	GLOBAL	BOOLEAN	Do not allow creating a table without primary key (off by default)	NULL	NULL	NULL	OFF,ON	NO	OPTIONAL	NULL
	651.	HISTOGRAM_SIZE	254	254	COMPILE-TIME	254	SESSION	BIGINT UNSIGNED	Number of bytes used for a histogram. If set to 0, no histograms are created by ANALYZE.	0	255	1	NULL	NO	REQUIRED	NULL
	652.	RELAY_LOG_PURGE	NULL	ON	COMPILE-TIME	ON	GLOBAL	BOOLEAN	if disabled - do not purge relay logs. if enabled - purge them as soon as they are no more needed.	NULL	NULL	NULL	OFF,ON	NO	OPTIONAL	NULL
	653.	WSREP_DIRTY_READS	OFF	OFF	COMPILE-TIME	OFF	SESSION	BOOLEAN	Allow reads even when the node is not in the primary component.	NULL	NULL	NULL	OFF,ON	NO	OPTIONAL	NULL
	654.	INNODB_FT_TOTAL_CACHE_SIZE	NULL	640000000	COMPILE-TIME	640000000	GLOBAL	BIGINT UNSIGNED	Total memory allocated for InnoDB Fulltext Search cache	32000000	1099511627776	0	NULL	NO	REQUIRED	NULL
	655.	INNODB_DEFRAGMENT_FILL_FACTOR	NULL	0.900000	COMPILE-TIME	0.900000	GLOBAL	DOUBLE	A number between [0.7, 1] that tells defragmentation how full it should fill a page. Default is 0.9. Number below 0.7 won't make much sense.This variable, together with innodb_defragment_fill_factor_n_recs, is introduced so defragmentation won't pack the page too full and cause page split on the next insert on every page. The variable indicating more defragmentation gain is the one effective.	0.7	1	NULL	NULL	NO	REQUIRED	NULL
	656.	ARIA_PAGE_CHECKSUM	NULL	ON	COMPILE-TIME	ON	GLOBAL	BOOLEAN	Maintain page checksums (can be overridden per table with PAGE_CHECKSUM clause in CREATE TABLE)	NULL	NULL	NULL	OFF,ON	NO	REQUIRED	NULL
	657.	ALTER_ALGORITHM	DEFAULT	DEFAULT	COMPILE-TIME	DEFAULT	SESSION	ENUM	Specify the alter table algorithm	NULL	NULL	NULL	DEFAULT,COPY,INPLACE,NOCOPY,INSTANT	NO	OPTIONAL	NULL
	658.	SESSION_TRACK_SCHEMA	ON	ON	COMPILE-TIME	ON	SESSION	BOOLEAN	Track changes to the default schema.	NULL	NULL	NULL	OFF,ON	NO	OPTIONAL	NULL
	659.	SQL_LOG_BIN	ON	ON	COMPILE-TIME	ON	SESSION	BOOLEAN	If set to 0 (1 is the default), no logging to the binary log is done for the client. Only clients with the SUPER privilege can update this variable. Can have unintended consequences if set globally, see SET SQL_LOG_BIN. Starting MariaDB 10.1.7, this variable does not affect the replication of events in a Galera cluster.	NULL	NULL	NULL	OFF,ON	NO	NULL	NULL
	660.	IDLE_TRANSACTION_TIMEOUT	0	0	COMPILE-TIME	0	SESSION	INT UNSIGNED	The number of seconds the server waits for idle transaction	0	31536000	1	NULL	NO	REQUIRED	NULL
	661.	PERFORMANCE_SCHEMA_USERS_SIZE	NULL	-1	COMPILE-TIME	-1	GLOBAL	BIGINT	Maximum number of instrumented users. Use 0 to disable, -1 for automated sizing.	-1	1048576	1	NULL	YES	REQUIRED	NULL
	662.	BACK_LOG	NULL	80	CONFIG	150	GLOBAL	BIGINT UNSIGNED	The number of outstanding connection requests MariaDB can have. This comes into play when the main MariaDB thread gets very many connection requests in a very short time	0	65535	1	NULL	YES	REQUIRED	NULL
	663.	INNODB_SYNC_SPIN_LOOPS	NULL	30	COMPILE-TIME	30	GLOBAL	BIGINT UNSIGNED	Count of spin-loop rounds in InnoDB mutexes (30 by default)	0	18446744073709551615	0	NULL	NO	REQUIRED	NULL
	664.	INNODB_STATS_PERSISTENT_SAMPLE_PAGES	NULL	20	COMPILE-TIME	20	GLOBAL	BIGINT UNSIGNED	The number of leaf index pages to sample when calculating persistent statistics (by ANALYZE, default 20)	1	18446744073709551615	0	NULL	NO	REQUIRED	NULL
	665.	TMPDIR	NULL	/users/_sql/temp	CONFIG		GLOBAL	VARCHAR	Path for temporary files. Several paths may be specified, separated by a colon (:), in this case they are used in a round-robin fashion	NULL	NULL	NULL	NULL	YES	REQUIRED	NULL
	666.	INNODB_COMPRESSION_LEVEL	NULL	6	COMPILE-TIME	6	GLOBAL	INT UNSIGNED	Compression level used for zlib compression. 0 is no compression, 1 is fastest, 9 is best compression and default is 6.	0	9	0	NULL	NO	REQUIRED	NULL

Datensätze 637 - 666 von insgesamt 666 << < > >>