> For the complete documentation index, see [llms.txt](https://mariadb.com/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://mariadb.com/docs/server/server-usage/storage-engines/myrocks/myrocks-and-start-transaction-with-consistent-snapshot.md).

# MyRocks START TRANSACTION WITH CONSISTENT SNAPSHOT

FB/MySQL has added new syntax:

```sql
START TRANSACTION WITH CONSISTENT ROCKSDB|INNODB SNAPSHOT;
```

The statement returns the binlog coordinates pointing at the snapshot.

MariaDB (and Percona Server) support extension to the regular

```sql
START TRANSACTION WITH CONSISTENT SNAPSHOT;
```

syntax as documented in [Enhancements for START TRANSACTION WITH CONSISTENT SNAPSHOT](/docs/server/ha-and-performance/standard-replication/enhancements-for-start-transaction-with-consistent-snapshot.md).

After issuing the statement, one can examine the [binlog\_snapshot\_file](/docs/server/ha-and-performance/standard-replication/replication-and-binary-log-status-variables.md#binlog_snapshot_file) and [binlog\_snapshot\_position](/docs/server/ha-and-performance/standard-replication/replication-and-binary-log-status-variables.md#binlog_snapshot_position) status variables to see the binlog position that corresponds to the snapshot.

## See Also

* [START TRANSACTION](/docs/server/reference/sql-statements/transactions/start-transaction.md)
* [Enhancements for START TRANSACTION WITH CONSISTENT SNAPSHOT](/docs/server/ha-and-performance/standard-replication/enhancements-for-start-transaction-with-consistent-snapshot.md)

<sub>*This page is licensed: CC BY-SA / Gnu FDL*</sub>

{% @marketo/form formId="4316" %}