Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-monitor-types.html
There are two types of InnoDB monitor: The standard InnoDB Monitor displays the following types of information: Work done by the main background thread Semaphore waits Data about the most recent foreign key and deadlock errors Lock waits for ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-online-ddl-limitations.html
Secondary indexes are not created as efficiently because keys are inserted in the order they appeared in the primary key. The following limitations apply to online DDL operations: The table is copied when creating an index on a TEMPORARY TABLE. The ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-page-compression.html
InnoDB supports page-level compression for tables that reside in file-per-table tablespaces. Page compression is enabled by specifying the COMPRESSION attribute with CREATE TABLE or ALTER TABLE. Supported Platforms Page compression requires sparse ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-performance-compression-oltp.html
The rise of SSD storage devices, which are fast but relatively small and expensive, makes compression attractive also for OLTP workloads: high-traffic, interactive websites can reduce their storage requirements and their I/O operations per second ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-performance-schema.html
This section provides a brief introduction to InnoDB integration with Performance Schema. For comprehensive Performance Schema documentation, see Chapter 29, MySQL Performance Schema. You can profile certain internal InnoDB operations using the ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-purge-configuration.html
When the purge lag exceeds the innodb_max_purge_lag threshold, a delay is imposed on INSERT, UPDATE, and DELETE operations to allow time for purge operations to catch up. InnoDB does not physically remove a row from the database immediately when ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-recovery.html
The insert buffer merge and the purge are performed during normal processing. To achieve point-in-time recovery after restoring a backup, you can apply changes from the binary log that occurred after the backup was made. Recovery from Data ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-redo-log-buffer.html
Thus, if you have transactions that update, insert, or delete many rows, increasing the size of the log buffer saves disk I/O. The log buffer is the memory area that holds data to be written to the log files on disk. The contents of the log buffer ...
https://dev.mysql.com/doc/refman/8.4/en/install-component.html
INSTALL COMPONENT requires the INSERT privilege for the mysql.component system table because it adds a row to that table to register the component. [SET variable = expr [, variable = expr] ...] variable: { {GLOBAL | @@GLOBAL.} ...
https://dev.mysql.com/doc/refman/8.4/en/install-plugin.html
It requires the INSERT privilege for the mysql.plugin system table because it adds a row to that table to register the plugin. INSTALL PLUGIN plugin_name SONAME 'shared_library_name' This statement installs a server plugin. plugin_name is the name ...