Daten-Ansicht
Datensatz einfügen Tabellenstruktur bearbeiten
Tabelle `configDB`.`SYSTEM_VARIABLES`
Datensätze 1 - 30 von insgesamt 642 << < > >>
Ansicht: kompakt Die Abfrage enthält 14 Spalten | |||||||||||||||
# | 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 | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1. | ARIA_PAGECACHE_AGE_THRESHOLD | NULL | 300 | COMPILE-TIME | 300 | GLOBAL | INT 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 | 4294967295 | 100 | NULL | NO | REQUIRED | |
2. | PERFORMANCE_SCHEMA | NULL | OFF | COMPILE-TIME | OFF | GLOBAL | BOOLEAN | Enable the performance schema. | NULL | NULL | NULL | OFF,ON | YES | OPTIONAL | |
3. | SQL_MODE | STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION | STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION | COMPILE-TIME | STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION | SESSION | SET | Sets the sql mode | NULL | NULL | NULL | 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 | NO | REQUIRED | |
4. | PERFORMANCE_SCHEMA_EVENTS_WAITS_HISTORY_LONG_SIZE | NULL | -1 | COMPILE-TIME | -1 | GLOBAL | INT | Number of rows in EVENTS_WAITS_HISTORY_LONG. Use 0 to disable, -1 for automated sizing. | -1 | 1048576 | 1 | NULL | YES | REQUIRED | |
5. | PERFORMANCE_SCHEMA_MAX_TABLE_INSTANCES | NULL | -1 | COMPILE-TIME | -1 | GLOBAL | INT | Maximum number of instrumented tables. Use 0 to disable, -1 for automated sizing. | -1 | 1048576 | 1 | NULL | YES | REQUIRED | |
6. | PERFORMANCE_SCHEMA_MAX_COND_CLASSES | NULL | 80 | COMPILE-TIME | 80 | GLOBAL | INT UNSIGNED | Maximum number of condition instruments. | 0 | 256 | 1 | NULL | YES | REQUIRED | |
7. | PERFORMANCE_SCHEMA_EVENTS_STAGES_HISTORY_LONG_SIZE | NULL | -1 | COMPILE-TIME | -1 | GLOBAL | INT | Number of rows in EVENTS_STAGES_HISTORY_LONG. Use 0 to disable, -1 for automated sizing. | -1 | 1048576 | 1 | NULL | YES | REQUIRED | |
8. | PERFORMANCE_SCHEMA_MAX_COND_INSTANCES | NULL | -1 | COMPILE-TIME | -1 | GLOBAL | INT | Maximum number of instrumented condition objects. Use 0 to disable, -1 for automated sizing. | -1 | 1048576 | 1 | NULL | YES | REQUIRED | |
9. | EXTERNAL_USER | NULL | COMPILE-TIME | NULL | SESSION ONLY | VARCHAR | The external user account used when logging in | NULL | NULL | NULL | NULL | YES | NULL | ||
10. | PERFORMANCE_SCHEMA_MAX_RWLOCK_CLASSES | NULL | 40 | COMPILE-TIME | 40 | GLOBAL | INT UNSIGNED | Maximum number of rwlock instruments. | 0 | 256 | 1 | NULL | YES | REQUIRED | |
11. | 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 | |
12. | SLAVE_PARALLEL_THREADS | NULL | 0 | COMPILE-TIME | 0 | GLOBAL | INT UNSIGNED | If non-zero, number of threads to spawn to apply in parallel events on the slave that were group-committed on the master or were logged with GTID in different replication domains. Note that these threads are in addition to the IO and SQL threads, which are always created by a replication slave | 0 | 16383 | 1 | NULL | NO | REQUIRED | |
13. | INNODB_ENCRYPT_TEMPORARY_TABLES | NULL | OFF | COMPILE-TIME | OFF | GLOBAL | BOOLEAN | Enrypt the temporary table data. | NULL | NULL | NULL | OFF,ON | YES | OPTIONAL | |
14. | USE_STAT_TABLES | NEVER | NEVER | COMPILE-TIME | NEVER | SESSION | ENUM | Specifies how to use system statistics tables | NULL | NULL | NULL | NEVER,COMPLEMENTARY,PREFERABLY | NO | REQUIRED | |
15. | SLAVE_EXEC_MODE | NULL | STRICT | COMPILE-TIME | STRICT | GLOBAL | ENUM | How replication events should be executed. Legal values are STRICT (default) and IDEMPOTENT. In IDEMPOTENT mode, replication will not stop for operations that are idempotent. For example, in row based replication attempts to delete rows that doesn't exist will be ignored. In STRICT mode, replication will stop on any unexpected difference between the master and the slave. | NULL | NULL | NULL | STRICT,IDEMPOTENT | NO | REQUIRED | |
16. | PERFORMANCE_SCHEMA_MAX_MUTEX_INSTANCES | NULL | -1 | COMPILE-TIME | -1 | GLOBAL | INT | Maximum number of instrumented MUTEX objects. Use 0 to disable, -1 for automated sizing. | -1 | 104857600 | 1 | NULL | YES | REQUIRED | |
17. | INNODB_DEFRAGMENT | NULL | OFF | COMPILE-TIME | OFF | GLOBAL | BOOLEAN | Enable/disable InnoDB defragmentation (default FALSE). When set to FALSE, all existing defragmentation will be paused. And new defragmentation command will fail.Paused defragmentation commands will resume when this variable is set to true again. | NULL | NULL | NULL | OFF,ON | NO | REQUIRED | |
18. | PERFORMANCE_SCHEMA_MAX_RWLOCK_INSTANCES | NULL | -1 | COMPILE-TIME | -1 | GLOBAL | INT | Maximum number of instrumented RWLOCK objects. Use 0 to disable, -1 for automated sizing. | -1 | 104857600 | 1 | NULL | YES | REQUIRED | |
19. | FT_MIN_WORD_LEN | NULL | 4 | COMPILE-TIME | 4 | GLOBAL | INT UNSIGNED | The minimum length of the word to be included in a FULLTEXT index. Note: FULLTEXT indexes must be rebuilt after changing this variable | 1 | 84 | 1 | NULL | YES | REQUIRED | |
20. | PERFORMANCE_SCHEMA_MAX_MUTEX_CLASSES | NULL | 200 | COMPILE-TIME | 200 | GLOBAL | INT UNSIGNED | Maximum number of mutex instruments. | 0 | 256 | 1 | NULL | YES | REQUIRED | |
21. | INNODB_STATS_TRANSIENT_SAMPLE_PAGES | NULL | 8 | COMPILE-TIME | 8 | GLOBAL | BIGINT UNSIGNED | The number of leaf index pages to sample when calculating transient statistics (if persistent statistics are not used, default 8) | 1 | 18446744073709551615 | 0 | NULL | NO | REQUIRED | |
22. | PERFORMANCE_SCHEMA_EVENTS_STATEMENTS_HISTORY_SIZE | NULL | -1 | COMPILE-TIME | -1 | GLOBAL | INT | Number of rows per thread in EVENTS_STATEMENTS_HISTORY. Use 0 to disable, -1 for automated sizing. | -1 | 1024 | 1 | NULL | YES | REQUIRED | |
23. | SLOW_LAUNCH_TIME | NULL | 2 | COMPILE-TIME | 2 | GLOBAL | INT UNSIGNED | If creating the thread takes longer than this value (in seconds), the Slow_launch_threads counter will be incremented | 0 | 31536000 | 1 | NULL | NO | REQUIRED | |
24. | PERFORMANCE_SCHEMA_ACCOUNTS_SIZE | NULL | -1 | COMPILE-TIME | -1 | GLOBAL | INT | Maximum number of instrumented user@host accounts. Use 0 to disable, -1 for automated sizing. | -1 | 1048576 | 1 | NULL | YES | REQUIRED | |
25. | PERFORMANCE_SCHEMA_HOSTS_SIZE | NULL | -1 | COMPILE-TIME | -1 | GLOBAL | INT | Maximum number of instrumented hosts. Use 0 to disable, -1 for automated sizing. | -1 | 1048576 | 1 | NULL | YES | REQUIRED | |
26. | MAX_STATEMENT_TIME | 0.000000 | 0.000000 | COMPILE-TIME | 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 | |
27. | INNODB_ADAPTIVE_HASH_INDEX_PARTS | NULL | 8 | COMPILE-TIME | 8 | GLOBAL | INT UNSIGNED | Number of InnoDB Adaptive Hash Index Partitions (default 8) | 1 | 512 | 0 | NULL | YES | OPTIONAL | |
28. | TX_ISOLATION | REPEATABLE-READ | REPEATABLE-READ | COMPILE-TIME | REPEATABLE-READ | SESSION | ENUM | Default transaction isolation level | NULL | NULL | NULL | READ-UNCOMMITTED,READ-COMMITTED,REPEATABLE-READ,SERIALIZABLE | NO | NULL | |
29. | THREAD_POOL_OVERSUBSCRIBE | NULL | 3 | COMPILE-TIME | 3 | GLOBAL | INT UNSIGNED | How many additional active worker threads in a group are allowed. | 1 | 1000 | 1 | NULL | NO | REQUIRED | |
30. | PERFORMANCE_SCHEMA_EVENTS_WAITS_HISTORY_SIZE | NULL | -1 | COMPILE-TIME | -1 | GLOBAL | INT | Number of rows per thread in EVENTS_WAITS_HISTORY. Use 0 to disable, -1 for automated sizing. | -1 | 1024 | 1 | NULL | YES | REQUIRED |
Datensätze 1 - 30 von insgesamt 642 << < > >>