List:General Discussion« Previous MessageNext Message »
From:Eric Bergen Date:April 27 2009 6:32pm
Subject:Re: innodb_thread_concurrency at runtime in 4.1 ?
View as plain text  
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> wrote:
> 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=4;
> 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  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! Edition *
> Click here!



-- 
Eric Bergen
eric.bergen@stripped
http://www.ebergen.net
Thread
innodb_thread_concurrency at runtime in 4.1 ?Alagar samy27 Apr
  • Re: innodb_thread_concurrency at runtime in 4.1 ?Eric Bergen27 Apr