Search Results
https://dev.mysql.com/doc/relnotes/heatwave/en/news-8-0-30.html
Advisor MySQL HeatWave AutoML Functionality Added or Changed Advisor MySQL HeatWave Advisor Auto Encoding, which recommends string column encodings, now provides encoding recommendations that optimize query performance. Previously, string column ...
https://dev.mysql.com/doc/refman/8.4/en/analyze-table.html
You can make the statistics collected by ANALYZE TABLE more precise and more stable by enabling innodb_stats_persistent, as explained in Section 17.8.10.1, “Configuring Persistent Optimizer Statistics Parameters”. For more information about key ...ANALYZE [NO_WRITE_TO_BINLOG | LOCAL] TABLE tbl_name UPDATE HISTOGRAM ON col_name [, col_name] ...
https://dev.mysql.com/doc/refman/8.4/en/column-indexes.html
Optimizations are applied to certain kinds of FULLTEXT queries against single InnoDB tables. For this optimization to apply, there must be no WHERE clauses and only a single ORDER BY clause in descending order. For queries that contain full-text ...
https://dev.mysql.com/doc/refman/8.4/en/delete.html
The speed of delete operations may also be affected by factors discussed in Section 10.2.5.3, “Optimizing DELETE Statements”. To reclaim unused space and reduce file sizes, use the OPTIMIZE TABLE statement or the myisamchk utility to reorganize ... DELETE is a DML statement that removes rows from a ...
https://dev.mysql.com/doc/refman/8.4/en/general-thread-states.html
Removing duplicates The query was using SELECT DISTINCT in such a way that MySQL could not optimize away the distinct operation at an early stage. Sorting index The thread is sorting index pages for more efficient access during a MyISAM table ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-online-ddl-operations.html
mysql> SELECT NAME, TOTAL_ROW_VERSIONS FROM INFORMATION_SCHEMA.INNODB_TABLES WHERE NAME LIKE 'test/t1'; +---------+--------------------+ | NAME | TOTAL_ROW_VERSIONS | +---------+--------------------+ | test/t1 | 0 | +---------+--------------------+ ... Online support details, syntax examples, and usage notes for DDL operations are provided under the following topics in this ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-maintenance.html
Table maintenance of partitioned tables can be accomplished using the statements CHECK TABLE, OPTIMIZE TABLE, ANALYZE TABLE, and REPAIR TABLE, which are supported for partitioned tables. OPTIMIZE PARTITION to reclaim any unused space and to ... A ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/admin-api-routing-guidelines-examples.html
This example shows how to create a Routing Guideline from a predefined JSON file, ensuring traffic is directed based on server regions and compliance tags for regulatory adherence and optimal latency. Load Balancing and Resource Management Load ...
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-mysqlai-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 ...
https://dev.mysql.com/doc/internals/en/implementing-info-method.html
Prior to commencing a table scan, the [custom-engine.html#custom-engine-api-reference-info info()] method is called to provide extra table information to the optimizer. The information required by the optimizer is not given through return values ...