Search Results
https://dev.mysql.com/doc/refman/9.7/en/faqs-stored-procs.html
Is it possible to group stored procedures or stored functions into packages? A.4.9. Is it possible to group stored procedures or stored functions into packages? No. Finally, nontransactional tables for which errors occur during large DML actions ...
https://dev.mysql.com/doc/refman/9.7/en/flush.html
FLUSH TABLES WITH READ LOCK does not prevent the server from inserting rows into the log tables (see Section 7.4.1, “Selecting General Query Log and Slow Query Log Output Destinations”). The .cfg file contains metadata needed to reimport the ...
https://dev.mysql.com/doc/refman/9.7/en/json-table-functions.html
NESTED [PATH] path COLUMNS (column_list): This flattens nested objects or arrays in JSON data into a single row along with the JSON values from the parent object or array. Using multiple PATH options allows projection of JSON values from multiple ...
https://dev.mysql.com/doc/refman/9.7/en/replication-upgrade.html
Upgrade the old source according to the procedure for a single server, and then reinsert it into the topology. For each replica, take out the replica from the topology, wait for it to apply all its relay log, downgrade it following the instructions ... When you upgrade servers that participate in a replication topology, you need to take into account each server's role in the topology and look out for issues specific to ...
https://dev.mysql.com/doc/mysql-ai/9.7/en/mys-ai-aml-predictions-ml-predict-table.html
If you specify the output table and the input table as the same name, the predictions are inserted into the input table. After generating predictions on a table, learn how to Generate Explanations on a table to get insights into which features have ... ML_PREDICT_TABLE generates predictions for an entire table of trained ...
https://dev.mysql.com/doc/relnotes/mysql-cluster/9.7/en/news-9-4-0.html
Functionality Added or Changed Bugs Fixed Functionality Added or Changed NDB Replication: It is now possible to divide binary logging for a MySQL Cluster or for individual NDBCLUSTER tables into equal portions or “slices” between multiple MySQL ... MySQL NDB Cluster 9.4.0 is a new Innovation release of NDB Cluster, based on MySQL Server 9.4 and including features in version 9.4 of the NDB storage engine, as well as fixing recently discovered bugs in previous NDB Cluster ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-selective-load.html
If a new file path is specified, then the data from the file is loaded into the table. Complete the following steps to perform the initial load of data: Upload the files to load into Object Storage. See Upload the files to load into Object Storage ... Available as of MySQL 9.1.2, you can update external tables using Selective Load, which lets you edit the list of files that comprise an external table without altering the directories in the Object Storage ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-tpch-quickstart.html
The tpch Analytics Quickstart shows how to import data into the DB System using the MySQL Shell Parallel Table Import Utility, manually loading data into MySQL HeatWave Cluster, and running queries. This quickstart contains the following sections: ...We recommend that you always run the latest version of MySQL Shell, which is currently MySQL version ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-learn-with-genai.html
This includes detailed instructions to do the following: Join your dataset's various tables into a single table. To use in-database LLMs with NL2ML: Specify the question and set it into a variable (@input). mysql> SELECT GROUP_CONCAT(seg SEPARATOR ... Available as of MySQL 9.4.0, the NL2ML routine enables you to learn about MySQL HeatWave AutoML by leveraging Oracle Cloud Infrastructure Generative AI (OCI) and asking questions in natural ...
https://dev.mysql.com/doc/refman/9.7/en/rewriter-query-rewrite-plugin-reference.html
Note The rules table is loaded into the plugin by the flush_rewrite_rules stored procedure. Load operations (performed by invoking the flush_rewrite_rules() stored procedure) load the rule from the table into the Rewriter in-memory cache only if ...