s1 unique keys into PK
ActivePublic
Actions

Authored by Marostegui on Mar 28 2017, 7:08 AM.

Tags

None

Referenced Files

	F7072857: s1 unique keys into PK
	Mar 29 2017, 6:15 AM

	F7046550: s1 unique keys into PK
	Mar 28 2017, 7:08 AM

Subscribers

Marostegui

	./osc_host.sh --host=db1089.eqiad.wmnet --port=3306 --db=enwiki --table=categorylinks --method=ddl --no-replicate "drop key cl_from, add primary key (cl_from,cl_to);"
	./osc_host.sh --host=db1089.eqiad.wmnet --port=3306 --db=enwiki --table=ep_users_per_course --method=ddl --no-replicate "drop key ep_users_per_course, add primary key (upc_user_id,upc_course_id,upc_role);"
	./osc_host.sh --host=db1089.eqiad.wmnet --port=3306 --db=enwiki --table=flaggedrevs_tracking --method=ddl --no-replicate "drop key from_namespace_title, add primary key (ftr_from,ftr_namespace,ftr_title)"
	./osc_host.sh --host=db1089.eqiad.wmnet --port=3306 --db=enwiki --table=imagelinks --method=ddl --no-replicate "drop key il_from, add primary key (il_from,il_to)"
	./osc_host.sh --host=db1089.eqiad.wmnet --port=3306 --db=enwiki --table=iwlinks --method=ddl --no-replicate "drop key iwl_from, add primary key (iwl_from,iwl_prefix,iwl_title)"
	./osc_host.sh --host=db1089.eqiad.wmnet --port=3306 --db=enwiki --table=langlinks --method=ddl --no-replicate "drop key ll_from, add primary key (ll_from,ll_lang)"
	./osc_host.sh --host=db1089.eqiad.wmnet --port=3306 --db=enwiki --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=db1089.eqiad.wmnet --port=3306 --db=enwiki --table=math --method=ddl --no-replicate "drop key math_inputhash, add primary key (math_inputhash)"
	./osc_host.sh --host=db1089.eqiad.wmnet --port=3306 --db=enwiki --table=module_deps --method=ddl --no-replicate "drop key md_module_skin, add primary key (md_module,md_skin)"
	./osc_host.sh --host=db1089.eqiad.wmnet --port=3306 --db=enwiki --table=objectcache --method=ddl --no-replicate "drop key keyname, add primary key (keyname)"
	./osc_host.sh --host=db1089.eqiad.wmnet --port=3306 --db=enwiki --table=pagelinks --method=ddl --no-replicate "drop key pl_from, add primary key (pl_from,pl_namespace,pl_title)"
	./osc_host.sh --host=db1089.eqiad.wmnet --port=3306 --db=enwiki --table=profiling --method=ddl --no-replicate "drop key pf_name_server, add primary key (pf_name,pf_server)"
	./osc_host.sh --host=db1089.eqiad.wmnet --port=3306 --db=enwiki --table=querycache_info --method=ddl --no-replicate "drop key qci_type, add primary key (qci_type)"
	./osc_host.sh --host=db1089.eqiad.wmnet --port=3306 --db=enwiki --table=site_stats --method=ddl --no-replicate "drop key ss_row_id, add primary key (ss_row_id)"
	./osc_host.sh --host=db1089.eqiad.wmnet --port=3306 --db=enwiki --table=templatelinks --method=ddl --no-replicate "drop key tl_from, add primary key (tl_from,tl_namespace,tl_title)"
	./osc_host.sh --host=db1089.eqiad.wmnet --port=3306 --db=enwiki --table=text --method=ddl --no-replicate "drop key old_id, add primary key (old_id)"
	./osc_host.sh --host=db1089.eqiad.wmnet --port=3306 --db=enwiki --table=transcache --method=ddl --no-replicate "drop key tc_url_idx, add primary key (tc_url)"
	./osc_host.sh --host=db1089.eqiad.wmnet --port=3306 --db=enwiki --table=user_former_groups --method=ddl --no-replicate "drop key ufg_user_group, add primary key (ufg_user,ufg_group)"
	./osc_host.sh --host=db1089.eqiad.wmnet --port=3306 --db=enwiki --table=user_properties --method=ddl --no-replicate "drop key user_properties_user_property, add primary key (up_user,up_property)"
	./osc_host.sh --host=db1089.eqiad.wmnet --port=3306 --db=enwiki --table=vote_log --method=ddl --no-replicate "drop key log_id, add primary key (log_id)"
	./osc_host.sh --host=db1089.eqiad.wmnet --port=3306 --db=enwiki --table=watchlist --method=ddl --no-replicate "drop key wl_user, add primary key (wl_user,wl_namespace,wl_title)"
	./osc_host.sh --host=db1089.eqiad.wmnet --port=3306 --db=enwiki --table=l10n_cache --method=ddl --no-replicate "add primary key (lc_lang, lc_key);"

Event Timeline

Marostegui created this paste.Mar 28 2017, 7:08 AM

Marostegui edited the content of this paste. (Show Details)Mar 29 2017, 6:15 AM

s1 unique keys into PKActivePublicActions

Event Timeline

s1 unique keys into PK
ActivePublic
Actions