Title: This will bloat your SQL Database
Last modified: June 22, 2020

---

# This will bloat your SQL Database

 *  [amykant](https://wordpress.org/support/users/amykant/)
 * (@amykant)
 * [5 years, 11 months ago](https://wordpress.org/support/topic/this-will-bloat-your-sql-database/)
 * This was a legacy plugin for a client’s website… I would not recommend it! It
   bloated our disk usage and one of the tables ended up with 22 million rows.
 * Here are the queries we used to clean things up.
 *     ```
       -- Run first
       delete m
       from wp_posts p
       join wp_postmeta m on p.ID = m.post_id
       where post_type = 'wp-rest-api-log'
   
       -- Run second
       delete
       from wp_posts
       where post_type = 'wp-rest-api-log'
   
       -- Run third
       DELETE wp_term_relationships FROM wp_term_relationships
           LEFT JOIN wp_posts ON wp_term_relationships.object_id = wp_posts.ID
           WHERE wp_posts.ID is NULL;
       ```
   

Viewing 1 replies (of 1 total)

 *  [ensemblebd](https://wordpress.org/support/users/ensemblebd/)
 * (@ensemblebd)
 * [5 years, 10 months ago](https://wordpress.org/support/topic/this-will-bloat-your-sql-database/#post-13119125)
 * Thank you!!!

Viewing 1 replies (of 1 total)

The topic ‘This will bloat your SQL Database’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/wp-rest-api-log.svg)
 * [REST API Log](https://wordpress.org/plugins/wp-rest-api-log/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/wp-rest-api-log/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/wp-rest-api-log/)
 * [Active Topics](https://wordpress.org/support/plugin/wp-rest-api-log/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wp-rest-api-log/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wp-rest-api-log/reviews/)

 * 1 reply
 * 2 participants
 * Last reply from: [ensemblebd](https://wordpress.org/support/users/ensemblebd/)
 * Last activity: [5 years, 10 months ago](https://wordpress.org/support/topic/this-will-bloat-your-sql-database/#post-13119125)