Comment 2 for bug 1618918

Revision history for this message
Sveta Smirnova (svetasmirnova) wrote :

Thank you for the report.

Verified as described.

sveta@Thinkie:~/build/ps-5.7/mysql-test$ mysqlmtr test -P13001
...

mysql> create table test(id int not null auto_increment primary key, test int);
Query OK, 0 rows affected (0.40 sec)

mysql> insert into test (test) values(1),(2),(3);
Query OK, 3 rows affected (0.12 sec)
Records: 3 Duplicates: 0 Warnings: 0

mysql> \q
Bye

sveta@Thinkie:~/build/ps-5.7/mysql-test$ ~/build/percona-toolkit/bin/pt-online-schema-change --alter 'drop column test' h=127.0.0.1,P=13001,u=root,D=test,t=test --max-load THREADPOOL_IDLE_THREADS=1 --execute
No slaves found. See --recursion-method if host Thinkie has slaves.
Not checking slave lag because no slaves were found and --check-slave-lag was not specified.
Operation, tries, wait:
  analyze_table, 10, 1
  copy_rows, 10, 0.25
  create_triggers, 10, 1
  drop_triggers, 10, 1
  swap_tables, 10, 1
  update_foreign_keys, 10, 1
Altering `test`.`test`...
Creating new table...
Created new table test._test_new OK.
Altering new table...
Altered `test`.`_test_new` OK.
2016-12-13T15:52:17 Creating triggers...
2016-12-13T15:52:17 Created triggers OK.
2016-12-13T15:52:17 Copying approximately 3 rows...
Pausing because THREADPOOL_IDLE_THREADS=0.
Pausing because THREADPOOL_IDLE_THREADS=0.