Page Menu
Home
Phabricator
Search
Configure Global Search
Log In
Files
F7051043
s5: commons UNIQUE into PK
No One
Actions
View File
Edit File
Delete File
View Transforms
Subscribe
Mute Notifications
Award Token
Flag For Later
Authored By
Marostegui
Mar 28 2017, 2:33 PM
2017-03-28 14:33:23 (UTC+0)
Size
3 KB
Referenced Files
None
Subscribers
None
s5: commons UNIQUE into PK
View Options
./osc_host.sh --host=db1091.eqiad.wmnet --port=3306 --db=commonswiki --table=categorylinks --method=ddl --no-replicate "drop key cl_from, add primary key (cl_from,cl_to);"
./osc_host.sh --host=db1091.eqiad.wmnet --port=3306 --db=commonswiki --table=imagelinks --method=ddl --no-replicate "drop key il_from, add primary key (il_from,il_to)"
./osc_host.sh --host=db1091.eqiad.wmnet --port=3306 --db=commonswiki --table=iwlinks --method=ddl --no-replicate "drop key iwl_from, add primary key (iwl_from,iwl_prefix,iwl_title)"
./osc_host.sh --host=db1091.eqiad.wmnet --port=3306 --db=commonswiki --table=langlinks --method=ddl --no-replicate "drop key ll_from, add primary key (ll_from,ll_lang)"
./osc_host.sh --host=db1091.eqiad.wmnet --port=3306 --db=commonswiki --table=log_search --method=ddl --no-replicate "drop key ls_field_val, add primary key (ls_field,ls_value,ls_log_id)"
./osc_host.sh --host=db1091.eqiad.wmnet --port=3306 --db=commonswiki --table=math --method=ddl --no-replicate "drop key math_inputhash, add primary key (math_inputhash)"
./osc_host.sh --host=db1091.eqiad.wmnet --port=3306 --db=commonswiki --table=module_deps --method=ddl --no-replicate "drop key md_module_skin, add primary key (md_module,md_skin)"
./osc_host.sh --host=db1091.eqiad.wmnet --port=3306 --db=commonswiki --table=objectcache --method=ddl --no-replicate "drop key keyname, add primary key (keyname)"
./osc_host.sh --host=db1091.eqiad.wmnet --port=3306 --db=commonswiki --table=pagelinks --method=ddl --no-replicate "drop key pl_from, add primary key (pl_from,pl_namespace,pl_title)"
./osc_host.sh --host=db1091.eqiad.wmnet --port=3306 --db=commonswiki --table=querycache_info --method=ddl --no-replicate "drop key qci_type, add primary key (qci_type)"
./osc_host.sh --host=db1091.eqiad.wmnet --port=3306 --db=commonswiki --table=revtag --method=ddl --no-replicate "drop key rt_type_page_revision, add primary key (rt_type,rt_page,rt_revision)"
./osc_host.sh --host=db1091.eqiad.wmnet --port=3306 --db=commonswiki --table=site_stats --method=ddl --no-replicate "drop key ss_row_id, add primary key (ss_row_id)"
./osc_host.sh --host=db1091.eqiad.wmnet --port=3306 --db=commonswiki --table=templatelinks --method=ddl --no-replicate "drop key tl_from, add primary key (tl_from,tl_namespace,tl_title)"
./osc_host.sh --host=db1091.eqiad.wmnet --port=3306 --db=commonswiki --table=text --method=ddl --no-replicate "drop key old_id, add primary key (old_id)"
./osc_host.sh --host=db1091.eqiad.wmnet --port=3306 --db=commonswiki --table=transcache --method=ddl --no-replicate "drop key tc_url_idx, add primary key (tc_url)"
./osc_host.sh --host=db1091.eqiad.wmnet --port=3306 --db=commonswiki --table=translate_messageindex --method=ddl --no-replicate "drop key tmi_key ,add primary key (tmi_key)"
./osc_host.sh --host=db1091.eqiad.wmnet --port=3306 --db=commonswiki --table=translate_reviews --method=ddl --no-replicate "drop key trr_user_page_revision ,add primary key (trr_user,trr_page,trr_revision)"
./osc_host.sh --host=db1091.eqiad.wmnet --port=3306 --db=commonswiki --table=user_former_groups --method=ddl --no-replicate "drop key ufg_user_group, add primary key (ufg_user,ufg_group)"
./osc_host.sh --host=db1091.eqiad.wmnet --port=3306 --db=commonswiki --table=user_properties --method=ddl --no-replicate "drop key user_properties_user_property, add primary key (up_user,up_property)"
./osc_host.sh --host=db1091.eqiad.wmnet --port=3306 --db=commonswiki --table=watchlist --method=ddl --no-replicate "drop key wl_user, add primary key (wl_user,wl_namespace,wl_title)"
File Metadata
Details
Attached
Mime Type
text/plain; charset=utf-8
Storage Engine
blob
Storage Format
Raw Data
Storage Handle
4509013
Default Alt Text
s5: commons UNIQUE into PK (3 KB)
Attached To
Mode
P5149 s4: commons UNIQUE into PK
Attached
Detach File
Event Timeline
Log In to Comment