[wordpress插件] Advanced Database Cleaner先进的数据库清理器

wordpress 插件 文章 2020-02-07 15:40 557 0 全屏看文

AI助手支持GPT4.0

评分

96

96

描述

Clean up database by deleting orphaned items such as ‘old revisions’, ‘spam comments’, optimize database and more…

通过删除孤立的项目来清理数据库,例如“旧修订”,“垃圾评论”,优化数据库等等。

If you have been using WordPress for a while, then you should think absolutely about a database cleanup.

如果您已经使用WordPress一段时间了,那么您应该绝对考虑数据库清理。

Indeed, your database may be full of garbage that makes your site sluggish and bloated such as old revisions, orphaned post meta, spam comments, etc. You should clean-up this unnecessary data to reduce your database size and improve website speed and performance.

确实,您的数据库可能充满了垃圾,使您的网站呆滞并and肿,例如旧的修订版,孤立的帖子meta,垃圾邮件评论等。您应该清理这些不必要的数据,以减小数据库的大小并提高网站的速度和性能。

In addition, you will have quicker database backup since the file of your backup will be smaller.

另外,由于备份文件较小,因此数据库备份速度更快。

‘Advanced Database Cleaner’ is a must-have plugin that allows you to clean database, optimize database and more.

“高级数据库清理程序”是必备插件,可让您清理数据库,优化数据库等等。

Main Features

