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

Comments

  • 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.

    -Scott
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.