Re: Very slow insert with Innodb
Posted by:
Rick James
Date: December 30, 2008 11:01PM
* InnoDB stumbles over itself when there are a lot of simultaneous connections (like a few dozen) -- 1000 is excessive; can you throttle that some external way?
* 3 secondary keys? It would be good to have a short PRIMARY KEY (since the PK is included in every key). INT UNSIGNED AUTO_INCREMENT is usually the best.
* Sort the things you are batch inserting. Otherwise, you can (rarely) get deadlocks with one of the INSERTs being rolled back. (Recover from such by redoing the transaction containing the INSERT.
* You have auto_commit on? If you need transactions, go ahead and add BEGIN / COMMIT. Otherwise, you are only half fixing what you are avoiding MyISAM for.
* If 1GB is not big enough for all the data and indexes (see SHOW TABLE STATUS), consider increasing it (but don't let the system page).
* Anything interesting in the slowlog?
Subject
Views
Written By
Posted
7024
December 30, 2008 09:12PM
Re: Very slow insert with Innodb
2924
December 30, 2008 11:01PM
2912
January 05, 2009 08:28AM
2641
January 05, 2009 07:08PM
2674
January 05, 2009 11:46PM
2415
January 06, 2009 09:45PM
2867
January 07, 2009 03:37AM
2423
January 11, 2009 10:47PM
2301
January 17, 2009 09:44AM
2387
January 17, 2009 11:58PM
2719
January 18, 2009 09:09AM
2341
January 18, 2009 05:01PM
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.