Search Results
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-locks-per-fragment.html
The locks_per_fragment table provides information about counts of lock claim requests, and the outcomes of these requests on a per-fragment basis, serving as a companion table to operations_per_fragment and memory_per_fragment. This table also ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/server-repository-options.html
log-bin-index[=PATH] Specify the absolute path (including file name and extension) for restoring the index file that lists all the binary log files, if it is different from the default path given below. relay-log-index[=PATH] Specify the absolute ...
https://dev.mysql.com/doc/relnotes/connector-net/en/news-8-0-23.html
New EF Core package naming for Connector/NET 8.0.23: 5.0.0+m8.0.23 3.1.10+m8.0.23 (WL #14214) Bugs Fixed If a prepared statement had no parameters, Connector/NET included in the COM_STMT_EXECUTE packet structure a byte corresponding to ...
https://dev.mysql.com/doc/relnotes/heatwave/en/news-9-5-0.html
(WL #16950) MySQL HeatWave GenAI now supports automatic creation of Vector Indexes using advanced index structures like Hierarchical Navigable Small World (HNSW) for frequently queried vector columns in vector store and embedding tables, enabling ...
https://dev.mysql.com/doc/refman/8.4/en/adding-collation-simple-8bit.html
This section describes how to add a simple collation for an 8-bit character set by writing the <collation> elements associated with a <charset> character set description in the MySQL Index.xml file. You can check the variable value as follows, ...
https://dev.mysql.com/doc/refman/8.4/en/cost-model.html
This occurs when a storage engine is dynamically loaded or when a FLUSH OPTIMIZER_COSTS statement is executed. For example, a query plan that performs a filesort becomes relatively more expensive compared to a query plan that avoids sorting by using ... To generate execution plans, the optimizer uses a cost model that is based on estimates of the cost of various operations that occur during query ...
https://dev.mysql.com/doc/refman/8.4/en/faqs-tablespace-encryption.html
Can indexed columns be encrypted? InnoDB data-at-rest encryption supports all indexes transparently. The master encryption key is rotated using the ALTER INSTANCE ROTATE INNODB MASTER KEY statement, which generates a new master encryption key, ...Is ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-fields-table.html
The INNODB_FIELDS table provides metadata about the key columns (fields) of InnoDB indexes. The INNODB_FIELDS table has these columns: INDEX_ID An identifier for the index associated with this key field; the same value as INNODB_INDEXES.INDEX_ID.
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-foreign-cols-table.html
The INNODB_FOREIGN_COLS table has these columns: ID The foreign key index associated with this index key field; the same value as INNODB_FOREIGN.ID. POS The ordinal position of this key field within the foreign key index, starting from 0. Use the ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-online-ddl-failure-conditions.html
The tmpdir or innodb_tmpdir file system runs out of disk space, while MySQL writes temporary sort files on disk during index creation. The operation only fails at the very end, when MySQL tries to apply all the changes from concurrent DML statements. For example, you might insert duplicate values into a column while a unique index is being created, or you might insert NULL values into a column while creating a primary key index on that ... The failure of an online ...