I am trying to optimize an update query on InnoDB table in MySQL 5.1.73-log. As per my understanding we can not use EXPLAIN on update query for 5.1 version. So what will be the alternate course of action for such cases. Thanks in advance.

  • 1
    To optimize the UPDATE query, you must to optimize the corresponding SELECT query. – Akina Jul 18 '18 at 10:37
  • If you would like to show us the UPDATE and SHOW CREATE TABLE, there may be some obvious tips. (Meanwhile, please plan upgrading in the near future.) – Rick James Jul 18 '18 at 22:49

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.