Re: Innodb Thread Concurrency
Posted by:
Rick James
Date: March 15, 2011 08:20PM
8 cores is about where InnoDB stops improving. And, as you found, the mutexes are the main villain. But also, InnoDB has yet to be well tuned for SSDs.
Percona's Xtradb is mostly compatible with InnoDB, and resolves some of the issues you bring up.
innodb_io_capacity should probably be 1000 or more because of your SSDs. (Again Percona may have done a better job.)
(Caveat: I have no stake in Percona, nor have I directly experienced the things I am claiming about xtradb.)
Subject
Views
Written By
Posted
7506
March 14, 2011 06:30AM
Re: Innodb Thread Concurrency
2598
March 15, 2011 08:20PM
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.