Search Results
https://dev.mysql.com/doc/refman/8.4/en/information-schema-resource-groups-table.html
RESOURCE_GROUP_ENABLED Whether the resource group is enabled (1) or disabled (0); VCPU_IDS The CPU affinity; that is, the set of virtual CPUs that the resource group can use. The RESOURCE_GROUPS table provides access to information about resource ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-compression-internals.html
Depending on the workload, this smaller database can in turn lead to a reduction in I/O, and an increase in throughput, at a modest cost in terms of increased CPU utilization. If innodb_strict_mode is ON, MySQL checks the maximum row size during ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-compression-usage.html
If innodb_strict_mode is disabled, warnings are issued and the temporary table is created using a non-compressed row format. When innodb_strict_mode is enabled (the default), CREATE TEMPORARY TABLE returns errors if ROW_FORMAT=COMPRESSED or ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-configuring-io-capacity.html
To adhere to the I/O rate defined by the innodb_io_capacity and innodb_io_capacity_max settings, disable innodb_flush_sync. The InnoDB master thread and other threads perform various tasks in the background, most of which are I/O related, such as ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-deadlocks-handling.html
This section builds on the conceptual information about deadlocks in Section 17.7.5.2, “Deadlock Detection”. It explains how to organize database operations to minimize deadlocks and the subsequent error handling required in applications.
https://dev.mysql.com/doc/refman/8.4/en/innodb-deadlocks.html
If deadlock detection is disabled using the innodb_deadlock_detect variable, InnoDB relies on the innodb_lock_wait_timeout setting to roll back transactions in case of a deadlock. A deadlock is a situation in which multiple transactions are unable ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-disk-management.html
The ACID design model requires a certain amount of I/O that might seem redundant, but helps to ensure data reliability. Enabling or disabling features that provide extra durability at the expense of additional I/O. As a DBA, you must manage disk ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-file-per-table-tablespaces.html
Disabling innodb_file_per_table causes InnoDB to create tables in the system tablespace. A file-per-table tablespace contains data and indexes for a single InnoDB table, and is stored on the file system in a single data file. File-per-table ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-information-schema-fulltext_index-tables.html
mysql> SELECT * FROM INFORMATION_SCHEMA.INNODB_FT_CONFIG; +---------------------------+-------+ | KEY | VALUE | +---------------------------+-------+ | optimize_checkpoint_limit | 180 | | synced_doc_id | 8 | | stopword_table_name | | | use_stopword ...INNODB_FT_BEING_DELETED: Provides a snapshot of the INNODB_FT_DELETED table; it is used only during an OPTIMIZE TABLE maintenance ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-linux-native-aio.html
This option may also be disabled automatically during startup if InnoDB detects a potential problem such as a combination of tmpdir location, tmpfs file system, and Linux kernel that does not support asynchronous I/O on tmpfs. InnoDB uses the ...