Search Results
https://dev.mysql.com/doc/refman/9.7/en/myisamchk-table-info.html
Possible values are crashed, open, changed, analyzed, optimized keys, and sorted index pages. For an optimized table without fragmented rows, this is the same as Data records. To obtain a description of a MyISAM table or statistics about it, use ...
https://dev.mysql.com/doc/relnotes/mysql/9.7/en/news-9-7-0.html
(Bug #38169053) 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 #38573278) A query using ... Note These ...
https://dev.mysql.com/doc/mysql-ai/26.7/en/mys-ai-genai-byo-embedding-tables.html
It involves using algorithms and techniques to automatically identify the best model for a given dataset and optimize its hyperparameters without requiring manual intervention from data analysts or ML practitioners. The source data is read from ...
https://dev.mysql.com/doc/mysql-ai/26.7/en/mys-ai-genai-rag.html
It involves using algorithms and techniques to automatically identify the best model for a given dataset and optimize its hyperparameters without requiring manual intervention from data analysts or ML practitioners. It involves using algorithms and ... The ML_RAG routine runs retrieval-augmented generation which aims to generate more accurate responses for your ...
https://dev.mysql.com/doc/refman/9.7/en/explain.html
When EXPLAIN is used with an explainable statement, MySQL displays information from the optimizer about the statement execution plan. TREE provides tree-like output with more precise descriptions of query handling than the TRADITIONAL format; it is ...In practice, the DESCRIBE keyword is more often used to obtain information about table structure, whereas EXPLAIN is used to obtain a query execution plan (that is, an explanation of how MySQL would execute a ...
https://dev.mysql.com/doc/refman/9.7/en/index-hints.html
Index hints give the optimizer information about how to choose indexes during query processing. Index hints, described here, differ from optimizer hints, described in Section 10.9.3, “Optimizer Hints”. Note MySQL 9.7 supports the index-level ...
https://dev.mysql.com/doc/refman/9.7/en/mysqlcheck.html
The mysqlcheck client performs table maintenance: It checks, repairs, optimizes, or analyzes tables. mysqlcheck uses the SQL statements CHECK TABLE, REPAIR TABLE, ANALYZE TABLE, and OPTIMIZE TABLE in a convenient way for the user. Command Meaning ...Each table is locked and therefore unavailable to other sessions while it is being processed, although for check operations, the table is locked with a READ lock only (see Section 15.3.6, “LOCK TABLES and UNLOCK TABLES Statements”, for more information about READ and WRITE ...
https://dev.mysql.com/doc/relnotes/mysql/9.7/en/news-9-3-0.html
(Bug #114897, Bug #3666073) MySQL Enterprise Notes The Option Tracker component has added support for two MySQL features—the traditional MySQL Optimizer, and the MySQL Hypergraph Optimizer (available in MySQL HeatWave only). This release extends ...(Bug #37570206) Audit Log Notes <COMMAND_CLASS> was not populated for ...
https://dev.mysql.com/doc/heatwave/en/heatwave-errors.html
Error number: 1004; Symbol: HW_ER_QUERY_CANCELLED Message: Query was canceled during HeatWave query optimization. Error number: 1005; Symbol: HW_ER_UNSUPPORTED_QUERY_OPT Message: Currently unsupported HeatWave query optimization scenario. Error ...
https://dev.mysql.com/doc/refman/9.7/en/explain-extended.html
The Message value in SHOW WARNINGS output displays how the optimizer qualifies table and column names in the SELECT statement, what the SELECT looks like after the application of rewriting and optimization rules, and possibly other notes about the ... The EXPLAIN statement produces extra (“extended”) information that is not part of EXPLAIN output but can be viewed by issuing a SHOW WARNINGS statement following ...