主要功能

    • Delete old revisions of posts and pages
    • 删除帖子和页面的旧修订版本

    • Delete old auto drafts
    • 删除旧的自动草稿

    • Delete trash posts
    • 删除垃圾帖

    • Delete pending comments
    • 删除待处理的评论

    • Delete spam comments
    • 删除垃圾邮件评论

    • Delete trash comments
    • 删除垃圾评论

    • Delete pingbacks
    • 删除pingbacks

    • Delete trackbacks
    • 删除引用

    • Delete orphan post metadata
    • 删除孤立的帖子元数据

    • Delete orphan comment metadata
    • 删除孤立的评论元数据

    • Delete orphan user metadata
    • 删除孤立的用户元数据

    • Delete orphan term metadata
    • 删除孤立词元数据

    • Delete orphan relationships
    • 删除孤儿关系

    • Delete expired transients
    • 删除过期的瞬变

    • Display and view orphaned information before making a database clean-up so you can be sure about what you are going to clean-up
    • 在清理数据库之前显示和查看孤立的信息,这样您就可以确定要清理的内容

    • Search & filter all items based on their names or values
    • 根据项目的名称或值搜索和过滤所有项目

    • Keep last x days’ data from being cleaned: clean only data older than the number of days you have specified
    • 保留最近x天的数据不被清除:仅清除早于指定天数的数据

    • Schedule database clean up to run automatically
    • 计划数据库清理以自动运行

    • Create as many scheduled cleanup tasks as you need and specify what items should be cleaned by the scheduled task
    • 根据需要创建多个计划的清理任务,并指定计划任务应清理哪些项目

    • Scheduled tasks can be executed based on several frequencies: Once, hourly, twice a day, daily, weekly or monthly
    • 计划的任务可以根据以下几种频率执行:一次,每小时,一天两次,每天,每周或每月

    • Display database tables information such as the number of rows, table size, etc.
    • 显示数据库表信息,例如行数,表大小等。

    • Optimize database tables (The plugin will notify you if any tables require optimization)
    • 优化数据库表(如果任何表需要优化,该插件将通知您)

    • Repair corrupted database tables or damaged ones (The plugin will notify you if any tables are corrupted or damaged)
    • 修复损坏的数据库表或损坏的数据库表(如果任何表已损坏或损坏,插件将通知您)

    • Schedule database optimization and/or reparation to run automatically and specify what tables should be optimized and/or repaired
    • 安排数据库优化和/或修复以自动运行并指定要优化和/或修复的表

    • Empty database tables rows
    • 空数据库表行

    • Clean and delete database tables
    • 清除和删除数据库表

    • Display options list
    • 显示选项列表

    • Display options information such as option name, option value, option size, option autoload
    • 显示选项信息,例如选项名称,选项值,选项大小,选项自动加载

    • Clean and delete options
    • 清洁和删除选项

    • Set options autoload to no / yes
    • 将选项自动加载设置为否/是

    • Display active cron tasks list (scheduled tasks) with their information such as arguments, next run, etc.
    • 显示活动的cron任务列表(计划任务)及其信息,例如参数,下次运行等。

    • Clean and delete scheduled tasks
    • 清理和删除计划任务

    • User-friendly and simple to use
    • 用户友好且易于使用

    Multisite Support

    多站点支持

      • The plugin is compatible with Multisite installations
      • 该插件与多站点安装兼容

      • Only the main site can view, clean and optimize the whole network.

      • 只有主站点可以查看,清理和优化整个网络。

        Other sites in the network cannot perform these tasks.

        网络中的其他站点无法执行这些任务。

        We have opted for this philosophy because we are sure that your DB is precious and only the super administrator can perform such actions

      • 我们之所以选择这种理念,是因为我们确保您的数据库是宝贵的,并且只有超级管理员才能执行此类操作

      • You can clean up all sites from one place (the main site).

      • 您可以从一个位置(主站点)清理所有站点。

        You can also specify specific sites you want to cleanup

      • 您还可以指定要清理的特定站点

      By using the ADC plugin, you will

      通过使用ADC插件,您将

        • Get and overview: The plugin will help you get an overview of what is happening in your database.

          获取和概述:该插件将帮助您概述数据库中正在发生的事情。

          It will report all unused/orphaned items that should be cleaned, it will give you the number of tables/options/tasks you have, etc. This way, you can control your database if anything goes wrong

          它会报告应清除的所有未使用/孤立的项目,并为您提供表/选项/任务的数量等。这样,如果出现任何问题,您就可以控制数据库

        • Save time: You can specify what items should be cleaned/optimizedepaired, what is the number of days’ data to keep and the cleanup/optimizationeparation frequency.

          节省时间:您可以指定要清洁/优化/修理的项目,要保留的天数以及清洁/优化/修复的频率。

          The plugin will then automate the process to run automatically based on your settings

          然后,该插件将根据您的设置自动执行该过程以自动运行

        • Save space: By deleting unused/orphaned items, you will save space in your database and make quicker backups since the file of your backup will be smaller

          节省空间:通过删除未使用/孤立的项目,您将节省数据库空间并加快备份速度,因为备份文件会更小

        Pro Features (Official website)

        Pro功能(官方网站

        Do you know that even after deleting a plugin/theme from your WordPress website, some of its leftovers may remain in your database?

        您知道吗,即使从您的WordPress网站删除了一个插件/主题,它的一些剩余部分仍可能保留在您的数据库中?

        Such as orphan options, orphan tables, and orphan cron tasks.

        例如孤立选项,孤立表和孤立cron任务。

        As you may know, not all plugins/themes care about the housekeeping of your WordPress database.

        如您所知,并非所有插件/主题都关心WordPress数据库的内务处理。

        As long as you are removing plugins/themes, leftovers will be accumulated in your database and will influence your website performance.

        只要您删除插件/主题,剩余的内容就会累积在您的数据库中,并会影响您的网站性能。

        The Pro version of Advanced Database Cleaner will help you remove all those leftovers and perform a deep database clean up.

        专业版的Advanced Database Cleaner将帮助您删除所有剩余的数据并执行深度数据库清理。

        In the pro version you can:

        在专业版中,您可以:

          • Classify options according to their “creator”.

          • 根据选项的“创建者”对选项进行分类。

            They can be either: plugins options, themes options or WP core options

          • 它们可以是:插件选项,主题选项或WP核心选项

          • Detect and delete orphan options.

          • 检测并删除孤立选项。

            Your ‘wp_options’ table may be full of orphaned options and therefore can impact the performance of loading data from it, which may lead to a slow website.

            您的“ wp_options”表可能充满了孤立的选项,因此可能会影响从中加载数据的性能,这可能会导致网站运行缓慢。

            Clean up orphaned options is then important

          • 那么清理孤立的选项很重要

          • Classify tables according to their “creator”.

          • 根据表格的“创建者”对表格进行分类。

            They can be either: plugins tables, themes tables or WP core tables

          • 它们可以是:插件表,主题表或WP核心表

          • Detect and delete orphan tables.

          • 检测和删除孤立表。

            As for options, you may also have some orphaned tables that were created by plugins/themes you are not using anymore.

            至于选项,您可能还会有一些由不再使用的插件/主题创建的孤立表。

            Clean up orphaned tables will decrease the size of your database

          • 清理孤立的表将减少数据库的大小

          • Classify all cron tasks (cron jobs) according to their “creator”.

          • 根据所有cron任务(cron作业)的“创建者”分类。

            They can be either: plugins cron tasks, themes cron tasks or WP core tasks

          • 它们可以是:插件cron任务,主题cron任务或WP核心任务

          • Detect and delete orphan cron jobs.

          • 检测并删除孤立的cron作业。

            After you uninstall a plugin/theme, some of its cron tasks may still be active making WordPress calling unknown functions.

            卸载插件/主题后,其某些cron任务可能仍处于活动状态,从而使WordPress调用未知功能。

            using the pro version, you can detect and clean orphaned tasks

          • 使用专业版,您可以检测并清理孤立的任务

          • Search & filter options, filter tables and filter cron tasks based on several criteria such as the “name”, “creator”, “value”, etc.
          • 基于多个条件(例如“名称”,“创建者”,“值”等)搜索和过滤选项,过滤表以及cron任务。

          • Get premium support: we will provide quick support as well as any technical answers to help you clean up your database efficiently
          • 获得高级支持:我们将提供快速支持以及所有技术解答,以帮助您有效地清理数据库

          Translations

          翻译

          You are welcome to contribute to the plugin translation via the WordPress translation website

          欢迎您通过 WordPress翻译网站为插件翻译做贡献

          .

安装步骤

This section describes how to install the plugin.

本节介绍如何安装插件。

In general, there are 3 ways to install this plugin like any other WordPress plugin.

通常,有3种方法可以像其他任何WordPress插件一样安装此插件。

1.

1。

Via WordPress dashboard

通过WordPress仪表板

    • Click on ‘Add New’ in the plugins dashboard
    • 在插件信息中心中点击“添加新项”

    • Search for ‘advanced-database-cleaner’
    • 搜索“高级数据库清洁器”

    • Click ‘Install Now’ button
    • 点击“立即安装”按钮

    • Activate the plugin from the same page or from the Plugins dashboard
    • 从同一页面或“插件”仪表板激活插件

    2.

    2。

    Via uploading the plugin to WordPress dashboard

    通过将插件上传到WordPress仪表板

      • Download the plugin to your computer from (https://wordpress.org/plugins/advanced-database-cleaner/)
      • 从(https://wordpress.org/plugins/advanced-database-cleaner/)将插件下载到您的计算机

      • Click on ‘Add New’ in the plugins dashboard
      • 在插件信息中心中点击“添加新项”

      • Click on ‘Upload Plugin’ button
      • 点击“上传插件”按钮

      • Select the zip file of the plugin that you have downloaded to your computer before
      • 选择之前已下载到计算机的插件的zip文件

      • Click ‘Install Now’
      • 点击“立即安装”

      • Activate the plugin from the Plugins dashboard
      • 从“插件”面板激活插件

      3.

      3。

      Via FTP

      通过FTP

        • Download the plugin to your computer from (https://wordpress.org/plugins/advanced-database-cleaner/)
        • 从(https://wordpress.org/plugins/advanced-database-cleaner/)将插件下载到您的计算机

        • Unzip the zip file, which will extract the ‘advanced-database-cleaner-3.0.0’ directory
        • 解压缩该zip文件,这将解压缩“ advanced-database-cleaner-3.0.0”目录

        • Upload the ‘advanced-database-cleaner’ directory (included inside the extracted folder) to the /wp-content/plugins/ directory in your web space
        • 将“ advanced-database-cleaner”目录(包含在提取的文件夹中)上传到网站空间中的/ wp-content / plugins /目录中

        • Activate the plugin from the Plugins dashboard
        • 从“插件”面板激活插件

        For Multisite installation

        用于多站点安装

          • Log in to your primary site and go to “My Sites” » “Network Admin” » “Plugins”
          • 登录到您的主站点,然后转到“我的站点”»“网络管理员”»“插件”

          • Install the plugin following one of the above ways
          • 按照上述方法之一安装插件

          • Network activate the plugin (Note that only the main site can have access to the plugin)
          • 网络激活插件(请注意,只有主站点才能访问该插件)

          Where the plugin menu will be displayed?

          将在何处显示插件菜单?

            • The plugin page can be accessed via “Dashboard” » “Tools” » “WP DB Cleaner” or via the left menu “WP DB Cleaner” (You can change this via the plugin settings)
            • 可以通过“仪表盘”»“工具”»“ WP DB Cleaner”或通过左侧菜单“ WP DB Cleaner”访问插件页面(您可以通过插件设置来更改)

下载地址

https://downloads.wordpress.org/plugin/advanced-database-cleaner.3.0.0.zip

https://downloads.wordpress.org/plugin/advanced-database-cleaner.3.0.0.zip

-EOF-

AI助手支持GPT4.0