MainWP Blog - database

If your site is using the MailOptin plugin which is used for lead generation, email automation, and newsletters. It is recommended to use a solid well built external platform for email automation and sending out newsletters than using a plugin that can cause performance issues on your site and cause database bloat. MailOptin WordPress Plugin The plugin will store data using the following custom database tables; wp_mo_campaign_log wp_mo_campaign_logmeta wp_mo_conversions wp_mo_email_campaignmeta wp_mo_email_campaigns wp_mo_optin_campaignmeta Wp_mo_optin_campaigns When the plugin is deactivated and deleted Continue reading the post...

With Spring coming up sooner than you would think now is a good time to make sure that your site’s database has been optimized. One of the newest plugins for database optimization is called SweepPress. The plugin uses SQL-optimized queries to find the data in the site’s database and then remove it. The free version of the SweepPress plugin supports the following database optimization options; Posts: Auto Drafts Posts: Spam Content Posts: Trashed Content Posts: Posts Revisions Posts: Posts Orphaned Continue reading the post...

Removing bloat that is being stored in your site’s database can help improve your site’s performance and it is worth taking the time to make sure that you perform database optimization weekly or at least monthly. If you have added tags on your posts or on products in WooCommerce in the past, then chances are high that there are some tags that you do not use anymore but they are still part of your site’s database. An easy plugin option Continue reading the post...

The AMP project from Google might be killed off in the future. Currently, the official AMP plugin does not have an uninstall option or a UI to remove posts and options that the plugin will store in the site’s database. The option to search for in phpMyAdmin would be using the following option name; amp-options Then once the AMP option has been found you select and then delete it. To delete the posts that the AMP plugin had created then Continue reading the post...

WordPress uses transients for storing cached short-term data in a sites database within the options database table. Depending on the set of plugins you are using in your plugin stack those plugins can end up bloating your options database table and those transients might not expire correctly. You can check to see how many transients are being stored in your options database table by using phpMyAdmin and then searching for the following option name from the options database table; _transient_% Continue reading the post...

There may be times when you need to change which security plugin on your child site to a different security plugin. In this example, this is going to cover how to remove all of the iThemes Security plugin created custom database tables on your site. All of the iThemes Security plugin created custom database tables; wp_itsec_distributed_storage wp_itsec_fingerprints wp_itsec_geolocation_cache wp_itsec_lockouts wp_itsec_logs wp_itsec_mutexes wp_itsec_opaque_tokens wp_itsec_temp wp_itsec_user_groups The iThemes Security plugin does make it easier than most plugins to remove the created custom Continue reading the post...

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

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

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

Stream is a plugin from XWP which works, but compared to newer security audit plugins such as WP Activity 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 Continue reading the post...