nabila.salmiorange-ftgroup.com
Date: Tue Sep 08 2009 - 10:27:43 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

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:mos99fastmail.fm]
Envoyé : mardi 8 septembre 2009 17:21
À : mysqllists.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.salmiorange-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.salmiorange-ftgroup.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]