usermeta table seems huge
-
One of my WooCommerce sites seems to be using an excessive amount of MySQL Disk Space. This seems to be the wp_usermeta table which is currently using 1.2GB when the total MySQL usage is 2.1GB. This is from 8339 rows.
The site only has 212 users (3 Admin & 209 Customers). Does this usermeta table seem like it’s much larger than it should be?By comparison I have another WooCommerce site with 120 users and the usermeta table size is 420kb with 4039 rows.
I have tried using LiteSpeed Cache database tools to clean up the database (delete trainsients, optimise tables etc). I also used Advanced Database Cleaner. Neither of these plugins flag anything up about the usermeta table.
To me it seems like something huge is being stored in the usermeta table for it to be at 1.2gb. I’m not sure how I can find out what is using all that space! Any help/suggestions gratefully accepted!
-
Howdy @jgdavison
Thank you for reaching out, with a concern on the
usermetatable size in your site’s database.WooCommerce installs some custom tables to store its data during install. More about tables installed:
https://github.com/woocommerce/woocommerce/wiki/Database-DescriptionLinked here is the related documentation page.
Just to clarify, the
_wp_usermetatable is part of the WordPress installation. Feel free to check out the details for it, in the related CODEX page, directly linked here.My suggestion would be to:
- Make a backup of the current installation
- Go ahead with utilizing the WP Reset plugin, for fine-tuning the site’s database contents
I trust that points you in the right direction, but if you have more questions, let us know. We’re happy to help.
The topic ‘usermeta table seems huge’ is closed to new replies.
