How to Use WP-Optimize

How to Use WP-Optimize

The WP-Optimize database is a medium for storing important information and data. WordPress uses a MySQL database to store various information and data, and this database has a significant role. As the website owner, you must always do backups to secure and keep the database working correctly. The growing blog with continuously updated articles affects the number of tables, so that it will be redundant and cause database overhead in MySQL. You have to regularly perform optimization and delete table data so that the database continues to work correctly.

WordPress has essential features that are very useful for users, such as post revision and auto-draft, which function to keep writing stored or can be returned when a problem occurs while writing (for example, there is a power outage and the laptop also shuts down but the writing in the WordPress editor is not yet saved, then the auto-draft feature will automatically keep your writing). But using this feature also harms the WordPress database because it adds excess size to the database, and you have to empty all the tables to keep the database size low.

Features revisions post or post revision could you limit so that the database does not occur overhead, how to add a single line of code, you can limit post revisions to any revisions 2-3. But if your blog is extensive and continually updated, it will certainly not be effective.To solve the above problems, you can use the easiest and practical way, namely by using the WP-Optimize plugin to clean everything with one click, and you only do it once a month.

You can also like this post: W3 Total Cache

why should you optimize your wordpress database

Why Should You Optimize Your WordPress Database?

Each website with a database can run fast or not depending on how many queries (the calling process data) the database was performed and how long it takes the question. If by any chance, you have been a WordPress user for a long time, your database may be full of useless things such as revised posts, spam comments, trash, new metadata, etc. Database files can also get more significant if you often install plugins to create their tables in your WordPress database.

These files can increase the database’s size and make your site slow, primarily if the code used to retrieve data from the database is inefficient. Cleaning up these data, especially if it’s done for the first time in a long time, can significantly reduce the database’s size. This can improve database performance, speed up the database backup process and reduce disk space usage.

What Is WP-Optimize and the Benefits of Using WP-Optimize?

WP-Optimize is a plugin used to optimize WordPress databases by cleaning useless database tables without needing to enter PHPMyAdmin. And it is a tool that has a wider function than just optimizing database tables. The plugin is also very mobile-friendly. You can use it easily via a smartphone.

WP-Optimize Features

  1. Clean and optimize the database tables from WordPress.
  2. Schedule database cleanings.
  3. Elimination of page and post revisions.
  4. Elimination of unapproved comments, spam located in the trash.
  5. Removal of Akismet metadata from comments.
  6. Removal of other metadata from comments.
  7. Elimination of all trackbacks and pingbacks.
  8. Elimination of temporary options.
  9. Ability to keep the data for a certain number of weeks to clean.
  10. You are viewing statistics for the database table. 
  11. Option to add or remove the WP-Optimize link in the WordPress admin top bar.
  12. Enable cleanup for administrators only.
  13. Enable/disable Trackbacks on published entries.
  14. Activate / Deactivate comments for all published posts.
  15. It is a free plugin.
  16. Some functions are disabled with databases type ” InnoDB.”
how to set up wp-optimize

How to Set Up WP-Optimize

Time needed: 30 minutes.

The first step you should follow is installing and activating WP-Optimize. Please follow the steps below.

  1. Log In

    Log in to your self-hosted WordPress blog using your username and password.

    You can also like this post: What Is Beaver Builder?

  2. Add New

    Once on the Dashboard, hover your computer mouse over the Plugins feature, then click Add New.

  3. Search for WP-Optimize

    In the search box for plugins on the page that appears, type WP-Optimize.

  4. Install

    In the short WP-Optimize description that appears, click Install Now.

  5. Activate Plugin

    Click Activate Plugin to activate WP-Optimize.

Database Optimization

When WP-Optimize is active, it’s time for you to use the plugin to optimize the WordPress blog database. How:

  • Click the WP-Optimize feature,
  • On the Optimizer page that appears, it says Clean-up options and Actions. In Clean-up options, select the options that match the conditions of your blog. Under Actions, choose Optimize database tables. After that, click the Process button.

What You Need to Know

Before we start deleting elements like crazy from the database, we know that we are deleting.

You can also like this post: The Best Blogging Platforms

  • The options that could be dangerous are marked in red, but we will explain all the options quickly so that you get an idea of ​​what you are deleting.
  • Clean up all publication reviews: every time you edit a page or post, a copy of the previous version is created if you have to go back and recover what was previously edited. These reviews remain in the database, taking up space, so do feel free to delete them.
  • Clean auto drafts and publications in the trash: Delete all the pages and posts that are drafts or have in the trash.
  • Delete Spam and Comments in the trash: Delete the trash and the Spam comments from the database.
  • Delete unapproved comments: Delete unapproved comments in WordPress.
  • Remove transient options: Transient options are WordPress configurations, themes, and plugins. These options are automatically regenerated so that the themes and plugins work correctly.
  • They tend to accumulate when you uninstall themes and plugins. So delete them if you have a lot because you have uninstalled a lot of themes and plugins.
  • Eliminate Pingbacks and Trackbacks: Without getting too technical, Pingbacks and Trackbacks serve to know if someone links any of our content and to notify other blogs if we link any of their content. They are useful because it allows you to know who links you or who you link to, but you can delete them if you want.
  • Delete the post and comment metadata: delete the “metadata” related to the pages, posts, and comments. It can cause unexpected results on some servers.

