# Transaction size exceed set threshold

**URL:** <https://forums.percona.com/t/transaction-size-exceed-set-threshold/15810>\
**Category:** Percona XtraDB Cluster 8.x\
**Created:** [May 25, 2022, 2:24am UTC](https://forums.percona.com/t/transaction-size-exceed-set-threshold/15810 "2022-05-25T02:24:24Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![liking](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/liking/32/5574_2.png) [@liking](https://forums.percona.com/u/liking)\
**Post date:** [May 25, 2022, 2:24am UTC](https://forums.percona.com/t/transaction-size-exceed-set-threshold/15810/1 "2022-05-25T02:24:24Z")

</div>

When I execute my proceduer, 1200 seconds later, I got an error like this:  
Got error 5 - ‘Transaction size exceed set threshold’ during COMMIT  
wsrep\_max\_ws\_size

```auto
mysql> select @@wsrep_max_ws_size;
+---------------------+
| @@wsrep_max_ws_size |
+---------------------+
| 2147483647 |
+---------------------+

```

But my trx size is small, less than 2G.  
Is there some other limits about the “Transaction size” in PXC 8.0 ?  
Where can I set the timeout more than 1200 seconds?  
Thanks a lot.

---

<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:** [May 25, 2022, 3:35am UTC](https://forums.percona.com/t/transaction-size-exceed-set-threshold/15810/2 "2022-05-25T03:35:21Z")

</div>

Is your transaction less than 2GB but larger than 1GB? If so, you might be hitting some internal C function limitations that can’t handle data objects larger than 1GB.

Since you are using PXC 8, you should take a look at the new streaming transaction option available.

> **[Galera 4 Streaming Replication in Percona XtraDB Cluster 8.0 - Percona...](https://www.percona.com/blog/2020/05/13/galera-4-streaming-replication-in-percona-xtradb-cluster-8-0/)**
>
> Testing Percona XtraDB Cluster 8.0 with the Galera 4 plugin, and sharing thoughts on the Streaming Replication feature.

---

<div class="post-metadata">

**Author:** ![liking](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/liking/32/5574_2.png) [@liking](https://forums.percona.com/u/liking)\
**Post date:** [June 1, 2022, 9:40am UTC](https://forums.percona.com/t/transaction-size-exceed-set-threshold/15810/3 "2022-06-01T09:40:22Z")

</div>

Thank you so much.  
According to you advice, we have changed our commit method.  
I will take a look at the new streaming transaction option in PXC 8.