Title: Exploding table in MySQL
Last modified: September 1, 2016

---

# Exploding table in MySQL

 *  [Driekes Boutier](https://wordpress.org/support/users/jboutierwebstijl/)
 * (@jboutierwebstijl)
 * [9 years, 11 months ago](https://wordpress.org/support/topic/exploding-table-in-mysql/)
 * Hi there,
 * We are using an multisite set-up with about 400 websites in it. There is one 
   table in the MySQL database that is exploding. How is this possible?
 * [http://www.imgdumper.nl/uploads9/5761178c097c9/5761178a8cdf0-Schermafbeelding_2016-06-15_om_10.53.27.png](http://www.imgdumper.nl/uploads9/5761178c097c9/5761178a8cdf0-Schermafbeelding_2016-06-15_om_10.53.27.png)
 * On this website WooCommerce is active, and within the table i see many transients
   etc.
 * How to fix this?
 * Best regards,
    Driekes

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

 *  [Bob Cristello](https://wordpress.org/support/users/gntmidnight/)
 * (@gntmidnight)
 * [9 years, 11 months ago](https://wordpress.org/support/topic/exploding-table-in-mysql/#post-7479226)
 * WooCommerce is notorious for the way they use transients in their system. One
   of the many ways that WooCommerce uses transients is when building carts that
   could later be abandoned. There are many other uses for transients but this has
   always been one of the primary problems I have had with transients in the past.
 * They can, in certain circumstances, cause your options table to “blow up” as 
   you so eloquently state. Here is a plugin that is supposed to clean up expired
   transients in your system. I hope this helps.
 * [https://wordpress.org/plugins/delete-expired-transients/](https://wordpress.org/plugins/delete-expired-transients/)
 *  Thread Starter [Driekes Boutier](https://wordpress.org/support/users/jboutierwebstijl/)
 * (@jboutierwebstijl)
 * [9 years, 11 months ago](https://wordpress.org/support/topic/exploding-table-in-mysql/#post-7479307)
 * Hi Bob,
 * I have installed the plug-in, but this plug-in only has founded 512 total transients.
   After deleting this transients there were only a few MySQL table rows deleted.
 * It is correct that in this webshop ‘WooCommerce Abandoned Cart’ is activated.
 * Best regards,
    Driekes

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

The topic ‘Exploding table in MySQL’ is closed to new replies.

## Tags

 * [multisite](https://wordpress.org/support/topic-tag/multisite/)
 * [MySQL](https://wordpress.org/support/topic-tag/mysql/)

 * In: [Networking WordPress](https://wordpress.org/support/forum/multisite/)
 * 2 replies
 * 2 participants
 * Last reply from: [Driekes Boutier](https://wordpress.org/support/users/jboutierwebstijl/)
 * Last activity: [9 years, 11 months ago](https://wordpress.org/support/topic/exploding-table-in-mysql/#post-7479307)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics