Search Results
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 ...
https://dev.mysql.com/doc/mysql-enterprise-backup/9.7/en/meb-backup-single-file.html
It can also pack an existing backup directory into a single file, unpack the single file back to a backup directory, list the contents of a single-file backup, verify the contents of a single-file backup against embedded checksums, or extract a ...
https://dev.mysql.com/doc/connectors/en/connector-python-coding.html
The following guidelines cover aspects of developing MySQL applications that might not be immediately obvious to developers coming from a Python background: For security, do not hardcode the values needed to connect and log into the database in ...
https://dev.mysql.com/doc/connector-python/en/connector-python-coding.html
The following guidelines cover aspects of developing MySQL applications that might not be immediately obvious to developers coming from a Python background: For security, do not hardcode the values needed to connect and log into the database in ...
https://dev.mysql.com/doc/internals/en/replication-source-code-files.html
rpl_injector.h/.cc The injector class that allows external insertions into the binary log. log.h/.cc The high-level binary logging mechanism for organizing events into a sequence so that it becomes a binary log. Reading and writing here is at a low ... Status of this section: up to date 2009-12-16 Files in the sql directory: File Description slave.h/.cc Contains the slave IO and SQL ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-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. Depending on your MySQL version, we recommend the following: Before MySQL 9.4.1, limit operations to batches of rows by ...
https://dev.mysql.com/doc/refman/9.7/en/cost-model.html
Cost Model General Operation The Cost Model Database Making Changes to the Cost Model Database Cost Model General Operation The configurable optimizer cost model works like this: The server reads the cost model tables into memory at startup and uses ... To generate execution plans, the optimizer uses a cost model that is based on estimates of the cost of various operations that occur during query ...
https://dev.mysql.com/doc/refman/9.7/en/csv-storage-engine.html
The CSV storage engine is always compiled into the MySQL server. When you store data into the table, the storage engine saves it into the data file in comma-separated values format. The CSV storage engine stores data in text files using ...