I have database locks. when I checked the process list the time taken for insert and update query was too large may I knw why and what is the root caused? what should I do inorder to reduce the execution time?

  • Sounds like a missing clustered index. Please show us CREATE TABE and the query.
    – Rick James
    Jul 31 at 14:39
  • hello sir, am working on mysql may be indexes only am not sure how can i send files to you please let me know I will share the details. Thanks for the help.
    – mark
    Aug 1 at 5:51

1 Answer 1


There maybe many reasons to cause lock. you can paste the result of "show processlist" and "select * from information_schema.innodb_trx" for furtur investigation

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.