title: MySQL update query slow with where on primary key
body: <p>I have table which has 10 million records, I am using MySQL 5.6 innodb engine. It's transactional table. I am trying to update row by using primary key in where clause. I am trying update two column out of them one has index and one is non index column. My query looks something like this</p>
  
  <pre><code>Update table 
  set index column = 1234, nonindexcolumn  = 'test' 
  where primary key = 12345678
  </code></pre>
  
  <p>It's taking more than 30 secs. When I removed index from index column its updating faster but I need index on that column.</p>