Search Results
https://dev.mysql.com/doc/mysql-router/9.4/en/mysql-router-installation-linux.html
Installing MySQL Router using an official DEB or RPM package creates a local system user and group named "mysqlrouter" on the host that MySQL Router runs as by default. There are binary distributions of MySQL Router available for several variants ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/innodb-clusterset-cluster-repair.html
Unless otherwise stated, use Cluster and ClusterSet objects that you fetched with an InnoDB Cluster administrator account or server configuration account, so that the default user account stored in the ClusterSet object has the correct permissions.
https://dev.mysql.com/doc/mysql-shell/9.4/en/mysql-shell-interactive-code-execution.html
The default mode of MySQL Shell provides interactive execution of database operations that you type at the command prompt. These operations can be written in JavaScript, Python or SQL depending on the current Section 5.1, “Active Language”. As ...
https://dev.mysql.com/doc/workbench/en/wb-migration-overview-steps.html
The current Workbench MySQL connections will be available here, or you can choose Manage DB Connections to create a new connection. "Schema Name Mapping Method" options while migrating Microsoft SQL Server: Keep schemas as they are: ... This example ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-metric-mysqlserver-showstatementactivity-category.html
Show Create DB (Delta) The total number of SHOW CREATE DATABASE statements executed. Show Create Event (Delta) The total number of SHOW CREATE EVENT statements executed. Show Create Func (Delta) The total number of SHOW CREATE FUNCTION statements ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-generate-embeddings.html
Using this method, you can create vector embedding tables that you can use to perform similarity searches using the DISTANCE() function, without setting up a vector store. To learn how to create vector embeddings for unstructured data, see Section ... This section describes how to generate vector embeddings using the ML_EMBED_ROW MySQL HeatWave GenAI ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-overview.html
External Tables When MySQL HeatWave loads data and creates a table from a file in Object Storage, it is an external Lakehouse table. Lakehouse Engine The lakehouse storage engine allows you to create tables that point to external data sources. As of ... The Lakehouse feature of MySQL HeatWave enables query processing on data in Object ...
https://dev.mysql.com/doc/refman/8.4/en/json-search-functions.html
The functions in this section perform search or comparison operations on JSON values to extract data from them, report whether data exists at a location within them, or report the path to data within them. JSON_CONTAINS(target, candidate[, path]) ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-selection.html
When a table is created using [LINEAR] HASH or [LINEAR] KEY partitioning and the names of the partitions are not specified, MySQL automatically names the partitions p0, p1, p2, ..., pN-1, where N is the number of partitions. Explicit selection of ...
https://dev.mysql.com/doc/refman/8.4/en/storage-engine-setting.html
When you create a new table, you can specify which storage engine to use by adding an ENGINE table option to the CREATE TABLE statement: -- ENGINE=INNODB not needed unless you have set a different -- default storage engine. CREATE TABLE t1 (i INT) ...You can specify the default engine by using the --default-storage-engine server startup option, or by setting the default-storage-engine option in the my.cnf configuration ...