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=arch...@jab.org

Reply via email to