Single row query output taking a long time .

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

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.