I'm a graduate school student researching OLAP with Mondrian OLAP. So I want to insert data into InnoDB (MySQL 5.5) faster at the initial loading. In this environment, the only user is me, so I think can allow more loose settings for insertion speed. At the moment, I'm using the following techniques.
innodb_buffer_pool_sizeto 5GB (system has 6GB RAM)
Are there any more techniques for faster insertion on InnoDB?
And do I have to modify
If you need more information, please tell me.