title: MySQL - How to Avoid Query Locking
body: <p>We use InnoDB engine for our mysql database but since the data set is huge we aggregate data in flat myisam table. We have to use myisam because we also utilizing full-text search.</p>
  
  <p>Generally queries against flat table as much faster, but the problem is that we now have to run update script which locks all search queries for long....</p>
  
  <p>I wonder if there is a better way maintaining search table or how to run update script without locking other search queries.</p>