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. | INNODB_LOG_CHECKSUMS | NULL | ON | COMPILE-TIME | ON | GLOBAL | BOOLEAN | Deprecated parameter with no effect. | NULL | NULL | NULL | OFF,ON | NO | REQUIRED | NULL | |
2. | PERFORMANCE_SCHEMA | NULL | OFF | COMPILE-TIME | OFF | GLOBAL | BOOLEAN | Enable the performance schema. | NULL | NULL | NULL | OFF,ON | YES | OPTIONAL | NULL | |
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 | 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,TIME_ROUND_FRACTIONAL | NO | REQUIRED | NULL | |
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 | NULL | NULL | NULL | ERROR,KEEP | NO | REQUIRED | NULL | |
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. | NULL | NULL | NULL | OFF,ON | NO | NULL | NULL | |
6. | 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 | |
7. | INNODB_ENCRYPT_TEMPORARY_TABLES | NULL | OFF | COMPILE-TIME | OFF | GLOBAL | BOOLEAN | Enrypt the temporary table data. | NULL | NULL | NULL | OFF,ON | YES | OPTIONAL | NULL | |
8. | SSL_CAPATH | NULL | COMPILE-TIME | GLOBAL | VARCHAR | CA directory (check OpenSSL docs, implies --ssl) | NULL | NULL | NULL | NULL | YES | REQUIRED | NULL | |||
9. | CORE_FILE | NULL | OFF | COMPILE-TIME | NULL | GLOBAL | BOOLEAN | write a core-file on crashes | NULL | NULL | NULL | OFF,ON | YES | NULL | NULL | |
10. | EVENT_SCHEDULER | NULL | 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) | NULL | NULL | NULL | OFF,ON,DISABLED,ORIGINAL | NO | OPTIONAL | NULL | |
11. | GTID_IGNORE_DUPLICATES | NULL | OFF | COMPILE-TIME | OFF | GLOBAL | BOOLEAN | When set, different master connections in multi-source replication are allowed to receive and process event groups with the same GTID (when using GTID mode). Only one will be applied, any others will be ignored. Within a given replication domain, just the sequence number will be used to decide whether a given GTID has been already applied; this means it is the responsibility of the user to ensure that GTID sequence numbers are strictly increasing. | NULL | NULL | NULL | OFF,ON | NO | OPTIONAL | NULL | |
12. | ARIA_RECOVER_OPTIONS | NULL | BACKUP,QUICK | COMPILE-TIME | BACKUP,QUICK | GLOBAL | SET | Specifies how corrupted tables should be automatically repaired | NULL | NULL | NULL | NORMAL,BACKUP,FORCE,QUICK,OFF | NO | OPTIONAL | NULL | |
13. | WSREP_DRUPAL_282555_WORKAROUND | NULL | OFF | COMPILE-TIME | OFF | GLOBAL | BOOLEAN | Enable a workaround to handle the cases where inserting a DEFAULT value into an auto-increment column could fail with duplicate key error | NULL | NULL | NULL | OFF,ON | NO | OPTIONAL | NULL | |
14. | REPORT_HOST | NULL | COMPILE-TIME | GLOBAL | VARCHAR | Hostname or IP of the slave to be reported to the master during slave registration. Will appear in the output of SHOW SLAVE HOSTS. Leave unset if you do not want the slave to register itself with the master. Note that it is not sufficient for the master to simply read the IP of the slave off the socket once the slave connects. Due to NAT and other routing issues, that IP may not be valid for connecting to the slave from the master or other hosts | NULL | NULL | NULL | NULL | YES | REQUIRED | NULL | |||
15. | SLAVE_TRANSACTION_RETRY_ERRORS | NULL | 1158,1159,1160,1161,1205,1213,1429,2013,12701 | COMPILE-TIME | GLOBAL | VARCHAR | Tells the slave thread to retry transaction for replication when a query event returns an error from the provided list. Deadlock error, elapsed lock wait timeout, net read error, net read timeout, net write error, net write timeout, connect error and 2 types of lost connection error are automatically added to this list | NULL | NULL | NULL | NULL | YES | REQUIRED | NULL | ||
16. | 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 | |
17. | WSREP_AUTO_INCREMENT_CONTROL | NULL | ON | COMPILE-TIME | ON | GLOBAL | BOOLEAN | To automatically control the assignment of autoincrement variables | NULL | NULL | NULL | OFF,ON | NO | OPTIONAL | NULL | |
18. | DEFAULT_STORAGE_ENGINE | InnoDB | InnoDB | COMPILE-TIME | InnoDB | SESSION | VARCHAR | The default storage engine for new tables | NULL | NULL | NULL | NULL | NO | NULL | NULL | |
19. | INNODB_BACKGROUND_SCRUB_DATA_COMPRESSED | NULL | OFF | COMPILE-TIME | OFF | GLOBAL | BOOLEAN | Deprecated parameter with no effect. | NULL | NULL | NULL | OFF,ON | NO | OPTIONAL | NULL | |
20. | SLOW_QUERY_LOG | OFF | OFF | COMPILE-TIME | OFF | SESSION | BOOLEAN | Log slow queries to a table or log file. Defaults logging to a file 'hostname'-slow.log or a table mysql.slow_log if --log-output=TABLE is used. Must be enabled to activate other slow log options. | NULL | NULL | NULL | OFF,ON | NO | OPTIONAL | NULL | |
21. | 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 | |
22. | BIND_ADDRESS | NULL | COMPILE-TIME | GLOBAL | VARCHAR | IP address to bind to. | NULL | NULL | NULL | NULL | YES | REQUIRED | NULL | |||
23. | INNODB_TMPDIR | COMPILE-TIME | SESSION | VARCHAR | Directory for temporary non-tablespace files. | NULL | NULL | NULL | NULL | NO | OPTIONAL | NULL | ||||
24. | LC_MESSAGES_DIR | NULL | COMPILE-TIME | GLOBAL | VARCHAR | Directory where error messages are | NULL | NULL | NULL | NULL | YES | REQUIRED | NULL | |||
25. | MYISAM_RECOVER_OPTIONS | NULL | BACKUP,QUICK | COMPILE-TIME | BACKUP,QUICK | GLOBAL | SET | Specifies how corrupted tables should be automatically repaired | NULL | NULL | NULL | DEFAULT,BACKUP,FORCE,QUICK,BACKUP_ALL,OFF | YES | OPTIONAL | NULL | |
26. | LOW_PRIORITY_UPDATES | OFF | OFF | COMPILE-TIME | OFF | SESSION | BOOLEAN | INSERT/DELETE/UPDATE has lower priority than selects | NULL | NULL | NULL | OFF,ON | NO | OPTIONAL | NULL | |
27. | 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 | |
28. | REPORT_PASSWORD | NULL | COMPILE-TIME | GLOBAL | VARCHAR | The account password of the slave to be reported to the master during slave registration | NULL | NULL | NULL | NULL | YES | REQUIRED | NULL | |||
29. | WSREP_DBUG_OPTION | NULL | COMPILE-TIME | GLOBAL | VARCHAR | DBUG options to provider library | NULL | NULL | NULL | NULL | NO | REQUIRED | NULL | |||
30. | 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 |
Datensätze 1 - 30 von insgesamt 666 << < > >>