NOTICE: Make a copy of the database before cleaning it in case something goes wrong.

Why Should You Use WP-Optimize?

Each website with a database can run fast or not depending on how many queries (the calling process data) the database was performed and how long it takes the question. If by any chance, you have been a WordPress user for a long time, your database may be full of useless things such as revised posts, spam comments, trash, new metadata, etc. Database files can also get more significant if you often install plugins to create their tables in your WordPress database.

These files can increase the database’s size and make your site slow, mainly if the code used to retrieve data from the database is inefficient. Cleaning up these data, especially if it’s done for the first time in a long time, can significantly reduce the database’s size. This can improve database performance, speed up the database backup process and reduce disk space usage.

features of wp-optimize and premium

Features of WP-Optimize and Premium

To use WP-Optimize Premium, please log in to the member’s area and download the latest version of the WP-Optimize plugin in the member’s area. At the time of this post, WP-Optimize Premium was version 3.1.8. Download and install the WP-Optimize plugin as usual via Add New / Add New in the plugin menu in the WordPress admin dashboard. Once WP-Optimize Premium is enabled, the accessible version of WP-Optimize will be automatically disabled.

You don’t need to make many WP-Optimize premium changes because the settings are the same as when using the Free version of WP-Optimize. Still, we recommend that you delete unused images in the Images section of the Unused Images and Dimensions menu. It can find a large number of unnecessary images automatically and in the test web database.

You can also like this post: How to Install an SSL Certificate to WordPress

As a result of using WP-Optimize and Premium: WP-Optimize Premium optimizes our WordPress database, you will find that you have unnecessary image files stored in the database. Since the image files found by WP-Optimize are not in the WordPress media library, the cache system, boot, etc. It is the same as the free version, but there are no unique settings in the premium version. Outstanding with results from speed tests using Google PageSpeed ​​Insights and worth buying and using.

Configuration Explanation

While configuring WP-Optimize, many different items are taken into consideration. There are many optimization settings for revision issues, spam, and redundant comment checks. In the rest of our topic, you can see how you can perform these optimizations in items.

Optimize Database Tables

By using this option, you will reset data and index data in database tables. It will help reduce table size and increase the efficiency of input and output when accessing the database.

Clean All Post Revision

With this method, a revision post will always be created every time we save the post. Both are still in draft form and in the post. So it is excellent to use this method when you have made revisions many times because revisions will always be saved if database optimization is not done.

Clean All Auto Draft Posts and Those That Are in the Trash

Like the previous Post Revision, auto-draft is a post saved when you make a draft. The difference is that auto-draft automatically creates a draft and only one per post-draft.

Remove Spam Comments and Those in the Trash

Spam comments and comments that have been deleted are useless data, so they will take up space in the database. Use this option to remove both.

Remove Unapproved Comments

If you choose to do moderation (filter) for each comment, there will usually be many comments that have not been approved. Use this option if you feel the comment is just spam.

FAQs About WP-Optimize

Can I Use WP-Optimize for Free With the WP Rocket Plugin? 

Smart question! But to be honest, I haven’t tried to combine WP-Optimize Free with WP Rocket. Still, from a temporary conclusion, WP-Optimize is excellent for optimizing our database, while WP Rocket is more about speed performance. But it is best to stick to only one performance plugin if it has nearly the same features.

You can also like this post: How to Unpublish a WordPress Site

Which has a better price, the WP-Optimize Premium or WP Rocket?

Well, this question is difficult to answer in terms of price. WP-Optimize has a much lower price when compared to WP Rocket. If we look at the functions and features, both are plugins to improve our WordPress website’s performance. Still, WP-Optimize prioritizes database optimization with simple and easy settings and not much like WP Rocket. WP Rocket is an optimization plugin that focuses more on speed by relying on complete tweak and optimization features. But both of them have their advantages and disadvantages.

Can I choose the number of features the WP-Optimize offers? 

When you are using the WP-Optimize plugin, you can choose to use all the features it carries or choose just a few of these features.

Is the setting different between WP-Optimize Premium and the free version? 

The WP-Optimize premium settings are the same as when using the Free version of WP-Optimize.

What does the Optimize Database Tables feature offer? 

By using this option, you will reset two parts. Those parts are the reset data and index data in database tables.

WP-Optimize in Short

Like a residence, the database must also be regularly cleaned and tidied up. That way, the database can be free of unused data, and the data search process can run more efficiently. In the end, this can help improve the performance of the database itself. If you are using WordPress, there are many ways you can optimize a database, especially if you know phpMyAdmin and SQL. But with a database optimizer plugin like WP-Optimize, this can quickly be done with just one click. If you are interested in other plugins, make sure to check out our other guide on 10 best WordPress plugins.

We think that you may also be interested in which is our previous post about Digital Marketing.
Click to rate this post!
[Total: 22 Average: 5]
Harold

Posts: 149

Since his early years as an academic, Harold has always been interested in writing, no matter what the subject was. But as years went by, he knew he should be writing about the latest trends in social media. Thus he jumped from academia to the world of social media.

No comments to show.

Your email address will not be published. Required fields are marked *