Suche

Suchbegriff(e):

Suchoptionen

eine Spalte muss alle Suchbegriffe enthalten (UND-Suche)
eine Spalte muss mindestens einen Suchbegriff enthalten (ODER-Suche)
ein Datensatz muss alle Suchbegriffe enthalten, diese können aber in beliebigen Spalten sein (Rechenintensiv!)
Suche in Tabelle:   ALL_PLUGINS APPLICABLE_ROLES CHARACTER_SETS CHECK_CONSTRAINTS COLLATIONS COLLATION_CHARACTER_SET_APPLICABILITY COLUMNS COLUMN_PRIVILEGES ENABLED_ROLES ENGINES EVENTS FILES GLOBAL_STATUS GLOBAL_VARIABLES KEYWORDS KEY_CACHES KEY_COLUMN_USAGE OPTIMIZER_TRACE PARAMETERS PARTITIONS PLUGINS PROCESSLIST PROFILING REFERENTIAL_CONSTRAINTS ROUTINES SCHEMATA SCHEMA_PRIVILEGES SESSION_STATUS SESSION_VARIABLES STATISTICS SQL_FUNCTIONS SYSTEM_VARIABLES TABLES TABLESPACES TABLE_CONSTRAINTS TABLE_PRIVILEGES TRIGGERS USER_PRIVILEGES VIEWS CLIENT_STATISTICS INDEX_STATISTICS INNODB_SYS_DATAFILES GEOMETRY_COLUMNS INNODB_SYS_TABLESTATS SPATIAL_REF_SYS INNODB_BUFFER_PAGE INNODB_TRX INNODB_CMP_PER_INDEX INNODB_METRICS INNODB_LOCK_WAITS INNODB_CMP THREAD_POOL_WAITS INNODB_CMP_RESET THREAD_POOL_QUEUES TABLE_STATISTICS INNODB_SYS_FIELDS INNODB_BUFFER_PAGE_LRU INNODB_LOCKS INNODB_FT_INDEX_TABLE INNODB_CMPMEM THREAD_POOL_GROUPS INNODB_CMP_PER_INDEX_RESET INNODB_SYS_FOREIGN_COLS INNODB_FT_INDEX_CACHE INNODB_BUFFER_POOL_STATS INNODB_FT_BEING_DELETED INNODB_SYS_FOREIGN INNODB_CMPMEM_RESET INNODB_FT_DEFAULT_STOPWORD INNODB_SYS_TABLES INNODB_SYS_COLUMNS INNODB_FT_CONFIG USER_STATISTICS INNODB_SYS_TABLESPACES INNODB_SYS_VIRTUAL INNODB_SYS_INDEXES INNODB_SYS_SEMAPHORE_WAITS INNODB_MUTEXES user_variables INNODB_TABLESPACES_ENCRYPTION INNODB_FT_DELETED THREAD_POOL_STATS

