Not the answer you need?
Register and ask your own question!

Single row query output taking a long time .

Deepak MadanDeepak Madan EntrantCurrent User Role Beginner
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


  • scott.nemesscott.nemes MySQL Sage Current User Role Patron
    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.

Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.