Search Results
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-heatwave-estimate-cluster-size.html
Estimating Cluster Size with HeatWave Autopilot 4.1.1 Estimating Cluster Size with HeatWave Autopilot This topic describes how to estimate the optimal HeatWave Cluster size for your data. If you have not loaded data into your DB System, and you ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-hwaml-create-model.html
Create a HeatWave AutoML model 12.2 Create a HeatWave AutoML model Use the HeatWave Console to create a new HeatWave AutoML model. Create a HeatWave AutoML model includes an advanced option to choose one or more algorithms. HeatWave AutoML uses the ...
https://dev.mysql.com/doc/connector-j/en/connector-j-connp-props-performance-extensions.html
Also notice that for prepared statements, if the stream length is not specified when using 'PreparedStatement.set*Stream()', the driver would not be able to determine the optimum number of parameters per batch and might return an error saying that ... callableStmtCacheSize If 'cacheCallableStmts' is enabled, how many callable statements should be cached? Default Value 100 Since Version 3.1.2 metadataCacheSize The number of queries to cache 'ResultSetMetadata' for if 'cacheResultSetMetaData' is set to ...
https://dev.mysql.com/doc/connector-j/en/connector-j-usagenotes-j2ee-concepts-connection-pooling.html
The optimal size for the connection pool depends on anticipated load and average database transaction time. In practice, the optimal connection pool size can be smaller than you might expect. Connection pooling is a technique of creating and ...
https://dev.mysql.com/doc/refman/8.4/en/backup-policy.html
For example, MySQL Enterprise Backup can perform a physical backup of an entire instance, with optimizations to minimize overhead and avoid disruption when backing up InnoDB data files; mysqldump provides online logical backup. They are not optimal ...A full backup (a snapshot of the data at a point in time) can be done in MySQL with several ...
https://dev.mysql.com/doc/refman/8.4/en/converting-tables-to-innodb.html
In this situation, there is no I/O penalty related to COMMIT or ROLLBACK, and InnoDB can automatically optimize the read-only workload. You might change the column and index definitions slightly, for better space utilization, reduced I/O and memory ... If you have MyISAM tables that you want to convert to InnoDB for better reliability and scalability, review the following guidelines and tips before ...
https://dev.mysql.com/doc/refman/8.4/en/correlated-subqueries.html
The optimizer can transform a correlated scalar subquery to a derived table when the subquery_to_derived flag of the optimizer_switch variable is enabled. This reflects the cardinality check that the optimizer performs as part of evaluating the JOIN ... A correlated subquery is a subquery that contains a reference to a table that also appears in the outer ...
https://dev.mysql.com/doc/refman/8.4/en/create-procedure.html
Declaring a nondeterministic routine as DETERMINISTIC might lead to unexpected results by causing the optimizer to make incorrect execution plan choices. Declaring a deterministic routine as NONDETERMINISTIC might diminish performance by causing ...
https://dev.mysql.com/doc/refman/8.4/en/create-table-generated-columns.html
If a generated column is indexed, the optimizer recognizes query expressions that match the column definition and uses indexes from the column as appropriate during query execution, even if a query does not refer to the column directly by name. For ...Values of a generated column are computed from an expression included in the column ...
https://dev.mysql.com/doc/refman/8.4/en/creating-spatial-indexes.html
The optimizer can use spatial indexes defined on columns that are SRID-restricted. For more information, see Section 13.4.1, “Spatial Data Types”, and Section 10.3.3, “SPATIAL Index Optimization”. For InnoDB and MyISAM tables, MySQL can ...