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