MySQL Forums
Forum List  »  Performance

Advanced Search
New Topic

Re: How to improve performance in a table with 70 million rows
Posted by: Srikanth Mamidi
Date: August 20, 2012 10:33AM

I have applied combination of following suggestions and see considerable improvement in the INSERTS with reduced/rare deadlocks:

- Removing the auto-increment 'id' column
- Removing the unnecessary index
- Increasing the innodb log file size to 50M
- Increasing the RAM size to 3.5G
- Sorting the batch inserts based on the key to reduce deadlocks

Thanks much, both Rick and Aftab :) Your suggestions have been very helpful.

Navigate: Previous Message• Next Message
Options: Reply• Quote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.