# Another way to ALTER table on heavily loaded database

**URL:** <https://forums.percona.com/t/another-way-to-alter-table-on-heavily-loaded-database/4848>\
**Category:** Other MySQL® Questions\
**Created:** [April 20, 2016, 1:10am UTC](https://forums.percona.com/t/another-way-to-alter-table-on-heavily-loaded-database/4848 "2016-04-20T01:10:25Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![skeletor](https://avatars.discourse-cdn.com/v4/letter/s/ac91a4/32.png) [@skeletor](https://forums.percona.com/u/skeletor)\
**Post date:** [April 20, 2016, 1:10am UTC](https://forums.percona.com/t/another-way-to-alter-table-on-heavily-loaded-database/4848/1 "2016-04-20T01:10:25Z")

</div>

```auto

```

---

<div class="post-metadata">

**Author:** ![systems28347](https://avatars.discourse-cdn.com/v4/letter/s/cc9497/32.png) [@systems28347](https://forums.percona.com/u/systems28347)\
**Post date:** [April 28, 2016, 2:10am UTC](https://forums.percona.com/t/another-way-to-alter-table-on-heavily-loaded-database/4848/2 "2016-04-28T02:10:40Z")

</div>

The Percona Toolkit has a tool for changing tables without locking, based on triggers. It’s probably what you’re looking for.