I have a CSV file that contains a lot of integer values. Is it better to insert these individual values in bulk as in a full transaction or should I be inserting the CSV file itself into the MySQL?
Insert the individual values in bulk. In other words, each row of the csv file should become a row in the database with the same number of columns.
Using Notepad++ you can use a regex find and replace to easily convert your CSV into a very large insert statement. Replace
','. Tidy up the first and last line of the file, then add the actual insert statement to the front.
insert into table (col1, col2, col3) values .....