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. | 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 | |
2. | CORE_FILE | NULL | OFF | COMPILE-TIME | NULL | GLOBAL | BOOLEAN | write a core-file on crashes | NULL | NULL | NULL | OFF,ON | YES | NULL | NULL | |
3. | LARGE_FILES_SUPPORT | NULL | ON | COMPILE-TIME | NULL | GLOBAL | BOOLEAN | Whether mysqld was compiled with options for large file support | NULL | NULL | NULL | OFF,ON | YES | NULL | NULL | |
4. | VERSION_COMMENT | NULL | Debian 11 | COMPILE-TIME | NULL | GLOBAL | VARCHAR | Value of the COMPILATION_COMMENT option specified by CMake when building MariaDB, for example mariadb.org binary distribution. | NULL | NULL | NULL | NULL | YES | NULL | NULL | |
5. | 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 | |
6. | HAVE_GEOMETRY | NULL | YES | COMPILE-TIME | NULL | GLOBAL | VARCHAR | If the server supports spatial data types, will be set to YES, otherwise will be set to NO. | NULL | NULL | NULL | NULL | YES | NULL | NULL | |
7. | CHARACTER_SET_SYSTEM | NULL | utf8 | COMPILE-TIME | NULL | GLOBAL | ENUM | The character set used by the server for storing identifiers | NULL | NULL | NULL | NULL | YES | NULL | NULL | |
8. | SYSTEM_TIME_ZONE | NULL | CET | COMPILE-TIME | NULL | GLOBAL | VARCHAR | The server system time zone | NULL | NULL | NULL | NULL | YES | NULL | NULL | |
9. | 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 | |
10. | VERSION_SSL_LIBRARY | NULL | OpenSSL 1.1.1n 15 Mar 2022 | COMPILE-TIME | NULL | GLOBAL | VARCHAR | Version of the used SSL library | NULL | NULL | NULL | NULL | YES | NULL | NULL | |
11. | PROXY_USER | NULL | COMPILE-TIME | NULL | SESSION ONLY | VARCHAR | The proxy user account name used when logging in | NULL | NULL | NULL | NULL | YES | NULL | NULL | ||
12. | HAVE_DYNAMIC_LOADING | NULL | YES | COMPILE-TIME | NULL | GLOBAL | VARCHAR | If the server supports dynamic loading of plugins, will be set to YES, otherwise will be set to NO. | NULL | NULL | NULL | NULL | YES | NULL | NULL | |
13. | LICENSE | NULL | GPL | COMPILE-TIME | NULL | GLOBAL | VARCHAR | The type of license the server has | NULL | NULL | NULL | NULL | YES | NULL | NULL | |
14. | GTID_SLAVE_POS | NULL | COMPILE-TIME | NULL | GLOBAL | VARCHAR | The list of global transaction IDs that were last replicated on the server, one for each replication domain. | NULL | NULL | NULL | NULL | NO | NULL | NULL | ||
15. | GTID_BINLOG_STATE | NULL | COMPILE-TIME | NULL | GLOBAL | VARCHAR | The internal GTID state of the binlog, used to keep track of all GTIDs ever logged to the binlog. | NULL | NULL | NULL | NULL | NO | NULL | NULL | ||
16. | LOCKED_IN_MEMORY | NULL | OFF | COMPILE-TIME | NULL | GLOBAL | BOOLEAN | Whether mysqld was locked in memory with --memlock | NULL | NULL | NULL | OFF,ON | YES | NULL | NULL | |
17. | EXTERNAL_USER | NULL | COMPILE-TIME | NULL | SESSION ONLY | VARCHAR | The external user account used when logging in | NULL | NULL | NULL | NULL | YES | NULL | NULL | ||
18. | VERSION_MALLOC_LIBRARY | NULL | system | COMPILE-TIME | NULL | GLOBAL | VARCHAR | Version of the used malloc library | NULL | NULL | NULL | NULL | YES | NULL | NULL | |
19. | SKIP_EXTERNAL_LOCKING | NULL | ON | COMPILE-TIME | NULL | GLOBAL | BOOLEAN | Don't use system (external) locking | NULL | NULL | NULL | OFF,ON | YES | NULL | NULL | |
20. | HOSTNAME | NULL | bplaced | COMPILE-TIME | NULL | GLOBAL | VARCHAR | Server host name | NULL | NULL | NULL | NULL | YES | NULL | NULL | |
21. | HAVE_COMPRESS | NULL | YES | COMPILE-TIME | NULL | GLOBAL | VARCHAR | If the zlib compression library is accessible to the server, this will be set to YES, otherwise it will be NO. The COMPRESS() and UNCOMPRESS() functions will only be available if set to YES. | NULL | NULL | NULL | NULL | YES | NULL | NULL | |
22. | GTID_CURRENT_POS | NULL | COMPILE-TIME | NULL | GLOBAL | VARCHAR | Current GTID position of the server. Per replication domain, this is either the last GTID replicated by a slave thread, or the GTID logged to the binary log, whichever is most recent. | NULL | NULL | NULL | NULL | YES | NULL | NULL | ||
23. | HAVE_PROFILING | NULL | YES | COMPILE-TIME | NULL | GLOBAL | VARCHAR | If statement profiling is available, will be set to YES, otherwise will be set to NO. See SHOW PROFILES and SHOW PROFILE. | NULL | NULL | NULL | NULL | YES | NULL | NULL | |
24. | HAVE_QUERY_CACHE | NULL | YES | COMPILE-TIME | NULL | GLOBAL | VARCHAR | If the server supports the query cache, will be set to YES, otherwise will be set to NO. | NULL | NULL | NULL | NULL | YES | NULL | NULL | |
25. | PROTOCOL_VERSION | NULL | 10 | COMPILE-TIME | NULL | GLOBAL | INT UNSIGNED | The version of the client/server protocol used by the MariaDB server | 0 | 4294967295 | 1 | NULL | YES | NULL | NULL | |
26. | HAVE_CRYPT | NULL | YES | COMPILE-TIME | NULL | GLOBAL | VARCHAR | If the crypt() system call is available this variable will be set to YES, otherwise it will be set to NO. If set to NO, the ENCRYPT() function cannot be used. | NULL | NULL | NULL | NULL | YES | NULL | NULL | |
27. | HAVE_OPENSSL | NULL | YES | COMPILE-TIME | NULL | GLOBAL | VARCHAR | Comparing have_openssl with have_ssl will indicate whether YaSSL or openssl was used. If YaSSL, have_ssl will be YES, but have_openssl will be NO. | NULL | NULL | NULL | NULL | YES | NULL | NULL | |
28. | RELAY_LOG_BASENAME | NULL | COMPILE-TIME | NULL | GLOBAL | VARCHAR | The full path of the relay log file names, excluding the extension. | NULL | NULL | NULL | NULL | YES | NULL | NULL | ||
29. | LOG_BIN_INDEX | NULL | COMPILE-TIME | NULL | GLOBAL | VARCHAR | File that holds the names for last binary log files. | NULL | NULL | NULL | NULL | YES | NULL | NULL | ||
30. | LOG_BIN_BASENAME | NULL | COMPILE-TIME | NULL | GLOBAL | VARCHAR | The full path of the binary log file names, excluding the extension. | NULL | NULL | NULL | NULL | YES | NULL | NULL |
Datensätze 1 - 30 von insgesamt 666 << < > >>