Thought I would throw this out here so I remember it, and it maybe useful for someone else. During a session here at Sun’s CEC conference one of the presenter was talking about setting CPU affinity for hardware interrupts. This made me think of our hack ( workaround ) for innodb scalability on a 16 core machine ( set the mysqld affinity to cpu’s 0-7 or 8-15 ). In order to get the top performance out of a 16 core machine we probably want to ensure everything else goes to the cpu’s not set to be servicing mysql. So a quick google search came up with this article on setting the affinity for IRQ’s in the linux kernel. So with a 16 core box, I could set the affinity for Mysqld to cpu’s 8-15, while setting the affinity of the interrupts to something in the 0-7 range.
-
Recent Posts
Recent Comments
- Harrison on Helping to Organize a MySQL Bootcamp @ IOUG’s COLLABORATE 11
- Mark Callaghan on More Debate, More Flame, More Choosing the correct tool for the job
- Matthew Yonkovit on New Benchmark I am working on that tests MYSQL -vs- NOSQL
- Sam on New Benchmark I am working on that tests MYSQL -vs- NOSQL
- Matt Montgomery on New Benchmark I am working on that tests MYSQL -vs- NOSQL
Archives
- October 2011
- May 2011
- October 2010
- September 2010
- April 2010
- March 2010
- July 2009
- June 2009
- May 2009
- April 2009
- March 2009
- February 2009
- January 2009
- December 2008
- November 2008
- October 2008
- August 2008
- July 2008
- June 2008
- April 2008
- March 2008
- February 2008
- January 2008
- December 2007
- November 2007
- October 2007
- September 2007
Categories
Meta
Yeah…. If there is a lot of everything else.
We used the hack to restrict the cores MySQL used for a while to help people who thought more cores should be better for MySQL and bought too many CPUs with too many cores
Also good tool if you run multiple MySQL instances with even load.
I have irqbalance installed (http://irqbalance.org/) – it’s in Ubuntu repos, and is made by Intel, most likely as a generic utility to do the work described in the article for you