Search Results
https://dev.mysql.com/doc/relnotes/heatwave/en/news-8-0-26.html
The MySQL HeatWave Advisor also provides a Query Insights feature, which provides runtimes for successfully executed queries, and runtime estimates for EXPLAIN queries, queries canceled using Ctrl+C, and queries that fail due to out of memory errors. This enhancement reduces memory allocation and deallocation operations, memory usage, and execution time for affected ...Runtime ... Advisor Auto Parallel Load Auto Scheduling Functionality Added or Changed Advisor The new MySQL HeatWave Advisor provides string ...
https://dev.mysql.com/doc/relnotes/mysql-monitor/8.0/en/news-8-0-24.html
Bugs Fixed The MySQL Enterprise Monitor console did not take the time zone into account and displayed an incorrect time. Functionality Added or Changed Bugs Fixed Functionality Added or Changed The MySQL server, bundled with MySQL Enterprise ...
https://dev.mysql.com/doc/refman/8.4/en/create-table-check-constraints.html
The effect of a violation depends on the statement being executed, as described later in this section. CHECK constraints are evaluated for INSERT, UPDATE, REPLACE, LOAD DATA, and LOAD XML statements and an error occurs if a constraint evaluates to ... CREATE TABLE permits the core features of table and column CHECK constraints, for all storage ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-data-drift-detection.html
Over time, the similarity between the training data and the test data can decrease. The second JSON_OBJECT includes the additional_details option set to true, so ml_results includes values for metric and attribution_percent. The LIMIT of 3 means ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-performance-compression-oltp.html
The rise of SSD storage devices, which are fast but relatively small and expensive, makes compression attractive also for OLTP workloads: high-traffic, interactive websites can reduce their storage requirements and their I/O operations per second ...
https://dev.mysql.com/doc/mysql-router/9.4/en/router-read-write-splitting-configuration.html
wait_for_my_writes_timeout [ 0 | 4294967295 ]: Maximum time in seconds to wait for a read_only destination to apply the written transaction, before falling back to a read_write destination. destinations: must be set to a metadata-cache URL with the ... To enable read-write splitting, the following router options must be enabled: access_mode: must be set to ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-data-drift-detection.html
Over time, the similarity between the training data and the test data can decrease. The second JSON_OBJECT includes the additional_details option set to true, so ml_results includes values for metric and attribution_percent. The LIMIT of 3 means ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-information-schema-examples.html
Identifying Blocking Transactions It is sometimes helpful to identify which transaction blocks another. Each session corresponds to a MySQL thread, and executes one transaction after another. For example, if the blocking_pid is 6, issue this query: ... This section describes the use of locking information as exposed by the Performance Schema data_locks and data_lock_waits ...
https://dev.mysql.com/doc/refman/8.4/en/command-line-options.html
For example, the following command tells mysqladmin to ping the server 1024 times, sleeping 10 seconds between each ping: mysqladmin --count=1K --sleep=10 ping When specifying file names as option values, avoid the use of the ~ shell metacharacter.
https://dev.mysql.com/doc/refman/8.4/en/using-spatial-indexes.html
| +-----+---------------------------------------------------------------+ 20 rows in set (0.00 sec) Use EXPLAIN to check the way this query is executed: mysql> SET @poly = -> 'Polygon((30000 15000, 31000 15000, 31000 16000, 30000 16000, 30000 ...The ... The optimizer investigates whether available spatial indexes can be involved in the search for queries that use a function such as MBRContains() or MBRWithin() in the WHERE ...