Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-airportdb-quickstart.html
This quickstart contains the following sections: AirportDB Requirements Download AirportDB Data Load AirportDB into DB system Load AirportDB into MySQL HeatWave Cluster Run AirportDB Queries Additional AirportDB Queries Unload AirportDB Tables ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-update-vector-store.html
To keep up with the changes and updates in the documents in your Object Storage, you must update the vector embeddings loaded in the vector store table on a regular basis. The following sections in this topic describe how to update a vector store: ...This ensures that the responses generated by MySQL HeatWave GenAI are ...
https://dev.mysql.com/doc/refman/8.4/en/commit.html
To disable autocommit mode implicitly for a single series of statements, use the START TRANSACTION statement: START TRANSACTION; SELECT @A:=SUM(salary) FROM table1 WHERE type=1; UPDATE table2 SET summary=@A WHERE type=1; COMMIT; With START ...SET ...
https://dev.mysql.com/doc/refman/8.4/en/index-statistics.html
Storage engines collect statistics about tables for use by the optimizer. Table statistics are based on value groups, where a value group is a set of rows with the same key prefix value. The average value group size is related to table cardinality, ...For optimizer purposes, an important statistic is the average value group ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-online-ddl-limitations.html
The following limitations apply to online DDL operations: The table is copied when creating an index on a TEMPORARY TABLE. The ALTER TABLE clause LOCK=NONE is not permitted if there are ON...CASCADE or ON...SET NULL constraints on the table. Before ...When the DML operations are applied, it is possible to encounter a duplicate key entry error (ERROR 1062 (23000): Duplicate entry), even if the duplicate entry is only temporary and would be reverted by a later entry in the online ...
https://dev.mysql.com/doc/refman/8.4/en/replication-rbr-usage.html
As noted in Section 19.5.1.31, “Replication and Temporary Tables”, temporary tables are not replicated when using row-based or mixed format. Temporary tables are not replicated when using row-based or mixed format because there is no need. In ...
https://dev.mysql.com/doc/refman/8.4/en/replication-solutions-diffengines.html
It does not matter for the replication process whether the original table on the source and the replicated table on the replica use different storage engine types. For example, in a typical scale-out scenario (see Section 19.4.5, “Using ...This ...
https://dev.mysql.com/doc/refman/8.4/en/timestamp-initialization.html
For any TIMESTAMP or DATETIME column in a table, you can assign the current timestamp as the default value, the auto-update value, or both: An auto-initialized column is set to the current timestamp for inserted rows that specify no value for the ...
https://dev.mysql.com/doc/workbench/en/wb-what-is-new-60.html
Figure 1.36 Comparing the SQL Editor interface for Workbench 5.2 and 6.0 Table Data Search You can select schemas, tables, or both to perform client-side searches for user specified strings and patterns. To access this new search feature, right ...
https://dev.mysql.com/doc/refman/8.4/en/fulltext-natural-language.html
For each row in the table, MATCH() returns a relevance value; that is, a similarity measure between the search string and the text in that row in the columns named in the MATCH() list. The search must be performed using a full-text index scan rather ... By default or with the IN NATURAL LANGUAGE MODE modifier, the MATCH() function performs a natural language search for a string against a text ...