Search Results
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-users-created-first-login.html
The Manager user: This user is the administrator of MySQL Enterprise Service Manager. The Agent user: MySQL Enterprise Monitor Agent broadcasts the status of the assets it is monitoring and requires access to MySQL Enterprise Service Manager. These ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-iris-quickstart.html
This quickstart illustrates an end-to-end example of creating and using a predictive machine learning model using MySQL HeatWave AutoML. Prepare Datasets Create and use the the database ml_data to store the table of data. mysql> CREATE SCHEMA ...It ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-limitations-syntax.html
Trying either to create a temporary table that uses the NDB storage engine or to alter an existing temporary table to use NDB fails with the error Table storage engine 'ndbcluster' does not support the create option 'TEMPORARY'. Attempting to create ... Some SQL statements relating to certain MySQL features produce errors when used with NDB tables, as described in the following list: Temporary ...
https://dev.mysql.com/doc/refman/8.4/en/mysqlslap.html
Invoke mysqlslap like this: mysqlslap [options] Some options such as --create or --query enable you to specify a string containing an SQL statement or a file containing statements. mysqlslap runs in three stages: Create schema, table, and optionally ... mysqlslap is a diagnostic program designed to emulate client load for a MySQL server and to report the timing of each ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-table-import.html
Otherwise, the table must be created on the same MySQL server instance into which it is being imported. If the table was created in an external directory by specifying the DATA DIRECTORY clause in the CREATE TABLE statement, the table that you ...
https://dev.mysql.com/doc/refman/8.4/en/keyring-functions-general-purpose.html
(This constraint rules out the use of the keyring functions for manipulation of instance-wide keys, such as those created by InnoDB to support tablespace encryption.) To enable multiple users to perform operations on the same key, “wrapper” ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-byo-embedding-tables.html
Create a table that satisfies the following criteria: To qualify as a valid embedding table, the table must contain the following columns: A string column containing the text segments. OutputTableName: the name of the table where you want to create ... As of MySQL 9.2.1, MySQL HeatWave GenAI lets you use tables containing your own vector embedding to run retrieval-augemented generation (RAG) with vector ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-load-event-based.html
Create and Set Up Streams The Events service requires an intermediary for events persistence and forwarding. Refer to the following resources from Oracle Cloud Infrastructure Documentation to learn more about streaming: Getting Started with ... As ...
https://dev.mysql.com/doc/refman/8.4/en/memory-storage-engine.html
The MEMORY storage engine (formerly known as HEAP) creates special-purpose tables with contents that are stored in memory. The following sections illustrate the syntax for creating both kinds of indexes. Characteristics of MEMORY Tables The MEMORY ...Because the data is vulnerable to crashes, hardware issues, or power outages, only use these tables as temporary work areas or read-only caches for data pulled from other ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-management-range-list.html
If you now execute a SHOW CREATE TABLE statement, you can see how the partitioning makeup of the table has been changed: mysql> SHOW CREATE TABLE tr\G *************************** 1. Another solution might appear to be to make a copy of the table ...