Re: mysql scaling questions

2008-01-03 Thread Gergely CZUCZY
On Thu, Jan 03, 2008 at 10:52:39PM +0100, Kris Kennaway wrote: > Gergely CZUCZY wrote: > > >>* Compare to my config file here: > >> > >>http://people.freebsd.org/~kris/scaling/my.cnf > >> > >>The default mysql config has very poor performance for innodb (you need at > >>least innodb_thread_concur

Re: mysql scaling questions

2008-01-03 Thread Kris Kennaway
Gergely CZUCZY wrote: * Compare to my config file here: http://people.freebsd.org/~kris/scaling/my.cnf The default mysql config has very poor performance for innodb (you need at least innodb_thread_concurrency = 0 to disable some mysql brain-death). Maybe tuning is required for myisam also.