Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-auto-loading-data-par.html
Review the following examples to see the different ways to use pre-authenticated requests (PAR) and Auto Parallel Load to specify files when creating external tables. These examples use an input_list variable to set up the creation of the external ...To learn more, see Load Structured Data Using Lakehouse Auto Parallel ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-auto-loading-data-rp.html
Review the following examples to see the different ways to use resource principals and Auto Parallel Load to specify files when creating external tables. These examples use an input_list variable to set up the creation of the external table and the ...To learn more, see Load Structured Data Using Lakehouse Auto Parallel ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-loading-data-par.html
Review the following examples to see the different ways to use pre-authenticated requests (PAR) to specify files when creating external tables manually. Create the external tables that will ingest the loaded data by either using SQL syntax or JSON ...Types of PARs You can create the following types of PARs: Bucket or prefix PAR: This type of PAR ends with ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/glossary.html
It offers the most efficiency and flexibility when backing up InnoDB tables; it can also back up MyISAM and other kinds of tables. B backup The process of copying some or all table data and metadata from a MySQL instance, for safekeeping. binary log ... These terms are commonly used in information about the MySQL Enterprise Backup ...
https://dev.mysql.com/doc/refman/8.4/en/general-tablespaces.html
A general tablespace is a shared InnoDB tablespace that is created using CREATE TABLESPACE syntax. The server keeps tablespace metadata in memory for the lifetime of a tablespace. Multiple tables in fewer general tablespaces consume less memory for ...To make an unknown directory known to InnoDB, add the directory to the innodb_directories argument ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-metric-mysqlserver-tableactivity-category.html
Lists the Table Activity metrics and provides a brief description of each. Table 6.44 Table Activity Metrics NameDescriptionCreated Tmp Disk Tables (Delta) The total number of temporary tables that were converted to disk based tables, due to ...
https://dev.mysql.com/doc/heatwave/en/mys-hwgenai-ml-rag-table.html
The ML_RAG_TABLE routine runs multiple retrieval-augmented generation (RAG) queries in a batch, in parallel. 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 ...The output ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-install-example-data.html
Working with database tables and data in NDB Cluster is not much different from doing so in standard MySQL. There are two key points to keep in mind: For a table to be replicated in the cluster, it must use the NDBCLUSTER storage engine. To specify ... Note The information in this section applies to NDB Cluster running on both Unix and Windows ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-config-metric-tableconfiguration-category.html
Lists the Table Configuration configuration metrics and provides a brief description of each. Table 7.35 Table Configuration Configuration Metrics NameDescriptionBig Tables Enabled Enable large result sets by saving all temporary sets in files.
https://dev.mysql.com/doc/refman/8.4/en/grant.html
(Alternatively, if you have the UPDATE privilege for the grant tables in the mysql system schema, you can grant any account any privilege.) When the read_only system variable is enabled, GRANT additionally requires the CONNECTION_ADMIN privilege (or ...[WITH GRANT OPTION] [AS user [WITH ROLE DEFAULT | NONE | ALL | ALL EXCEPT role [, role ] ...