title: pandas push data to mysql with index column
body: <p>I am using python pandas with a mysql database. Initally it worked fine but recently as the table gets larger, the query get slower and slower. </p>
  
  <p>I have read that using index on columns can increase the performance a lot. I am not familiar with index, especially when working with pandas.</p>
  
  <p>Currently I am using pandas.DataFrame.to_sql to push a dataframe to database. I noticed there is an argument about the index in that method but not sure if that is what I am looking for. The column I would like to index is date which non-unique. Thanks for any suggestions!</p>
  
  <p>Bo</p>