Page MenuHomePhabricator
Paste P7935

(An Untitled Masterwork)
ActivePublic

Authored by Banyek on Dec 20 2018, 11:12 AM.
Tags
None
Referenced Files
F27685064:
Dec 20 2018, 11:12 AM
Subscribers
None
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#