Search Results
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/mysql-monitor/8.0/en/mem-event-handlers-creating.html
Auto-Close Events Defines whether the events are closed after the trigger status changes. The following values are possible: Yes: the default auto-close policy is honored and the events are closed when the conditions defined are no longer met. No: ... Event handlers enable you to create a condition which, when met, triggers notifications to concerned parties such as DBAs, System Administrators and so ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mysql-process-discovery-advisor-ref.html
If you choose to enable the Auto-Create Less Privileged Users option, this user is used to create those with the required privileges to monitor this instance. Auto-Create Less Privileged Users When monitoring an instance, multiple levels of user can ... The MySQL Process Discovery Advisor enables you to find and, optionally, establish a connection with unmonitored MySQL ...
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 ...