title: Two InnoDB table Join taking a Day!! I can't use the MYISAM because my table goes over the MaxData Length. How to solve this problem?
body: <p>I have two tables(InnoDB) one with 15 million records and the other with 14 million records and I need to do a Left Join on these tables based on a 'title reference'. I'm currently using a Innodb table as I may need to add more data to the resulting table in future. The query has been going on since yesterday.</p>
  
  <p>This 'Title_reference' is a varchar(20), its not a primary key but there are no duplicates in either tables. </p>
  
  <p>I have been checking the table status and it's being updated approximately every two hours. So Does that mean the query is active? </p>
  
  <p>I have the 15 million table as the first in the order while doing the join. </p>
  
  <p>Where am I making a mistake? How to solve this problem?</p>