[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 << < > >>
| Ansicht: kompakt Die Abfrage enthält 15 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 [BB] | READ_ONLY | COMMAND_LINE_ARGUMENT | GLOBAL_VALUE_PATH | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
  | 1. | 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 |
|
| 2. | 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 |
|
| 3. | 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 |
|
| 4. | 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 |
|
| 5. | PERFORMANCE_SCHEMA_MAX_MUTEX_INSTANCES | NULL | -1 | COMPILE-TIME | -1 | GLOBAL | BIGINT | Maximum number of instrumented MUTEX objects. Use 0 to disable, -1 for automated sizing. | -1 | 104857600 | 1 | NULL | YES | REQUIRED | NULL |
|
| 6. | PERFORMANCE_SCHEMA_ACCOUNTS_SIZE | NULL | -1 | COMPILE-TIME | -1 | GLOBAL | BIGINT | Maximum number of instrumented user@host accounts. Use 0 to disable, -1 for automated sizing. | -1 | 1048576 | 1 | NULL | YES | REQUIRED | NULL |
|
| 7. | PERFORMANCE_SCHEMA_SETUP_OBJECTS_SIZE | NULL | -1 | COMPILE-TIME | -1 | GLOBAL | BIGINT | Maximum number of rows in SETUP_OBJECTS. | -1 | 1048576 | 1 | NULL | YES | REQUIRED | NULL |
|
| 8. | PERFORMANCE_SCHEMA_MAX_INDEX_STAT | NULL | -1 | COMPILE-TIME | -1 | GLOBAL | BIGINT | Maximum number of index statistics for instrumented tables. Use 0 to disable, -1 for automated scaling. | -1 | 1048576 | 1 | NULL | YES | REQUIRED | NULL |
|
| 9. | PERFORMANCE_SCHEMA_EVENTS_STAGES_HISTORY_SIZE | NULL | -1 | COMPILE-TIME | -1 | GLOBAL | BIGINT | Number of rows per thread in EVENTS_STAGES_HISTORY. Use 0 to disable, -1 for automated sizing. | -1 | 1024 | 1 | NULL | YES | REQUIRED | NULL |
|
| 10. | PERFORMANCE_SCHEMA_EVENTS_STATEMENTS_HISTORY_SIZE | NULL | -1 | COMPILE-TIME | -1 | GLOBAL | BIGINT | Number of rows per thread in EVENTS_STATEMENTS_HISTORY. Use 0 to disable, -1 for automated sizing. | -1 | 1024 | 1 | NULL | YES | REQUIRED | NULL |
|
| 11. | PERFORMANCE_SCHEMA_SETUP_ACTORS_SIZE | NULL | -1 | COMPILE-TIME | -1 | GLOBAL | BIGINT | Maximum number of rows in SETUP_ACTORS. | -1 | 1024 | 1 | NULL | YES | REQUIRED | NULL |
|
| 12. | PERFORMANCE_SCHEMA_SESSION_CONNECT_ATTRS_SIZE | NULL | -1 | COMPILE-TIME | -1 | GLOBAL | BIGINT | Size of session attribute string buffer per thread. Use 0 to disable, -1 for automated sizing. | -1 | 1048576 | 1 | NULL | YES | REQUIRED | NULL |
|
| 13. | PERFORMANCE_SCHEMA_EVENTS_TRANSACTIONS_HISTORY_SIZE | NULL | -1 | COMPILE-TIME | -1 | GLOBAL | BIGINT | Number of rows per thread in EVENTS_TRANSACTIONS_HISTORY. Use 0 to disable, -1 for automated sizing. | -1 | 1024 | 1 | NULL | YES | REQUIRED | NULL |
|
| 14. | PERFORMANCE_SCHEMA_EVENTS_STAGES_HISTORY_LONG_SIZE | NULL | -1 | COMPILE-TIME | -1 | GLOBAL | BIGINT | Number of rows in EVENTS_STAGES_HISTORY_LONG. Use 0 to disable, -1 for automated sizing. | -1 | 1048576 | 1 | NULL | YES | REQUIRED | NULL |
|
| 15. | PERFORMANCE_SCHEMA_EVENTS_TRANSACTIONS_HISTORY_LONG_SIZE | NULL | -1 | COMPILE-TIME | -1 | GLOBAL | BIGINT | Number of rows in EVENTS_TRANSACTIONS_HISTORY_LONG. Use 0 to disable, -1 for automated sizing. | -1 | 1048576 | 1 | NULL | YES | REQUIRED | NULL |
|
| 16. | PERFORMANCE_SCHEMA_DIGESTS_SIZE | NULL | -1 | COMPILE-TIME | -1 | GLOBAL | BIGINT | Size of the statement digest. Use 0 to disable, -1 for automated sizing. | -1 | 1048576 | 1 | NULL | YES | REQUIRED | NULL |
|
| 17. | PERFORMANCE_SCHEMA_MAX_THREAD_INSTANCES | NULL | -1 | COMPILE-TIME | -1 | GLOBAL | BIGINT | Maximum number of instrumented threads. Use 0 to disable, -1 for automated sizing. | -1 | 1048576 | 1 | NULL | YES | REQUIRED | NULL |
|
| 18. | PERFORMANCE_SCHEMA_MAX_PROGRAM_INSTANCES | NULL | -1 | COMPILE-TIME | -1 | GLOBAL | BIGINT | Maximum number of instrumented programs. Use 0 to disable, -1 for automated scaling. | -1 | 1048576 | 1 | NULL | YES | REQUIRED | NULL |
|
| 19. | PERFORMANCE_SCHEMA_EVENTS_WAITS_HISTORY_LONG_SIZE | NULL | -1 | COMPILE-TIME | -1 | GLOBAL | BIGINT | Number of rows in EVENTS_WAITS_HISTORY_LONG. Use 0 to disable, -1 for automated sizing. | -1 | 1048576 | 1 | NULL | YES | REQUIRED | NULL |
|
| 20. | PERFORMANCE_SCHEMA_MAX_TABLE_INSTANCES | NULL | -1 | COMPILE-TIME | -1 | GLOBAL | BIGINT | Maximum number of instrumented tables. Use 0 to disable, -1 for automated sizing. | -1 | 1048576 | 1 | NULL | YES | REQUIRED | NULL |
|
| 21. | PERFORMANCE_SCHEMA_MAX_TABLE_LOCK_STAT | NULL | -1 | COMPILE-TIME | -1 | GLOBAL | BIGINT | Maximum number of lock statistics for instrumented tables. Use 0 to disable, -1 for automated scaling. | -1 | 1048576 | 1 | NULL | YES | REQUIRED | NULL |
|
| 22. | INNODB_AUTOINC_LOCK_MODE | NULL | 1 | COMPILE-TIME | 1 | GLOBAL | BIGINT | The AUTOINC lock modes supported by InnoDB: 0 => Old style AUTOINC locking (for backward compatibility); 1 => New style AUTOINC locking; 2 => No AUTOINC locking (unsafe for SBR) | 0 | 2 | 0 | NULL | YES | REQUIRED | NULL |
|
| 23. | PERFORMANCE_SCHEMA_HOSTS_SIZE | NULL | -1 | COMPILE-TIME | -1 | GLOBAL | BIGINT | Maximum number of instrumented hosts. Use 0 to disable, -1 for automated sizing. | -1 | 1048576 | 1 | NULL | YES | REQUIRED | NULL |
|
| 24. | PERFORMANCE_SCHEMA_MAX_SQL_TEXT_LENGTH | NULL | 1024 | COMPILE-TIME | 1024 | GLOBAL | BIGINT | Maximum length of displayed sql text. | 0 | 1048576 | 1 | NULL | YES | REQUIRED | NULL |
|
| 25. | PERFORMANCE_SCHEMA_MAX_FILE_INSTANCES | NULL | -1 | COMPILE-TIME | -1 | GLOBAL | BIGINT | Maximum number of instrumented files. Use 0 to disable, -1 for automated sizing. | -1 | 1048576 | 1 | NULL | YES | REQUIRED | NULL |
|
| 26. | PERFORMANCE_SCHEMA_MAX_SOCKET_INSTANCES | NULL | -1 | COMPILE-TIME | -1 | GLOBAL | BIGINT | Maximum number of opened instrumented sockets. Use 0 to disable, -1 for automated sizing. | -1 | 1048576 | 1 | NULL | YES | REQUIRED | NULL |
|
| 27. | PERFORMANCE_SCHEMA_MAX_DIGEST_LENGTH | NULL | 1024 | COMPILE-TIME | 1024 | GLOBAL | BIGINT | Maximum length considered for digest text, when stored in performance_schema tables. | 0 | 1048576 | 1 | NULL | YES | REQUIRED | NULL |
|
| 28. | PERFORMANCE_SCHEMA_EVENTS_STATEMENTS_HISTORY_LONG_SIZE | NULL | -1 | COMPILE-TIME | -1 | GLOBAL | BIGINT | Number of rows in EVENTS_STATEMENTS_HISTORY_LONG. Use 0 to disable, -1 for automated sizing. | -1 | 1048576 | 1 | NULL | YES | REQUIRED | NULL |
|
| 29. | PERFORMANCE_SCHEMA_MAX_TABLE_HANDLES | NULL | -1 | COMPILE-TIME | -1 | GLOBAL | BIGINT | Maximum number of opened instrumented tables. Use 0 to disable, -1 for automated sizing. | -1 | 1048576 | 1 | NULL | YES | REQUIRED | NULL |
|
| 30. | PERFORMANCE_SCHEMA_MAX_METADATA_LOCKS | NULL | -1 | COMPILE-TIME | -1 | GLOBAL | BIGINT | Maximum number of metadata locks. Use 0 to disable, -1 for automated scaling. | -1 | 104857600 | 1 | NULL | YES | REQUIRED | NULL |
Datensätze 1 - 30 von insgesamt 666 << < > >>