Search Results
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/working-with-locking.html
X DevAPI supports MySQL locking through the lockShared() and lockExclusive() methods for the Collection.find() and Table.select() methods. This enables you to control row locking to ensure safe, transactional document updates on collections and to ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/working-with-sql-result-sets.html
When you execute an SQL operation on a Session using the sql() method, an SqlResult is returned. Iterating over an SqlResult is identical to working with results from CRUD operations. res = mySession.sql('SELECT name, age FROM users').execute() row ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-advisor-syntax.html
query_insights: Provides runtime information for successfully executed queries and runtime estimates for EXPLAIN queries, queries cancelled using Ctrl+C, and queries that fail due to an out-of-memory error. Produces summarized output and sends it to ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-async-add-task-log.html
The add_task_log routine add a log entry for the task with the specified ID. You can use this routine with an application-level task as well and it does not require an application-managed user ID. Syntax mysql> CALL mysql_tasks.add_task_log( IN ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-async-exec.html
Note Tasks that are completed, canceled, or encountered an error are automatically removed after six days. As of MySQL 9.3.1, you can run SQL statements as asynchronous tasks that run in the background. This lets your current session to continue ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-auto-unload-syntax.html
This adds an include list to exactly specify the tables to unload, which eliminates the need to include a database and exclude unnecessary tables. mysql> CALL sys.HEATWAVE_UNLOAD_all ([options]); options: { JSON_OBJECT("key","value"[,"key","value"] ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-change-propagation.html
Tables that have become stale due to change propagation failures resulting from out-of-code errors are automatically reloaded. After tables are loaded into MySQL HeatWave, data changes are automatically propagated from DB System tables to their ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-summarize-docs.html
The document concludes by inviting readers to try MySQL HeatWave on AWS for free.", "error": null} *************************** 2. As of MySQL 9.4.1, MySQL HeatWave GenAI lets you generate text summaries for unstructured files available in Object ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-troubleshoot.html
This section describes some commonly encountered issues and errors for MySQL HeatWave GenAI and their workarounds. The folder you are trying to load might contain unsupported format files or the file that you are trying to load might be of an ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-vector-store-overview.html
However, if there are minor character recognition errors, the overall meaning of the text is still preserved. This section describes the Vector Store functionality available in MySQL HeatWave. About Vector Store MySQL HeatWave vector store is a ...