Being able to easily delete auto-draft posts, post revisions, spam comments, trashed comments can be a pain to be able to remove that bloat out of your child sites database. There is a very simple plugin that can easily help in deleting that bloat out of your database and it is called Sparkle. After you have installed and activated the Sparkle plugin it will add a sub-menu item into the Settings menu in wp-admin; Settings > Sparkle The setting page for Sparkle will show how many auto-draft posts, draft posts, spam comments, and trashed comments that are in the sites
Jetpack is a well-used plugin on a number of sites and has over 5+ million active installs. But will all modules active it can cause extra requests on load as well as adding a number of extra external requests on load. When you uninstall the Jetpack plugin it will not remove any of the 108 created options that will be left in your sites options database table. You can search for the option_name which matches the following option name patterns; _transient_jetpack% _transient_timeout_jetpack_% jetpack_% Once you can then select the option names that match then select those options to be deleted.
Wordfence is well known and heavily used site security plugin but there may times when either a database table that Wordfence uses has been corrupted or you need to delete all of the data that Wordfence created on your site database. Wordfence does have a setting that you can enable to delete tables and data on deactivation it can be found from the following settings page; Wordfence > All Options > General Wordfence Options Wordfence has a plugin that can remove all data easily the plugin is called Wordfence Assistant. The plugin when installed and activated will add a new
Stream is a plugin from XWP which works, but compared to newer security audit plugins such as WP Security Audit Log, it is quite limited. Stream can also bloat the site database, depending on how long logs are being stored by. To reset the database of entries that Stream has created, you can do so from wp-admin; Stream > Settings > Reset Stream Database When you deactivate and delete the Stream plugin, the two custom database tables that the plugin creates will not be removed, unless you click on the uninstall next to the plugin in the plugin list. An
A well-known plugin for logging all emails sent from a site is Email Log. The plugin creates a custom database table for storing the log entries of email set in the database table called; wp_email_log If the email log plugin is used on a site which has a decent amount of activity, where a normal to high number of emails are being sent, then the site database can easily be bloated. Also, when the plugin is deactivated and deleted, the custom database table will not be deleted. Email Log does have an option in the setting where you can remove
If you need a lightweight option for tracking content changes made directly into a site’s database, one plugin which can help is Better Detection. Better Detection is best used In the case where a site might have been hacked, or content for malware was inserted into a site. Once the plugin has been installed and activated, it will add a submenu in wp-admin on; Better Detection Settings The plugin will add two tabs for errors and options. The errors will be in the form of content which has been directly changed in the site’s database, and not from wp-admin. In
VaultPress is a backup plugin, built by Automattic. VaultPress can also cause the site installation to bloat the database for postmeta and option entries. Some of the examples of the bloat will be in these option names, created by the plugin; vaultpress vaultpress_allow_forwarded_for vaultpress_service_ips_external_cidr _vp_ai_ping _vp_config_post_meta_name_ignore _vp_config_should_ignore_files _vp_current_scan _vp_signatures The option name which can cause the most issues is _vp_ai_ping. On some sites, _vp_ai_ping has entries which have been known to bloat the site’s options database table with 300-500MB of data. VaultPress plugin has an option in its settings to delete all VaultPress settings. When the VaultPress plugin is