START TRANSACTION READ ONLY
or BEGIN READ ONLY
command. Subsequently, you can execute queries to read data from the consistent snapshot. To finalize the transaction and submit the queries as a single unit, use the COMMIT
command.
Please note that data modifications are not allowed while a transaction is initiated but not yet committed. The statements listed below are not allowed within a transaction:
CREATE
, ALTER
, and DROP
)INSERT
, UPDATE
, and DELETE
)USER
. This category may overlap with DDL statements.GRANT
and REVOKE
.WITH
clause of the CREATE TABLE
statement. Note that this feature is only available if you are using the native MySQL CDC or PostgreSQL CDC connectors.
For performance considerations, transactions involving changes to more than 4096 rows cannot be guaranteed.