Page MenuHomePhabricator
Paste P5152

s6: frwiki,jawiki,ruwiki UNIQUE to PK
ActivePublic
Actions

Authored by • Marostegui on Mar 29 2017, 7:48 AM.
Tags
None
Referenced Files
F7080480: s6: frwiki,jawiki,ruwiki UNIQUE to PK
Mar 29 2017, 10:36 AM
F7077643: s6: frwiki,jawiki,ruwiki UNIQUE to PK
Mar 29 2017, 9:08 AM
F7077629: s6: frwiki,jawiki,ruwiki UNIQUE to PK
Mar 29 2017, 9:07 AM
F7075994: s6: frwiki,jawiki,ruwiki UNIQUE to PK
Mar 29 2017, 8:07 AM
F7075328: s6: frwiki,jawiki,ruwiki UNIQUE to PK
Mar 29 2017, 7:48 AM
Subscribers
• Marostegui
./osc_host.sh --host=db1093.eqiad.wmnet --port=3306 --db=frwiki --table=categorylinks --method=ddl --no-replicate "drop key cl_from, add primary key (cl_from,cl_to);"
./osc_host.sh --host=db1093.eqiad.wmnet --port=3306 --db=frwiki --table=imagelinks --method=ddl --no-replicate "drop key il_from, add primary key (il_from,il_to)"
./osc_host.sh --host=db1093.eqiad.wmnet --port=3306 --db=frwiki --table=iwlinks --method=ddl --no-replicate "drop key iwl_from, add primary key (iwl_from,iwl_prefix,iwl_title)"
./osc_host.sh --host=db1093.eqiad.wmnet --port=3306 --db=frwiki --table=langlinks --method=ddl --no-replicate "drop key ll_from, add primary key (ll_from,ll_lang)"
./osc_host.sh --host=db1093.eqiad.wmnet --port=3306 --db=frwiki --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=db1093.eqiad.wmnet --port=3306 --db=frwiki --table=math --method=ddl --no-replicate "drop key math_inputhash, add primary key (math_inputhash)"
./osc_host.sh --host=db1093.eqiad.wmnet --port=3306 --db=frwiki --table=module_deps --method=ddl --no-replicate "drop key md_module_skin, add primary key (md_module,md_skin)"
./osc_host.sh --host=db1093.eqiad.wmnet --port=3306 --db=frwiki --table=objectcache --method=ddl --no-replicate "drop key keyname, add primary key (keyname)"
./osc_host.sh --host=db1093.eqiad.wmnet --port=3306 --db=frwiki --table=pagelinks --method=ddl --no-replicate "drop key pl_from, add primary key (pl_from,pl_namespace,pl_title)"
./osc_host.sh --host=db1093.eqiad.wmnet --port=3306 --db=frwiki --table=querycache_info --method=ddl --no-replicate "drop key qci_type, add primary key (qci_type)"
./osc_host.sh --host=db1093.eqiad.wmnet --port=3306 --db=frwiki --table=searchindex --method=ddl --no-replicate "drop key si_page, add primary key (si_page)"
./osc_host.sh --host=db1093.eqiad.wmnet --port=3306 --db=frwiki --table=site_stats --method=ddl --no-replicate "drop key ss_row_id, add primary key (ss_row_id)"
./osc_host.sh --host=db1093.eqiad.wmnet --port=3306 --db=frwiki --table=templatelinks --method=ddl --no-replicate "drop key tl_from, add primary key (tl_from,tl_namespace,tl_title)"
./osc_host.sh --host=db1093.eqiad.wmnet --port=3306 --db=frwiki --table=text --method=ddl --no-replicate "drop key old_id, add primary key (old_id)"
./osc_host.sh --host=db1093.eqiad.wmnet --port=3306 --db=frwiki --table=transcache --method=ddl --no-replicate "drop key tc_url_idx, add primary key (tc_url)"
./osc_host.sh --host=db1093.eqiad.wmnet --port=3306 --db=frwiki --table=user_former_groups --method=ddl --no-replicate "drop key ufg_user_group, add primary key (ufg_user,ufg_group)"
./osc_host.sh --host=db1093.eqiad.wmnet --port=3306 --db=frwiki --table=user_properties --method=ddl --no-replicate "drop key user_properties_user_property, add primary key (up_user,up_property)"
./osc_host.sh --host=db1093.eqiad.wmnet --port=3306 --db=frwiki --table=watchlist --method=ddl --no-replicate "drop key wl_user, add primary key (wl_user,wl_namespace,wl_title)"
./osc_host.sh --host=db1093.eqiad.wmnet --port=3306 --db=frwiki --table=l10n_cache --method=ddl --no-replicate "add primary key (lc_lang, lc_key);"
./osc_host.sh --host=db1093.eqiad.wmnet --port=3306 --db=jawiki --table=categorylinks --method=ddl --no-replicate "drop key cl_from, add primary key (cl_from,cl_to);"
./osc_host.sh --host=db1093.eqiad.wmnet --port=3306 --db=jawiki --table=imagelinks --method=ddl --no-replicate "drop key il_from, add primary key (il_from,il_to)"
./osc_host.sh --host=db1093.eqiad.wmnet --port=3306 --db=jawiki --table=iwlinks --method=ddl --no-replicate "drop key iwl_from, add primary key (iwl_from,iwl_prefix,iwl_title)"
./osc_host.sh --host=db1093.eqiad.wmnet --port=3306 --db=jawiki --table=langlinks --method=ddl --no-replicate "drop key ll_from, add primary key (ll_from,ll_lang)"
./osc_host.sh --host=db1093.eqiad.wmnet --port=3306 --db=jawiki --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=db1093.eqiad.wmnet --port=3306 --db=jawiki --table=math --method=ddl --no-replicate "drop key math_inputhash, add primary key (math_inputhash)"
./osc_host.sh --host=db1093.eqiad.wmnet --port=3306 --db=jawiki --table=module_deps --method=ddl --no-replicate "drop key md_module_skin, add primary key (md_module,md_skin)"
./osc_host.sh --host=db1093.eqiad.wmnet --port=3306 --db=jawiki --table=objectcache --method=ddl --no-replicate "drop key keyname, add primary key (keyname)"
./osc_host.sh --host=db1093.eqiad.wmnet --port=3306 --db=jawiki --table=pagelinks --method=ddl --no-replicate "drop key pl_from, add primary key (pl_from,pl_namespace,pl_title)"
./osc_host.sh --host=db1093.eqiad.wmnet --port=3306 --db=jawiki --table=querycache_info --method=ddl --no-replicate "drop key qci_type, add primary key (qci_type)"
./osc_host.sh --host=db1093.eqiad.wmnet --port=3306 --db=jawiki --table=searchindex --method=ddl --no-replicate "drop key si_page, add primary key (si_page)"
./osc_host.sh --host=db1093.eqiad.wmnet --port=3306 --db=jawiki --table=site_stats --method=ddl --no-replicate "drop key ss_row_id, add primary key (ss_row_id)"
./osc_host.sh --host=db1093.eqiad.wmnet --port=3306 --db=jawiki --table=templatelinks --method=ddl --no-replicate "drop key tl_from, add primary key (tl_from,tl_namespace,tl_title)"
./osc_host.sh --host=db1093.eqiad.wmnet --port=3306 --db=jawiki --table=text --method=ddl --no-replicate "drop key old_id, add primary key (old_id)"
./osc_host.sh --host=db1093.eqiad.wmnet --port=3306 --db=jawiki --table=transcache --method=ddl --no-replicate "drop key tc_url_idx, add primary key (tc_url)"
./osc_host.sh --host=db1093.eqiad.wmnet --port=3306 --db=jawiki --table=user_former_groups --method=ddl --no-replicate "drop key ufg_user_group, add primary key (ufg_user,ufg_group)"
./osc_host.sh --host=db1093.eqiad.wmnet --port=3306 --db=jawiki --table=user_properties --method=ddl --no-replicate "drop key user_properties_user_property, add primary key (up_user,up_property)"
./osc_host.sh --host=db1093.eqiad.wmnet --port=3306 --db=jawiki --table=watchlist --method=ddl --no-replicate "drop key wl_user, add primary key (wl_user,wl_namespace,wl_title)"
./osc_host.sh --host=db1093.eqiad.wmnet --port=3306 --db=jawiki --table=l10n_cache --method=ddl --no-replicate "add primary key (lc_lang, lc_key);"
./osc_host.sh --host=db1093.eqiad.wmnet --port=3306 --db=ruwiki --table=categorylinks --method=ddl --no-replicate "drop key cl_from, add primary key (cl_from,cl_to);"
./osc_host.sh --host=db1093.eqiad.wmnet --port=3306 --db=ruwiki --table=imagelinks --method=ddl --no-replicate "drop key il_from, add primary key (il_from,il_to)"
./osc_host.sh --host=db1093.eqiad.wmnet --port=3306 --db=ruwiki --table=iwlinks --method=ddl --no-replicate "drop key iwl_from, add primary key (iwl_from,iwl_prefix,iwl_title)"
./osc_host.sh --host=db1093.eqiad.wmnet --port=3306 --db=ruwiki --table=langlinks --method=ddl --no-replicate "drop key ll_from, add primary key (ll_from,ll_lang)"
./osc_host.sh --host=db1093.eqiad.wmnet --port=3306 --db=ruwiki --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=db1093.eqiad.wmnet --port=3306 --db=ruwiki --table=math --method=ddl --no-replicate "drop key math_inputhash, add primary key (math_inputhash)"
./osc_host.sh --host=db1093.eqiad.wmnet --port=3306 --db=ruwiki --table=module_deps --method=ddl --no-replicate "drop key md_module_skin, add primary key (md_module,md_skin)"
./osc_host.sh --host=db1093.eqiad.wmnet --port=3306 --db=ruwiki --table=objectcache --method=ddl --no-replicate "drop key keyname, add primary key (keyname)"
./osc_host.sh --host=db1093.eqiad.wmnet --port=3306 --db=ruwiki --table=pagelinks --method=ddl --no-replicate "drop key pl_from, add primary key (pl_from,pl_namespace,pl_title)"
./osc_host.sh --host=db1093.eqiad.wmnet --port=3306 --db=ruwiki --table=querycache_info --method=ddl --no-replicate "drop key qci_type, add primary key (qci_type)"
./osc_host.sh --host=db1093.eqiad.wmnet --port=3306 --db=ruwiki --table=searchindex --method=ddl --no-replicate "drop key si_page, add primary key (si_page)"
./osc_host.sh --host=db1093.eqiad.wmnet --port=3306 --db=ruwiki --table=site_stats --method=ddl --no-replicate "drop key ss_row_id, add primary key (ss_row_id)"
./osc_host.sh --host=db1093.eqiad.wmnet --port=3306 --db=ruwiki --table=templatelinks --method=ddl --no-replicate "drop key tl_from, add primary key (tl_from,tl_namespace,tl_title)"
./osc_host.sh --host=db1093.eqiad.wmnet --port=3306 --db=ruwiki --table=text --method=ddl --no-replicate "drop key old_id, add primary key (old_id)"
./osc_host.sh --host=db1093.eqiad.wmnet --port=3306 --db=ruwiki --table=transcache --method=ddl --no-replicate "drop key tc_url_idx, add primary key (tc_url)"
./osc_host.sh --host=db1093.eqiad.wmnet --port=3306 --db=ruwiki --table=user_former_groups --method=ddl --no-replicate "drop key ufg_user_group, add primary key (ufg_user,ufg_group)"
./osc_host.sh --host=db1093.eqiad.wmnet --port=3306 --db=ruwiki --table=user_properties --method=ddl --no-replicate "drop key user_properties_user_property, add primary key (up_user,up_property)"
./osc_host.sh --host=db1093.eqiad.wmnet --port=3306 --db=ruwiki --table=watchlist --method=ddl --no-replicate "drop key wl_user, add primary key (wl_user,wl_namespace,wl_title)"
./osc_host.sh --host=db1093.eqiad.wmnet --port=3306 --db=ruwiki --table=l10n_cache --method=ddl --no-replicate "add primary key (lc_lang, lc_key);"
Content licensed under Creative Commons Attribution-ShareAlike (CC BY-SA) 4.0 unless otherwise noted; code licensed under GNU General Public License (GPL) 2.0 or later and other open source licenses. By using this site, you agree to the Terms of Use, Privacy Policy, and Code of Conduct. · Wikimedia Foundation · Privacy Policy · Code of Conduct · Terms of Use · Disclaimer · CC-BY-SA · GPL