Search Results
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-mysqlai-ml-metrics.html
If the input table overlaps with the training table, and remove_seen is true, which is the default setting, then the model will not repeat a recommendation and it ignores the overlap items. The precision_at_k value for the input table is the average ... The ML_TRAIN routine includes the optimization_metric option, and the ML_SCORE routine includes the metric ...
https://dev.mysql.com/doc/heatwave-aws/en/mysql-server-storage-engines.html
You can manually convert tables to InnoDB using the following ALTER TABLE statement: mysql> ALTER TABLE table_name ENGINE=InnoDB; The recommended method for migrating data is to use the MySQL Shell client. MySQL Shell dump utilities provide a ocimds ... MySQL Storage Engines 3.1.2.5 MySQL Storage Engines MySQL HeatWave on AWS supports only the InnoDB storage ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-limitations-exclusive-to-cluster.html
NDB Cluster has the following limitations or restrictions with regard to binary logging: NDB Cluster cannot produce a binary log for tables having BLOB columns but no primary key. The following are limitations specific to the NDB storage engine: ...
https://dev.mysql.com/doc/refman/8.4/en/view-syntax.html
To alter the definition of a view or drop a view, use ALTER VIEW (see Section 15.1.11, “ALTER VIEW Statement”), or DROP VIEW (see Section 15.1.35, “DROP VIEW Statement”). The CREATE VIEW statement creates a new view (see Section 15.1.23, ...
https://dev.mysql.com/doc/workbench/en/wb-what-is-new-62.html
Overlay Icons in the Object Viewer The schema navigator now includes shortcut buttons for common operations such as table data view, the table editor, and the table/schema inspector. The new spatial view panel renders data from each row into a ...
https://dev.mysql.com/doc/internals/en/creating-handlerton.html
Possible values are defined in sql/handler.h and copied here: #define HTON_NO_FLAGS 0 #define HTON_CLOSE_CURSORS_AT_COMMIT (1 << 0) #define HTON_ALTER_NOT_SUPPORTED (1 << 1) #define HTON_CAN_RECREATE (1 << 2) #define HTON_FLUSH_AFTER_RENAME (1 << 3) ... The handlerton (short for handler singleton) defines the storage engine and contains method pointers to those methods that apply to the storage engine as a whole, as opposed to methods that work on a per-table ...
https://dev.mysql.com/doc/refman/8.4/en/faqs-replication.html
On the source, issue the following statement to enable the source to begin processing updates again: mysql> UNLOCK TABLES; A.14.5. Thus, when the update of client A makes it to co-source 2, it produces tables that are different from what you have on ... In the following section, we provide answers to questions that are most frequently asked about MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/fulltext-search.html
A FULLTEXT index definition can be given in the CREATE TABLE statement when a table is created, or added later using ALTER TABLE or CREATE INDEX. Full-text indexes can be used only with InnoDB or MyISAM tables, and can be created only for CHAR, ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-reserved-words.html
For example, a table column named rank on a MySQL 5.7 source that is replicating to a MySQL 8.4 replica could cause a problem because RANK became a reserved word in MySQL 8.0. Replication can fail in such cases with Error 1064 You have an error in ... You can encounter problems when you attempt to replicate from an older source to a newer replica and you make use of identifiers on the source that are reserved words in the newer MySQL version running on the ...
https://dev.mysql.com/doc/refman/8.4/en/replication-howto-additionalslaves.html
For example, the InnoDB system tablespace, undo tablespace, and redo log might be stored in an alternative location. Alternatively, you can use the ALTER EVENT statement to set individual events to DISABLE or DISABLE ON REPLICA to prevent them from ... You can add another replica to an existing replication configuration without stopping the source ...