Page Menu
Home
Phabricator
Search
Configure Global Search
Log In
Files
F27685064
No One
Actions
View File
Edit File
Delete File
View Transforms
Subscribe
Mute Notifications
Award Token
Flag For Later
Authored By
•
Banyek
Dec 20 2018, 11:12 AM
2018-12-20 11:12:05 (UTC+0)
Size
2 KB
Referenced Files
None
Subscribers
None
View Options
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#
File Metadata
Details
Attached
Mime Type
text/plain; charset=utf-8
Storage Engine
blob
Storage Format
Raw Data
Storage Handle
6864145
Default Alt Text
(2 KB)
Attached To
Mode
P7935 (An Untitled Masterwork)
Attached
Detach File
Event Timeline
Log In to Comment