Search Results
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-advisors-wiki-format.html
When editing or defining an advisor, you can enter text in Wiki format in the Problem Description, Advice, Recommended Action, and Links and Further Reading text boxes. You can format and highlight text and add hyperlinks, using the notation listed ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-event-handlers-list-reference.html
The Event Handlers section lists all event handlers defined on the system and enables you to create Event Handlers. Figure 22.1 Event Handlers section Event Handlers section contains the following controls: Table 22.1 Event Handlers Controls Name ...Show * Entries Select the maximum number of event handlers to ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-autopilot-index-advisor-report-table.html
When Autopilot Indexing runs, it sends detailed output to the autopilot_index_advisor_report table in the sys schema. The autopilot_index_advisor_report table is a temporary table that contains data from the last execution of Autopilot Indexing.
https://dev.mysql.com/doc/heatwave/en/mys-hwgenai-ml-rag-table.html
Note In versions older than MySQL 9.2.1, to alter an existing table or create a new table, MySQL requires you to set the sql-require-primary-key system variable to 0. If the specified output table doesn't exist, then a new table is created. The ...
https://dev.mysql.com/doc/heatwave-aws/en/database-vector-store.html
To generate embedding for a file stored in your Amazon S3 bucket, connect to your DB System, create a database, and use the heatwave_load() stored procedure routine to load the file. MySQL HeatWave GenAI In-database Vector Store 14.3 MySQL HeatWave ...
https://dev.mysql.com/doc/heatwave-aws/en/ha-prerequisites.html
Prerequisites 12.2 Prerequisites Here are some prerequisites for creating a high availability DB System. All default MySQL configurations that are compatible with high availability are indicated as so in the MySQL Configuration Details, If you want ...A high availability DB System requires a high availability compatible ...
https://dev.mysql.com/doc/connector-j/en/connector-j-opentelemetry.html
This simple demonstration contains a class OTelDemo, which creates a connection to the Sakila database and executes an SQL SELECT statement that returns five rows from the table film. This trace becomes the current context (parent) for any ...
https://dev.mysql.com/doc/connector-j/en/connector-j-usagenotes-last-insert-id.html
getGeneratedKeys() is the preferred method to use if you need to retrieve AUTO_INCREMENT keys and through JDBC; this is illustrated in the first example below. The second example shows how you can retrieve the same value using a standard SELECT ...
https://dev.mysql.com/doc/refman/8.4/en/alter-table-generated-columns.html
CREATE TABLE t1 (c1 INT); ALTER TABLE t1 ADD COLUMN c2 INT GENERATED ALWAYS AS (c1 + 1) STORED; The data type and expression of generated columns can be modified. CREATE TABLE t1 (c1 INT, c2 INT GENERATED ALWAYS AS (c1 + 1) STORED); ALTER TABLE t1 ... ALTER TABLE operations permitted for generated columns are ADD, MODIFY, and ...
https://dev.mysql.com/doc/refman/8.4/en/alter-tablespace.html
Once a data file has been created, its size cannot be changed; however, you can add more data files to an NDB tablespace using additional ALTER TABLESPACE ... ADD DATAFILE is used with ENGINE = NDB, a data file is created on each Cluster data node, ...It can be used to add a new data file to, or to drop a data file from an NDB ...