# Commit latency for rows containing longblob columns..

**URL:** <https://forums.percona.com/t/commit-latency-for-rows-containing-longblob-columns/82>\
**Category:** Other MySQL® Questions\
**Created:** [September 14, 2006, 9:59pm UTC](https://forums.percona.com/t/commit-latency-for-rows-containing-longblob-columns/82 "2006-09-14T21:59:23Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![rame](https://avatars.discourse-cdn.com/v4/letter/r/74df32/32.png) [@rame](https://forums.percona.com/u/rame)\
**Post date:** [September 14, 2006, 9:59pm UTC](https://forums.percona.com/t/commit-latency-for-rows-containing-longblob-columns/82/1 "2006-09-14T21:59:23Z")

</div>

Hi,

I have two longblob columns in my table that might run into 4MB each at its peak. I see some latency while updating and committing these rows.

What I did is:

a) try committing these rows in one transaction  
b) Once the transaction commit is returned back to the application, do a query using mysql client. (I use Java 1.5-\>Hibernate2.0-\>Mysql 5.1)  
c) Though, I see the rows being populated - I don’t see the longblob columns populated until sometime.

Is there any missing configuration that I need to set?

Any help is appreciated.

Thanks,  
Ramesh.

---

<div class="post-metadata">

**Author:** ![Peter](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/peter/32/2_2.png) [@Peter](https://forums.percona.com/u/Peter)\
**Post date:** [October 3, 2006, 4:21pm UTC](https://forums.percona.com/t/commit-latency-for-rows-containing-longblob-columns/82/2 "2006-10-03T16:21:09Z")

</div>

Are you saying you have called commit from certain transaction and after commit has succeed you do not see values for longblob columns ?

This would be the bug. I would however try to create it using some simple script rather than Hybernate (Java test case is fine)