# Does mysqldump --single-transaction work normally for the latest version of the tokudb engine?

**URL:** https://forums.percona.com/t/does-mysqldump-single-transaction-work-normally-for-the-latest-version-of-the-tokudb-engine/14237
**Category:** MySQL & MariaDB
**Created:** [February 4, 2022, 7:52am UTC](https://forums.percona.com/t/does-mysqldump-single-transaction-work-normally-for-the-latest-version-of-the-tokudb-engine/14237 "2022-02-04T07:52:26Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![shinyu\_kim](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/shinyu_kim/32/5771_2.png) [@shinyu\_kim](https://forums.percona.com/u/shinyu_kim)
#### Post date: [February 4, 2022, 7:52am UTC](https://forums.percona.com/t/does-mysqldump-single-transaction-work-normally-for-the-latest-version-of-the-tokudb-engine/14237/1 "2022-02-04T07:52:26Z")

</div>

I have an additional question.  
Currently, mariadb 10.1.48 is being used, and engine is using tokuDB 5.6.49-89.0.  
Do you know if the mysqldump --single-transaction applies normally to the engine I’m using? As far as I know, there was a bug that didn’t apply in the past, but I wonder if it’s solved.  
I hope there will be no database lock during the service.

---

<div class="post-metadata">

### Author: ![matthewb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/matthewb/32/34_2.png) [@matthewb](https://forums.percona.com/u/matthewb)
#### Post date: [February 5, 2022, 7:01pm UTC](https://forums.percona.com/t/does-mysqldump-single-transaction-work-normally-for-the-latest-version-of-the-tokudb-engine/14237/2 "2022-02-05T19:01:03Z")

</div>

TokuDB supports transactions so it should work. To ensure, just add the flag —lock-mode=none (IIRC)