I am attempting to load S3 files to an Aurora MySQL DB Cluster using the below AWS documentation:
LOAD DATA FROM S3 PREFIX '://' INTO TABLE my_table FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n';
Everything works fine and looks good in MySQL when I run a test on 1-2 csv files in my S3 bucket, but when I try loading 2,000+ csv files from my S3 bucket, after exactly 7,200 seconds the query fails and I get the error "MySQL Error 2013 Lost connection to MySQL server during query" (this has happened multiple times now).
MySQL settings are set as such:
I am using MySQL Workbench, MySQL Version 8.0.15, and engine InnoDB.
Any ideas why this keeps happening? Any guidance or help would be extremely appreciated!!