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.	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
	2.	ANALYZE_SAMPLE_PERCENTAGE	100.000000	100.000000	COMPILE-TIME	100.000000	SESSION	DOUBLE	Percentage of rows from the table ANALYZE TABLE will sample to collect table statistics. Set to 0 to let MariaDB decide what percentage of rows to sample.	0	100	NULL	NULL	NO	REQUIRED	NULL
	3.	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
	4.	ARIA_CHECKPOINT_INTERVAL	NULL	30	COMPILE-TIME	30	GLOBAL	BIGINT UNSIGNED	Interval between tries to do an automatic checkpoints. In seconds; 0 means 'no automatic checkpoints' which makes sense only for testing.	0	4294967295	1	NULL	NO	REQUIRED	NULL
	5.	ARIA_CHECKPOINT_LOG_ACTIVITY	NULL	1048576	COMPILE-TIME	1048576	GLOBAL	BIGINT UNSIGNED	Number of bytes that the transaction log has to grow between checkpoints before a new checkpoint is written to the log.	0	4294967295	1	NULL	NO	REQUIRED	NULL
	6.	ARIA_ENCRYPT_TABLES	NULL	OFF	COMPILE-TIME	OFF	GLOBAL	BOOLEAN	Encrypt tables (only for tables with ROW_FORMAT=PAGE (default) and not FIXED/DYNAMIC)	NULL	NULL	NULL	OFF,ON	NO	OPTIONAL	NULL
	7.	ARIA_FORCE_START_AFTER_RECOVERY_FAILURES	NULL	0	COMPILE-TIME	0	GLOBAL	BIGINT UNSIGNED	Number of consecutive log recovery failures after which logs will be automatically deleted to cure the problem; 0 (the default) disables the feature.	0	255	1	NULL	YES	REQUIRED	NULL
	8.	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
	9.	ARIA_GROUP_COMMIT_INTERVAL	NULL	0	COMPILE-TIME	0	GLOBAL	BIGINT UNSIGNED	Interval between commits in microseconds (1/1000000 sec). 0 stands for no waiting for other threads to come and do a commit in "hard" mode and no sync()/commit at all in "soft" mode. Option has only an effect if aria_group_commit is used	0	4294967295	1	NULL	NO	REQUIRED	NULL
	10.	ARIA_LOG_FILE_SIZE	NULL	1073741824	COMPILE-TIME	1073741824	GLOBAL	BIGINT UNSIGNED	Limit for transaction log size	8388608	4294967295	8192	NULL	NO	REQUIRED	NULL
	11.	ARIA_LOG_PURGE_TYPE	NULL	immediate	COMPILE-TIME	immediate	GLOBAL	ENUM	Specifies how Aria transactional log will be purged	NULL	NULL	NULL	immediate,external,at_flush	NO	REQUIRED	NULL
	12.	ARIA_MAX_SORT_FILE_SIZE	NULL	9223372036853727232	COMPILE-TIME	9223372036853727232	GLOBAL	BIGINT UNSIGNED	Don't use the fast sort index method to created index if the temporary file would get bigger than this.	0	9223372036854775807	1048576	NULL	NO	REQUIRED	NULL
	13.	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
	14.	ARIA_PAGECACHE_BUFFER_SIZE	NULL	1073741824	CONFIG	134217728	GLOBAL	BIGINT UNSIGNED	The size of the buffer used for index blocks for Aria tables. Increase this to get better index handling (for all reads and multiple writes) to as much as you can afford.	131072	18446744073709551615	1	NULL	YES	REQUIRED	NULL
	15.	ARIA_PAGECACHE_DIVISION_LIMIT	NULL	100	COMPILE-TIME	100	GLOBAL	BIGINT UNSIGNED	The minimum percentage of warm blocks in key cache	1	100	1	NULL	NO	REQUIRED	NULL
	16.	ARIA_PAGECACHE_FILE_HASH_SIZE	NULL	512	COMPILE-TIME	512	GLOBAL	BIGINT UNSIGNED	Number of hash buckets for open and changed files. If you have a lot of Aria files open you should increase this for faster flush of changes. A good value is probably 1/10 of number of possible open Aria files.	128	16384	1	NULL	YES	REQUIRED	NULL
	17.	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
	18.	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
	19.	ARIA_REPAIR_THREADS	1	1	COMPILE-TIME	1	SESSION	BIGINT UNSIGNED	Number of threads to use when repairing Aria tables. The value of 1 disables parallel repair.	1	128	1	NULL	NO	REQUIRED	NULL
	20.	ARIA_SORT_BUFFER_SIZE	268434432	268434432	COMPILE-TIME	268434432	SESSION	BIGINT UNSIGNED	The buffer that is allocated when sorting the index when doing a REPAIR or when creating indexes with CREATE INDEX or ALTER TABLE.	4096	9223372036854775807	1	NULL	NO	REQUIRED	NULL
	21.	ARIA_STATS_METHOD	nulls_unequal	nulls_unequal	COMPILE-TIME	nulls_unequal	SESSION	ENUM	Specifies how Aria index statistics collection code should treat NULLs	NULL	NULL	NULL	nulls_unequal,nulls_equal,nulls_ignored	NO	REQUIRED	NULL
	22.	ARIA_SYNC_LOG_DIR	NULL	NEWFILE	COMPILE-TIME	NEWFILE	GLOBAL	ENUM	Controls syncing directory after log file growth and new file creation	NULL	NULL	NULL	NEVER,NEWFILE,ALWAYS	NO	REQUIRED	NULL
	23.	ARIA_USED_FOR_TEMP_TABLES	NULL	ON	COMPILE-TIME	NULL	GLOBAL	BOOLEAN	Whether temporary tables should be MyISAM or Aria	NULL	NULL	NULL	OFF,ON	YES	NULL	NULL
	24.	AUTOCOMMIT	ON	ON	COMPILE-TIME	ON	SESSION	BOOLEAN	If set to 1, the default, all queries are committed immediately. If set to 0, they are only committed upon a COMMIT statement, or rolled back with a ROLLBACK statement. If autocommit is set to 0, and then changed to 1, all open transactions are immediately committed.	NULL	NULL	NULL	OFF,ON	NO	NULL	NULL
	25.	AUTOMATIC_SP_PRIVILEGES	NULL	ON	COMPILE-TIME	ON	GLOBAL	BOOLEAN	Creating and dropping stored procedures alters ACLs	NULL	NULL	NULL	OFF,ON	NO	OPTIONAL	NULL
	26.	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
	27.	AUTO_INCREMENT_OFFSET	1	1	COMPILE-TIME	1	SESSION	BIGINT UNSIGNED	Offset added to Auto-increment columns. Used when auto-increment-increment != 1	1	65535	1	NULL	NO	OPTIONAL	NULL
	28.	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
	29.	BASEDIR	NULL	/usr/local/mysql	COMMAND-LINE		GLOBAL	VARCHAR	Path to installation directory. All paths are usually resolved relative to this	NULL	NULL	NULL	NULL	YES	REQUIRED	NULL
	30.	BIG_TABLES	OFF	OFF	COMPILE-TIME	OFF	SESSION	BOOLEAN	Old variable, which if set to 1, allows large result sets by saving all temporary sets to disk, avoiding 'table full' errors. No longer needed, as the server now handles this automatically.	NULL	NULL	NULL	OFF,ON	NO	OPTIONAL	NULL

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