Search Results
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/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 ...
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/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.4/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/insert.html
| TABLE table_name | VALUES row_constructor_list } [ON DUPLICATE KEY UPDATE assignment_list] value: {expr | DEFAULT} value_list: value [, value] ... For the reasons for this, see Section 15.2.7.3, “INSERT DELAYED Statement”, Inserting into a ...
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-ai-genai-rag.html
For context retrieval, the ML_RAG routine uses the name of the embedding model used to embed the input query to find relevant vector store tables that contain vector embeddings from the same embedding model. The examples in this topic use the vector ... The ML_RAG routine runs retrieval-augmented generation which aims to generate more accurate responses for your ...
https://dev.mysql.com/doc/connectors/en/connector-python-asyncio.html
References: [asyncio.gather]: https://docs.python.org/3/library/asyncio-task.html#asyncio.gather """ print("-------------------- ASYNCHRONOUS --------------------") # reset indent global indent indent = 0 clock = time.time() # `asyncio.gather()` ...