Re: Optimizing the MySQL server performance

[bob ly]

Thanks for the response.
Actually I do a 1 row per insert statetment. I could have done a LOAD DATA INFILE if i was just dumping the data files completely. I add in 4 fields apart from those present in the data files which match each line. So i am not able to do a multi row insertion.

And I using INSERT LOW PRIORITY instead of INSERT DELAYED so that read access has more priority. Which is better - LOW PRIORITY OR DELAYED ? Is there anything I could at the OS level so that my perl script which do the loading process has a lower priority