Linux 软件免费装

在这里免费安装WordPress以及其他软件

Banner图

Index WP Users For Speed

开发者 OllieJones
Ollie Jones
Oliver Jones
更新时间 2025年11月18日 00:41
捐献地址: 去捐款
PHP版本: 5.6 及以上
WordPress版本: 6.9
版权: GPL v2 or later
版权网址: 版权信息

标签

performance users database index largesite

下载

1.0.0 1.0.2 1.0.3 1.1.3 1.1.4 1.1.5 1.1.7 1.1.8 1.1.1 1.1.10 1.1.2 1.1.6 1.0.4 1.1.11 1.0.1 1.1.12 1.1.9 1.2.0

详情介绍:

This plugin speeds up the handling of your WordPress registered users, especially when your site has many thousands of them. (Congratulations! Building a successful site with thousands of users is an accomplishment.) With optimized MySQL / MariaDB database techniques, it finds and displays your users more quickly. Your All Users panel on your dashboard displays faster and searches faster. Your All Posts and All Pages panels no longer lag when displaying. And, you can edit your posts to change authorship more efficiently. Without this plugin WordPress sites with many users slow down drastically on Dashboard pages. It can take many seconds each time you display your Users dashboard panel. It takes just about the same large amount of time to display your Posts or Pages panels. While those slow displays are loading, WordPress is hammering on your site's MySQL or MariaDB database server. That means your site serves your visitors slowly too, not just your dashboard users. And, versions of WordPress since 6.0.1 have dealt with this performance problem by preventing changes to the authors of posts and pages in the Gutenberg editor, the classic editor, and the Quick Edit feature. Those recent versions also suppress the user counts shown at the top of the Users panel. This plugin restores those functions. This plugin helps speed up the handling of those large numbers of users. It does so by indexing your users by adding metadata that's easily optimized by MySQL or MariaDB. For example, when your site must ask the database for your post-author users, the database no longer needs to examine every user on your system. (In database jargon, it no longer needs to do notoriously slow full table scans to find users.) When slow queries are required to make sure the metadata indexes are up to date, this plugin does them in the background so nobody has to wait for them to complete. You can set the plugin to do this background work at a particular time each day. Many people prefer to do them overnight or at some other off-peak time. How can I learn more about making my WordPress site more efficient? This is a companion plugin to Index WP MySQL for Speed. If that plugin is in use, this plugin will perform better. But they are in no way dependent on one another; you may use either, both, or of course neither. I offer several plugins to help with your site's database efficiency. You can read about them here.

安装:

Install and activate this plugin in the usual way via the Plugins panel in your site's dashboard. Once you have activated it, configure it via the Index for Speed menu item under Users. WP-CLI wp plugin install index-wp-users-for-speed wp plugin activate index-wp-users-for-speed Composer If you configure your WordPress installation using composer, you may install this plugin into your WordPress top level configuration with this command. composer require "wpackagist-plugin/index-wp-users-for-speed":"^1.1" Credits

屏幕截图:

  • This plugin's configuration panel.
  • The bulk editor for All Posts showing the selection box with autocompletion of author name.

升级注意事项:

Version 1.2.0 handles discontinuous user ID values. The percent-complete display may be a bit misleading when there are large gaps in those values. Thanks to my loyal users who have reported problems.

常见问题:

Should I back up my site before using this?

Yes. Backups are good practice. Still, this plugin makes no changes to your site or database layout. It adds a few non-autoloaded options, and adds rows to wp_usermeta. = My WordPress host offers MariaDB, not MySQL. Can I use this plugin? Yes. = I have a multi-site WordPress installation. Can I use this plugin? Yes. = I see high CPU usage (load average) on my MariaDB / MySQL database server during user index building or refresh. Is that normal? Yes. Indexing your registered users requires us to insert a row in your wp_usermeta tab;e for each of them. We do this work in batches of 5000 users to avoid locking up your MariaDB / MySQL server. Each batch takes server time. Once all index building or refresh batches are complete, your CPU usage will return to normal. = Can I use this if I have disabled WP_Cron and use an operating system cronjob instead? Yes

What if I assign multiple roles to some users?

Plugins like Vladimir Garagulya's User Role Editor let you assign multiple roles to users. This plugin handles those users correctly.

How does it work? (Geeky!)

Standard WordPress puts a wp_capabilities row in the wp_usermeta table for each user. Its meta_value contains a small data structure. For example, an author has this data structure. array("author") In order to find all the authors WordPress must issue a database query containing a filter like this one, that starts and ends with the SQL wildcard character %. meta_key = 'wp_capabilities' AND meta_value LIKE '%"author"%' Filters like that are notoriously slow: they cannot exploit any database keys, and so MySQL or MariaDB must examine that wp_usermeta row for every user in your site. This plugin adds rows to wp_usermeta describing each user's role (or roles) in a way that's easier to search. To find authors, the plugin uses this much faster filter instead. meta_key = 'wp_index_wp_users_for_speed_role_author' It takes a while to insert these extra indexing rows into the database; that happens with WP_Cron tasks in the background. Once the indexing rows are in place, you can add, delete, or change user roles without regenerating those rows: the plugin maintains them.

How does the plugin handle large numbers of users without timing out?

It performs the indexing for batches of users, each in a separate WP_Cron task. The number of users in a batch defaults to 5000 and can be set, if need be, with the INDEX_WP_USERS_FOR_SPEED_BATCHSIZE variable in wp-config.php. It breaks each batch into chunks of 50 users, by default. That can be set with the INDEX_WP_USERS_FOR_SPEED_CHUNKSIZE variable in wp-config.php.

What is the background for this plugin?

WordPress's trac (defect-tracking) system has this ticket # 38741.

Why use this plugin?

Three reasons (maybe four):

  1. to save carbon footprint.
  2. to save carbon footprint.
  3. to save carbon footprint.
  4. to save people time.
Seriously, the microwatt hours of electricity saved by faster web site technologies add up fast, especially at WordPress's global scale.

更新日志:

1.2.0 Handle non-consecutive wp_user.ID values with large gaps. Control of batch and chunk size is possible in wp-config.php. 1.1.12 Fix incompatibility with https://wordpress.org/plugins/advanced-ads/ . Props to @carlos978. 1.1.11 Fix incompatibility with https://wordpress.org/plugins/co-authors-plus/ .