title: How to speed up MySQL INSERTs/UPDATEs?
body: <p>I have three large MySQL tables.  They are approaching 2 million records.  Two of the tables are InnoDB and are currently around 500 MB in size.  The other table is MyISAM and is about 2.5 GB.</p>
  
  <p>We run an import script from FileMaker to insert and update records in these tables but lately it has become very slow - only inserting a few hundred records per hour.</p>
  
  <p>What can I do to increase performance to make inserts and updates happen faster?</p>