Search Results
https://dev.mysql.com/doc/x-devapi-userguide/en/collection-add.html
The collection needs to be created with the Schema.createCollection() function before documents can be inserted. The Collection.add() function is for storing documents in a collection, similar to the INSERT statement for an SQL database. It takes a ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/admin-advisors-reference.html
Common uses are the cleanup of obsolete data, the creation of summary tables for statistics, and monitoring of server performance and usage. Default frequency 00:05:00 Default auto-close enabled no In-Memory Temporary Table Size Limited By Maximum ...However, for performance reasons, it is recommended to run 64-bit binaries on 64-bit platforms, and 32-bit binaries on 32-bit ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-loading-data-manually.html
After creating an external table manaully and specifying the files to load into the table, you specify the SECONDARY_UNLOAD clause in an ALTER TABLE statement to load the data from the files into the table. This topic contains the following ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-regression-prepare.html
To ensure reliable predictions, you should create an additional validation dataset. You can reserve 20% of the records in the training dataset to create the validation dataset. mysql> CREATE DATABASE regression_data; mysql> USE regression_data; ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-events.html
Events 16 Events Statuses of actions and operations on MySQL HeatWave on AWS resources are reported as Events. A list of all Events is found on the Service Events pane, accessible from the console's Home page by the following means: The Monitoring ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-page-compression.html
Page compression is enabled by specifying the COMPRESSION attribute with CREATE TABLE or ALTER TABLE. For page compression to work on Windows, the file system must be created with a cluster size smaller than 4K, and the innodb_page_size must be at ... InnoDB supports page-level compression for tables that reside in file-per-table ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-tablespace-autoextend-size.html
When a file-per-table or general tablespace is created with a non-zero AUTOEXTEND_SIZE setting, the tablespace is initialized at the specified AUTOEXTEND_SIZE size. For tables created in file-per-table tablespaces, SHOW CREATE TABLE shows the ... By ...
https://dev.mysql.com/doc/refman/8.4/en/mysqldump-sql-format.html
This section describes how to use mysqldump to create SQL-format dump files. With --all-databases or --databases, mysqldump writes CREATE DATABASE and USE statements prior to the dump output for each database. This ensures that when the dump file ...For information about reloading such dump files, see Section 9.4.2, “Reloading SQL-Format ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-management.html
Note All partitions of a partitioned table must have the same number of subpartitions; it is not possible to change the subpartitioning once the table has been created. To change a table's partitioning scheme, it is necessary only to use the ALTER ... There are a number of ways using SQL statements to modify partitioned tables; it is possible to add, drop, redefine, merge, or split existing partitions using the partitioning extensions to the ALTER TABLE ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-pruning.html
In the second case, the optimizer evaluates the partitioning expression for each value in the list, creates a list of matching partitions, and then scans only the partitions in this partition list. The optimization known as partition pruning is ...