Search Results
https://dev.mysql.com/doc/extending-mysql/8.4/en/plugin-types.html
Storage Engine Plugins The pluggable storage engine architecture used by MySQL Server enables storage engines to be written as plugins and loaded into and unloaded from a running server. In this role, the plugin reads the input to be parsed, splits ... The plugin API enables creation of plugins that implement several capabilities: Loadable functions (UDFs) Storage engines Full-text parsers Daemons INFORMATION_SCHEMA tables Semisynchronous replication Auditing Authentication Password validation and strength checking Protocol tracing Query rewriting Secure keyring storage and retrieval The following sections provide an overview of these plugin ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-export-query-results-json-json.html
INTO OUTFILE WITH PARAMETERS 'file_URI_JSON "file": begin-array ("uri": "OCIFS_URI") | ("uri": "PAR_URI") | ("uri": "NATIVE_URI"), [, "dialect": begin-object dialect_option [, dialect_option]... SELECT sum(l_quantity) from lineitem limit 1000 INTO ... The option to export query results as an ND-JSON file is available as of MySQL ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-ml-model-import.html
Use the ML_MODEL_IMPORT routine to import a pre-trained model into your model catalog. Models in ONNX format (.onnx) cannot be loaded directly into a MySQL table. Before running ML_MODEL_IMPORT, follow the instructions in Import an External ONNX ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-heatwave-estimate-cluster-size.html
If you have not loaded data into your DB System, and you want to estimate the optimal MySQL HeatWave Cluster size, load data into the DB System before you create a MySQL HeatWave Cluster. Prerequisites: The data you intend to load into the MySQL ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-workspace-managing-hw-data.html
Data is loaded into MySQL HeatWave from the associated DB System. If you have not loaded data into the DB System, see Importing Data. The source data is read from an Amazon S3 bucket, transformed into a memory-optimized format, stored in the MySQL ...Creating Lakehouse Data Mapping: MySQL HeatWave Lakehouse enables query processing on the data residing in an Amazon S3 ...
https://dev.mysql.com/doc/refman/8.4/en/replication-gtids-functions.html
On server2, extract that statement from the mysqldump output, and store the GTID set into a local variable, such as $gtid_purged_set. To check, on server1, extract and store gtid_purged from the output into a local variable as done previously, then ... This section provides examples of stored functions (see Chapter 27, Stored Objects) which you can create using some of the built-in functions provided by MySQL for use with GTID-based replication, listed here: GTID_SUBSET(): Shows whether one GTID set is a subset of ...
https://dev.mysql.com/doc/refman/8.4/en/semijoins-antijoins.html
The following subqueries are transformed into antijoins: NOT IN (SELECT ... IN (SELECT ...)) IS NOT TRUE can be transformed into antijoins. Materialize the subquery into an indexed temporary table that is used to perform a join, where the index is ... A semijoin is a preparation-time transformation that enables multiple execution strategies such as table pullout, duplicate weedout, first match, loose scan, and ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-using-import-cluster-create-configure.html
The import status and its effects on newcluster and its cluster processes persist until we have completed importing another cluster into newcluster. After the successful dry run, you are now ready to import the wild cluster's configuration into ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-mysqlai-ml-model-import.html
Use the ML_MODEL_IMPORT routine to import a pre-trained model into your model catalog. Models in ONNX format (.onnx) cannot be loaded directly into a MySQL table. Before running ML_MODEL_IMPORT, follow the instructions in Import an External ONNX ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-bulk-load-mysql-server.html
MySQL includes a bulk load extension to the LOAD DATA statement that is only available in MySQL HeatWave on AWS. It can do the following: Optimize the loading of data sorted by primary key. Monitor bulk load progress with the Performance Schema (As ...