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

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

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

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

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

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

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

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

如何使用列表

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

1、创建数据库备份

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

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

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

2、打开PHPMyAdmin和插件列表

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

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

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

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

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

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

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

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

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

  注意:该列表显示所有不带前缀的表名称。上例表中的前缀是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或。

PluginDatenbank-Tabellen
AAWPaawp_lists
aawp_products
Action Scheduler
( Rank Math)
actionscheduler_actions
actionscheduler_claims
actionscheduler_groups
actionscheduler_logs
Affiliate Couponsaffcoups_stats
All in One SEOaioseo_notifications
aioseo_posts
All in One WP Securityaiowps_events
aiowps_failed_logins
aiowps__global_meta
aiowps__login_activity
aiowps__login_lockdown
aiowps__permanent_block
Anycommentanycomment_email_queue
anycomment_likes
anycomment_rating
anycomment_subscriptions
anycomment_uploaded_files
Avatar Privacyavatar_privacy
avatar_privacy_hashes
Amazon Super Assistent (ASA 1)asa_collection
asa_collection_item
ASA 2 Proasa2_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
Bloomet_bloom_stats
Borlabs Cookieborlabs_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 Checkerblc_filters
blc_instances
blc_links
blc_synch
Broken Link Status Checkerwplnst_scans
wplnst_scans_objects
wplnst_urls
wplinst_urls_locations
wplnst_urls_locations_att
wplnst_urls_status
Code Snippetsms_snippets
Complianzcmplz_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 Slidercrellyslider_elements
crellyslider_nonces
crellyslider_sliders
crellyslider_slides
CSS & JavaScript Toolboxcjtoolbox_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 Supsysticsupsystic_tbl_columns
supsystic_tbl_diagrams
supsystic_tbl_rows
supsystic_tbl_tables
Digimemberdigimember_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 Appointmentsea_error_logs
Easy Social Iconscn_social_icon
Easy Update Managereum_logs
Elementor Pro (Formulare)e_submissions
e_submissions_actions_log
e_submissions_values
Everest Formsevf_entries
evf_entrymeta
evf_sessions
EWWW Image Optimizerewwwio_images
ewwwio_queue
Ez Form Calculatorezfc_debug
ezfc_files
ezfc_forms
ezfc_forms_elements
ezfc_forms_options
ezfc_forms_views
ezfc_options
ezfc_preview
ezfc_submissions
ezfc_templates
Ezoicezoic_endpoints
Facebook Comments Importerfb_comments_image_data
FeedStats defs_data
fs_visits
Fluent Formsff_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
FooGallerygallery_albums
gallery_pics
gallery_settings
Formcraftformcraft_b_forms
formcraft_b_submissions
formcraft_b_views
Formidable Formsfrm_fields
frm_forms
frm_items
frm_item_metas
Forminatorfrmt_form_entry
frmt_form_entry_meta
frmt_form_views
Form Makerformmaker
formmaker_backup
formmaker_blocked
formmaker_cookies
formmaker_display_options
formmaker_groups
formmaker_query
formmaker_sessions
formmaker_submits
formmaker_themes
formmaker_views
FV Gravatar Cachegravatars
FV Playerfv_fp_hls_access_tokens
fv_player_players
fv_player_videometa
fv_player_videos
GD Rating Systemgdrts_cache
gdrts_itemmeta
gdrts_items
gdrts_items_basic
gdrts_logmeta
gdrts_logs
Gravity Formsgf_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 Managerhfcm_scripts
HTML Formshf_submissions
Hustlehustle_entries
hustle_entries_meta
hustle_modules
hustle_modules_meta
hustle_tracking
ImagePressip_collectionmeta
ip_collections
Imagifyimagify_files
imagify_folders
Insights from Google PageSpeedgpi_page_blacklist
gpi_page_reports
gpi_page_stats
iThemes Securityitsec_lockouts
itsec_log
itsec_temp
JC Couponjcorgcr_categories
jcorgcr_coupons
Koko Analyticskoko_analytics_post_stats
koko_analytics_referrer_stats
koko_analytics_referrer_urls
koko_analytics_site_stats
Layer Sliderlayerslider
layerslider_revisions
Link Whisperwpil_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 Lockdownlockdowns
login_fails
MailChimp for WordPressmc4wp_log
MailOptinmo_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 Dashboardmainwp_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 Slidermasterslider_options
masterslider_sliders
Matomomatomo_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 Cleanermclean_refs
mclean_scan
Mediavine Createmv_creations
mv_images
mv_nutrition
mv_products
mv_products_map
mv_relations
mv_reviews
mv_revisions
mv_settings
mv_shapes
mv_supplies
MemberPressmepr_events
mepr_jobs
mepr_members
mepr_rule_access_conditions
mepr_subscriptions
mepr_tax_rates
mepr_tax_rate_locations
mepr_transactions
mepr_transaction_meta
Monarchet_social_stats
Multi Ratingmr_rating_item
mr_rating_item_entry
mr_rating_item_entry_value
mr_rating_subject
NextGEN Galleryngg_album
ngg_gallery
ngg_pictures
NextScriptsnxs_log
nxs_query
Ninja Formsnf3_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 Proninja_table_items
Novasharenovashare_meta
Opt-In Pandaopanda_leads
opanda_leads_fields
opanda_stats_v2
Portfolio Post Typecrp_portfolios
crp_projects
Pretty Linksprli_clicks
prli_groups
prli_links
prli_link_metas
ProfilePressppress_coupons
ppress_customers
ppress_forms
ppress_formsmeta
ppress_meta_data
ppress_ordermeta
ppress_orders
ppress_plans
ppress_sessions
ppress_subscriptions
Prosodia VGW OSwpvgw_markers
wpvgw_posts_extras
Rank Mathrank_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 Postrmp_analytics
Real Cookie Bannerrcb_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
Redirectionredirection_404
redirection_groups
redirection_items
redirection_logs
redirection_modules
ReviewXreviewx_criterias
reviewx_import_history
reviewx_process_jobs
reviewx_reminder_email
RevSliderrevslider_css
revslider_layer_animations
revlider_navigations
revslider_sliders
revslider_slides
revslider_static_slides
Simple:Presssfadversaries
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
Shortpixelshortpixel_folders
shortpixel_meta
Slider Revolutionrevslider_css
revslider_layer_animations
revslider_settings
revslider_sliders
revslider_slides
revslider_static_slides
Slider WDwdslayer
wdsslide
wdsslider
Smart Slidernextend2_image_storage
nextend2_section_storage
nextend2_smartslider3_generators
nextend2_smartslider3_sliders
nextend2_smartslider3_sliders_xref
nextend2_smartslider3_slides
Smash Balloon Instagram Feedsbi_feeds
sbi_feed_caches
sbi_instagram_feeds_posts
sbi_instagram_feed_locator
sbi_instagram_posts
sbi_sources
Smushitsmush_dir_images
Social Share Buttons by Supsysticsupsystic_ss_networks
supsystic_ss_projects
supsystic_ss_project_networks
supsystic_ss_shares
supsystic_ss_views
Spyder Spankerspyders_ip_cache
spyders_live
Subscribe to Comments Reloadedsubscribe_reloaded_subscribers
Survey Slamsvs_submits
Swift Performanceswift_performance_warmup
Tablesometablesome_records
tablesome_table_0
tablesome_table_827
Thirsty Affiliatesta_link_clicks
ta_link_clicks_meta
Thrive Apprenticetva_ipn_log
tva_orders
tva_order_items
tva_transactions
Thrive Architecttcb_api_error_log
tcb_lp_templates
Thrive Commentstcm_email_hash
tcm_logs
Thrive Headline Optimizertho_event_log
tho_tests
tho_test_items
Thrive Leadstve_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 Ovationtvo_activity_log
Thrive Quiz Buildertqb_event_log
tqb_results
tqb_results_links
tqb_tests
tqb_tests_items
tqb_users
tqb_user_answers
tqb_variations
Thrive Ultimatumtve_ult_designs
tve_ult_emails
tve_ult_events
tve_ult_event_log
tve_ult-setings_campaign
tve_ult_settings_templates
Toolkit for Elementortoolkit_gtmetrix
Uji Countdownuji_counter
uji_subscriptions
Visitors Traffic Real Time Staticsahc_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
weFormsweforms_entries
weforms_entrymeta
WooCommercewc_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
WordfencewfBlockedIPLog
wfBlocks7
wfConfig
wfCrawlers
wfFileChanges
wfFileMods
wfHits
wfHoover
wfissues
wfKnownFileList
wfLiveTrafficHuman
wfLocs
wfLogins
wfls_2fa_secrets
wfls_settings
wfNotifications
wfPendingIssues
wfReverseCache
wfSNIPCache
wfTrafficRates
WordLiftwl_mapping
wl_mapping_property
wl_mapping_rule
wl_mapping_rule_group
wl_relation_instances
WordPress Advanced Bulk Editwpmelon_wadvbedit_temp
WordPress File Uploadwfu_dbxqueue
wfu_log
wfu_userdata
WP All Exportpmxe_exports
pmxe_google_cats
pmxe_posts
pmxe_templates
WPBackItUpwpfm_backup
WP Business Directory Prowpbdp_fees
wpbdp_form_fields
wpbdp_listing_fees
wpbdp_payments
wpbdp_payments_items
wpbdp_submit_state
wpDataTableswpdatatables
wpdatatables_columns
wpdatatables_rows
wpdatatable_1
wpdatatable_2
wpDiscuzwc_avatars_cache
wc_comments_subscription
wc_feedback_forms
wc_follow_users
wc_phrases
wc_users_rated
wc_users_voted
WP Download Managerahm_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 Checkwebpages_data
WPMLicl_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 Optimizewpai_blocks
wpai_settings
WP Recipe Makerwprm_analytics
wprm_ratings
WP Reviewsmts_wp_reviews
WP Rocketwpr_rucss_resources
wpr_rucss_used_css
WP RSS Aggregatorwprss_logs
WP Search Insightssearchinsights_archive
searchinsights_single
WP Security Auditwsal_metadata
wsal_occurrences
wsal_options
wpSEOWP_SEO_404_links
WP_SEO_Cache
WP_SEO_Redirection
WP_SEO_Redirection_LOG
WP Stagingwpstg_queue
WP Statisticsstatistics_exclusions
statistics_historical
statistics_pages
statistics_search
statistics_useronline
statistics_visit
statistics_visitor
statistics_visitor_relationships
WP ULikeulike
ulike_activities
ulike_comments
ulike_forums
ulike_meta
XML Sitemap Generatorxsg_sitemap_meta
Yoastyoast_indexable
yoast_indexable_hierarchy
yoast_migrations
yoast_primary_term
yoast_seo_links
yoast_seo_meta
YARPP – Yet Another Related Posts Pluginyarpp_related_cache
YASR – Yet Another Stars Ratingyasr_log
yasr_log_multi_set
yasr_multi_set
yasr_multi_set_fields
yasr_multi_values
Yoast SEOyoast_indexable
yoast_indexable_hierarchy
yoast_migrations
yoast_primary_term
yoast_prominent_words
yoast_seo_links
yoast_seo_meta
YOP Pollyop2_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
YumPrintyumprint_recipe_recipe
yumprint_recipe_theme
yumprint_recipe_view
Zip Recipesamd_zlrecipe_recipes

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

