怎么删除WordPress未使用的数据库表(150+插件主题数据库表名称）

怎么删除WordPress未使用的数据库表

　　您想清理WordPress数据库并删除未使用的数据库表吗？

　　WordPress未使用的表会占用一定数据库空间,删除这些冗余表可以缩小数据库大小,降低存储成本。数据库表越多,查询性能会有所下降。删除无用表可以简化数据库结构,提升查询和操作速度。删除不需要的表可以减少潜在的安全风险。定期优化数据库是数据库管理的最佳实践之一。删除无用表可以让数据库保持整洁有序。

　　简言之删除WordPress无用表对于数据库管理非常必要,可以让数据库更精简、高效、安全,也使网站运维工作更轻松。

　　这篇文章晓得博客为你介绍怎么删除WordPress未使用的数据库表，整理了150多个插件和主题的数据库表名称。这使您可以更轻松地将数据库表分配给它们所属或曾经所属的相应插件和主题，并找到可以删除的插件和主题。

　　推荐：Asset Cleanup Pro插件使用WordPress性能优化插件教程

如何使用列表

　　为了让您可以使用该列表更快地实现您的目标，并将 WordPress数据库从不必要的表中释放出来，我为您整理了一份关于如何使用它的简短指南：

1、创建数据库备份

　　在更改数据库中的任何内容之前，您应该始终对其进行备份或确保您的自动备份是最新的！

　　因为您总是可能会意外删除一个或多个不正确的WordPress数据库表。您可以在本文中阅读如何创建 WordPress 备份：WordPress备份初学者指南

　　注意：如果删除数据库表，插件的设置可能会被删除。如果您打算稍后再次使用该插件，则暂时不要删除关联的表。

2、打开PHPMyAdmin和插件列表

　　创建备份后，同时在 PHPMyAdmin 中打开数据库并在 WordPress 中打开插件列表。

　　要打开 PHPMyAdmin，您需要登录虚拟主机的客户区域并访问您的数据库。在那里您通常还会找到 PHPMyAdmin 的链接。

　　推荐：如何使用 phpMyAdmin 导出MySQL数据库

3、搜索列表中的表或插件

　　接下来，逐步检查WordPress数据库表以查找不再使用的表。

　　所有不属于 WordPress 自己的表（参见第 2 点）的数据库表都是潜在的删除候选者。复制表名称（不带前缀）并STRG/CMD + F在文章中搜索该名称。

　　在下面的示例中，您可以例如 例如TranslatePress在列表中搜索：

　　注意：该列表显示所有不带前缀的表名称。上例表中的前缀是wp_（WordPress数据库表前缀,)或者，您可以在列表底部查找您曾经安装过但不再使用的插件，然后在 PHPMyAdmin 中查找相应的表。

4、使用Advanced Database Cleaner Pro

　　如果您使用Advanced Database Cleaner Pro，步骤 1.2 和 1.3 会更容易。这允许您直接在 WordPress 中删除数据库表，而无需登录 PHPMyAdmin：该插件还可以扫描您的数据库表并将它们分配给您的插件。Advanced Database Cleaner Pro 并不总是 100% 正确映射所有数据库表。有时会发生数据库表被分配给错误的插件或被识别为“孤立！”的情况，即使它们被积极使用。

　　但是，可以使用批量编辑选项“编辑分类”自行设置分配，这将使您将来更轻松地维护数据库。

　　推荐：Hummingbird Pro插件使用教程WordPress速度优化插件

WordPress自定义表格

　　每次安装WordPress 时都会默认创建如下WordPress数据库表：

• commentmeta
• comments
• links
• options
• postmeta
• posts
• termmeta
• terms
• term_relationships
• term_taxonomy
• usermeta
• users

　　推荐：Contact Form 7插件教程WordPress设置Contact Form表单插件

插件表

　　以下WordPress数据库表是由 WordPress 插件创建的。该列表按插件名称组织：

　　注意：wp-config.php请注意，这些表不包含 .db文件中指定的数据库前缀。因此，如果您的前缀是，则actionscheduler_logs 可以调用数据库中的表wp_actionscheduler_logs或。

