Critical memory usage issue
-
Looks like your most recent version has memory usage isues that caused our /wp-admin section to use 300mb every hit. I had to disable the plugin for now.
It produces really heavy queries like this:
Name
wp_usermeta SELECT
Duration
413.02 ms
% of transaction
3.74%
Type
db
Subtype
mysql
Action
query
Database statement
SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (4154,6762,7175,9476,10138,2372,2751,3250,8334,12030,11239,6896,3177,9291,7399,6959,8627,10248,5937,12084,4257,600,528,1429,7804,8575,8876,7993,10911,6760,6568,10947,3067,7185,510,619,3007,3013,8175,6676,9132,9309,5708,9266,8424,3742,3678,8571,8696,8476,4289,9455,669,895,208,8974,797,1070,5377,11067,445,11115,1605,5791,7255,4348,10099,6954,9960,10915,9695,2727,4532,9543,3436,1944,11275,8363,3020,5927,11616,8395,5416,1618,51,8726,10618,11450,7530,7919,5310,9042,2712,7638,8281,1872,4238,3287,9097,10118,3057,1318,6243,9809,7659,409,1270,6516,6256,928,708,7528,8130,6717,12016,9593,3333,8507,8135,7961,5363,9678,10342,9679,3569,8943,8677,3630,5489,3000,11353,9831,3195,11906,11730,5783,8217,11217,11893,5904,11530,6922,177,156,673,2531,11325,7394,6328,9028,1840,3284,11596 ............. ) ORDER BY umeta_id ASCDisabling the plugin brought the memory usage from 300MB to just 60MB.
I think this would be helpful for you:
Stack trace
class-wpdb.php in wpdb→query at line 3152
meta.php in wpdb→get_results at line 1189
pluggable.php in update_meta_cache at line 128
class-wp-user-query.php in cache_users at line 886
class-wp-user-query.php in WP_User_Query→query at line 80
user.php in WP_User_Query→__construct at line 862
scripts.php in get_users at line 10
scripts.php in Mtphr\PostDuplicator\get_users_with_edit_caps at line 60
class-wp-hook.php in Mtphr\PostDuplicator\enqueue_scripts at line 326
admin-header.php in do_action at line 123
Viewing 1 replies (of 1 total)
Viewing 1 replies (of 1 total)
You must be logged in to reply to this topic.