Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hwgenai-nl-sql.html
The routine also runs the generated SQL statement and displays the result set. You can use this routine for generating and running SQL queries only for databases and tables that you have access to. The routine automatically detects these errors, and ...By default, databases that the routine finds most relevant to the entered natural-language statement are ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-lakehouse.html
If you have external data that you want to use with MySQL HeatWave AutoML, you can load it directly from Object Storage with Lakehouse. MySQL HeatWave AutoML and Lakehouse Overview For MySQL HeatWave on OCI, you have three options to access ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-information-schema-transactions.html
Each transaction in InnoDB that is waiting for another transaction to release a lock (INNODB_TRX.TRX_STATE is LOCK WAIT) is blocked by exactly one blocking lock request. That blocking lock request is for a row or table lock held by another ...
https://dev.mysql.com/doc/refman/8.4/en/sql-prepared-statements.html
The parameter values can contain unescaped SQL quote and delimiter characters. Other language interfaces can provide support for prepared statements that use the binary protocol by linking in the C client library, one example being the mysqli ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-performance-multiple_io_threads.html
You can set values for these parameters in the MySQL option file (my.cnf or my.ini); you cannot change values dynamically. InnoDB uses background threads to service various types of I/O requests. You can configure the number of background threads ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-standard-monitor.html
Example Standard Monitor output: mysql> SHOW ENGINE INNODB STATUS\G *************************** 1. The Lock Monitor is the same as the Standard Monitor except that it includes additional lock information. Enabling either monitor for periodic output ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/mysql-shell-extension-sqlhandler-registration.html
description: a brief description of the SQL extensions provided by the handler. prefixes: a list of prefixes (string) identifying the SQL statements processed by this handler. The function must have the following signature: function(session, sql): ...callback: name of the function to execute when a statement matching the prefix is ...
https://dev.mysql.com/doc/refman/8.4/en/xa-statements.html
To perform XA transactions in MySQL, use the following statements: XA {START|BEGIN} xid [JOIN|RESUME] XA END xid [SUSPEND [FOR MIGRATE]] XA PREPARE xid XA COMMIT xid [ONE PHASE] XA ROLLBACK xid XA RECOVER [CONVERT XID] For XA START, the JOIN and ...
https://dev.mysql.com/doc/internals/en/transactions-roles-responsibilities.html
The server has only one way to know that an engine participates in the statement and a transaction has been started in an engine: the engine says so. So, in order to be a part of a transaction, an engine must "register" itself. Although ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-iris-quickstart.html
This quickstart illustrates an end-to-end example of creating and using a predictive machine learning model using MySQL HeatWave AutoML. For an online workshop based on this tutorial, see Get started with MySQL MySQL HeatWave AutoML. Possible ...It ...