Comment 5 for bug 1113301

Revision history for this message
Daniel Nichter (daniel-nichter) wrote :

So the specific fix for this bug has become:

=item --set-vars

type: Array

Set the MySQL variables in this comma-separated list of C<variable=value> pairs.

By default, the tool sets:

=for comment ignore-pt-internal-value
MAGIC_set_vars

   wait_timeout=10000
   innodb_lock_wait_timeout=1
   lock_wait_timeout=60

So pt-osc will set those vars to those values by default (except lock_wait_timeout for < MySQL 5.5). If you want a different value for the now removed --lock-wait-timeout, say, 10 instead of 1, then specify:

--set-vars innodb_lock_wait_timeout=10

That will only override the default innodb_lock_wait_timeout=1.