Search Results
https://dev.mysql.com/doc/relnotes/mysql/9.7/en/news-9-2-0.html
(WL #16529) Optimizer Notes JSON: Added lookup references to iterator-based EXPLAIN FORMAT=JSON for index lookups. (Bug #110706, Bug #113812, Bug #115608, Bug #116764, Bug #35303494, Bug #36261480, Bug #36846567, Bug #37318367) InnoDB: Queries with ...(Bug #37132323) This release adds the CREATE_SPATIAL_REFERENCE_SYSTEM privilege, which allows the user to execute any of the statements CREATE SPATIAL REFERENCE SYSTEM, CREATE OR REPLACE SPATIAL REFERENCE SYSTEM, and DROP SPATIAL REFERENCE ...
https://dev.mysql.com/doc/relnotes/mysql/9.7/en/news-9-5-0.html
For further information, see the description of innodb_log_writer_threads in the MySQL documentation; see also Optimizing InnoDB Redo Logging. (WL #16999) InnoDB: The dict_stats_analyze_index() function could discard optimal index-based access ...
https://dev.mysql.com/doc/relnotes/mysql/9.7/en/news-9-7-0.html
(WL #17202) InnoDB Notes Memory usage during FTS index construction for large tables has been optimized. (WL #17056) Optimizer Notes Fixed an issue relating to optimized prepared DELETE and UPDATE statements. (Bug #38043311) Fixed an issue relating ... Note These release notes were created with the assistance of MySQL HeatWave ...
https://dev.mysql.com/doc/refman/9.7/en/descending-indexes.html
Descending indexes also make it possible for the optimizer to use multiple-column indexes when the most efficient scan order mixes ascending order for some columns and descending order for others. Indexes that have descending key parts are not used ... MySQL supports descending indexes: DESC in an index definition is no longer ignored but causes storage of key values in descending ...
https://dev.mysql.com/doc/refman/9.7/en/index-statistics.html
Storage engines collect statistics about tables for use by the optimizer. For optimizer purposes, an important statistic is the average value group size. For optimization purposes, the relevant value is the average size of the non-NULL value groups. This makes index appear to the optimizer to be less useful than it really is for joins that look for non-NULL ...
https://dev.mysql.com/doc/refman/9.7/en/json.html
The MySQL optimizer also looks for compatible indexes on virtual columns that match JSON expressions. Partial Updates of JSON Values In MySQL 9.7, the optimizer can perform a partial, in-place update of a JSON column instead of removing the old ...
https://dev.mysql.com/doc/refman/9.7/en/select.html
tbl_name [[AS] alias] [index_hint] The use of index hints provides the optimizer with information about how to choose indexes during query processing. (If no GROUP BY is present, all rows implicitly form a single aggregate group.) The HAVING clause ... SELECT [ALL | DISTINCT | DISTINCTROW ] [HIGH_PRIORITY] [STRAIGHT_JOIN] [SQL_SMALL_RESULT] [SQL_BIG_RESULT] [SQL_BUFFER_RESULT] [SQL_NO_CACHE] [SQL_CALC_FOUND_ROWS] select_expr [, select_expr] ...
https://dev.mysql.com/doc/mysql-enterprise-backup/9.7/en/backup-capacity-options.html
See Section 13.1, “Optimizing Backup Performance” and Section 13.2, “Optimizing Restore Performance” for additional advice about recommended combinations of values for this and other performance-related options for various hardware ... These ...
https://dev.mysql.com/doc/relnotes/mysql/9.7/en/news-9-1-0.html
(Bug #36723117) InnoDB: FTS index optimization would sometimes not function correctly with tokens equal in collation order but different in terms of bytes. InnoDB: Replaced std::this_thread::sleep_for(std::chrono::seconds(0)) usage with ...This ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-ml-train.html
optimization_metric: The scoring metric to optimize for when training a machine learning model. It identifies the optimal weight between the two components based on the metric. Anomaly detection models don't support the following options during ...