---
title: "Cleaning up wp_options after WooCommerce 2.5"
description: "Following the recent release of WooCommerce 2.5, on whose new features we already gave you every last detail in yesterday’s entry WooCommerce 2.5 – Dashing Dolphin, it is very important that we thoroughly clean the wp_options table of our database,"
url: https://artprojectgroup.com/cleaning-up-wp_options-after-woocommerce-2-5
date: 2016-01-20
modified: 2023-02-12
author: "Art Project Group"
image: https://artprojectgroup.com/wp-content/uploads/2023/04/woocommerce-blog.webp
categories: ["Tutorials"]
tags: ["MySQL", "phpMyAdmin", "SQL", "WooCommerce", "WordPress plugins"]
type: post
lang: en-US
---

# Cleaning up wp_options after WooCommerce 2.5

Following the recent release of WooCommerce 2.5, on whose new features we already gave you every last detail in yesterday’s entry [WooCommerce 2.5 – Dashing Dolphin](/tag/woocommerce), it is very important that we thoroughly clean the *wp_options* table of our database, since it is packed with WooCommerce session records that are never going to be used from this table again and that have done nothing but needlessly fatten this table, which is the backbone of our WordPress.

After updating dozens of online shop installations running WooCommerce, we have come across really curious cases in which we have been able to delete hundreds of thousands of records, slimming the size of the *wp_options* table by dozens of MB, in some cases exceeding a hundred MB.

### How have we done it?

We have created some simple SQL queries that are going to take care of leaving our WooCommerce installations really optimized. Thanks to these four queries we are going to delete all the records of transients and sessions stored in the *wp_options* table that have caused us so many performance problems on so many installations; lastly, and so that the slimming of the table takes effect, we are going to optimize the table. Specifically the queries we have used are these:

Copy to clipboardSyntax HighlighterDELETE FROM `wp_options` WHERE `option_name` LIKE '%_transient_wc%';
DELETE FROM `wp_options` WHERE `option_name` LIKE '%_transient_timeout_wc%';
DELETE FROM `wp_options` WHERE `option_name` LIKE '%_wc_session%';
OPTIMIZE TABLE `wp_options`;
Remember that you can run these SQL queries from [phpMyAdmin](https://www.phpmyadmin.net/downloads/), [MySQL Workbench](https://dev.mysql.com/downloads/workbench/) or [MySQL Utilities](https://downloads.mysql.com/archives/utilities/).

Thanks to these small SQL queries you are going to notice a considerable improvement in the performance of your WooCommerce, especially if you have an online shop with a lot of traffic and/or a lot of products, where the result can end up being really spectacular.

If you combine the solution put forward today with the solution put forward in the entry [Do you need to convert your tables from InnoDB to MyISAM?](/do-you-need-to-convert-your-tables-from-innodb-to-myisam) you are going to notice even more performance improvements.

## All in one

We hope this simple solution is useful to you and that it optimizes your online shops as much as possible. If even so you still have performance problems, remember that **APG** can help you get the most out of your WooCommerce installation with our **[All in one](/shop/all-in-one)** service.