Your WordPress website is getting slower and slower because you are because you Too many posts or are running a lot of plug -in?
You may already know that the page speed has been recognized as a key ranking factor for the optimization of search engine today, especially for mobile search:
Today we announced that starting in July 2018, the speed of the page will become a ranking factor for mobile search. – Google website administrator center blog
The database performance is one of the most important factor affecting the speed of the page.
Optimized WordPress database
Old style method
:
Log in to your network custody control panel (such as CPANEL).
- Log in to PHPMYADMIN.
- check all
-
In the drop -down list, selectOptimize Table -
Find and select the database to be optimized.
Select all tables by clicking
.
.
To accelerate your WordPress site without PHP and MySQL skills,
The fastest and simplest method
is the
database optimization plug -in.
Database optimization and operation are essential to manage the data on the WordPress website. In order to manage data appropriately on the WordPress website and increase speed, it is very important to have these tools, especially when editing posts, pages, etc. in batches. It is important to use some database cleaner that can optimize WordPress. It is very important to choose a plug -in to provide at least trouble when optimizing the database.
If you do not have the budget of the high WordPress plug -in, there are a large number of excellent and completely free WordPress database optimization plug -in.
The following is the first 5
The latest and completely free
database optimization plug -in, you can choose to clean up and optimize the database and accelerate your WordPress website. enjoy.
最初于2018 年3 月19 日发布，于2022 年3 月12 日更新
[123 ]
1. WP-Optimization
Total volume: 1,000,000+[123 [123 ]
Five-star rating: 1,700+ WP-Optimize is an effective tool for automatic cleaning WordPress database in order to so It runs at the highest efficiency.
Features: Delete all unnecessary data (such as deleted/unruly/unprepared/outdated data) and pingbacks, trackbacks and expired Temporary Options
Use the button compression/organize the MySQL table
Detailed control of the optimization you want to execute execute per week (or other) automatic cleaning
- in the place Reserve a certain weekly data during the cleanup
- Show database statistics and potential saving
- Mobile friendly and easy to use
- Translate into a variety of languages \u200b\u200b
You can perform optimization without running a manual query
through the updraftplus (https://updraftplus.com.com) automatic trigger pre -optimized backup
more information and
2. Delete the optimized database after the revision [ 123]
-
Total volume: 100,000+
Five -star rating: 170+
A popular \”one -click\” plug -in for cleaning up and optimizing your WordPress database. Features:
Delete posts, pages, and/or custom posts (you can choose to retain the latest revision of the number of \”X\”, you can choose to delete the revision earlier … Pages and comments (optional) Delete garbage comments (optional)
Delete the unused label (optional)
Delete \”expired or all transients\” ( Optional)
Delete \”PingBacks\” and \”Trackbacks\” (optional)
Delete the \”Orphan Postmeta Project\”
- Optimized database table (optional land, you can follow from you from from Optimize some tables, even specific posts/pages)
- Create optimized log files (optional)
- Optimization can be arranged automatically once an hour, twice a day, daily a day, daily a day Run once or once a week (optional)
- The \”Optimized Database (1 Click)\” link (optional)
- More information and
- [ 123]
The \”Optimized Database \”Icon (optional)
Multisite compatible: One -click optimization of all sites in the network
3. wp-sweep
Total volume: 100,000+ Five -star rating: 100+
A WordPress plug -in, focusing on deleting useless data Clean up your WordPress website, such as revision, automatic drafts, deleted comments, unspeakable comments, spam comments, deleted comments, isolated posts, isolated comments, isolated user elements, isolated terms, isolated terms, isolated terminology Relationships, unused terms, repeated post elements, repeated comment elements, duplicate user elements, duplicate term elements, transient options, optimized database tables, and O embedded in the cache in the post element.
More information and
4.wp-dbmanager
Total : 100,000+
Five -star rating: 80+
This is a oneMulti -purpose WordPress plug -in can be used to backup, optimize and repair databases.
The plug -in will automatically create a folder called a database backup to ensure that all the most important files are stored in a separate area for recovery. However, most of the cleansing options of this plug -in at home are the smallest. It is more suitable for recovery and management.
More information and 5. Advanced database cleaner
] Total : 80,000+
Five -star rating: 960+
This plugin was created by Younes JFR created It performs many automatic inspections to complete a comprehensive database cleanup. You may be surprised to find that your database is filled with a series of old drafts, unsolved spam comments, and so on.
This cleansor can regularly remove almost all aspects of these batch files, and these files are not good for your website. This is one of the most advanced database cleaning programs available on the WordPress network. Various functions it performs usually requires users to spend several hours.
Features:
-
Delete the post and the old version of the page
Delete the old draft of the post and the page
- Delete Old automatic draft
Delete the comments to be treated
Delete spam comments
Delete spam comment Delete the isolated postmeta Delete delete The isolated comment Yuan
Delete the isolation relationship Delete the transient source of the isolated instrument board You can choose the item you want to clean up
You can arrange the database to clean up Optimize the database with automatic operation
to improve the speed of the website
You can arrange your database optimization automatic operation View and clean the CRON mission (plan task)
- ] View and clean up table
- View and clean up the options
- Support multi -site installation
- more information and
- In the final analysis, database optimization is a complex process. Any plug -in can only do so much, which is why it takes other steps to keep the database as important as possible. This may not be ideal for experienced WordPress users because it involves too many manual steps. But for beginners and those who are not familiar with the extra features of PHP My Admin, this plug -in introduces the world of performance optimization.
- To optimize your website with WordPress plug -in, read our best WordPress SEO plugin and access the SEO part to get more information.
- Evaluation of this article
Conclusion:
]
123]
User comments
5
( 1
vote)
]