Linux 软件免费装
Banner图

Optimize Database after Deleting Revisions

开发者 cageehv
nerdpressteam
更新时间 2024年8月13日 22:56
PHP版本: 5.6 及以上
WordPress版本: 6.6
版权: GPLv2 or later

标签

optimize database delete revisions database size database cleanup delete unused tags

下载

1.1 1.0.2 1.0.4 2.7.6 4.4.1 4.4.2 4.7.3 4.8.3 4.8.4 4.7.1 5.0.8 1.1.1 1.1.2 1.1.3 1.1.4 1.1.5 1.1.6 1.1.7 1.1.8 1.1.9 1.2 1.3.1 1.3.2 2.0 2.1 2.2 2.2.1 2.2.2 2.2.3 2.2.5 2.2.6 2.2.7 2.3.1 2.4 2.4.1 2.4.2 2.5 2.5.1 2.6 2.7.1 2.7.2 2.7.3 2.7.4 2.7.5 2.7.7 2.7.8 2.7.9 2.8 2.8.1 2.8.2 2.8.3 2.9 3.0 3.1 3.1.1 3.1.2 3.1.3 3.1.4 3.2 3.2.1 3.3 3.3.1 3.4 3.4.1 3.4.2 3.4.4 3.4.5 3.4.7 3.4.8 3.4.9 3.5 3.5.1 4.0 4.0.1 4.0.2 4.0.3 4.1 4.1.10 4.1.2 4.1.3 4.1.4 4.1.5 4.1.6 4.1.7 4.1.8 4.1.9 4.2.0 4.2.2 4.4 4.4.3 4.5 4.5.2 1.0.5 2.2.4 4.3.1 5.0.2 5.0.9 5.1.1 1.3 4.8.5 4.8.6 4.8.7 4.8.8 4.9 4.9.1 5.0 5.0.1 4.2.3 4.3.2 4.5.1 4.7.2 5.1 1.0 1.0.1 1.3.3 1.3.4 2.2.9 3.4.6 4.1.1 4.6.1 4.8.0 4.8.2 5.0.10 5.0.3 5.0.4 5.2 5.2.2 1.0.3 2.2.8 2.3 2.7 4.2.1 4.3 4.6 4.6.2 4.6.3 4.7.4 4.8.1 5.0.5 5.0.6 5.0.7 5.2.1

详情介绍:

NerdPress has adopted Optimize Database After Deleting Revisions! Read the announcement here. This plugin is a 'One Click' WordPress database cleaner & optimizer, with precise revision cleanup and flexible scheduling. Main Features Settings You can find the settings page in the WP Admin Panel » Optimize Database -or- via the WP Admin Panel » Optimize Database icon (depends on settings) Excluding specific posts/pages from deleting revisions If you want to keep revisions for a specific post/page (no matter what the other settings are), create a custom field named 'keep_revisions' for that post/page and give it the value 'Y' Starting the Analysis / Optimization You can start the Optimization in the WP Admin Panel » Optimize Database. Note: if you use the Scheduler the Optimization will run automatically! Note: you also can click the 'Optimize DB (1 click)' link in the admin bar (if enabled) You can click one of the following buttons: 'Analyze (summary): analyzes the database and gives the count of what will be cleaned 'Analyze (detail): analyzes the database and gives a detailed report of what will be deleted 'Optimize (summary): actually deletes the items and gives the count of what has been deleted 'Optimize (detail): actually deletes the items and gives a detailed report of what has been deleted Multisite Support Running the plug in from a Unix crontab In case you cannot use WPCron, but you can edit the Unix crontab: Create a .php file, in the root directory of your site, with: <?php define('RUN_OPTIMIZE_DATABASE', true); require_once('wp-load.php'); ?> Then, start the .php file from your crontab! Supported languages Disclaimer NO WARRANTY, USE IT AT YOUR OWN RISK! MAKE BACKUPS FIRST!

安装:

Single site Multisite

常见问题:

How can I change the settings of this plugin?

  • Change the settings in the WP Admin Panel » Settings » Optimize Database -or- via the WP Admin Panel » Optimize Database icon (depends on settings)

How do I run this plugin?

  • Go to: Dashboard » Tools &araquo; Optimize Database. Then click the 'Start Optimization'-button -or- via the WP Admin Panel » Optimize Database icon (depends on settings)
  • Click the 'Optimize DB (1 click)' link in the Admin Bar (if enabled)

How do I run the Analyzer?

  • Go to: Dashboard » Tools » Optimize Database and click the 'Analyze Database' button

Why do I see 'InnoDB table: skipped...'?

  • That's because optimizing InnoDB tables is not really efficient, so change the table type to MyISAM to have them being optimized.
  • Update: if you want to optimize your InnoDB tables too, just check the 'Optimize InnoDB tables too' option on the settings page
  • IMPORTANT: optimizing InnoDB tables, might increase the size of the database! However, it will speed up the performance of the database

After I ran the plugin, I got "Total savings since the first run: -64 KB"

  • Sometimes that happens when you optimize InnoDB tables (instead of MyISAM tables). Optimizing InnoDB tables works differently than MyISAM. InnoDB focuses on speed optimization and sometimes it means the database can grow a little.

I scheduled the optimization for 8pm but it runs at 6pm (my local time)

  • The scheduler uses the local time of the web server which can differ from your own local time

