CODEWITHSUNDEEP
mysqlsqlinnodb
tcett
tcett

Reputation: 37

MySQL Error:#1238 - Variable 'innodb_lock_wait_timeout' is a read only variable

I am using MySQL version:5.1.73

I want to change innodb_lock_wait_timeout mysql variable.

set innodb_lock_wait_timeout=100;

But I am getting this error:

#1238 - Variable 'innodb_lock_wait_timeout' is a read only variable

How can I fix this?

Upvotes: 1

Views: 9052

Answers (2)

evtok
evtok

Reputation: 1

Dynamic modification is not supported, and it needs to be restarted to take effect. Dynamic: NO

homebrew mysql config location: /opt/homebrew/etc/my.cnf

innodb_rollback_on_timeout = ON

Upvotes: 0

Rimas
Rimas

Reputation: 6024

innodb_lock_wait_timeout variable in MySQL 5.1 is not dynamic, so you must specify it on command line when starting server:

 mysqld --innodb_lock_wait_timeout=100

or in the configuration file (my.cnf, my.ini):

[mysqld]
innodb_lock_wait_timeout=100

restart MySQL server after configuration file change.

Upvotes: 2

Related Questions