significant admin-ajax requests

  • Hello,

    We’ve been running some New Relic testing on one of our sites to track down issues with performance. Our host has provided information that points to some significant admin-ajax calls they say might be related to PO.

    Per the host support:

    “seeing some 8-10 second requests to admin-ajax.php due to Plugin Organizer… seems to be causing some long admin-ajax requests.”

    “just scrolled through the trace details, and it looks like it’s just making tons of the database queries to wp_posts… a lot of SELECT queries on wp_posts.”

    Looking at their info is seemed like a lot, like thousands during that hour. Maybe this is an expected thing, maybe I’ve got something set up wrong (although I’ve used PO since like v 6.x without much issue), I honestly don’t know, but I told them you were very responsive and I’d pass it along to see if there was something more to it.

    Of note, we ran some NR testing a few weeks back, before updating to PO v 10.+ and this issue didn’t show at that time. Maybe not related, but mentioning.

    So I guess my questions would be:

    Is this an expected occurrence?

    Might it be we have something misconfigured?

    Or if not, is there anything we can do about it?

    Thanks.

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Jeff Sterup

    (@foomagoo)

    It’s hard to say what is causing that without knowing what the queries are. My guess is that you are setting plugins by post type. That would generate a lot of queries to the posts table and can take a significant amount of time to complete. Can you give me some more detail on what the queries are?

    Thread Starter majecdad

    (@majecdad)

    I’ll see what else support can provide. But, yes, we had a number of post-type settings where we used PO – I think nine total with the standard ones and some CPT’s. I didn’t realize that using PO to selectively load on the different post types would affect it like this, so I have reconfigured a couple of types to remove them from being enabled on the PO settings page.

    There are still seven types where we are using “Custom Post Type Support” – probably five of these are really important to use PO to help resolve conflicts.

    I’m just going to remove those CPT’s with nominal post counts where I am using PO for performance convenience and just instead load everything on those. I’ll see what happens there.

    I also reconfigured another plugin that was making a number of ajax requests.

    Hoping the combination of all of the above resolves these issues.

    Thanks for your timely reply.

    Plugin Author Jeff Sterup

    (@foomagoo)

    The only part that would create queries to the posts table is if you edit the list of plugins using the post type plugins page. When you click save it has to go through all the different posts. Normal operation would not generate queries to the posts table. Like someone visiting your site. So if you weren’t editing the post types then it wouldn’t have been PO that caused it. Nothing in the MU plugin (which does all the disabling) does a query on the posts table.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘significant admin-ajax requests’ is closed to new replies.