I am performing massive insertion operation towards a MySQL database (100+ million records). Afterwards, I select records out of the two tables using for the most part their primary key. I seek to optimise the system with regards to performance and the current configuration parameters I have in mind are:
- binary logging turned off for increased performance,
- MyISAM storage engine for increased performance (however I will also try the "heavier" (transactional) InnoDB since it utilises private data buffer and finer locking),
- connection via socket since I am connecting to a server in the same computer.