Hello Mike, Thank you very much for your answer. MySQl is on Ubuntu server and i tried thread_concurrency=x, it doesn't work.
Do you mean, i should configure MySQL with INNODB engine ? How to do that ? Thanks again ! Nabila -----Message d'origine----- De : mos [mailto:mo...@fastmail.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 Linux. It may work on Windows, I'm not sure. InnoDb has their own innodb_thread_concurrency variable that you can see the value of using SHOW INNODB STATUS. If you want true multi-threading then you may have to use MySQL Clusters. See http://dev.mysql.com/doc/refman/5.1/en/mysql-cluster-programs-ndbmtd.html Mike At 02:39 AM 9/8/2009, nabila.sa...@orange-ftgroup.com wrote: > Hello, > >I have a mysql server where thousands of users connect. I configured >max connections but i didn't found how to configure concurrent raunning >threads. When i do show status, always RUNNING THREADS=1, even several >threads are pending. > >How to change this please ? > >Anyone can help me please ? > >Thank you very much ! > >Nabila -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=nabila.sa...@orange-ftgroup.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
