Skip to:
mysql> show global variables like 'autocommit'; +---------------+-------+ | Variable_name | Value | +---------------+-------+ | autocommit | ON | +---------------+-------+ 1 row in set (0.01 sec) pt-online-schema-change --alter "FORCE;" --user="" --password="" P=3306,D="test",t="t5" --preserve-triggers --no-version-check --execute --max-flow-ctl=0 --chunk-size=1000 --set-vars autocommit=1 --alter-foreign-keys-method=auto --chunk-time=0.1 --no-check-foreign-keys --noanalyze-before-swap --max-load "Threads_running=100" --set-vars sql_mode=\'\' mysql> select * from performance_schema.processlist; select * from performance_schema.variables_by_thread where variable_name like 'autocommit'; +----+-----------------+-----------+------+---------+------+------------------------+-------------------------------------------------------------------------------+---------+-----------+---------------+------------------+ | ID | USER | HOST | DB | COMMAND | TIME | STATE | INFO | TIME_MS | ROWS_SENT | ROWS_EXAMINED | EXECUTION_ENGINE | +----+-----------------+-----------+------+---------+------+------------------------+-------------------------------------------------------------------------------+---------+-----------+---------------+------------------+ | 29 | root | localhost | test | Query | 0 | wsrep: replicating ... | INSERT LOW_PRIORITY IGNORE INTO test._t5_new (id, tcol01, tcol09... | 204 | 1 | 1000 | PRIMARY | +----+-----------------+-----------+------+---------+------+------------------------+-------------------------------------------------------------------------------+---------+-----------+---------------+------------------+ 13 rows in set (0.00 sec) +-----------+---------------+----------------+ | THREAD_ID | VARIABLE_NAME | VARIABLE_VALUE | +-----------+---------------+----------------+ | 64 | autocommit | ON | | 77 | autocommit | ON | | 78 | autocommit | ON | +-----------+---------------+----------------+ 3 rows in set (0.00 sec) mysql> show global variables like 'autocommit'; +---------------+-------+ | Variable_name | Value | +---------------+-------+ | autocommit | OFF | +---------------+-------+ 1 row in set (0.01 sec) pt-online-schema-change --alter "FORCE;" --user="" --password="" P=3306,D="test",t="t5" --preserve-triggers --no-version-check --execute --max-flow-ctl=0 --chunk-size=1000 --set-vars autocommit=1 --alter-foreign-keys-method=auto --chunk-time=0.1 --no-check-foreign-keys --noanalyze-before-swap --max-load "Threads_running=100" --set-vars sql_mode=\'\' mysql> select * from performance_schema.processlist; select * from performance_schema.variables_by_thread where variable_name like 'autocommit'; +----+-----------------+-----------+------+---------+------+------------------------+-------------------------------------------------------------------------------+---------+-----------+---------------+------------------+ | ID | USER | HOST | DB | COMMAND | TIME | STATE | INFO | TIME_MS | ROWS_SENT | ROWS_EXAMINED | EXECUTION_ENGINE | +----+-----------------+-----------+------+---------+------+------------------------+-------------------------------------------------------------------------------+---------+-----------+---------------+------------------+ | 29 | root | localhost | test | Query | 0 | wsrep: replicating ... | INSERT LOW_PRIORITY IGNORE INTO test._t5_new (id, tcol01, tcol09... | 204 | 1 | 1000 | PRIMARY | +----+-----------------+-----------+------+---------+------+------------------------+-------------------------------------------------------------------------------+---------+-----------+---------------+------------------+ 13 rows in set (0.00 sec) +-----------+---------------+----------------+ | THREAD_ID | VARIABLE_NAME | VARIABLE_VALUE | +-----------+---------------+----------------+ | 64 | autocommit | ON | | 88 | autocommit | OFF | | 89 | autocommit | OFF | +-----------+---------------+----------------+ 3 rows in set (0.00 sec) mysql> show global variables like 'autocommit'; +---------------+-------+ | Variable_name | Value | +---------------+-------+ | autocommit | OFF | +---------------+-------+ 1 row in set (0.01 sec) pt-online-schema-change --alter "FORCE;" --user="" --password="" P=3306,D="test",t="t5" --preserve-triggers --no-version-check --execute --max-flow-ctl=0 --chunk-size=1000 --set-vars autocommit=1 --alter-foreign-keys-method=auto --chunk-time=0.1 --no-check-foreign-keys --noanalyze-before-swap --max-load "Threads_running=100" mysql> select * from performance_schema.processlist; select * from performance_schema.variables_by_thread where variable_name like 'autocommit'; +----+-----------------+-----------+------+---------+------+------------------------+-------------------------------------------------------------------------------+---------+-----------+---------------+------------------+ | ID | USER | HOST | DB | COMMAND | TIME | STATE | INFO | TIME_MS | ROWS_SENT | ROWS_EXAMINED | EXECUTION_ENGINE | +----+-----------------+-----------+------+---------+------+------------------------+-------------------------------------------------------------------------------+---------+-----------+---------------+------------------+ | 2 | system user | NULL | NULL | Sleep | 1018 | wsrep: aborter idle | NULL | 1017915 | 0 | 0 | PRIMARY | | 1 | system user | NULL | NULL | Connect | 1017 | | DELETE FROM mysql.wsrep_cluster_members | 1017002 | 0 | 0 | PRIMARY | | 22 | root | localhost | NULL | Query | 0 | executing | select * from performance_schema.processlist | 0 | 10 | 573 | PRIMARY | | 29 | root | localhost | test | Query | 0 | wsrep: replicating ... | INSERT LOW_PRIORITY IGNORE INTO test._t5_new (id, tcol01, tcol09... | 204 | 1 | 1000 | PRIMARY | | 30 | root | localhost | test | Sleep | 10 | | NULL | 9615 | 1 | 1 | PRIMARY | +----+-----------------+-----------+------+---------+------+------------------------+-------------------------------------------------------------------------------+---------+-----------+---------------+------------------+ 13 rows in set (0.00 sec) +-----------+---------------+----------------+ | THREAD_ID | VARIABLE_NAME | VARIABLE_VALUE | +-----------+---------------+----------------+ | 64 | autocommit | ON | | 77 | autocommit | ON | | 78 | autocommit | ON | +-----------+---------------+----------------+ 3 rows in set (0.00 sec)
Medium
MediumMedium
mysql> show global variables like 'autocommit'; +---------------+-------+ | Variable_name | Value | +---------------+-------+ | autocommit | ON | +---------------+-------+ 1 row in set (0.01 sec) pt-online-schema-change --alter "FORCE;" --user="" --password="" P=3306,D="test",t="t5" --preserve-triggers --no-version-check --execute --max-flow-ctl=0 --chunk-size=1000 --set-vars autocommit=1 --alter-foreign-keys-method=auto --chunk-time=0.1 --no-check-foreign-keys --noanalyze-before-swap --max-load "Threads_running=100" --set-vars sql_mode=\'\' mysql> select * from performance_schema.processlist; select * from performance_schema.variables_by_thread where variable_name like 'autocommit'; +----+-----------------+-----------+------+---------+------+------------------------+-------------------------------------------------------------------------------+---------+-----------+---------------+------------------+ | ID | USER | HOST | DB | COMMAND | TIME | STATE | INFO | TIME_MS | ROWS_SENT | ROWS_EXAMINED | EXECUTION_ENGINE | +----+-----------------+-----------+------+---------+------+------------------------+-------------------------------------------------------------------------------+---------+-----------+---------------+------------------+ | 29 | root | localhost | test | Query | 0 | wsrep: replicating ... | INSERT LOW_PRIORITY IGNORE INTO test._t5_new (id, tcol01, tcol09... | 204 | 1 | 1000 | PRIMARY | +----+-----------------+-----------+------+---------+------+------------------------+-------------------------------------------------------------------------------+---------+-----------+---------------+------------------+ 13 rows in set (0.00 sec) +-----------+---------------+----------------+ | THREAD_ID | VARIABLE_NAME | VARIABLE_VALUE | +-----------+---------------+----------------+ | 64 | autocommit | ON | | 77 | autocommit | ON | | 78 | autocommit | ON | +-----------+---------------+----------------+ 3 rows in set (0.00 sec) mysql> show global variables like 'autocommit'; +---------------+-------+ | Variable_name | Value | +---------------+-------+ | autocommit | OFF | +---------------+-------+ 1 row in set (0.01 sec) pt-online-schema-change --alter "FORCE;" --user="" --password="" P=3306,D="test",t="t5" --preserve-triggers --no-version-check --execute --max-flow-ctl=0 --chunk-size=1000 --set-vars autocommit=1 --alter-foreign-keys-method=auto --chunk-time=0.1 --no-check-foreign-keys --noanalyze-before-swap --max-load "Threads_running=100" --set-vars sql_mode=\'\' mysql> select * from performance_schema.processlist; select * from performance_schema.variables_by_thread where variable_name like 'autocommit'; +----+-----------------+-----------+------+---------+------+------------------------+-------------------------------------------------------------------------------+---------+-----------+---------------+------------------+ | ID | USER | HOST | DB | COMMAND | TIME | STATE | INFO | TIME_MS | ROWS_SENT | ROWS_EXAMINED | EXECUTION_ENGINE | +----+-----------------+-----------+------+---------+------+------------------------+-------------------------------------------------------------------------------+---------+-----------+---------------+------------------+ | 29 | root | localhost | test | Query | 0 | wsrep: replicating ... | INSERT LOW_PRIORITY IGNORE INTO test._t5_new (id, tcol01, tcol09... | 204 | 1 | 1000 | PRIMARY | +----+-----------------+-----------+------+---------+------+------------------------+-------------------------------------------------------------------------------+---------+-----------+---------------+------------------+ 13 rows in set (0.00 sec) +-----------+---------------+----------------+ | THREAD_ID | VARIABLE_NAME | VARIABLE_VALUE | +-----------+---------------+----------------+ | 64 | autocommit | ON | | 88 | autocommit | OFF | | 89 | autocommit | OFF | +-----------+---------------+----------------+ 3 rows in set (0.00 sec) mysql> show global variables like 'autocommit'; +---------------+-------+ | Variable_name | Value | +---------------+-------+ | autocommit | OFF | +---------------+-------+ 1 row in set (0.01 sec) pt-online-schema-change --alter "FORCE;" --user="" --password="" P=3306,D="test",t="t5" --preserve-triggers --no-version-check --execute --max-flow-ctl=0 --chunk-size=1000 --set-vars autocommit=1 --alter-foreign-keys-method=auto --chunk-time=0.1 --no-check-foreign-keys --noanalyze-before-swap --max-load "Threads_running=100" mysql> select * from performance_schema.processlist; select * from performance_schema.variables_by_thread where variable_name like 'autocommit'; +----+-----------------+-----------+------+---------+------+------------------------+-------------------------------------------------------------------------------+---------+-----------+---------------+------------------+ | ID | USER | HOST | DB | COMMAND | TIME | STATE | INFO | TIME_MS | ROWS_SENT | ROWS_EXAMINED | EXECUTION_ENGINE | +----+-----------------+-----------+------+---------+------+------------------------+-------------------------------------------------------------------------------+---------+-----------+---------------+------------------+ | 2 | system user | NULL | NULL | Sleep | 1018 | wsrep: aborter idle | NULL | 1017915 | 0 | 0 | PRIMARY | | 1 | system user | NULL | NULL | Connect | 1017 | | DELETE FROM mysql.wsrep_cluster_members | 1017002 | 0 | 0 | PRIMARY | | 22 | root | localhost | NULL | Query | 0 | executing | select * from performance_schema.processlist | 0 | 10 | 573 | PRIMARY | | 29 | root | localhost | test | Query | 0 | wsrep: replicating ... | INSERT LOW_PRIORITY IGNORE INTO test._t5_new (id, tcol01, tcol09... | 204 | 1 | 1000 | PRIMARY | | 30 | root | localhost | test | Sleep | 10 | | NULL | 9615 | 1 | 1 | PRIMARY | +----+-----------------+-----------+------+---------+------+------------------------+-------------------------------------------------------------------------------+---------+-----------+---------------+------------------+ 13 rows in set (0.00 sec) +-----------+---------------+----------------+ | THREAD_ID | VARIABLE_NAME | VARIABLE_VALUE | +-----------+---------------+----------------+ | 64 | autocommit | ON | | 77 | autocommit | ON | | 78 | autocommit | ON | +-----------+---------------+----------------+ 3 rows in set (0.00 sec)