Search Results
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-1.html
It was removed due to a critical issue that could stop the server from restarting following the creation of a very large number of tables (8001 or more). (Bug #35205358) Data Dictionary Notes Attempting to upgrade a MyISAM table containing a mix of ...Now pruning continues in such cases, but with a warning printed in the error log stating that it was not possible to delete the missing audit log ...
https://dev.mysql.com/doc/refman/8.4/en/tracing-example.html
Next, for every table in the query, we estimate the cost of, and number of records returned by, a table scan or a range access. "resulting_clause_is_simple": true, "resulting_clause": "`test`.`alias1`.`col_int_key`" } /* clause_processing */ }, The ...Now we can examine the trace, whose first column (QUERY), containing the original statement to be traced, is shown here: SELECT * FROM INFORMATION_SCHEMA.OPTIMIZER_TRACE\G *************************** ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-5.html
If this happens in a table's constraints, default expressions, partitioning expressions, or virtual columns, the table could not be opened. This prevented both analyzing the problem (using, for example, SHOW CREATE TABLE) and addressing it (such as ...(Bug #37570206) Audit Log Notes <COMMAND_CLASS> was not populated for ...
https://dev.mysql.com/doc/refman/8.4/en/insert-on-duplicate.html
In general, you should try to avoid using an ON DUPLICATE KEY UPDATE clause on tables with multiple unique indexes. It is possible to use IGNORE with ON DUPLICATE KEY UPDATE in an INSERT statement, but this may not behave as you expect when ... If ...
https://dev.mysql.com/doc/ndbapi/en/ndb-examples-simple-dual.html
This example demonstrates synchronous transactions and connecting to multiple clusters in a single NDB API application. The source code for this program may be found in the NDB Cluster source tree, in the file ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-run-chat.html
As of MySQL 9.2.1, MySQL HeatWave Chat lets you use your own embedding tables for context retrieval. And, it uses only the name of the embedding model used to embed the input query to find relevant tables. In earlier versions of MySQL, MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-replication-issues.html
In the event of a node failure, errors in replication of NDB tables without primary keys can still occur, due to the possibility of duplicate rows being inserted in such cases. For this reason, it is highly recommended that all NDB tables being ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-genai-run-chat.html
GenAI Chat also lets you use your own embedding tables for context retrieval. And, it uses only the name of the embedding model used to embed the input query to find relevant tables. If you do not have a vector store or an embedding table set up, ...
https://dev.mysql.com/doc/refman/8.4/en/handler.html
] HANDLER tbl_name CLOSE The HANDLER statement provides direct access to table storage engine interfaces. OPEN statement opens a table, making it accessible using subsequent HANDLER ... This table object is not shared by other sessions and is not ...
https://dev.mysql.com/doc/refman/8.4/en/create-trigger.html
A trigger is a named database object that is associated with a table, and that activates when a particular event occurs for the table. The trigger becomes associated with the table named tbl_name, which must refer to a permanent table. You cannot ...