astmail.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 Lin
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
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
