What are WordPress trash comments and how to clean them?

A trash comment is a comment that you have deleted from your WordPress site and have been moved to the trash. A trash comment is not visible in your site and should be deleted forever. You can either use our plugin Advanced Database Cleaner to clean-up these trash comments or execute the following SQL code…

What are WordPress spam comments and how to clean them?

A WordPress spam comment is a comment that you (or a plugin like Akismet) have marked as spam. You can either use our plugin Advanced Database Cleaner to clean-up these spam comments or execute the following SQL code (which is used by the plugin) directly via your phpMyAdmin: DELETE FROM comments WHERE comment_approved = ‘spam’

What are WordPress pending comments and how to clean them?

Pending comments are comments published by users and which are waiting for your approval before appearing in your site. In some cases, you will have to clean all these comments. You can either use our plugin Advanced Database Cleaner to clean-up these comments or execute the following SQL code (which is used by the plugin)…

What are WordPress auto-drafts and how to clean them?

WordPress automatically saves your post (or page) while you are editing it. This is called WordPress auto-draft. If you don’t hit the publish/update button, then the post/page will be saved as auto-draft and any modification to your post/page will not be visible in your public site. Over time, you could have multiple auto-drafts that you…

What are WordPress revisions and how to clean them?

WordPress stores a record called revision of each saved draft or published update. This system allows you to see what changes were made in each post and page over time. However, as you use WordPress, this can lead to a lot of unnecessary overhead in your WordPress database, which consumes a lot of space and…

Is it safe to clean orphan WordPress scheduled tasks?

A scheduled task enables plugins to execute some actions at specified times, without having to manually execute code at that time. WordPress itself uses some scheduled tasks to perform some regular actions. However, some scheduled tasks may not be removed even if the responsible plugins are deleted from your WordPress installation. As you know, not…

What does mean “Optimize my WordPress database”?

Optimizing your WordPress database will reclaim unused space in your tables, which will reduce storage space and improve efficiency when accessing tables. Optimizing the database can sometimes significantly improve performance, particularly on sites that receive a lot of traffic or have a large amount of content. Moreover, optimizing your database is absolutely safe. Use our…

Is it safe to clean-up my WordPress database?

It is always safe to clean-up your WordPress database if you use the appropriate tools. Our plugin Advanced Database Cleaner does not run any code that can break down your site or delete your posts, pages, comments, etc. However, either by using our plugin or other ones, we advise you to always make a database…