RE: Tuning mysql concurrent running threads

2009-09-08 Thread nabila.salmi
astmail.fm] Envoyé : mardi 8 septembre 2009 17:21 À : mysql@lists.mysql.com Objet : Re: Tuning mysql concurrent running threads If you are talking about MyISAM tables, in my.cnf you can set the thread_concurrency=x where x=2*# of CPU's but this unfortunately only works on Solaris and not on Lin

Re: Tuning mysql concurrent running threads

2009-09-08 Thread mos
If you are talking about MyISAM tables, in my.cnf you can set the thread_concurrency=x where x=2*# of CPU's but this unfortunately only works on Solaris and not on Linux. It may work on Windows, I'm not sure. InnoDb has their own innodb_thread_concurrency variable that you can see the value