How to manage very large amount of data in mysql
Use a "staging table".  Insert the unprocessed data into a separate table, then remove it when processed.

How big will the table eventually become?  A million row -- no problem.  A billion rows -- let's discuss more details.

For really high speed ingestion, see my blog.