Question 2564 in Wordpress Question posted in
The official Wordpress documentation can be found here.

Woocommerce_log too big database folder – WordPress

I can’t find answers to my question so I’m doing it. My site’s database occupies 10.9 Gb of which 10.5 is the woocommerce_log folder, what can I do?? Can older logs be deleted? Is there a problem with the configuration?

Tags:

2

Answers


  1. 0

    post_meta (in WordPress or WooCommerce) is inefficiently indexed. Suggest you add this plugin: WP Index Improvements

    More discussion: http://mysql.rjweb.org/doc.php/index_cookbook_mysql#speeding_up_wp_postmeta

    (Deleting unused data from any big table rarely helps as much as improving the indexes.)

    Login or Signup to reply.
  2. 0

    Folder and Database are 2 different things.

    10.5 is the woocommerce_log folder

    You’ve mentioned folder but wrote the table name so it’s confusing if you’re talking about folder or database table.

    however, if you are talking about the folder with the path wp-content/uploads/wc-logs then yes you can delete all the files with the extension .log

    if you’re talking about database table wp_woocommerce_log then generally it should be empty unless your log handler is set to DB. you can empty data from this table as well. but don’t delete the table.

    You also need to look in wp-config.php if you have defined a logger using constant WC_LOG_HANDLER you should use a file logging system instead of DB.

    You can find more details on the WooCommerce logger on this page. https://developer.woocommerce.com/2017/01/26/improved-logging-in-woocommerce-2-7/

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search