Die Suche nach "" in der Tabelle "SYSTEM_VARIABLES" lieferte folgende Treffer:
      Blättern: vor=ALT+V, zurück=ALT+C

	#	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	READ_ONLY	COMMAND_LINE_ARGUMENT	GLOBAL_VALUE_PATH
	1.	INNODB_LOG_CHECKSUMS		ON	COMPILE-TIME	ON	GLOBAL	BOOLEAN	Deprecated parameter with no effect.				OFF,ON	NO	REQUIRED
	2.	PERFORMANCE_SCHEMA		OFF	COMPILE-TIME	OFF	GLOBAL	BOOLEAN	Enable the performance schema.				OFF,ON	YES	OPTIONAL
	3.	SQL_MODE	NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION	NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION	CONFIG	STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION	SESSION	SET	Sets the sql mode				REAL_AS_FLOAT,PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE,IGNORE_BAD_TABLE_OPTIONS,ONLY_FULL_GROUP_BY,NO_UNSIGNED_SUBTRACTION,NO_DIR_IN_CREATE,POSTGRESQL,ORACLE,MSSQL,DB2,MAXDB,NO_KEY_OPTIONS,NO_TABLE_OPTIONS,NO_FIELD_OPTIONS,MYSQL323,MYSQL40,ANSI,NO_AUTO_VALUE_ON_ZERO,NO_BACKSLASH_ESCAPES,STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ALLOW_INVALID_DATES,ERROR_FOR_DIVISION_BY_ZERO,TRADITIONAL,NO_AUTO_CREATE_USER,HIGH_NOT_PRECEDENCE,NO_ENGINE_SUBSTITUTION,PAD_CHAR_TO_FULL_LENGTH,EMPTY_STRING_IS_NULL,SIMULTANEOUS_ASSIGNMENT,TIME_ROUND_FRACTIONAL	NO	REQUIRED
	4.	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				ERROR,KEEP	NO	REQUIRED
	5.	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.				OFF,ON	NO
	6.	PERFORMANCE_SCHEMA_EVENTS_WAITS_HISTORY_SIZE		-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		YES	REQUIRED
	7.	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		NO	REQUIRED
	8.	PERFORMANCE_SCHEMA_MAX_COND_CLASSES		90	COMPILE-TIME	90	GLOBAL	BIGINT UNSIGNED	Maximum number of condition instruments.	0	256	1		YES	REQUIRED
	9.	HAVE_RTREE_KEYS		YES	COMPILE-TIME		GLOBAL	VARCHAR	If RTREE indexes (used for spatial indexes) are available, will be set to YES, otherwise will be set to NO.					YES
	10.	PERFORMANCE_SCHEMA_MAX_COND_INSTANCES		-1	COMPILE-TIME	-1	GLOBAL	BIGINT	Maximum number of instrumented condition objects. Use 0 to disable, -1 for automated sizing.	-1	1048576	1		YES	REQUIRED
	11.	INNODB_FLUSH_LOG_AT_TIMEOUT		1	COMPILE-TIME	1	GLOBAL	INT UNSIGNED	Write and flush logs every (n) second.	0	2700	0		NO	OPTIONAL
	12.	PERFORMANCE_SCHEMA_MAX_RWLOCK_INSTANCES		-1	COMPILE-TIME	-1	GLOBAL	BIGINT	Maximum number of instrumented RWLOCK objects. Use 0 to disable, -1 for automated sizing.	-1	104857600	1		YES	REQUIRED
	13.	INNODB_ENCRYPT_TEMPORARY_TABLES		OFF	COMPILE-TIME	OFF	GLOBAL	BOOLEAN	Enrypt the temporary table data.				OFF,ON	YES	OPTIONAL
	14.	PERFORMANCE_SCHEMA_MAX_PREPARED_STATEMENTS_INSTANCES		-1	COMPILE-TIME	-1	GLOBAL	BIGINT	Maximum number of instrumented prepared statements. Use 0 to disable, -1 for automated scaling.	-1	1048576	1		YES	REQUIRED
	15.	PERFORMANCE_SCHEMA_MAX_THREAD_CLASSES		50	COMPILE-TIME	50	GLOBAL	BIGINT UNSIGNED	Maximum number of thread instruments.	0	256	1		YES	REQUIRED
	16.	RPL_SEMI_SYNC_SLAVE_TRACE_LEVEL		32	COMPILE-TIME	32	GLOBAL	BIGINT UNSIGNED	The tracing level for semi-sync replication.	0	18446744073709551615	1		NO	REQUIRED
	17.	SSL_CAPATH			COMPILE-TIME		GLOBAL	VARCHAR	CA directory (check OpenSSL docs, implies --ssl)					YES	REQUIRED
	18.	PERFORMANCE_SCHEMA_MAX_MUTEX_INSTANCES		-1	COMPILE-TIME	-1	GLOBAL	BIGINT	Maximum number of instrumented MUTEX objects. Use 0 to disable, -1 for automated sizing.	-1	104857600	1		YES	REQUIRED
	19.	CORE_FILE		OFF	COMPILE-TIME		GLOBAL	BOOLEAN	write a core-file on crashes				OFF,ON	YES
	20.	EVENT_SCHEDULER		OFF	COMPILE-TIME	OFF	GLOBAL	ENUM	Enable the event scheduler. Possible values are ON, OFF, and DISABLED (keep the event scheduler completely deactivated, it cannot be activated run-time)				OFF,ON,DISABLED,ORIGINAL	NO	OPTIONAL