MySQL Forums
Forum List  »  InnoDB

Advanced Search
New Topic

Re: simultaneous updates take time
Posted by: Paul Paulus
Date: October 03, 2008 01:20AM

MySQL prior 5.1.22 has locking issues with auto_increment and InnoDB tables. See http://dev.mysql.com/doc/refman/5.0/en/innodb-auto-increment-handling.html and http://dev.mysql.com/doc/refman/5.1/en/innodb-auto-increment-handling.html. This might explain your performance problems. (Unfortunately MySQL 5.1 isn't production ready right now.)

Otherwise, you might find a solution to your problem at http://dev.mysql.com/doc/refman/5.1/en/innodb-tuning.html.



Edited 1 time(s). Last edit at 10/03/2008 01:55AM by Paul Paulus.

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


Subject
Views
Written By
Posted
simultaneous updates take time
3008
Mohil Chandra
October 03, 2008 12:34AM
Re: simultaneous updates take time
1604
Paul Paulus
October 03, 2008 01:20AM
Re: simultaneous updates take time
1680
Mohil Chandra
October 03, 2008 03:32AM


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.