The plugin is visible in Main Site Tools but not in my subsites

  • Multisite Support – Install the plugin as Network Administrator (Network Admin » Plugins) – ‘Network Activate’ the plugin – You only can configure and run the plugin on the main network site, but it will optimize ALL the sub-sites too!

更新日志:

5.2.2 [02/07/2024] 5.2.1 [02/05/2024] 5.2 [01/31/2024] 5.1.1 [01/24/2024] 5.1 [08/02/2023] 5.0.10 [10/26/2021] 5.0.9 [08/04/2021] 5.0.8 [08/03/2021] 5.0.7 [07/24/2021] 5.0.6 [07/23/2021] 5.0.5 [07/20/2021] 5.0.4 [02/26/2021] 5.0.3 [11/17/2020] 5.0.2 [11/06/2020] 5.0.1 [09/10/2020] 5.0 [08/14/2020] 4.9.1 [05/17/2020] 4.9 [04/10/2020] 4.8.8 [12/02/2019] 4.8.7 [09/28/2019] 4.8.6 [09/22/2019] 4.8.5 [09/19/2019] 4.8.4 [09/07/2019] 4.8.3 [09/01/2019] 4.8.2 [08/15/2019] 4.8.1 [07/15/2019] 4.8.0 [05/26/2019] 4.7.4 [01/05/2019] 4.7.3 [12/12/2018] 4.7.2 [11/12/2018] 4.7.1 [11/11/2018] 4.7 [11/10/2018] 4.6.3 [08/23/2018] 4.6.2 [06/05/2018] 4.6.1 [06/04/2018] 4.6 [05/08/2018] 4.5.2 [03/21/2018] 4.5.1 [01/29/2018] 4.5 [01/08/2018] 4.4.3 [01/06/2018] 4.4.2 [12/14/2017] 4.4.1 [11/06/2017] 4.4 [08/22/2017] 4.3.2 [08/12/2017] 4.3.1 [08/10/2017] 4.3 [07/24/2017] 4.2.3 [07/05/2017] 4.2.2 [04/06/2017] 4.2.1 [09/23/2016] 4.2.0 [09/16/2016] 4.1.10 [07/15/2016] 4.1.9 [07/15/2016] 4.1.8 [06/24/2016] 4.1.7 [06/23/2016] 4.1.6 [05/20/2016] 4.1.5 [03/11/2016] 4.1.4 [03/02/2016] 4.1.3 [02/22/2016] 4.1.2 [02/14/2016] 4.1.1 [01/17/2016] 4.1 [01/14/2016] 4.0.3 [12/17/2015] 4.0.2 [11/28/2015] 4.0.1 [11/27/2015] 4.0 [11/22/2015] 3.5.1 [11/01/2015] 3.5 [10/24/2015] 3.4.9 [10/23/2015] 3.4.8 [09/14/2015] 3.4.7 [08/30/2015] 3.4.6 [06/21/2015] 3.4.5 [06/07/2015] 3.4.4 [06/03/2015] 3.4.3 [06/01/2015] 3.4.2 [05/10/2015] 3.4.1 [04/26/2015] 3.4 [04/24/2015] 3.3.1 [04/08/2015] 3.3 [03/27/2015] 3.2.1 [03/18/2015] 3.2 [03/18/2015] 3.1.4 [03/01/2015] 3.1.3 [02/21/2015] 3.1.2 [02/20/2015] 3.1.1 [02/20/2015] 3.1 [01/29/2015] 3.0 [12/28/2014] 2.9 [10/22/2014] 2.8.3 [09/10/2014] 2.8.2 [08/01/2014] 2.8.1 [07/31/2014] 2.8 [07/30/2014] 2.7.9 [05/02/2014] 2.7.8 [05/01/2014] 2.7.7 [02/16/2014] 2.7.6 [01/16/2014] 2.7.5 [12/13/2013] 2.7.4 [12/11/2013] 2.7.3 [12/09/2013] 2.7.2 [12/09/2013] 2.7.1 [12/09/2013] 2.7 [12/06/2013] 2.6 [07/22/2013] 2.5.1 [05/24/2013] 2.5 [05/24/2013] 2.3.1 [05/03/2013] 2.3 [04/26/2013] 2.2.9 [04/10/2013] 2.2.8 [03/19/2013] 2.2.7 [03/18/2013] 2.2.6 [03/05/2013] 2.2.5 [02/20/2013] 2.2.4 [02/12/2013] 2.2.3 [02/09/2013] 2.2.2 [01/20/2013] 2.2.1 [01/17/2013] 2.2 [01/11/2013] 2.1 [01/04/2013] 2.0 [12/18/2012] 1.3.4 [12/14/2012] 1.3.3 [12/01/2012] 1.3.2 [11/14/2012] 1.3.1 [10/07/2012] 1.3 [10/06/2012] 1.2 [10/03/2012] 1.1.9 [09/27/2012] 1.1.8 [09/08/2012] 1.1.7 [09/03/2012] 1.1.6 [09/01/2012] 1.1.3 [09/01/2012] 1.1.2 [08/30/2012] 1.1 [08/29/2012] 1.0.5 [08/21/2012] 1.0.4 [06/06/2012] 1.0.3 [12/15/2011] 1.0.2 [12/02/2011] 1.0.1 [11/24/2011] 1.0 [11/22/2011]