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. | 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 | |
2. | 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 | |
3. | CORE_FILE | NULL | OFF | COMPILE-TIME | NULL | GLOBAL | BOOLEAN | write a core-file on crashes | NULL | NULL | NULL | OFF,ON | YES | NULL | NULL | |
4. | 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 | |
5. | DEFAULT_STORAGE_ENGINE | InnoDB | InnoDB | COMPILE-TIME | InnoDB | SESSION | VARCHAR | The default storage engine for new tables | NULL | NULL | NULL | NULL | NO | NULL | NULL | |
6. | 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 | |
7. | CHARACTER_SET_RESULTS | utf8 | latin1 | COMPILE-TIME | latin1 | SESSION | ENUM | The character set used for returning query results to the client | NULL | NULL | NULL | NULL | NO | NULL | NULL | |
8. | CHARACTER_SET_CONNECTION | utf8 | latin1 | COMPILE-TIME | latin1 | SESSION | ENUM | The character set used for literals that do not have a character set introducer and for number-to-string conversion | NULL | NULL | NULL | NULL | NO | NULL | NULL | |
9. | SQL_BIG_SELECTS | ON | ON | COMPILE-TIME | OFF | SESSION | BOOLEAN | If set to 0, MariaDB will not perform large SELECTs. See max_join_size for details. If max_join_size is set to anything but DEFAULT, sql_big_selects is automatically set to 0. If sql_big_selects is again set, max_join_size will be ignored. | NULL | NULL | NULL | OFF,ON | NO | NULL | NULL | |
10. | CHECK_CONSTRAINT_CHECKS | ON | ON | COMPILE-TIME | ON | SESSION | BOOLEAN | check_constraint_checks | NULL | NULL | NULL | OFF,ON | NO | NULL | NULL | |
11. | SQL_AUTO_IS_NULL | OFF | OFF | COMPILE-TIME | OFF | SESSION | BOOLEAN | If set to 1, the query SELECT * FROM table_name WHERE auto_increment_column IS NULL will return an auto-increment that has just been successfully inserted, the same as the LAST_INSERT_ID() function. Some ODBC programs make use of this IS NULL comparison. | NULL | NULL | NULL | OFF,ON | NO | NULL | NULL | |
12. | 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 | |
13. | 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 | |
14. | REPLICATE_WILD_DO_TABLE | NULL | COMPILE-TIME | GLOBAL | VARCHAR | Tells the slave thread to restrict replication to statements where any of the updated tables match the specified database and table name patterns. | NULL | NULL | NULL | NULL | NO | NULL | NULL | |||
15. | TIME_ZONE | SYSTEM | SYSTEM | COMPILE-TIME | SYSTEM | SESSION | VARCHAR | The current time zone, used to initialize the time zone for a client when it connects. Set to SYSTEM by default, in which the client uses the system time zone value. | NULL | NULL | NULL | NULL | NO | NULL | NULL | |
16. | 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 | |
17. | CHARACTER_SET_SERVER | latin1 | latin1 | COMPILE-TIME | latin1 | SESSION | ENUM | The default character set | NULL | NULL | NULL | NULL | NO | NULL | NULL | |
18. | RAND_SEED1 | 985355973 | NULL | COMPILE-TIME | 0 | SESSION ONLY | BIGINT UNSIGNED | Sets the internal state of the RAND() generator for replication purposes | 0 | 18446744073709551615 | 1 | NULL | NO | NULL | NULL | |
19. | REPLICATE_IGNORE_TABLE | NULL | COMPILE-TIME | GLOBAL | VARCHAR | Tells the slave thread not to replicate any statement that updates the specified table, even if any other tables might be updated by the same statement. | NULL | NULL | NULL | NULL | NO | NULL | NULL | |||
20. | SYSTEM_TIME_ZONE | NULL | CET | COMPILE-TIME | NULL | GLOBAL | VARCHAR | The server system time zone | NULL | NULL | NULL | NULL | YES | NULL | NULL | |
21. | 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 | NULL | |
22. | SYSTEM_VERSIONING_ASOF | DEFAULT | DEFAULT | COMPILE-TIME | SESSION | VARCHAR | Default value for the FOR SYSTEM_TIME AS OF clause | NULL | NULL | NULL | NULL | NO | NULL | NULL | ||
23. | LC_MESSAGES | en_US | en_US | COMPILE-TIME | en_US | SESSION | ENUM | Set the language used for the error messages | NULL | NULL | NULL | NULL | NO | NULL | NULL | |
24. | 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 | |
25. | CHARACTER_SET_CLIENT | utf8 | latin1 | COMPILE-TIME | latin1 | SESSION | ENUM | The character set for statements that arrive from the client | NULL | NULL | NULL | NULL | NO | NULL | NULL | |
26. | PSEUDO_THREAD_ID | 1013994100 | NULL | COMPILE-TIME | 0 | SESSION ONLY | BIGINT UNSIGNED | This variable is for internal server use | 0 | 18446744073709551615 | 1 | NULL | NO | NULL | NULL | |
27. | 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 | |
28. | 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 | ||
29. | 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 | |
30. | COLLATION_CONNECTION | utf8_general_ci | latin1_swedish_ci | COMPILE-TIME | latin1_swedish_ci | SESSION | ENUM | The collation of the connection character set | NULL | NULL | NULL | NULL | NO | NULL | NULL |
Datensätze 1 - 30 von insgesamt 666 << < > >>