# Single row query output taking a long time .

**URL:** <https://forums.percona.com/t/single-row-query-output-taking-a-long-time/4391>\
**Category:** Other MySQL® Questions\
**Created:** [September 9, 2015, 11:37pm UTC](https://forums.percona.com/t/single-row-query-output-taking-a-long-time/4391 "2015-09-09T23:37:36Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Deepak\_Madan](https://avatars.discourse-cdn.com/v4/letter/d/a87d85/32.png) [@Deepak\_Madan](https://forums.percona.com/u/Deepak_Madan)\
**Post date:** [September 9, 2015, 11:37pm UTC](https://forums.percona.com/t/single-row-query-output-taking-a-long-time/4391/1 "2015-09-09T23:37:36Z")

</div>

One column has longblob data type. There are total 6 rows in the table. mysql Ver 14.14 Distrib 5.6.21. Single row output takes too long

---

<div class="post-metadata">

**Author:** ![scott.nemes](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/scott.nemes/32/5_2.png) [@scott.nemes](https://forums.percona.com/u/scott.nemes)\
**Post date:** [September 10, 2015, 11:49am UTC](https://forums.percona.com/t/single-row-query-output-taking-a-long-time/4391/2 "2015-09-10T11:49:59Z")

</div>

Hi Deepak Madan;

If a table with 6 rows in it takes a long time to return, then likely either the query is very bad, or some sort of locking/deadlock is happening (or a combination of some of those things).

If you post the query and the table schema, query, and system specs, we could potentially suggest more.

-Scott