PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.1Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/innodb-benefits.html
For InnoDB-specific tuning techniques you can apply to your MySQL server and application code, see Section 10.5, “Optimizing for InnoDB Tables”. InnoDB tables have the following benefits: If the server unexpectedly exits because of a hardware ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-fulltext-index.html
Full-text indexes are created on text-based columns (CHAR, VARCHAR, or TEXT columns) to speed up queries and DML operations on data contained within those columns. A full-text index is defined as part of a CREATE TABLE statement or added to an ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-information-schema-system-tables.html
You can extract metadata about schema objects managed by InnoDB using InnoDB INFORMATION_SCHEMA tables. Traditionally, you would get this type of information using the techniques from Section 17.17, “InnoDB Monitors”, setting up InnoDB monitors ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-locking-transaction-model.html
To implement a large-scale, busy, or highly reliable database application, to port substantial code from a different database system, or to tune MySQL performance, it is important to understand InnoDB locking and the InnoDB transaction model. This ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-benefits.html
The serialization features of memcached, which can turn complex data structures, binary files, or even code blocks into storable strings, offer a simple way to get such objects into a database. The combination of InnoDB tables and memcached offers ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-online-ddl-single-multi.html
The downside was that SQL code involving DDL operations was harder to maintain and to reuse in different scripts. Before the introduction of online DDL, it was common practice to combine many DDL operations into a single ALTER TABLE statement.
https://dev.mysql.com/doc/refman/8.0/en/innodb-transaction-scheduling.html
INNODB_METRICS counters are provided for monitoring of code-level transaction scheduling events. InnoDB uses the Contention-Aware Transaction Scheduling (CATS) algorithm to prioritize transactions that are waiting for locks. When multiple ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-aws-plugin.html
C interface: In C-language code, call the keyring service functions described in Section 7.6.9.2, “The Keyring Service”. Note The keyring_aws plugin is an extension included in MySQL Enterprise Edition, a commercial product. The keyring_aws ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-encrypted-file-plugin.html
C interface: In C-language code, call the keyring service functions described in Section 7.6.9.2, “The Keyring Service”. Note The keyring_encrypted_file plugin is an extension included in MySQL Enterprise Edition, a commercial product. The ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-file-plugin.html
C interface: In C-language code, call the keyring service functions described in Section 7.6.9.2, “The Keyring Service”. The keyring_file keyring plugin stores keyring data in a file local to the server host. As of MySQL 8.0.34, this plugin is ...