From: Eric Bergen
Date: April 27 2009 6:32pm
Subject: Re: innodb_thread_concurrency at runtime in 4.1 ?
List-Archive: http://lists.mysql.com/mysql/217294
Message-Id: <11b1bd990904271132q32e3acacp7deed67f85135049@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Hi,

I checked the 4.1.24 source and I don't see innodb_thread_concurrency
in the list of variables that can be set at runtime. I only see:

innodb_max_dirty_pages_pct,
innodb_max_purge_lag,
innodb_table_locks,
innodb_max_purge_lag,
innodb_autoextend_increment,

-Eric

On Sun, Apr 26, 2009 at 11:48 PM, Alagar samy <a.alagarsamy@stripped> wr=
ote:
> Hi,
>
> i am using mysql_server-4.1.23 and in the documentation of 4.1
> (http://dev.mysql.com/doc/refman/4.1/en/dynamic-system-variables.html) , =
it
> is mentioned innodb_thread_concurrency variable can be set at runtime.
>
> but i am getting error when trying to set dynamically ..
>
> mysql> SET GLOBAL innodb_thread_concurrency=3D4;
> ERROR 1193 (HY000): Unknown system variable 'innodb_thread_concurrency'
>
> still throws error when tried as set @innodb_thread_concurrency and set
> global @innodb_thread_concurrency ...
>
> can you please let me know whether 4.1 documentation is misleading or=A0 =
this
> is a bug in mysql-4.1 (as in, this variable cannot be set at run-time) ?
>
>
> PS : i am able to set innodb_thread_concurrency variable at runtime in
> mysql-5.1 .. but this is not an option for me now .. i have to go with 4.=
1
> at this point ..
>
>
> A.Alagarsamy
>
> ________________________________
> Now surf faster and smarter ! Check out the new Firefox 3 - Yahoo! Editio=
n *
> Click here!



--=20
Eric Bergen
eric.bergen@stripped
http://www.ebergen.net