Daten-Ansicht
Datensatz einfügen Tabellenstruktur bearbeiten
Tabelle `information_schema`.`SYSTEM_VARIABLES`
Datensätze 637 - 666 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 | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
637. | IN_TRANSACTION | 0 | NULL | COMPILE-TIME | NULL | SESSION ONLY | BIGINT UNSIGNED | Whether there is an active transaction | 0 | 1 | 1 | NULL | YES | NULL | NULL | |
638. | TCP_KEEPALIVE_PROBES | NULL | 0 | COMPILE-TIME | 0 | GLOBAL | INT | The number of unacknowledged probes to send before considering the connection dead and notifying the application layer.If set to 0, system dependent default is used. | 0 | 2147483 | 1 | NULL | NO | REQUIRED | NULL | |
639. | ARIA_LOG_FILE_SIZE | NULL | 1073741824 | COMPILE-TIME | 1073741824 | GLOBAL | BIGINT UNSIGNED | Limit for transaction log size | 8388608 | 4294967295 | 8192 | NULL | NO | REQUIRED | NULL | |
640. | ARIA_GROUP_COMMIT | NULL | none | COMPILE-TIME | none | GLOBAL | ENUM | Specifies Aria group commit mode. Possible values are "none" (no group commit), "hard" (with waiting to actual commit), "soft" (no wait for commit (DANGEROUS!!!)) | NULL | NULL | NULL | none,hard,soft | NO | REQUIRED | NULL | |
641. | OPTIMIZER_SEARCH_DEPTH | 62 | 62 | COMPILE-TIME | 62 | SESSION | BIGINT UNSIGNED | Maximum depth of search performed by the query optimizer. Values larger than the number of relations in a query result in better query plans, but take longer to compile a query. Values smaller than the number of tables in a relation result in faster optimization, but may produce very bad query plans. If set to 0, the system will automatically pick a reasonable value. | 0 | 62 | 1 | NULL | NO | REQUIRED | NULL | |
642. | MAX_ALLOWED_PACKET | 268435456 | 268435456 | CONFIG | 16777216 | SESSION | BIGINT UNSIGNED | Max packet length to send to or receive from the server | 1024 | 1073741824 | 1024 | NULL | NO | REQUIRED | NULL | |
643. | TCP_KEEPALIVE_TIME | NULL | 0 | COMPILE-TIME | 0 | GLOBAL | INT | Timeout, in seconds, with no activity until the first TCP keep-alive packet is sent.If set to 0, system dependent default is used. | 0 | 2147483 | 1 | NULL | NO | REQUIRED | NULL | |
644. | RELAY_LOG_RECOVERY | NULL | OFF | COMPILE-TIME | OFF | GLOBAL | BOOLEAN | Enables automatic relay log recovery right after the database startup, which means that the IO Thread starts re-fetching from the master right after the last transaction processed. | NULL | NULL | NULL | OFF,ON | NO | OPTIONAL | NULL | |
645. | READ_ONLY | NULL | OFF | COMPILE-TIME | OFF | GLOBAL | BOOLEAN | Make all non-temporary tables read-only, with the exception for replication (slave) threads and users with the SUPER privilege | NULL | NULL | NULL | OFF,ON | NO | OPTIONAL | NULL | |
646. | INNODB_VERSION | NULL | 10.5.19 | COMPILE-TIME | NULL | GLOBAL | VARCHAR | InnoDB version | NULL | NULL | NULL | NULL | YES | NULL | NULL | |
647. | SESSION_TRACK_SYSTEM_VARIABLES | autocommit,character_set_client,character_set_connection,character_set_results,time_zone | autocommit,character_set_client,character_set_connection,character_set_results,time_zone | COMPILE-TIME | autocommit,character_set_client,character_set_connection,character_set_results,time_zone | SESSION | VARCHAR | Track changes in registered system variables. | NULL | NULL | NULL | NULL | NO | REQUIRED | NULL | |
648. | INNODB_TABLE_LOCKS | ON | ON | COMPILE-TIME | ON | SESSION | BOOLEAN | Enable InnoDB locking in LOCK TABLES | NULL | NULL | NULL | OFF,ON | NO | OPTIONAL | NULL | |
649. | INNODB_ADAPTIVE_MAX_SLEEP_DELAY | NULL | 0 | COMPILE-TIME | 0 | GLOBAL | INT UNSIGNED | Deprecated parameter with no effect. | 0 | 1000000 | 0 | NULL | NO | REQUIRED | NULL | |
650. | INNODB_FORCE_PRIMARY_KEY | NULL | OFF | COMPILE-TIME | OFF | GLOBAL | BOOLEAN | Do not allow creating a table without primary key (off by default) | NULL | NULL | NULL | OFF,ON | NO | OPTIONAL | NULL | |
651. | HISTOGRAM_SIZE | 254 | 254 | COMPILE-TIME | 254 | SESSION | BIGINT UNSIGNED | Number of bytes used for a histogram. If set to 0, no histograms are created by ANALYZE. | 0 | 255 | 1 | NULL | NO | REQUIRED | NULL | |
652. | RELAY_LOG_PURGE | NULL | ON | COMPILE-TIME | ON | GLOBAL | BOOLEAN | if disabled - do not purge relay logs. if enabled - purge them as soon as they are no more needed. | NULL | NULL | NULL | OFF,ON | NO | OPTIONAL | NULL | |
653. | WSREP_DIRTY_READS | OFF | OFF | COMPILE-TIME | OFF | SESSION | BOOLEAN | Allow reads even when the node is not in the primary component. | NULL | NULL | NULL | OFF,ON | NO | OPTIONAL | NULL | |
654. | INNODB_FT_TOTAL_CACHE_SIZE | NULL | 640000000 | COMPILE-TIME | 640000000 | GLOBAL | BIGINT UNSIGNED | Total memory allocated for InnoDB Fulltext Search cache | 32000000 | 1099511627776 | 0 | NULL | NO | REQUIRED | NULL | |
655. | INNODB_DEFRAGMENT_FILL_FACTOR | NULL | 0.900000 | COMPILE-TIME | 0.900000 | GLOBAL | DOUBLE | A number between [0.7, 1] that tells defragmentation how full it should fill a page. Default is 0.9. Number below 0.7 won't make much sense.This variable, together with innodb_defragment_fill_factor_n_recs, is introduced so defragmentation won't pack the page too full and cause page split on the next insert on every page. The variable indicating more defragmentation gain is the one effective. | 0.7 | 1 | NULL | NULL | NO | REQUIRED | NULL | |
656. | ARIA_PAGE_CHECKSUM | NULL | ON | COMPILE-TIME | ON | GLOBAL | BOOLEAN | Maintain page checksums (can be overridden per table with PAGE_CHECKSUM clause in CREATE TABLE) | NULL | NULL | NULL | OFF,ON | NO | REQUIRED | NULL | |
657. | ALTER_ALGORITHM | DEFAULT | DEFAULT | COMPILE-TIME | DEFAULT | SESSION | ENUM | Specify the alter table algorithm | NULL | NULL | NULL | DEFAULT,COPY,INPLACE,NOCOPY,INSTANT | NO | OPTIONAL | NULL | |
658. | SESSION_TRACK_SCHEMA | ON | ON | COMPILE-TIME | ON | SESSION | BOOLEAN | Track changes to the default schema. | NULL | NULL | NULL | OFF,ON | NO | OPTIONAL | NULL | |
659. | SQL_LOG_BIN | ON | ON | COMPILE-TIME | ON | SESSION | BOOLEAN | If set to 0 (1 is the default), no logging to the binary log is done for the client. Only clients with the SUPER privilege can update this variable. Can have unintended consequences if set globally, see SET SQL_LOG_BIN. Starting MariaDB 10.1.7, this variable does not affect the replication of events in a Galera cluster. | NULL | NULL | NULL | OFF,ON | NO | NULL | NULL | |
660. | IDLE_TRANSACTION_TIMEOUT | 0 | 0 | COMPILE-TIME | 0 | SESSION | INT UNSIGNED | The number of seconds the server waits for idle transaction | 0 | 31536000 | 1 | NULL | NO | REQUIRED | NULL | |
661. | PERFORMANCE_SCHEMA_USERS_SIZE | NULL | -1 | COMPILE-TIME | -1 | GLOBAL | BIGINT | Maximum number of instrumented users. Use 0 to disable, -1 for automated sizing. | -1 | 1048576 | 1 | NULL | YES | REQUIRED | NULL | |
662. | BACK_LOG | NULL | 80 | CONFIG | 150 | GLOBAL | BIGINT UNSIGNED | The number of outstanding connection requests MariaDB can have. This comes into play when the main MariaDB thread gets very many connection requests in a very short time | 0 | 65535 | 1 | NULL | YES | REQUIRED | NULL | |
663. | INNODB_SYNC_SPIN_LOOPS | NULL | 30 | COMPILE-TIME | 30 | GLOBAL | BIGINT UNSIGNED | Count of spin-loop rounds in InnoDB mutexes (30 by default) | 0 | 18446744073709551615 | 0 | NULL | NO | REQUIRED | NULL | |
664. | INNODB_STATS_PERSISTENT_SAMPLE_PAGES | NULL | 20 | COMPILE-TIME | 20 | GLOBAL | BIGINT UNSIGNED | The number of leaf index pages to sample when calculating persistent statistics (by ANALYZE, default 20) | 1 | 18446744073709551615 | 0 | NULL | NO | REQUIRED | NULL | |
665. | TMPDIR | NULL | /users/_sql/temp | CONFIG | GLOBAL | VARCHAR | Path for temporary files. Several paths may be specified, separated by a colon (:), in this case they are used in a round-robin fashion | NULL | NULL | NULL | NULL | YES | REQUIRED | NULL | ||
666. | INNODB_COMPRESSION_LEVEL | NULL | 6 | COMPILE-TIME | 6 | GLOBAL | INT UNSIGNED | Compression level used for zlib compression. 0 is no compression, 1 is fastest, 9 is best compression and default is 6. | 0 | 9 | 0 | NULL | NO | REQUIRED | NULL |
Datensätze 637 - 666 von insgesamt 666 << < > >>