I am importing a load of data from a CSV file via the LOAD DATA INFILE command. This seems to be working fine but says there are 109 warnings. I have no idea how to view all of these warnings? You have the SHOW WARNINGS syntax but it only shows the warning on the last query that had one. So I can never see all the 109 warnings using this?
Also the database has about 1.8 million records and the average search takes 100 seconds, is this right? I could do with getting it down to around 8 seconds!