Search Results
https://dev.mysql.com/doc/mysql-shell/9.7/en/mysql-shell-read-replicas-creating.html
incremental: Uses distributed state recovery to apply missing transactions copied from another cluster member. If cloneDonor is not defined, but clone is the selected recovery method, either by explicitly specifying clone or if auto selects clone as ... Create Read Replicas using addReplicaInstance(): Cluster.addReplicaInstance(instance, [options]) Examples Default Read Replica Defining a Replication Source for the Read Replica Defining the Recovery Method for Read Replicas Certificate-based Authentication Examples The examples in this and subsequent sections assume a simple Cluster of three instances, a primary and two ...
https://dev.mysql.com/doc/relnotes/mysql/9.7/en/news-9-7-0.html
(WL #17246) MySQL now supports the use of auto-increment columns in DML operations with JSON duality views, allowing for more flexible and efficient data management. (WL #17213) Audit Log now supports automatic recovery from invalid filter ... Note ...
https://dev.mysql.com/doc/connectors/en/connector-odbc-configuration-connection-parameters.html
Note The SSL configuration parameters can also be automatically loaded from a my.ini or my.cnf file. Do not use this option with transactions, since an auto-reconnection during a incomplete transaction may cause corruption. An auto-reconnected ...On ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-configuration-connection-parameters.html
Note The SSL configuration parameters can also be automatically loaded from a my.ini or my.cnf file. Do not use this option with transactions, since an auto-reconnection during a incomplete transaction may cause corruption. An auto-reconnected ...On ...
https://dev.mysql.com/doc/internals/en/transactions-historical-note.html
First, observe that in BerkeleyDB the "auto-commit" mode causes automatic commit of operations that are atomic from the storage engine's perspective, such as a write of a record, but are too fine-grained to be atomic from the application's (MySQL's) ... "Statement transaction" is a non-standard term that comes from the days when MySQL supported the BerkeleyDB storage ...
https://dev.mysql.com/doc/ndbapi/en/ndb-tablespace.html
Tablespace Class Overview Tablespace Constructor Tablespace::getAutoGrowSpecification() Tablespace::getDefaultLogfileGroup() Tablespace::getDefaultLogfileGroupId() Tablespace::getExtentSize() Tablespace::getObjectId() Tablespace::getName() ...For an ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-advisor.html
The MySQL HeatWave Autopilot improves MySQL database performance without manual tuning. It uses machine learning to study how the database is used and automatically recommends or applies optimizations such as indexing and data compression. This ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-query-runtimes.html
This topic describes how you can view MySQL HeatWave query runtimes and runtime estimates using the MySQL HeatWave Autopilot Advisor Auto Query Time Estimation feature, or by querying the performance_schema.rpd_query_stats table. Runtime data is ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-workload-optimization-olap.html
Apply these optimizations manually, or use MySQL HeatWave Autopilot Advisor, which includes the following: Auto Encoding recommends string column encodings that minimize the required cluster size and improve query performance. Auto Data Placement ...
https://dev.mysql.com/doc/relnotes/heatwave/en/news-8-4-0.html
Auto Parallel Load now has a validation mode to validate files before loading them. (WL #16098) MySQL HeatWave Auto Parallel Load and Auto Unload now support a table inclusion list, as well as a table exclusion list. MySQL HeatWave Lakehouse ...