How do I change innodb_autoinc_lock_mode to 0 out of 1?

Question

How can I change a global variable innodb_autoinc_lock_mode

from 1 to 0 in MySQL?

+3

sidhesh 01 Feb 13 at 7:48

1 answer

Iswanto san · Accepted Answer · 2013-02-01T07:57:06+0000

Open mysql.ini and add the following line:

innodb_autoinc_lock_mode=0

Or start mysql with a command line parameter: --innodb_autoinc_lock_mode=0