Default Usermeta Entries for every newly created user?

admin管理员组

文章数量:1122846

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!

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!

• users
• user-meta
• buddypress

Share Improve this question asked Jul 16, 2024 at 6:58 timtim 16488 bronze badges

Add a comment  | 

1 Answer 1

Sorted by: 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.

本文标签： Default Usermeta Entries for every newly created user