Title: DB size explodes
Last modified: July 15, 2024

---

# DB size explodes

 *  Resolved [maaike53](https://wordpress.org/support/users/maaike53/)
 * (@maaike53)
 * [1 year, 8 months ago](https://wordpress.org/support/topic/db-size-explodes/)
 * Whenever I create a staging copy (Im with siteground hosting) my DB size explodes
   over 1000MB, due to your plugin: viw_wpml_mails
 * Live site is fine and usage/storage is normal. Why does this happen?

Viewing 2 replies - 1 through 2 (of 2 total)

 *  [Nukak Asanansi](https://wordpress.org/support/users/nasanansi/)
 * (@nasanansi)
 * [1 year, 8 months ago](https://wordpress.org/support/topic/db-size-explodes/#post-17901904)
 * Hi [@maaike53](https://wordpress.org/support/users/maaike53/),
 * Thanks for reaching out, and I sincerely apologize for the delay in getting back
   to you.
 * The **viw_wpml_mails** table is used by **WP Mail Logging** to store logs of 
   the emails sent from your site. When you create a staging site, all the data 
   from your live site is copied, including the email logs. It’s possible that this
   duplication is causing a huge increase in your database size on the staging site.
 * Here are a few steps you can take to resolve this:
 * 1. **Clear Old Email Logs**: Before creating your staging site, you can clear
   old logs to reduce the size of the viw_wpml_mails table.
   To do this, go to **
   WP Mail Logging** > **Settings**. Under the **Log Rotation** section, configure
   the plugin to automatically delete logs older than a certain period or after 
   a certain number of emails have been logged. ([https://a.supportally.com/i/QCw92C](https://a.supportally.com/i/QCw92C)).
   This will help keep the table size manageable.
 * 2. **Exclude the viw_wpml_mails Table from Staging**: If your staging tool allows
   it, exclude the viw_wpml_mails table from being copied to the staging site. This
   will prevent the large table from bloating your staging database. Then your staging
   site can begin accumulating its own email logs.
 * I hope this helps. Thanks 🙂
    -  This reply was modified 1 year, 8 months ago by [Nukak Asanansi](https://wordpress.org/support/users/nasanansi/).
    -  This reply was modified 1 year, 8 months ago by [Nukak Asanansi](https://wordpress.org/support/users/nasanansi/).
    -  This reply was modified 1 year, 8 months ago by [Nukak Asanansi](https://wordpress.org/support/users/nasanansi/).
 *  [trevellfr](https://wordpress.org/support/users/trevellfr/)
 * (@trevellfr)
 * [1 year, 7 months ago](https://wordpress.org/support/topic/db-size-explodes/#post-17992227)
 * Hi [@nasanansi](https://wordpress.org/support/users/nasanansi/),
 * When the rotation is done ? Indeed I set a limit now and I want to know how many
   times this will work.
 * Thx,

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘DB size explodes’ is closed to new replies.

 * ![](https://ps.w.org/wp-mail-logging/assets/icon-256x256.jpg?rev=2562296)
 * [WP Mail Logging](https://wordpress.org/plugins/wp-mail-logging/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/wp-mail-logging/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/wp-mail-logging/)
 * [Active Topics](https://wordpress.org/support/plugin/wp-mail-logging/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wp-mail-logging/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wp-mail-logging/reviews/)

 * 2 replies
 * 3 participants
 * Last reply from: [trevellfr](https://wordpress.org/support/users/trevellfr/)
 * Last activity: [1 year, 7 months ago](https://wordpress.org/support/topic/db-size-explodes/#post-17992227)
 * Status: resolved