pandas to_sql   mysql
sql.to_sql(df,tablename,self.engine,flavor=None,schema=None,if_exists='append',index=False,chunksize=100000)  

Pandas this to_sql slow storage speed is not a good way, the amount of data per hour 140w now takes 10 minutes