# Using Compressed row\_format in Percona xtradb cluster

**URL:** https://forums.percona.com/t/using-compressed-row-format-in-percona-xtradb-cluster/34283
**Category:** Percona XtraDB Cluster 5.x
**Tags:** percona
**Created:** [October 10, 2024, 6:46am UTC](https://forums.percona.com/t/using-compressed-row-format-in-percona-xtradb-cluster/34283 "2024-10-10T06:46:31Z")
**Posts on this page:** 5
**Page:** 1

<div class="post-metadata">

### Author: ![anjaneyarajus](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/anjaneyarajus/32/15125_2.png) [@anjaneyarajus](https://forums.percona.com/u/anjaneyarajus)
#### Post date: [October 10, 2024, 6:46am UTC](https://forums.percona.com/t/using-compressed-row-format-in-percona-xtradb-cluster/34283/1 "2024-10-10T06:46:31Z")

</div>

Hi  
Because the tables are relatively large, we intend to convert existing tables to use compressed row\_fromat in PXC.  
This will reduce the amount of disk space used.

Please let us know if there are any known issues that need to be addressed when converting the row\_format.

---

<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: [October 10, 2024, 1:25pm UTC](https://forums.percona.com/t/using-compressed-row-format-in-percona-xtradb-cluster/34283/2 "2024-10-10T13:25:02Z")

</div>

Hello @anjaneyarajus,  
Converting tables to compressed will require complete table rebuilds. If you do this in TOI mode, it will block everything on the cluster for the duration. If you use RSU, you must alter each table on every node individually. You can also try NBO, which is like TOI but won’t block other operations, however not all ALTER types are supported with NBO. Of course, you can use TOI + pt-online-schema-change for best results.

---

<div class="post-metadata">

### Author: ![anjaneyarajus](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/anjaneyarajus/32/15125_2.png) [@anjaneyarajus](https://forums.percona.com/u/anjaneyarajus)
#### Post date: [October 18, 2024, 8:30am UTC](https://forums.percona.com/t/using-compressed-row-format-in-percona-xtradb-cluster/34283/3 "2024-10-18T08:30:56Z")

</div>

HI Mathew,

are there any challenges in using compressed row\_format?

---

<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: [October 18, 2024, 12:08pm UTC](https://forums.percona.com/t/using-compressed-row-format-in-percona-xtradb-cluster/34283/4 "2024-10-18T12:08:15Z")

</div>

No challenges. Compression is transparent to the app and queries.

---

<div class="post-metadata">

### Author: ![anjaneyarajus](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/anjaneyarajus/32/15125_2.png) [@anjaneyarajus](https://forums.percona.com/u/anjaneyarajus)
#### Post date: [November 8, 2024, 5:42am UTC](https://forums.percona.com/t/using-compressed-row-format-in-percona-xtradb-cluster/34283/5 "2024-11-08T05:42:26Z")

</div>

Hi Mathew,

thank you for the response. we have observed the difference in disk space utilisation between a writer node and non-writer nodes.

the difference between writer node and non-writer is around 6%.  
data space utilisation is more on non-writer nodes when compared to writer node. the data was generated using sysbench and used customised lua from one of the services.
