• Resolved Darko G.

    (@darkog)


    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 ASC

    Disabling 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)
  • Plugin Support Joe

    (@joemc)

    @darkog thanks for pointing this out. You must have a lot of users!

    I have released an update (v3.0.6) that moves the author query to an on-demand api call instead of on page load. I also tightened up the conditionals for loading Post Duplicator scripts so they only load on edit list and post edit screens.

    Check it out when you get a chance and let me know if your site performance is better.

Viewing 1 replies (of 1 total)

You must be logged in to reply to this topic.