# Write lock on tables when executing backup

**URL:** https://forums.percona.com/t/write-lock-on-tables-when-executing-backup/3002
**Category:** Percona XtraBackup
**Created:** [October 11, 2013, 5:05am UTC](https://forums.percona.com/t/write-lock-on-tables-when-executing-backup/3002 "2013-10-11T05:05:58Z")
**Posts on this page:** 1
**Showing post:** 5

<div class="post-metadata">

### Author: ![nekoanz26](https://avatars.discourse-cdn.com/v4/letter/n/d9b06d/32.png) [@nekoanz26](https://forums.percona.com/u/nekoanz26)
#### Post date: [October 14, 2013, 9:06pm UTC](https://forums.percona.com/t/write-lock-on-tables-when-executing-backup/3002/5 "2013-10-14T21:06:35Z")

</div>

Hi,

But upon checking all my tables are InnoDB and no table is on MyISAM.

Is it possible that the entire database is on MyISAM?

We have tried using mysqldump with --single-transaction parameter it works well without locking any table and we can still execute writes to the tables. How can we achieve this in percona?

Thanks in advance.

---

_[View the full topic](https://forums.percona.com/t/write-lock-on-tables-when-executing-backup/3002)._