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.	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
	2.	CHARACTER_SETS_DIR	NULL	/usr/local/mysql/share/mysql/charsets/	AUTO		GLOBAL	VARCHAR	Directory where character sets are	NULL	NULL	NULL	NULL	YES	REQUIRED	NULL
	3.	LOWER_CASE_FILE_SYSTEM	NULL	OFF	AUTO	NULL	GLOBAL	BOOLEAN	Case sensitivity of file names on the file system where the data directory is located	NULL	NULL	NULL	OFF,ON	YES	NULL	NULL
	4.	HOST_CACHE_SIZE	NULL	272	AUTO	128	GLOBAL	BIGINT UNSIGNED	How many host names should be cached to avoid resolving.	0	65536	1	NULL	NO	REQUIRED	NULL
	5.	THREAD_CACHE_SIZE	NULL	144	AUTO	256	GLOBAL	BIGINT UNSIGNED	How many threads we should keep in a cache for reuse. These are freed after 5 minutes of idle time	0	16384	1	NULL	NO	REQUIRED	NULL
	6.	OPEN_FILES_LIMIT	NULL	49359	AUTO	0	GLOBAL	BIGINT UNSIGNED	If this is not 0, then mysqld will use this value to reserve file descriptors to use with setrlimit(). If this value is 0 or autoset then mysqld will reserve max_connections5 or max_connections + table_cache2 (whichever is larger) number of file descriptors	0	4294967295	1	NULL	YES	REQUIRED	NULL
	7.	REPORT_PORT	NULL	3306	AUTO	0	GLOBAL	INT UNSIGNED	Port for connecting to slave reported to the master during slave registration. Set it only if the slave is listening on a non-default port or if you have a special tunnel from the master or other clients to the slave. If not sure, leave this option unset	0	4294967295	1	NULL	YES	REQUIRED	NULL
	8.	THREAD_POOL_SIZE	NULL	32	AUTO	8	GLOBAL	INT UNSIGNED	Number of thread groups in the pool. This parameter is roughly equivalent to maximum number of concurrently executing threads (threads in a waiting state do not count as executing).	1	100000	1	NULL	NO	REQUIRED	NULL
	9.	SLAVE_LOAD_TMPDIR	NULL	/users/_sql/temp	AUTO		GLOBAL	VARCHAR	The location where the slave should put its temporary files when replicating a LOAD DATA INFILE command	NULL	NULL	NULL	NULL	YES	REQUIRED	NULL
	10.	LOG_TC_SIZE	NULL	24576	AUTO	24576	GLOBAL	BIGINT UNSIGNED	Size of transaction coordinator log.	12288	18446744073709551615	4096	NULL	YES	REQUIRED	NULL
	11.	DATADIR	NULL	/users/_sql/mysql/	COMMAND-LINE	/users/_sql/mysql/	GLOBAL	VARCHAR	Path to the database root directory	NULL	NULL	NULL	NULL	YES	REQUIRED	NULL
	12.	PLUGIN_DIR	NULL	/usr/lib/mysql/plugin/	COMMAND-LINE		GLOBAL	VARCHAR	Directory for plugins	NULL	NULL	NULL	NULL	YES	REQUIRED	NULL
	13.	PID_FILE	NULL	/run/mysqld/mysqld.pid	COMMAND-LINE		GLOBAL	VARCHAR	Pid file used by safe_mysqld	NULL	NULL	NULL	NULL	YES	REQUIRED	NULL
	14.	PORT	NULL	3306	COMMAND-LINE	0	GLOBAL	INT UNSIGNED	Port number to use for connection or 0 to default to, my.cnf, $MYSQL_TCP_PORT, /etc/services, built-in default (3306), whatever comes first	0	4294967295	1	NULL	YES	REQUIRED	NULL
	15.	LOG_ERROR	NULL	/users/_sql/mysql/bplaced.err	COMMAND-LINE	0	GLOBAL	VARCHAR	Log errors to file (instead of stdout). If file name is not specified then 'datadir'/'log-basename'.err or the 'pid-file' path with extension .err is used	NULL	NULL	NULL	NULL	YES	OPTIONAL	NULL
	16.	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
	17.	SOCKET	NULL	/run/mysqld/mysqld.sock	COMMAND-LINE		GLOBAL	VARCHAR	Socket file to use for connection	NULL	NULL	NULL	NULL	YES	REQUIRED	NULL
	18.	INNODB_LOG_CHECKSUMS	NULL	ON	COMPILE-TIME	ON	GLOBAL	BOOLEAN	Deprecated parameter with no effect.	NULL	NULL	NULL	OFF,ON	NO	REQUIRED	NULL
	19.	PERFORMANCE_SCHEMA	NULL	OFF	COMPILE-TIME	OFF	GLOBAL	BOOLEAN	Enable the performance schema.	NULL	NULL	NULL	OFF,ON	YES	OPTIONAL	NULL
	20.	SYSTEM_VERSIONING_ALTER_HISTORY	ERROR	ERROR	COMPILE-TIME	ERROR	SESSION	ENUM	Versioning ALTER TABLE mode. ERROR: Fail ALTER with error; KEEP: Keep historical system rows and subject them to ALTER	NULL	NULL	NULL	ERROR,KEEP	NO	REQUIRED	NULL
	21.	UNIQUE_CHECKS	ON	ON	COMPILE-TIME	ON	SESSION	BOOLEAN	If set to 1, the default, secondary indexes in InnoDB tables are performed. If set to 0, storage engines can (but are not required to) assume that duplicate keys are not present in input data. Set to 0 to speed up imports of large tables to InnoDB. The storage engine will still issue a duplicate key error if it detects one, even if set to 0.	NULL	NULL	NULL	OFF,ON	NO	NULL	NULL
	22.	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
	23.	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
	24.	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
	25.	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
	26.	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
	27.	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
	28.	INNODB_ENCRYPT_TEMPORARY_TABLES	NULL	OFF	COMPILE-TIME	OFF	GLOBAL	BOOLEAN	Enrypt the temporary table data.	NULL	NULL	NULL	OFF,ON	YES	OPTIONAL	NULL
	29.	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
	30.	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

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