MySQL Forums
Forum List  »  Performance

Re: InnoDB write performance
Posted by: Parvesh Garg
Date: July 11, 2007 11:54PM

No, that is not the only option. There may be others, but depends on how you are performing inserts. Others options, but not limited to, may be:

1. If you have auto_commit on, bundle up your inserts in a transaction.
2. Do bulk inserts instead of each one as a separate one, like insert into ... values(a,b,c), (d,e,f), ....,(x,y,z);
3. Reset your global variables depending on your server's performance - I know this is a very generic and weird statement, but cannot elaborate until provided with the details.

Thanks & Regards,
Parvesh Garg
http://optimmysql.blogspot.com

-------------------------------
"Language shapes the way we think, and determines what we can think about."
-- B. L. Whorf

Options: ReplyQuote


Subject
Views
Written By
Posted
4619
July 10, 2007 03:56AM
Re: InnoDB write performance
1965
July 11, 2007 11:54PM
4354
July 18, 2007 02:27PM


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.