PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.5Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/innodb-introduction.html
Key Advantages of InnoDB Its DML operations follow the ACID model, with transactions featuring commit, rollback, and crash-recovery capabilities to protect user data. With foreign keys, inserts, updates, and deletes are checked to ensure they do not ... InnoDB is a general-purpose storage engine that balances high reliability and high ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-setup.html
After updating the innodb_memcache.containers table, restart the daemon_memcache plugin to apply the changes. daemon_memcached_r_batch_size is set to 1 by default so that every get request accesses the most recently committed data in the InnoDB ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-online-ddl-limitations.html
An online DDL operation may briefly require an exclusive metadata lock on the table during its execution phase, and always requires one in the final phase of the operation when updating the table definition. OPTIMIZE TABLE for an InnoDB table is ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-page-compression.html
During recovery, updated pages are written out in an uncompressed form. 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 ...
https://dev.mysql.com/doc/refman/8.0/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.0/en/innodb-performance-optimizer-statistics.html
Persistent optimizer statistics also provide control and flexibility with these additional benefits: You can use the innodb_stats_auto_recalc configuration option to control whether statistics are updated automatically after substantial changes to a ... This section describes how to configure persistent and non-persistent optimizer statistics for InnoDB ...
https://dev.mysql.com/doc/refman/8.0/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. The InnoDB transaction system maintains a list of transactions that have index ... InnoDB does not physically remove a row from the database immediately when you delete it with an SQL ...
https://dev.mysql.com/doc/refman/8.0/en/invisible-indexes.html
Using the SET_VAR optimizer hint to update the value of optimizer_switch temporarily, you can enable invisible indexes for the duration of a single query only, like this: mysql> EXPLAIN SELECT /*+ SET_VAR(optimizer_switch = ... MySQL supports ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-functions-plugin-specific.html
keyring_hashicorp_update_config() Associated keyring plugin: keyring_hashicorp When invoked, the keyring_hashicorp_update_config() function causes keyring_hashicorp to perform a runtime reconfiguration, as described in keyring_hashicorp ... For each ...
https://dev.mysql.com/doc/refman/8.0/en/kill.html
During UPDATE or DELETE operations, the kill flag is checked after each block read and after each updated or deleted row. KILL [CONNECTION | QUERY] processlist_id Each connection to mysqld runs in a separate thread. Thread processlist identifiers ...