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.	WSREP_NOTIFY_CMD	NULL		COMPILE-TIME		GLOBAL	VARCHAR		NULL	NULL	NULL	NULL	YES	REQUIRED	NULL
	2.	FLUSH_TIME	NULL	0	COMPILE-TIME	0	GLOBAL	BIGINT UNSIGNED	A dedicated thread is created to flush all tables at the given interval	0	31536000	1	NULL	NO	REQUIRED	NULL
	3.	INNODB_BUF_DUMP_STATUS_FREQUENCY	NULL	0	COMPILE-TIME	0	GLOBAL	BIGINT UNSIGNED	A number between [0, 100] that tells how oftern buffer pool dump status in percentages should be printed. E.g. 10 means that buffer pool dump status is printed when every 10% of number of buffer pool pages are dumped. Default is 0 (only start and end status is printed).	0	100	0	NULL	NO	REQUIRED	NULL
	4.	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
	5.	MAX_STATEMENT_TIME	300.000000	300.000000	CONFIG	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	NULL
	6.	INNODB_BUFFER_POOL_LOAD_ABORT	NULL	OFF	COMPILE-TIME	OFF	GLOBAL	BOOLEAN	Abort a currently running load of the buffer pool	NULL	NULL	NULL	OFF,ON	NO	REQUIRED	NULL
	7.	WSREP_CLUSTER_ADDRESS	NULL		COMPILE-TIME		GLOBAL	VARCHAR	Address to initially connect to cluster	NULL	NULL	NULL	NULL	NO	REQUIRED	NULL
	8.	WSREP_SST_RECEIVE_ADDRESS	NULL	AUTO	COMPILE-TIME	AUTO	GLOBAL	VARCHAR	Address where node is waiting for SST contact	NULL	NULL	NULL	NULL	NO	REQUIRED	NULL
	9.	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
	10.	MAX_WRITE_LOCK_COUNT	NULL	4294967295	COMPILE-TIME	4294967295	GLOBAL	BIGINT UNSIGNED	After this many write locks, allow some read locks to run in between	1	4294967295	1	NULL	NO	REQUIRED	NULL
	11.	STORAGE_ENGINE	InnoDB	InnoDB	COMPILE-TIME	InnoDB	SESSION	VARCHAR	Alias for @@default_storage_engine. Deprecated	NULL	NULL	NULL	NULL	NO	NULL	NULL
	12.	OLD_ALTER_TABLE	DEFAULT	DEFAULT	COMPILE-TIME	DEFAULT	SESSION	ENUM	Alias for alter_algorithm. Deprecated. Use --alter-algorithm instead.	NULL	NULL	NULL	DEFAULT,COPY,INPLACE,NOCOPY,INSTANT	NO	OPTIONAL	NULL
	13.	SLAVE_PARALLEL_WORKERS	NULL	0	COMPILE-TIME	0	GLOBAL	BIGINT UNSIGNED	Alias for slave_parallel_threads	0	16383	1	NULL	NO	REQUIRED	NULL
	14.	TMP_TABLE_SIZE	33554432	33554432	CONFIG	16777216	SESSION	BIGINT UNSIGNED	Alias for tmp_memory_table_size. If an internal in-memory temporary table exceeds this size, MariaDB will automatically convert it to an on-disk MyISAM or Aria table.	0	18446744073709551615	1	NULL	NO	REQUIRED	NULL
	15.	QUERY_ALLOC_BLOCK_SIZE	200704	200704	CONFIG	16384	SESSION	BIGINT UNSIGNED	Allocation block size for query parsing and execution	1024	4294967295	1024	NULL	NO	REQUIRED	NULL
	16.	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
	17.	TRANSACTION_ALLOC_BLOCK_SIZE	8192	8192	COMPILE-TIME	8192	SESSION	BIGINT UNSIGNED	Allocation block size for transactions to be stored in binary log	1024	134217728	1024	NULL	NO	REQUIRED	NULL
	18.	INNODB_FLUSH_SYNC	NULL	ON	COMPILE-TIME	ON	GLOBAL	BOOLEAN	Allow IO bursts at the checkpoints ignoring io_capacity setting.	NULL	NULL	NULL	OFF,ON	NO	NONE	NULL
	19.	STANDARD_COMPLIANT_CTE	ON	ON	COMPILE-TIME	ON	SESSION	BOOLEAN	Allow only CTEs compliant to SQL standard	NULL	NULL	NULL	OFF,ON	NO	OPTIONAL	NULL
	20.	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
	21.	MAX_SESSION_MEM_USED	9223372036854775807	9223372036854775807	COMPILE-TIME	9223372036854775807	SESSION	BIGINT UNSIGNED	Amount of memory a single user session is allowed to allocate. This limits the value of the session variable MEM_USED	8192	18446744073709551615	1	NULL	NO	REQUIRED	NULL
	22.	INNODB_ADAPTIVE_FLUSHING	NULL	ON	COMPILE-TIME	ON	GLOBAL	BOOLEAN	Attempt flushing dirty pages to avoid IO bursts at checkpoints.	NULL	NULL	NULL	OFF,ON	NO	NONE	NULL
	23.	WSREP_SST_AUTH	NULL		COMPILE-TIME		GLOBAL	VARCHAR	Authentication for SST connection	NULL	NULL	NULL	NULL	NO	REQUIRED	NULL
	24.	AUTO_INCREMENT_INCREMENT	1	1	COMPILE-TIME	1	SESSION	BIGINT UNSIGNED	Auto-increment columns are incremented by this	1	65535	1	NULL	NO	OPTIONAL	NULL
	25.	WSREP_GTID_MODE	NULL	OFF	COMPILE-TIME	OFF	GLOBAL	BOOLEAN	Automatically update the (joiner) node's wsrep_gtid_domain_id value with that of donor's (received during state transfer) and use it in place of gtid_domain_id for all galera transactions. When OFF (default), wsrep_gtid_domain_id is simply ignored (backward compatibility).	NULL	NULL	NULL	OFF,ON	NO	OPTIONAL	NULL
	26.	MAX_BINLOG_SIZE	NULL	1073741824	COMPILE-TIME	1073741824	GLOBAL	BIGINT UNSIGNED	Binary log will be rotated automatically when the size exceeds this value.	4096	1073741824	4096	NULL	NO	REQUIRED	NULL
	27.	WSREP_FORCED_BINLOG_FORMAT	NULL	NONE	COMPILE-TIME	NONE	GLOBAL	ENUM	binlog format to take effect over user's choice	NULL	NULL	NULL	MIXED,STATEMENT,ROW,NONE	NO	REQUIRED	NULL
	28.	ARIA_BLOCK_SIZE	NULL	8192	COMPILE-TIME	8192	GLOBAL	BIGINT UNSIGNED	Block size to be used for Aria index pages.	4096	32768	1024	NULL	YES	REQUIRED	NULL
	29.	MYISAM_BLOCK_SIZE	NULL	1024	COMPILE-TIME	1024	GLOBAL	BIGINT UNSIGNED	Block size to be used for MyISAM index pages	1024	16384	1024	NULL	YES	REQUIRED	NULL
	30.	INNODB_CHANGE_BUFFERING	NULL	none	COMPILE-TIME	none	GLOBAL	ENUM	Buffer changes to secondary indexes.	NULL	NULL	NULL	none,inserts,deletes,changes,purges,all	NO	REQUIRED	NULL

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