0

we have a Buddyboss page running with 30k users. Our usermeta Table is growing fast because of a few plugins we use which all seem to write a lot of settings to it. I try to remove as many obsolete or unneeded Usermeta Entries as possible.

hence my question is: For every newly added user there seem to be a few default WP-based Usermeta entries, this is the meta_key list:

  1. nickname
  2. syntax_highlighting
  3. use_ssl
  4. admin_color
  5. rich_editing
  6. show_admin_bar_front
  7. locale

A Buddyboss/Buddypress user usually never accesses WP-Admin as such - so I guess most of these are irrelevant, isn't it? And even if not, all values are anyhow the same! What do you think?? These alone are already 7*30k = 210k entries (growing the table as well the index by a lot).

Is there any harm removing those? I hope at worst they get re-created...

Thanks!

Improve this question

1 Answer 1

Reset to default
2

I believe it will not create any issue because these are mainly used if the user is accessing the WP Admin but we should done this proper plan by taking the backup of database first and then remove these fields and then testing the website to verify everything working fine or not and if anything goes wrong then just restore the backup.

Improve this answer
2
  • 1
    Maybe I will do one thing: I will just rename those meta_keys. This way, they are kept in the database and can quickly be recovered by renaming back. If everything still works as expected, I will finally remove them from the DB Commented Jul 18, 2024 at 10:43
  • That also looks like the good idea, we can got with this. Commented Jul 18, 2024 at 11:03

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.