Re: innodb_data_file_path

[Mat private]

Hi Rick,

I thought it would be better to keep the files a bit smaller (but that was just a feeling). I have to add literally over 100 million rows of data (with just 6 columns with mainly doubles or (u)ints) to the DB. I wasn't sure if that would effect the overall performance. I'll give it a try with the file per table suggestion on a test computer, before implementing it on the production server. I'll also put back the setting for "innodb_log_buffer_size" to higher level, as it was before. I changed it due to the error message "It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 787385 K
bytes of memory", nut it seems that that was not the problem.
And thanks for the link. I'll go though the suggestion for speeding up the DB.
Thanks,

Matthijs