Change Details

This is the report from a random replica: ``` wikiadmin2023@10.64.131.10(performance_schema)> select OBJECT_NAME, INDEX_NAME from table_io_waits_summary_by_index_usage where OBJECT_SCHEMA = 'fawiki' and SUM_TIMER_READ = 0 and NOT INDEX_NAME IS NULL limit 500; ``` To be checked: [] abuse_filter:af_actor [] abuse_filter:af_user [] abuse_filter_log:afl_ip_timestamp [] abuse_filter_log:afl_rev_id [] abuse_filter_log:afl_wiki_timestamp [] archive:PRIMARY [] babel:babel_lang_level [] categorylinks:cl_collation_ext [] change_tag:PRIMARY [] comment:comment_hash [] content_models:model_name [] cu_changes:cuc_xff_hex_time [] cu_log:PRIMARY [] filearchive:fa_deleted_timestamp [] flaggedpage_pending:fpp_quality_pending [] flaggedpages:fp_quality_page [] flaggedpages:fp_reviewed_page [] flaggedrevs:fr_page_qal_rev [] flaggedrevs:fr_page_qal_time [] flaggedrevs:fr_user [] global_block_whitelist:gbw_by [] ipblocks_restrictions:ir_type_value [] iwlinks:iwl_prefix_from_title [] log_search:ls_log_id [] oldimage:oi_sha1 [] ores_classification:PRIMARY [] ores_model:PRIMARY [] ores_model:ores_model_status [] ores_model:oresm_version [] page:page_len [] page_restrictions:pr_level [] querycachetwo:qcc_titletwo [] recentchanges:rc_ip [] securepoll_votes:spvote_ip [] site_identifiers:PRIMARY [] site_identifiers:si_key [] sites:site_domain [] sites:site_forward [] sites:site_global_key [] sites:site_group [] sites:site_language [] sites:site_protocol [] sites:site_source [] sites:site_type [] slot_roles:role_name [] transcode:PRIMARY [] updatelog:PRIMARY [] uploadstash:PRIMARY [] uploadstash:us_user [] user:user_email_token [] wikilove_log:PRIMARY [] wikilove_log:wll_receiver_time [] wikilove_log:wll_sender_time [] wikilove_log:wll_timestamp [] wikilove_log:wll_type_time Now we need to check if the index is needed or not. there are many cases that the index is needed in some shape or form but might end up in list of unused indexes. So any action must be done with caution. To be dropped: [] cur:name_title [] cur:cur_title [] cur:cur_timestamp [] cur:cur_random [] cur:name_title_timestamp [] cur:user_timestamp [] cur:usertext_timestamp [] cur:namespace_redirect_timestamp | [] cur:jamesspecialpages [] cur:qry_checktouched [] cur:id_title_ns_red

This is the report from a random replica: ``` wikiadmin2023@10.64.131.10(performance_schema)> select OBJECT_NAME, INDEX_NAME from table_io_waits_summary_by_index_usage where OBJECT_SCHEMA = 'fawiki' and SUM_TIMER_READ = 0 and NOT INDEX_NAME IS NULL limit 500; ``` To be checked: [] abuse_filter:af_actor [] abuse_filter:af_user [] abuse_filter_log:afl_ip_timestamp [] abuse_filter_log:afl_rev_id [] abuse_filter_log:afl_wiki_timestamp [] archive:PRIMARY [] babel:babel_lang_level [] categorylinks:cl_collation_ext [] change_tag:PRIMARY [] comment:comment_hash [] content_models:model_name [] cu_changes:cuc_xff_hex_time [] cu_log:PRIMARY [] filearchive:fa_deleted_timestamp [] flaggedpage_pending:fpp_quality_pending [] flaggedpages:fp_quality_page [] flaggedpages:fp_reviewed_page [] flaggedrevs:fr_page_qal_rev [] flaggedrevs:fr_page_qal_time [] flaggedrevs:fr_user [] global_block_whitelist:gbw_by [] ipblocks_restrictions:ir_type_value [] iwlinks:iwl_prefix_from_title [] log_search:ls_log_id [] oldimage:oi_sha1 [] ores_classification:PRIMARY [] ores_model:PRIMARY [] ores_model:ores_model_status [] ores_model:oresm_version [] page:page_len [] page_restrictions:pr_level [] querycachetwo:qcc_titletwo [] recentchanges:rc_ip [] securepoll_votes:spvote_ip [] site_identifiers:PRIMARY [] site_identifiers:si_key [] slot_roles:role_name [] transcode:PRIMARY [] updatelog:PRIMARY [] uploadstash:PRIMARY [] uploadstash:us_user [] user:user_email_token [] wikilove_log:PRIMARY [] wikilove_log:wll_receiver_time [] wikilove_log:wll_sender_time [] wikilove_log:wll_timestamp [] wikilove_log:wll_type_time Now we need to check if the index is needed or not. there are many cases that the index is needed in some shape or form but might end up in list of unused indexes. So any action must be done with caution. To be dropped: [] cur:name_title [] cur:cur_title [] cur:cur_timestamp [] cur:cur_random [] cur:name_title_timestamp [] cur:user_timestamp [] cur:usertext_timestamp [] cur:namespace_redirect_timestamp | [] cur:jamesspecialpages [] cur:qry_checktouched [] cur:id_title_ns_red [] sites:site_domain [] sites:site_forward [] sites:site_global_key [] sites:site_group [] sites:site_language [] sites:site_protocol [] sites:site_source [] sites:site_type