Python script for CSV to mysql Database

I have CSV files totaling about 40GB and need to insert the data into a MySQL database hosted on DigitalOcean. I’m looking for a Python script to handle this task efficiently, as the process with MongoDB took around 5-6 hours. The script should optimize for bulk insertion to speed up the process. It should also consider disabling indexes during the import and re-enabling them afterward.