# Order of the tables - suggestion for performance improvement

**URL:** https://forums.percona.com/t/order-of-the-tables-suggestion-for-performance-improvement/39487
**Category:** Percona XtraBackup
**Created:** [October 2, 2025, 1:29pm UTC](https://forums.percona.com/t/order-of-the-tables-suggestion-for-performance-improvement/39487 "2025-10-02T13:29:14Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![edhunter](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/edhunter/32/18922_2.png) [@edhunter](https://forums.percona.com/u/edhunter)
#### Post date: [October 2, 2025, 1:29pm UTC](https://forums.percona.com/t/order-of-the-tables-suggestion-for-performance-improvement/39487/1 "2025-10-02T13:29:14Z")

</div>

My specific scenario is: 20TB mysql instance with about 400 innodb tables. From that many tables there are only a few very large (\>2TB). The tables sizes are varaying 1-100G.  
The time it takes to do full xtrabackup is scaling by using the parallel parameter up to 10-12. But at the last 1-2 hours of the backup there is only one table left running and the speed is low. Practically its single threaded.  
Currently I dont see any logic of how the tables are ordered.  
So my suggestion here would be that if the **tables are ordered from largest to smallest** than the whole time needed to complete will be much lower because most of the time the xtrabackup will run multithreaded.

---

<div class="post-metadata">

### Author: ![satya.bodapati](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/satya.bodapati/32/1322_2.png) [@satya.bodapati](https://forums.percona.com/u/satya.bodapati)
#### Post date: [October 2, 2025, 1:43pm UTC](https://forums.percona.com/t/order-of-the-tables-suggestion-for-performance-improvement/39487/2 "2025-10-02T13:43:07Z")

</div>

Hello, we are aware of the issue and the JIRA: PXB-3502 [Jira](https://perconadev.atlassian.net/browse/PXB-3502) . I hope it will be fixed in future releases, but I cannot promise an exact date.

---

<div class="post-metadata">

### Author: ![edhunter](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/edhunter/32/18922_2.png) [@edhunter](https://forums.percona.com/u/edhunter)
#### Post date: [October 2, 2025, 8:25pm UTC](https://forums.percona.com/t/order-of-the-tables-suggestion-for-performance-improvement/39487/3 "2025-10-02T20:25:12Z")

</div>

Thank you for your quick reply. Fingers crossed it will be completed 🙂