文档章节

WP-Optimize数据库优化

Amamatthew
 Amamatthew
发布于 2014/08/14 16:09
字数 679
阅读 14
收藏 0

WP-Optimize is an extensive WordPress database cleanup and optimization tool. It doesn't require PhpMyAdmin to clean and optimize your database tables.

Please show your support for this plugin by giving it a rating :)

Now hosted at GitHub. I do not monitor wp forums, so use plugins+support(at)ruhanirabin.com for support questions.

Please join GitHub and collaborate.

MAJOR FEATURES:

  • Removal of stale post revisions

  • Removal of stale unapproved and spam comments

  • Removal of trshed comments

  • Mobile device friendly, now you can optimize your site on the go

  • Removal of all trackbacks and pingbacks

  • Cleaning up auto draft posts

  • Removal of transient options

  • Clear out the post trash

  • Automatic cleanup of all the integrated options (also uses retention if enabled)

  • Ability to keep selected number of weeks data when cleaning up

  • Option to add or remove link on wp admin bar.

  • Enable/Disable weekly schedules of optimization

  • Apply native WordPress MySql optimize commands on your database tables without phpMyAdmin or any manual query.

  • Display Database table statistics. Shows how much space can be optimized and how much space has been cleared.

  • Enabled for Administrators only.

All the potentially dangerous clean up options are marked RED.

When you use this plugin for the first time or just updated to major version, make a backup of your database. It is always the best practice to make a database backup before using this program first time.

How this could help you?

  • Every-time you save a new post or pages, WordPress creates a revision of that post or page. If you edit a post 6 times you might have 5 copy of that post as revisions. Imagine if your post or pages are long and big. It is a huge number of bytes that's on your MySQL overhead. Now WP-Optimize allows you to optimize and shrink your posts table by removing not necessary post revisions from the database. As example, if you have a post which is approximately 100KB data and you have 5 revisions of that post, the total space wasted is about 500KB. And if you have 100 posts similar to it, you have 50MB database space wasted.

  • Similar to the scenario described above, there might be thousands of spam and un-approved comments in your comments table, WP-Optimize can clean and remove those in a single click

  • WP-Optimize reports which database tables have overhead and wasted spaces also it allows you to shrink and get rid of those wasted spaces

  • Automatically cleans database every week and respects the "Keeps selected number of weeks data" option.

Are you interested to be a contributed developer of this plugin, join with me at GitHub. Or email plugins(at)ruhanirabin.com

You will be credited inside the plugin screen and the plugin listing at WordPress.

Requirements:

  • WordPress 3.8+

  • PHP 5.1.xx

  • MySql 5.1.xx

Translators are welcome to send their Translated Files to be included.Existing translators should join GitHub to submit their translations too.

Download the RAW .POT file. This is for the translators, who wants to translate to new language.

You can Email translations to plugins(at)ruhanirabin.com

WP-Optimize Translators:


本文转载自:http://wordpress.org/plugins/wp-optimize/

Amamatthew
粉丝 67
博文 1050
码字总数 76443
作品 0
厦门
后端工程师
私信 提问
给wordpess博客的数据库减肥提速

随着wordpress网站的时间越来越久,文章越来越多,大家是不是也感受到自己的wordpress网站的运行速度也随之下降?这是什么原因呢?前面的文章,高时银博客也介绍过一些方法,如:评论头像优化...

hero2019
2018/07/15
12
0
查询mysql表是否被损坏和修复、优化

查询mysql表是否被损坏命令,如下: # CHECK TABLE 表名 mysql的长期使用,肯定会出现一些问题,一般情况下mysql表无法访问,就可以修复表了,优化时减少磁盘占用空间。方便备份。 表修复和优...

Thebreezecomes
2018/06/28
0
0
10 款用于提升 WordPress 性能的插件

WordPress 已经成为最受欢迎的博客以及网站内容管理系统(没有之一),WordPress 最强大的在于其庞大的开发者社区,为 WP 开发出很多的插件,本文向大家介绍 10 款用于提升 WP 性能的插件。 ...

红薯
2011/07/11
1K
4
Innodb数据库优化

简述:由于数据更新比较频繁且数据量增长太快,导致机器磁盘跟不上节奏。已经采用数据库的分库和迁移历史库了。现在对数据的优化操作,减少数据占用磁盘空间,达到节省磁盘空间。 1.利用opt...

amwuqd
2014/02/20
0
0
使用Minify来压缩JS和CSS文件来提高网站性能

最近在访问中遇到了连接数多的情况,我采用的是Minfy来减少连接数,压缩JS和CSS文件,以达到提高性能的目的。 Minify把CSS和JS压缩和削减(Minify:去掉空格回车符等),以及把多个CSS,JS文件...

随风随影
2013/08/19
1K
2

没有更多内容

加载失败,请刷新页面

加载更多

Git ssh配置

生成密钥对 ssh-keygen -t rsa -C "email@email.com"邮箱替换自己邮箱在地址C:\Users\账户\.ssh下,id_rsa、id_rsa.pub两个文件复制文件id_rsa.pub内容到github\gitlab的Settings-> SSH ......

JUKE
29分钟前
5
0
014、使用docker-compose安装软件

创建docker-compose基础目录 mkdir -p /usr/local/docker 1、安装mysql 在/usr/local/docker/目录下创建mysql目录 mkdir -p /usr/local/docker/mysql 在/usr/local/docker/mysql目录编写doc......

北岩
29分钟前
6
0
【并发那些事 】创建线程的三种方式

创建线程可以说是并发知识中最基础的操作了,JDK 提供的创建线程的方式,如果不包括通过线程池的话,目前有三种形式,它们分别是通过继承 Thread 类,通过实现 Runable 接口,通过 FutureTa...

K1W1
35分钟前
7
0
判断链表是否有环

如果列表中不存在环,最终快指针将会最先到达尾部,此时我们可以返回 false。 如果存在环则会相遇。返回true。 Java代码实现: public boolean hasCycle(ListNode head) { if (head == ...

无名氏的程序员
36分钟前
5
0
uni-app 项目记录

await 等候,等待;期待 什么是async、await await 用于等待异步完成 通常async、await都是跟随Promise一起使用的 async返回的都是一个Promise对象同时async适用于任何类型的函数上。这样awa...

达达前端小酒馆
38分钟前
5
0

没有更多内容

加载失败,请刷新页面

加载更多

返回顶部
顶部