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. | RAND_SEED1 | 152663968 | 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 | |
2. | PSEUDO_THREAD_ID | 1013689049 | NULL | COMPILE-TIME | 0 | SESSION ONLY | BIGINT UNSIGNED | This variable is for internal server use | 0 | 18446744073709551615 | 1 | NULL | NO | NULL | NULL | |
3. | 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 | ||
4. | PSEUDO_SLAVE_MODE | OFF | NULL | COMPILE-TIME | OFF | SESSION ONLY | BOOLEAN | SET pseudo_slave_mode= 0,1 are commands that mysqlbinlog adds to beginning and end of binary log dumps. While zero value indeed disables, the actual enabling of the slave applier execution mode is done implicitly when a Format_description_event is sent through the session. | NULL | NULL | NULL | OFF,ON | NO | NULL | NULL | |
5. | RAND_SEED2 | 732948806 | 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 | |
6. | WSREP_GTID_SEQ_NO | 0 | NULL | COMPILE-TIME | 0 | SESSION ONLY | BIGINT UNSIGNED | Internal server usage, manually set WSREP GTID seqno. | 0 | 18446744073709551615 | 1 | NULL | NO | NULL | NULL | |
7. | DEFAULT_MASTER_CONNECTION | NULL | COMPILE-TIME | SESSION ONLY | VARCHAR | Master connection to use for all slave variables and slave commands | NULL | NULL | NULL | NULL | NO | NULL | NULL | |||
8. | EXTERNAL_USER | NULL | COMPILE-TIME | NULL | SESSION ONLY | VARCHAR | The external user account used when logging in | NULL | NULL | NULL | NULL | YES | NULL | NULL | ||
9. | LAST_INSERT_ID | 0 | NULL | COMPILE-TIME | 0 | SESSION ONLY | BIGINT UNSIGNED | The value to be returned from LAST_INSERT_ID() | 0 | 18446744073709551615 | 1 | NULL | NO | NULL | NULL | |
10. | TIMESTAMP | 1716116498.948731 | NULL | COMPILE-TIME | 0.000000 | SESSION ONLY | DOUBLE | Set the time for this client | 0 | 2147483647 | NULL | NULL | NO | NULL | NULL | |
11. | GTID_SEQ_NO | 0 | NULL | COMPILE-TIME | 0 | SESSION ONLY | BIGINT UNSIGNED | Internal server usage, for replication with global transaction id. When set, next event group logged to the binary log will use this sequence number, not generate a new one, thus allowing to preserve master's GTID in slave's binlog. | 0 | 18446744073709551615 | 1 | NULL | NO | NULL | NULL | |
12. | SKIP_PARALLEL_REPLICATION | OFF | NULL | COMPILE-TIME | OFF | SESSION ONLY | BOOLEAN | If set when a transaction is written to the binlog, parallel apply of that transaction will be avoided on a slave where slave_parallel_mode is not "aggressive". Can be used to avoid unnecessary rollback and retry for transactions that are likely to cause a conflict if replicated in parallel. | NULL | NULL | NULL | OFF,ON | NO | NULL | NULL | |
13. | INSERT_ID | 0 | NULL | COMPILE-TIME | 0 | SESSION ONLY | BIGINT UNSIGNED | The value to be used by the following INSERT or ALTER TABLE statement when inserting an AUTO_INCREMENT value | 0 | 18446744073709551615 | 1 | NULL | NO | NULL | NULL | |
14. | SKIP_REPLICATION | OFF | NULL | COMPILE-TIME | OFF | SESSION ONLY | BOOLEAN | Changes are logged into the binary log with the @@skip_replication flag set. Such events will not be replicated by slaves that run with --replicate-events-marked-for-skip set different from its default of REPLICATE. See Selectively skipping replication of binlog events for more information. | NULL | NULL | NULL | OFF,ON | NO | NULL | NULL | |
15. | LAST_GTID | NULL | COMPILE-TIME | NULL | SESSION ONLY | VARCHAR | The GTID of the last commit (if binlogging was enabled), or the empty string if none. | NULL | NULL | NULL | NULL | YES | NULL | NULL | ||
16. | IDENTITY | 0 | NULL | COMPILE-TIME | 0 | SESSION ONLY | BIGINT UNSIGNED | Synonym for the last_insert_id variable | 0 | 18446744073709551615 | 1 | NULL | NO | NULL | NULL | |
17. | WARNING_COUNT | 0 | NULL | COMPILE-TIME | NULL | SESSION ONLY | BIGINT UNSIGNED | The number of errors, warnings, and notes that resulted from the last statement that generated messages | 0 | 18446744073709551615 | 1 | NULL | YES | NULL | NULL | |
18. | ERROR_COUNT | 0 | NULL | COMPILE-TIME | NULL | SESSION ONLY | BIGINT UNSIGNED | The number of errors that resulted from the last statement that generated messages | 0 | 18446744073709551615 | 1 | NULL | YES | NULL | NULL | |
19. | IN_TRANSACTION | 0 | NULL | COMPILE-TIME | NULL | SESSION ONLY | BIGINT UNSIGNED | Whether there is an active transaction | 0 | 1 | 1 | NULL | YES | NULL | NULL | |
20. | SSL_CAPATH | NULL | COMPILE-TIME | GLOBAL | VARCHAR | CA directory (check OpenSSL docs, implies --ssl) | NULL | NULL | NULL | NULL | YES | REQUIRED | NULL | |||
21. | 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 | |||
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. | 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 | |||
26. | WSREP_DBUG_OPTION | NULL | COMPILE-TIME | GLOBAL | VARCHAR | DBUG options to provider library | NULL | NULL | NULL | NULL | NO | REQUIRED | NULL | |||
27. | WSREP_CLUSTER_ADDRESS | NULL | COMPILE-TIME | GLOBAL | VARCHAR | Address to initially connect to cluster | NULL | NULL | NULL | NULL | NO | REQUIRED | NULL | |||
28. | INNODB_FILE_FORMAT | NULL | COMPILE-TIME | GLOBAL | VARCHAR | Deprecated parameter with no effect. | NULL | NULL | NULL | NULL | YES | REQUIRED | NULL | |||
29. | 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 | |||
30. | 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 |
Datensätze 1 - 30 von insgesamt 666 << < > >>