POLALA.COM
welcome to my space |
| innodb_thread_concurrency | | Published by: admin 2009-01-08 |
I was tweaking some of our InnoDB settings today and I came across this: http://www.mysqlperformanceblog.com/2006/05/12/mess-with-innodb_thread_concurrency/
Now, we use 5.0.33 so this applied to us greatly. In the past we have been using innodb_thread_concurrency=20. I changed it to innodb_thread_concurrency=0 (for unlimited) and our server loads shot waaaaaayyyyy down.
Getting Best Out of MySQL on Solaris::
An example of how to use solaris performance tools to innodb_thread_concurrency. innodb_flush_log_at_trx_commit = 0 could make big gain but at risk of
http://www.sun.com/third-party/srsc/resources/mysql/sun_mysql2007.pdfHOME |
innodb | MySQL Performance Blog::
5.0.19 the meaning of innodb_thread_concurrency variable was changed (yeah, So if you used innodb_thread_concurrency over 500 (or default
http://www.mysqlperformanceblog.com/page/4/?s=innodb+HOME |
So, if you are using InnoDB tables, try innodb_thread_concurrency=0 and see if it makes as big of an improvement as it did for us.
<3 mysqlperformanceblog.com
After reading some more, I'm not quite sure about this. I think I am going to email them and ask what the real deal is, because a month later they say this:
http://www.mysqlperformanceblog.com/2006/06/05/innodb-thread-concurrency/
edit: I'm currently using innodb_thread_concurrency=32 and things seem fine.
wow nice find :)
could be dependent on mysql version used and hardware/number of cpus used ?
 Where's The Advantage In Windows Genuine Advantage?
 Stocks Bounce After S&P Joins Bear Market |
#If you have any other info about this subject , Please add it free.# | |
|
