admin管理员组

文章数量:1291786

I'm having performance issues with my Wordpress site, due to the number of registered users, the wp_usermeta table has almost 70 million rows.

Users do not have access to modify their profile so I have thought about deleting the unnecessary metadata that Wordpress creates when registering a new user. The following rows are created for a normal user:

+----------------------+------------------------------+
| meta_key             | meta_value                   |
+----------------------+------------------------------+
| nickname             | [USER_NICKNAME]              |
| first_name           |                              |
| last_name            |                              |
| description          |                              |
| rich_editing         | true                         |
| syntax_highlighting  | true                         |
| comment_shortcuts    | false                        |
| admin_color          | fresh                        |
| use_ssl              | 0                            |
| show_admin_bar_front | true                         |
| locale               |                              |
| wpe_capabilities     | a:1:{s:10:"subscriber";b:1;} |
| wpe_user_level       | 0                            |
| default_password_nag |                              |
| session_tokens       | [SESSION_DATA]               |
+----------------------+------------------------------+

I have thought of deleting all rows except nickname and session_tokens. Will i have a problem if i do this? Is there a way for Wordpress to not create these rows for new users?

本文标签： databaseIs it safe to delete unnecessary user metadata

版权声明：本文标题：database - Is it safe to delete unnecessary user metadata? 内容由网友自发贡献，该文观点仅代表作者本人， 转载请联系作者并注明出处：http://www.betaflare.com/web/1741540409a2384288.html， 本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。