Re: How to improve the insertion speed

[Aftab Khan]

># Innobd Tuning
>innodb_buffer_pool_size=6G # Should 50%-80% of the available RAM
its is too high for a 7G RAM System.

1). you can collect new rows into a temp table and then transfer them into your `messa` table.

2). use latin1 instead of utf8, as utf8 uses upto 3 bytes/char.

3). Try innodb_flush_log_at_trx_commit=2 ( not 0), innodb_doublewrite=OFF ( when top performance is needed rather than concern for data integrity or possible failures)

4). innodb_log_file_size is set to default, try to increase this too ,The larger the value, the less checkpoint flush activity is needed in the buffer pool, saving disk I/O. But larger log files also mean that recovery is slower in case of a crash



Edited 1 time(s). Last edit at 05/21/2009 02:27AM by Aftab Khan.