root@cumin2001:/home/banyek# time PYTHONPATH=/home/banyek/wmfmariadbpy/ ./wmfmariadbpy/wmfmariadbpy/osc_host.py --method=ddl --host db1068 --dblist mediawiki-config/dblists/s4.dblist --table user --no-replicate "DROP COLUMN IF EXISTS user_options"
Host        : db1068
Port        : 3306
Databases   : ['commonswiki']
Table       : user
Alter SQL   : DROP COLUMN IF EXISTS user_options
method      : ddl
pt dry args : ['--recurse=0', '--set-vars=sql_log_bin=off']
pt args     : ['--recurse=0', '--set-vars=sql_log_bin=off']
ddl args    : ['SET SESSION innodb_lock_wait_timeout=1;', 'SET SESSION lock_wait_timeout=60;', 'set session sql_log_bin=0;']
analyze     : False
continue? yes/no yes
host: db1068, database: commonswiki
SET SESSION innodb_lock_wait_timeout=1;
SET SESSION lock_wait_timeout=60;
set session sql_log_bin=0;
alter table `user` DROP COLUMN IF EXISTS user_options
WARNING DROP COLUMN IF EXISTS user_options encountered problems while being executed at commonswiki.user
continue? yes/no no
abort

real    1m9.060s
user    0m0.136s
sys     0m0.024s
root@cumin2001:/home/banyek# mysql.py -h db1068 commonswiki -e "show create table user\G"            *************************** 1. row ***************************                                              Table: user
Create Table: CREATE TABLE `user` (
  `user_id` int(5) unsigned NOT NULL AUTO_INCREMENT,
  `user_name` varbinary(255) NOT NULL DEFAULT '',
  `user_real_name` varbinary(255) NOT NULL DEFAULT '',
  `user_password` tinyblob NOT NULL,
  `user_newpassword` tinyblob NOT NULL,
  `user_email` tinyblob NOT NULL,
  `user_options` blob NOT NULL,
  `user_touched` varbinary(14) NOT NULL DEFAULT '',
  `user_token` varbinary(32) NOT NULL DEFAULT '',
  `user_email_authenticated` varbinary(14) DEFAULT NULL,
  `user_email_token` varbinary(32) DEFAULT NULL,
  `user_email_token_expires` varbinary(14) DEFAULT NULL,
  `user_registration` varbinary(14) DEFAULT NULL,
  `user_newpass_time` varbinary(14) DEFAULT NULL,
  `user_editcount` int(11) DEFAULT NULL,
  `user_password_expires` varbinary(14) DEFAULT NULL,
  PRIMARY KEY (`user_id`),
  UNIQUE KEY `user_name` (`user_name`),
  KEY `user_email_token` (`user_email_token`),
  KEY `user_email` (`user_email`(50))
) ENGINE=InnoDB AUTO_INCREMENT=7577541 DEFAULT CHARSET=binary
root@cumin2001:/home/banyek#