Search Results
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-4.html
(Bug #110706, Bug #113812, Bug #115608, Bug #116764, Bug #35303494, Bug #36261480, Bug #36846567, Bug #37318367) InnoDB: Queries with a descending primary key and the index_merge optimization sometimes yielded incorrect results such as missing rows.
https://dev.mysql.com/doc/connectors/en/connector-python-opentelemetry.html
MySQL Server added OpenTelemetry support in MySQL Enterprise Edition version 8.1.0, which is a commercial product. Introduction to OpenTelemetry OpenTelemetry is an observability framework and toolkit designed to create and manage telemetry data ...
https://dev.mysql.com/doc/connector-python/en/connector-python-opentelemetry.html
MySQL Server added OpenTelemetry support in MySQL Enterprise Edition version 8.1.0, which is a commercial product. Introduction to OpenTelemetry OpenTelemetry is an observability framework and toolkit designed to create and manage telemetry data ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/memory-usage-advisors-ref.html
When enabled, the query cache should experience a high degree of hits, meaning that queries in the cache are being reused by other user connections. A low hit rate may indicate not enough memory is allocated to the cache, identical queries are not ...It is true that logical I/O is not free, and that the DBA should work to keep all I/O to a minimum, but it is best if most data access is performed in ...
https://dev.mysql.com/doc/refman/8.4/en/fulltext-search.html
Some examples of such queries are shown here: # MATCH() in SELECT list... MATCH (col1,col2,...) AGAINST (expr [search_modifier]) search_modifier: { IN NATURAL LANGUAGE MODE | IN NATURAL LANGUAGE MODE WITH QUERY EXPANSION | IN BOOLEAN MODE | WITH ...
https://dev.mysql.com/doc/refman/8.4/en/json-search-functions.html
Queries using JSON_CONTAINS() on InnoDB tables can be optimized using multi-valued indexes; see Multi-Valued Indexes, for more information. Queries on JSON columns of InnoDB tables using JSON_OVERLAPS() in the WHERE clause can be optimized using ...
https://dev.mysql.com/doc/refman/8.4/en/semijoins-antijoins.html
The following subqueries are transformed into antijoins: NOT IN (SELECT ... For more information about materialization, see Section 10.2.2.2, “Optimizing Subqueries with Materialization”. This affects queries that use the STRAIGHT_JOIN modifier ... A semijoin is a preparation-time transformation that enables multiple execution strategies such as table pullout, duplicate weedout, first match, loose scan, and ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-3.html
This had an adverse effect on queries using joins on InnoDB tables. This also improves the iteration logic complexity in terms of speed and memory to decrease the impact of these queries on the rest of the system. C API Notes Compilation Notes ...
MySQL Enterprise Monitor 8.0 Release Notes :: Changes in MySQL Enterprise Monitor 8.0.1 (2018-07-24)
https://dev.mysql.com/doc/relnotes/mysql-monitor/8.0/en/news-8-0-1.html
This resulted in an error and no new queries were displayed on the Query Analyzer. Functionality Added or Changed Bugs Fixed Functionality Added or Changed The usability of the Context and Target selection fields has been improved. As of this ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-ml-train.html
Syntax Examples for Recommendation Training The following example defines a model handle, trains a recommendation model with no specified model type, and then queries the automatically selected model_type for the trained model from the model catalog. Run the ML_TRAIN routine on a training dataset to produce a trained machine learning ...