MainWP Blog - database

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 Continue reading the post...

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 Continue reading the post...

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 Continue reading the post...