Plugin	Datenbank-Tabellen
AAWP	aawp_lists aawp_products
Action Scheduler ( Rank Math)	actionscheduler_actions actionscheduler_claims actionscheduler_groups actionscheduler_logs
Affiliate Coupons	affcoups_stats
All in One SEO	aioseo_notifications aioseo_posts
All in One WP Security	aiowps_events aiowps_failed_logins aiowps__global_meta aiowps__login_activity aiowps__login_lockdown aiowps__permanent_block
Anycomment	anycomment_email_queue anycomment_likes anycomment_rating anycomment_subscriptions anycomment_uploaded_files
Avatar Privacy	avatar_privacy avatar_privacy_hashes
Amazon Super Assistent (ASA 1)	asa_collection asa_collection_item
ASA 2 Pro	asa2_api_stats asa2_associate_id_set asa2_collections asa2_collections_items asa2_feeds asa2_images asa2_log asa2_proxies asa2_ratings asa2_repo_meta asa2_repo_notifications asa2_repo_queue asa2_shop2tax asa2_templates asa2_tpltranslation
Bloom	et_bloom_stats
Borlabs Cookie	borlabs_cookie_blocked_content_types borlabs_cookie_consent_log borlabs_cookie_content_blocker borlabs_cookie_cookies borlabs_cookie_groups borlabs_cookie_script_blocker borlabs_cookie_statistics
Broken Link Checker	blc_filters blc_instances blc_links blc_synch
Broken Link Status Checker	wplnst_scans wplnst_scans_objects wplnst_urls wplinst_urls_locations wplnst_urls_locations_att wplnst_urls_status
Code Snippets	ms_snippets
Complianz	cmplz_cookiebanners cmplz_cookies cmplz_dnsmpd cmplz_services cmplz_statistics
Cookie Law Info (CookieYes)	cli_cookie_scan cli_cookie_scan_categories cli_cookie_scan_cookies cli_cookie_scan_url cli_scripts
Crelly Slider	crellyslider_elements crellyslider_nonces crellyslider_sliders crellyslider_slides
CSS & JavaScript Toolbox	cjtoolbox_authors cjtoolbox_backups cjtoolbox_blocks cjtoolbox_block_files cjtoolbox_block_pins cjtoolbox_block_templates cjtoolbox_forms cjtoolbox_form_groups cjtoolbox_form_group_parameters cjtoolbox_form_group_xfields cjtoolbox_packages cjtoolbox_package_objects cjtoolbox_parameters cjtoolbox_parameter_typedef cjtoolbox_parameter_typeparams cjtoolbox_plus_block_pintype cjtoolbox_templates cjtoolbox_template_revisions
Data Tables Generator by Supsystic	supsystic_tbl_columns supsystic_tbl_diagrams supsystic_tbl_rows supsystic_tbl_tables
Digimember	digimember_action digimember_action_out_queue digimember_apilog digimember_autoresponder digimember_config_store digimember_counter digimember_download digimember_exam digimember_exam_answer digimember_exam_certificate digimember_has_preview_cache digimember_ipn_in_log digimember_ipn_out_queue digimember_ip_counter digimember_ip_lock digimember_ip_log digimember_lock digimember_log digimember_loginkey digimember_mail_text digimember_notifier_queue digimember_one_time_login digimember_page_product digimember_payment digimember_product digimember_server_cookie digimember_session_store digimember_timer digimember_user digimember_user_product digimember_user_settings digimember_webhook digimember_webpush_message digimember_webpush_queue digimember_webpush_settings digimember_webpush_subscription
Easy Appointments	ea_error_logs
Easy Social Icons	cn_social_icon
Easy Update Manager	eum_logs
Elementor Pro (Formulare)	e_submissions e_submissions_actions_log e_submissions_values
Everest Forms	evf_entries evf_entrymeta evf_sessions
EWWW Image Optimizer	ewwwio_images ewwwio_queue
Ez Form Calculator	ezfc_debug ezfc_files ezfc_forms ezfc_forms_elements ezfc_forms_options ezfc_forms_views ezfc_options ezfc_preview ezfc_submissions ezfc_templates
Ezoic	ezoic_endpoints
Facebook Comments Importer	fb_comments_image_data
FeedStats de	fs_data fs_visits
Fluent Forms	ff_scheduled_actions fluentform_draft_submissions fluentform_entry_details fluentform_forms fluentform_form_analytics fluentform_form_meta fluentform_logs fluentform_order_items fluentform_submissions fluentform_submission_meta fluentform_subscriptions fluentform_transactions
FooGallery	gallery_albums gallery_pics gallery_settings
Formcraft	formcraft_b_forms formcraft_b_submissions formcraft_b_views
Formidable Forms	frm_fields frm_forms frm_items frm_item_metas
Forminator	frmt_form_entry frmt_form_entry_meta frmt_form_views
Form Maker	formmaker formmaker_backup formmaker_blocked formmaker_cookies formmaker_display_options formmaker_groups formmaker_query formmaker_sessions formmaker_submits formmaker_themes formmaker_views
FV Gravatar Cache	gravatars
FV Player	fv_fp_hls_access_tokens fv_player_players fv_player_videometa fv_player_videos
GD Rating System	gdrts_cache gdrts_itemmeta gdrts_items gdrts_items_basic gdrts_logmeta gdrts_logs
Gravity Forms	gf_addon_feed gf_draft_submissions gf_entry gf_entry_meta gf_entry_notes gf_form gf_form_meta gf_form_revisions gf_form_view rg_form rg_form_meta rg_form_view rg_incomplete_submissions rg_lead rg_lead_detail rg_lead_detail_long rg_lead_meta rg_lead_notes
Header Footer Code Manager	hfcm_scripts
HTML Forms	hf_submissions
Hustle	hustle_entries hustle_entries_meta hustle_modules hustle_modules_meta hustle_tracking
ImagePress	ip_collectionmeta ip_collections
Imagify	imagify_files imagify_folders
Insights from Google PageSpeed	gpi_page_blacklist gpi_page_reports gpi_page_stats
iThemes Security	itsec_lockouts itsec_log itsec_temp
JC Coupon	jcorgcr_categories jcorgcr_coupons
Koko Analytics	koko_analytics_post_stats koko_analytics_referrer_stats koko_analytics_referrer_urls koko_analytics_site_stats
Layer Slider	layerslider layerslider_revisions
Link Whisper	wpil_broken_links wpil_click_data wpil_ignore_links wpil_keywords wpil_keyword_links wpil_keyword_select_links wpil_report_links wpil_target_keyword_data wpil_urls wpil_url_links
Login Lockdown	lockdowns login_fails
MailChimp for WordPress	mc4wp_log
MailOptin	mo_campaign_log mo_campaign_logmeta mo_conversions mo_email_campaignmeta mo_email_campaigns mo_optin_advance_stat mo_optin_campaignmeta mo_optin_campaigns
MailPoet (inklusive alter Wysija-Tabellen)	mailpoet_custom_fields mailpoet_dynamic_segment_filters mailpoet_feature_flags mailpoet_forms mailpoet_log mailpoet_mapping_to-external_entities mailpoet_newsletters mailpoet_newsletter_links mailpoet_newsletter_option mailpoet_newsletter_option_fields mailpoet_newsletter_posts mailpoet_newsletter_segment mailpoet_newsletter_templates mailpoet_scheduled_tasks mailpoet_scheduled_task_subscribers mailpoet_segments mailpoet_sending_queues mailpoet_settings mailpoet_statistics_clicks mailpoet_statistics_forms mailpoet_statistics_newsletters mailpoet_statistics_opens mailpoet_statistics_unsubscribes mailpoet_statistic_woocommerce_purchases mailpoet_stats_notifications mailpoet_subscribers mailpoet_subscriber_custom_field mailpoet_subscriber_ips mailpoet_subscriber_segment mailpoet_user_flags wysija_campaign wysija_campaign_list wysija_custom_field wysija_email wysija_email_user_stat wysija_email_user_url wysija_form wysija_list wysija_queue wysija_subscriber_ips wysija_url wysija_url_mail wysija_user wysija_user_field wysija_history wysija_list
MainWP Dashboard	mainwp_action_log mainwp_bulk_settings_manager_entries mainwp_bulk_settings_manager_previews mainwp_bulk_settings_manager_rings mainwp_bulk_settings_manager_rings_to_entry mainwp_client_report mainwp_client_report_client mainwp_client_report_format mainwp_client_report_site_token mainwp_client_report_token mainwp_domain_monitor mainwp_extract_urls_template mainwp_group mainwp_lighthouse mainwp_maintenance_schedule mainwp_pro_reports mainwp_pro_reports_content mainwp_pro_reports_site_token mainwp_pro_reports_token mainwp_request_log mainwp_tips mainwp_uptime_monitor_urls mainwp_uptime_stats_betteruptime mainwp_uptime_stats_nodeping mainwp_uptime_stats_site24x7 mainwp_uptime_stats_uptimerobot mainwp_uptime_url_options mainwp_users mainwp_vulnerability_checker mainwp_wp mainwp_wp_backup mainwp_wp_backup_progress mainwp_wp_group mainwp_wp_options mainwp_wp_settings_backup mainwp_wp_status mainwp_wp_sync
Master Slider	masterslider_options masterslider_sliders
Matomo	matomo_access matomo_archive_invalidations matomo_archive_numeric_2022_04 matomo_brute_force_log matomo_custom_dimensions matomo_goal matomo_locks matomo_logger_message matomo_log_action matomo_log_conversion matomo_log_conversion_item matomo_log_link_visit_action matomo_log_profiling matomo_log_visit matomo_option matomo_plugin_setting matomo_privacy_logdata_anonymizations matomo_report matomo_report_subscriptions matomo_segment matomo_sequence matomo_session matomo_site matomo_site_setting matomo_site_url matomo_tagmanager_container matomo_tagmanager_container_release matomo_tagmanager_container_version matomo_tagmanager_tag matomo_tagmanager_trigger matomo_tagmanager_variable matomo_tracking_failure matomo_twofactor_recovery_code matomo_user matomo_user_dashboard matomo_user_language matomo_user_token_auth
Media Cleaner	mclean_refs mclean_scan
Mediavine Create	mv_creations mv_images mv_nutrition mv_products mv_products_map mv_relations mv_reviews mv_revisions mv_settings mv_shapes mv_supplies
MemberPress	mepr_events mepr_jobs mepr_members mepr_rule_access_conditions mepr_subscriptions mepr_tax_rates mepr_tax_rate_locations mepr_transactions mepr_transaction_meta
Monarch	et_social_stats
Multi Rating	mr_rating_item mr_rating_item_entry mr_rating_item_entry_value mr_rating_subject
NextGEN Gallery	ngg_album ngg_gallery ngg_pictures
NextScripts	nxs_log nxs_query
Ninja Forms	nf3_actions nf3_action_meta nf3_chunks nf3_fields nf3_field_meta nf3_forms nf3_form_meta nf3_objects nf3_object_meta nf3_relationships nf3_upgrades
Ninja Tables Pro	ninja_table_items
Novashare	novashare_meta
Opt-In Panda	opanda_leads opanda_leads_fields opanda_stats_v2
Portfolio Post Type	crp_portfolios crp_projects
Pretty Links	prli_clicks prli_groups prli_links prli_link_metas
ProfilePress	ppress_coupons ppress_customers ppress_forms ppress_formsmeta ppress_meta_data ppress_ordermeta ppress_orders ppress_plans ppress_sessions ppress_subscriptions
Prosodia VGW OS	wpvgw_markers wpvgw_posts_extras
Rank Math	rank_math_404_logs rank_math_analytics_ga rank_math_analytics_gsc rank_math_analytics_keyword_manager rank_math_analytics_objects rank_math_internal_links rank_math_internal_meta rank_math_redirections rank_math_redirections_cache rank_math_sc_analytics
Rate my Post	rmp_analytics
Real Cookie Banner	rcb_asset_seo_redirect rcb_blocker_thumbnails rcb_consent rcb_presets rcb_revision rcb_revision_independent rcb_scan rcb_scan_markup rcb_stats rcb_tcf_features rcb_tcf_purposes rcb_tcf_special_features rcb_tcf_special_purposes rcb_tcf_stacks rcb_tcf_vendors real_queue
Redirection	redirection_404 redirection_groups redirection_items redirection_logs redirection_modules
ReviewX	reviewx_criterias reviewx_import_history reviewx_process_jobs reviewx_reminder_email
RevSlider	revslider_css revslider_layer_animations revlider_navigations revslider_sliders revslider_slides revslider_static_slides
Simple:Press	sfadversaries sfauthcats sfauths sfbuddies sfcache sfdefpermissions sferrorlog sfforums sfgroups sflog sflogmeta sfmembers sfmemberships sfmeta sfnotices sfoptions sfpermissions sfpmattachments sfpmmessages sfpmrecipients sfpmthreads sfpolls sfpollsanswers sfpollsvoters sfpostattachments sfposts sfroles sfspecialranks sftagmeta sftags sftopics sftrack sfuseractivity sfusergroups sfwaiting sfwarnings
Shortpixel	shortpixel_folders shortpixel_meta
Slider Revolution	revslider_css revslider_layer_animations revslider_settings revslider_sliders revslider_slides revslider_static_slides
Slider WD	wdslayer wdsslide wdsslider
Smart Slider	nextend2_image_storage nextend2_section_storage nextend2_smartslider3_generators nextend2_smartslider3_sliders nextend2_smartslider3_sliders_xref nextend2_smartslider3_slides
Smash Balloon Instagram Feed	sbi_feeds sbi_feed_caches sbi_instagram_feeds_posts sbi_instagram_feed_locator sbi_instagram_posts sbi_sources
Smushit	smush_dir_images
Social Share Buttons by Supsystic	supsystic_ss_networks supsystic_ss_projects supsystic_ss_project_networks supsystic_ss_shares supsystic_ss_views
Spyder Spanker	spyders_ip_cache spyders_live
Subscribe to Comments Reloaded	subscribe_reloaded_subscribers
Survey Slam	svs_submits
Swift Performance	swift_performance_warmup
Tablesome	tablesome_records tablesome_table_0 tablesome_table_827
Thirsty Affiliates	ta_link_clicks ta_link_clicks_meta
Thrive Apprentice	tva_ipn_log tva_orders tva_order_items tva_transactions
Thrive Architect	tcb_api_error_log tcb_lp_templates
Thrive Comments	tcm_email_hash tcm_logs
Thrive Headline Optimizer	tho_event_log tho_tests tho_test_items
Thrive Leads	tve_leads_contacts tve_leads_contact_download tve_leads_event_log tve_leads_form_variations tve_leads_group_options tve_leads_saved_group_options tve_leads_split_test tve_leads_split_test_items td_fields td_groups
Thrive Ovation	tvo_activity_log
Thrive Quiz Builder	tqb_event_log tqb_results tqb_results_links tqb_tests tqb_tests_items tqb_users tqb_user_answers tqb_variations
Thrive Ultimatum	tve_ult_designs tve_ult_emails tve_ult_events tve_ult_event_log tve_ult-setings_campaign tve_ult_settings_templates
Toolkit for Elementor	toolkit_gtmetrix
Uji Countdown	uji_counter uji_subscriptions
Visitors Traffic Real Time Statics	ahc_browsers ahc_countries ahc_daily_visitors_stats ahc_hits ahc_keywords ahc_online_users ahc_recent_visitors ahc_refering_sites ahc_searchng_visits ahc_search_engines ahc_search_engine_crawlers ahc_settings ahc_title_traffic ach_visitors ahc_visits_time
weForms	weforms_entries weforms_entrymeta
WooCommerce	wc_admin_notes wc_admin_note_actions wc_category_lookup wc_customer_lookup wc_download_log wc_order_coupon_lookup wc_order_product_lookup wc_order_stats wc_order_tax_lookup wc_product_attributes_lookup wc_product_download_directories wc_product_meta_lookup wc_rate_limits wc_reserved_stock wc_tax_rate_classes wc_webhooks woocommerce_api_keys woocommerce_attribute_taxonomies woocommerce_downloadable_product_permissions woocommerce_log woocommerce_order_itemmeta woocommerce_order_items woocommerce_payment_tokenmeta woocommerce_payment_tokens woocommerce_sessions woocommerce_shipping_zones woocommerce_shipping_zone_locations woocommerce_shipping_zone_methods woocommerce_tax_rates woocommerce_tax_rate_locations
Wordfence	wfBlockedIPLog wfBlocks7 wfConfig wfCrawlers wfFileChanges wfFileMods wfHits wfHoover wfissues wfKnownFileList wfLiveTrafficHuman wfLocs wfLogins wfls_2fa_secrets wfls_settings wfNotifications wfPendingIssues wfReverseCache wfSNIPCache wfTrafficRates
WordLift	wl_mapping wl_mapping_property wl_mapping_rule wl_mapping_rule_group wl_relation_instances
WordPress Advanced Bulk Edit	wpmelon_wadvbedit_temp
WordPress File Upload	wfu_dbxqueue wfu_log wfu_userdata
WP All Export	pmxe_exports pmxe_google_cats pmxe_posts pmxe_templates
WPBackItUp	wpfm_backup
WP Business Directory Pro	wpbdp_fees wpbdp_form_fields wpbdp_listing_fees wpbdp_payments wpbdp_payments_items wpbdp_submit_state
wpDataTables	wpdatatables wpdatatables_columns wpdatatables_rows wpdatatable_1 wpdatatable_2
wpDiscuz	wc_avatars_cache wc_comments_subscription wc_feedback_forms wc_follow_users wc_phrases wc_users_rated wc_users_voted
WP Download Manager	ahm_assets ahm_country ahm_coupons ahm_download_stats ahm_emails ahm_licenses ahm_orders ahm_order_items ahm_order_renews ahm_payment_methods ahm_refunds ahm_withdraws
wp Hosting Performance Check	webpages_data
WPML	icl_cms_nav_cache icl_content_status icl_core_status icl_flags icl_languages icl_languages_translations icl_locale_map icl_message_status icl_mo_files_domains icl_node icl_reminders icl_strings icl_string_batches icl_string_packages icl_string_pages icl_string_positions icl_string_status icl_string_translations icl_string_urls icl_translate icl_translate_job icl_translations icl_translation_batches icl_translation_downloads icl_translation_status
WP Optimize	wpai_blocks wpai_settings
WP Recipe Maker	wprm_analytics wprm_ratings
WP Reviews	mts_wp_reviews
WP Rocket	wpr_rucss_resources wpr_rucss_used_css
WP RSS Aggregator	wprss_logs
WP Search Insights	searchinsights_archive searchinsights_single
WP Security Audit	wsal_metadata wsal_occurrences wsal_options
wpSEO	WP_SEO_404_links WP_SEO_Cache WP_SEO_Redirection WP_SEO_Redirection_LOG
WP Staging	wpstg_queue
WP Statistics	statistics_exclusions statistics_historical statistics_pages statistics_search statistics_useronline statistics_visit statistics_visitor statistics_visitor_relationships
WP ULike	ulike ulike_activities ulike_comments ulike_forums ulike_meta
XML Sitemap Generator	xsg_sitemap_meta
Yoast	yoast_indexable yoast_indexable_hierarchy yoast_migrations yoast_primary_term yoast_seo_links yoast_seo_meta
YARPP – Yet Another Related Posts Plugin	yarpp_related_cache
YASR – Yet Another Stars Rating	yasr_log yasr_log_multi_set yasr_multi_set yasr_multi_set_fields yasr_multi_values
Yoast SEO	yoast_indexable yoast_indexable_hierarchy yoast_migrations yoast_primary_term yoast_prominent_words yoast_seo_links yoast_seo_meta
YOP Poll	yop2_pollmeta yop2_polls yop2_poll_answermeta yop2_poll_answers yop2_poll_bans yop2_poll_custom_fields yop2_poll_logs yop2_poll_questionmeta yop2_poll_questions yop2_poll_results yop2_poll_templates yop2_poll_votes_custom_fields pollsa pollsip pollsq
YumPrint	yumprint_recipe_recipe yumprint_recipe_theme yumprint_recipe_view
Zip Recipes	amd_zlrecipe_recipes

　　以下数据库表是由 WordPress 题创建的WordPress数据库WordPress数据库：

Theme	Datenbank-Tabellen
affiliatetheme.io	aws_feed at_price_trend
Avada	fusion_forms fusion_form_entries fusion_form_fields fusion_form_submissions

　　推荐：如何手动清理WordPress数据库

常问问题

　　推荐：[最新版]MailPoet Pro高级插件WordPress电子邮件插件

　　推荐：Swift Performance插件教程WordPress缓存性能优化插件