Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-compression.html
Compression can be especially important for SSD storage devices, because they tend to have lower capacity than HDD devices. This section provides information about the InnoDB table compression and InnoDB page compression features. The page ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-fulltext-index.html
Most importantly, it stores the FTS_SYNCED_DOC_ID, which identifies documents that have been parsed and flushed to disk. Full-text indexes are created on text-based columns (CHAR, VARCHAR, or TEXT columns) to speed up queries and DML operations on ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-index-types.html
To get the best performance from queries, inserts, and other database operations, it is important to understand how InnoDB uses the clustered index to optimize the common lookup and DML operations. Each InnoDB table has a special index called the ...
https://dev.mysql.com/doc/refman/8.4/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.4/en/innodb-locks-set.html
It is important to create good indexes so that your queries do not scan more rows than necessary. A locking read, an UPDATE, or a DELETE generally set record locks on every index record that is scanned in the processing of an SQL statement. It does ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-online-ddl-operations.html
DISCARD PARTITION No No No Only permits ALGORITHM=DEFAULT, LOCK=DEFAULT IMPORT PARTITION No No No Only permits ALGORITHM=DEFAULT, LOCK=DEFAULT TRUNCATE PARTITION No Yes Yes Does not copy existing data. Online support details, syntax examples, and ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-persistent-stats.html
The number of columns in the table's primary key is also important to consider, as primary key columns are appended to each nonunique index. The persistent optimizer statistics feature improves plan stability by storing statistics to disk and ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-statistics-estimation.html
This technique is especially important for large tables and tables used in joins. Optimizer statistics are not persisted to disk when innodb_stats_persistent=OFF or when individual tables are created or altered with STATS_PERSISTENT=0. Instead, ...
https://dev.mysql.com/doc/refman/8.4/en/introduction.html
Important To report problems or bugs, please use the instructions at Section 1.6, “How to Report Bugs or Problems”. The MySQL software delivers a very fast, multithreaded, multi-user, and robust SQL (Structured Query Language) database server.
https://dev.mysql.com/doc/refman/8.4/en/keyring-aws-plugin.html
Note The keyring_aws plugin is an extension included in MySQL Enterprise Edition, a commercial product. The keyring_aws keyring plugin communicates with the Amazon Web Services Key Management Service (AWS KMS) as a back end for key generation and ...