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.