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.alagars...@yahoo.co.in> 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.ber...@gmail.com http://www.ebergen.net -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org