Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-loading-data-manually.html
After creating an external table manually and specifying the files to load into the table, you have the option (as of MySQL 9.6.0) to validate a load command before loading data into the external table. Load and Validate Tables Statement To load an ...This topic contains the following sections: Before You Begin Load and Validate Tables Statement Guided Load Validate Load Load External Data Manually Example What's Next Before You Begin Complete the steps to Create an External Table ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-loading-data-par.html
To specify multiple external files into one external table, you can create a folder in the Object Storage bucket and upload the required files into that folder. See the following to learn more: Regular Expression Syntax Modified ECMAScript regular ... Review the following examples to see the different ways to use pre-authenticated requests (PAR) to specify files when creating external tables ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-loading-data-resource-principal.html
Create file items as needed to specify the files to load into the table. See the following to learn more: Regular Expression Syntax Modified ECMAScript regular expression grammar The following example specifies all files in the data_files folder ...
https://dev.mysql.com/doc/refman/8.4/en/alter-table-partition-operations.html
In this case, partitions 4 and 5 are merged into the first 4 partitions (the partitions numbered 0, 1, 2, and 3). This statement can be used in several ways: To merge a set of partitions into a single partition. Partitioning-related clauses for ...
https://dev.mysql.com/doc/refman/8.4/en/firewall-reference.html
Firewall Group Profile Tables Firewall Account Profile Tables Firewall Group Profile Tables MySQL Enterprise Firewall maintains group profile information using tables in the firewall database (mysql or custom) for persistent storage and Performance ...When enabled, the firewall bases operational decisions on the cached ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-commands.html
This behavior on the server side comes into play for multiple-statement execution (see Multiple Statement Execution Support), and for parsing the body of stored procedures and functions, triggers, and events (see Section 27.1, “Defining Stored ...
https://dev.mysql.com/doc/refman/8.4/en/selinux-troubleshooting.html
Troubleshooting SELinux typically involves placing SELinux into permissive mode, rerunning problematic operations, checking for access denial messages in the SELinux audit log, and placing SELinux back into enforcing mode after problems are ...grep ...
https://dev.mysql.com/doc/refman/8.4/en/stored-program-restrictions.html
This includes SELECT statements that do not have an INTO var_list clause and other statements such as SHOW, EXPLAIN, and CHECK TABLE. If a trigger uses a table and the table has changed since the trigger was loaded into the cache, the trigger ...
https://dev.mysql.com/doc/refman/8.4/en/windows-restrictions.html
The following restrictions apply to use of MySQL on the Windows platform: Process memory On Windows 32-bit platforms, it is not possible by default to use more than 2GB of RAM within a single process, including MySQL. This is because the physical ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/meb-encrypted-innodb.html
mysqlbackup then copies over from the server the encrypted keyring data file, which contains the master key used to encrypt all the tablespace keys, into the meta folder in the backup and names the file keyring_kef; the file is encrypted with the ...