Hi Catalin, Here are some InnoDB performance tuning tips that may boost your insert speed:
Catalin Trifu wrote:
... innodb_buffer_pool_size = 256M
Higher is better, in fact pushing this up to 60%-80% on a dedicated database would be good. If there are other things running like a web server, then you will have to take its memory requirements into account, but 256M could likely be bigger. Maybe this could be 512M ? Then data sets up to this size will be as fast as possible.
innodb_additional_mem_pool_size = 64M
Rarely does this need to be set over 8M.
# Set .._log_file_size to 25 % of buffer pool size innodb_log_file_size = 32M
Try setting this to 1/2 your buffer pool size, otherwise you might get too much checkpointing during lots of inserts.
innodb_log_buffer_size = 8M
Looks good.
innodb_flush_log_at_trx_commit = 1
Try setting to trx_commit = 2 for faster insert performance, however you then lose ACID transactions, where if you have a system failure you could lose around 1 second worth committed data. These suggestions will not necessarily fix your problem. If you continue to have issues and they go unresolved on this list, you might consider getting help via our commercial offerings: http://www.mysql.com/network/ - OR - http://www.mysql.com/consulting/packaged/performance.html http://www.mysql.com/consulting/packaged/rapidresponse.html Regards, Josh -- Josh Chamas Director, Professional Services MySQL Inc., www.mysql.com Get More with MySQL! www.mysql.com/consulting -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