ThemeDatenbank-Tabellen
affiliatetheme.ioaws_feed
at_price_trend
Avadafusion_forms
fusion_form_entries
fusion_form_fields
fusion_form_submissions

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

常问问题

哪些数据库表属于我的多站点

对于多站点,WordPress Core 创建新表,例如:
wp_blogs
wp_blogs-versions
wp_registration_log
wp_signups
wp_site
wp_sitemeta
此外,还会为第二个网站创建特定于页面的表,例如wp_2_postswp_2_postmeta

哪些 WordPress 插件占用大量数据库空间?

一般来说,WordPress 插件会占用大量数据库空间来记录网站访问者或其操作。这包括:
WordPress cookie 插件(例如 Borlabs Cookie)
统计插件
联系表单插件
潜在客户生成插件(例如 Thrive Leads)
记录状态代码的插件(例如 301 重定向或排名数学)
但其他类型的插件也会占用大量数据库空间,例如:
图像优化插件(例如 EWWW Image Optimizer)

每个WordPress插件都会创建自己的数据库表吗?

并非每个 WordPress 插件都会创建自己的数据库表。许多插件还将数据存储在现有表中,例如wp_postswp_optionspostmeta

WordPress 需要多少个数据库?

每个 WordPress 都需要一个数据库。但是,多个 WordPress 安装可以共享数据库,无论是作为单独的网站还是作为多站点。

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

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

给文章评分

Claude、Netflix、Midjourney、Chatgpt Plus账号购买,ChatGPT API购买,优惠码XDBK,用户购买的时候输入优惠码可以打95折

Chatgpt-Plus注册购买共享账号
Kinsta-free-hosting主机
Kinsta-free-hosting主机
Elementor可视化创建WordPress网站
Elementor可视化创建WordPress网站
滚动至顶部