Tuning mysql concurrent running threads

------_=_NextPart_001_01CA3057.8845BBB5
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable



Hello,=20

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=3D1, even several =
threads are pending.=20

How to change this please ?=20

Anyone can help me please ?=20

Thank you very much !=20

Nabila=20


------_=_NextPart_001_01CA3057.8845BBB5--

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-program s-ndbmtd.html

Mike

At 02:39 AM 9/8/2009, nabila.salmi@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=gcdmg-mysql-2@m.gmane.org

RE: Tuning mysql concurrent running threads

Hello Mike,

Thank you very much for your answer.=20
MySQl is on Ubuntu server and i tried thread_concurrency=3Dx, 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:mos99@fastmail.fm]=20
Envoy=E9 : mardi 8 septembre 2009 17:21
=C0 : 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=3Dx

where x=3D2*# 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.=20
See =
http://dev.mysql.com/doc/refman/5.1/en/mysql-cluster-program s-ndbmtd.html=


Mike

At 02:39 AM 9/8/2009, nabila.salmi@orange-ftgroup.com wrote:


> Hello,
>
>I have a mysql server where thousands of users connect. I configured=20
>max connections but i didn't found how to configure concurrent raunning =

>threads. When i do show status, always RUNNING THREADS=3D1, even =
several=20
>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=3Dnabila.salmi@orange-ftg roup.com


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg