Re: innodb thread concurrency size [mysql performance tuning]

2005-09-11 Thread Josh Chamas
Clyde Lewis wrote: Hey guys, I'm looking for any best practices or a formula that is commonly used in setting the value for thread concurrency in the configuration file. I have 24 instances running on a sun 2900 server with 32GB or ram. Here is a sample of my configuration file. The

innodb thread concurrency size

2005-08-30 Thread Clyde Lewis
Hey guys, I'm looking for any best practices or a formula that is commonly used in setting the value for thread concurrency in the configuration file. I have 24 instances running on a sun 2900 server with 32GB or ram. Here is a sample of my configuration file. #use this line mfor mysq

Thread concurrency

2004-11-22 Thread gunmuse
Just out of curiosity I recently turned this up from a 4 to a 16 to see what would choke.  Nothing did.  Matter of fact it seems like my load went down quite a bit.   Is there something wrong with leaving it this way? Since it should be really simple tasks on Xeon processors shouldn't it be