Top-10 Causing Slowness When Clicking “Posts” on Back End

  • Hey,

    This past week, I’ve had a ton of issues with performance on my blog. Those have all been resolved (server improvements, replacing WordFence) but one. When I’m on the back end of Word Press and click “Posts”, it takes a long time to come up. This didn’t used to happen. It might have taken 2-3 seconds before the mess of the past week. My hosting company support stated that when they checked the cause of this specific slowness, this is what they came back with.

    *********************
    The posts page does not load until the last of the queries which is shown below finishes. So these queries involving the wp_vry4pg_top_ten_daily
    ====
    SELECT postnumber, SUM(cntaccess) as visits FROM wp_vry4pg_top_ten_daily WHERE postnumber = 35712 AN
    ====
    *********************

    There were 2.1M rows in that table, so I let maintenance run to truncate it down to 431K. But, the slowness is still there, just not quite as severe.

    None of the front-end pages are experiencing slowness. And if I’m editing, there’s no slowness. So I’m wondering why wp_vry4pg_top_ten_daily getd queried when I click “Posts”. And is there anything I can do settings-wise (or the like) to help improve things beyond the truncation?

    The page I need help with: [log in to see the link]

Viewing 8 replies - 1 through 8 (of 8 total)
  • Plugin Author Ajay

    (@ajay)

    Can you please try going to Counter Tracker and disable Page Views in admin to see if this makes a difference.

    I suspect it’s because the query runs for each post on the Admin screen which is causing this issue.

    Can you also check that there is an index in wp_vry4pg_top_ten_daily

    Thread Starter AstroNerdBoy

    (@astronerdboy)

    Can you please try going to Counter Tracker and disable Page Views in admin to see if this makes a difference.

    You are correct. Unchecking that immediately solved the problem.

    Can you also check that there is an index in wp_vry4pg_top_ten_daily

    This is where my ignorance of DB stuff comes into play. How do I check this?

    Plugin Author Ajay

    (@ajay)

    If you open up wp_vry4pg_top_ten_daily in phpMyAdmin and go to Structure, it will show you that there is a PRIMARY index for “post number,dp_date,blog_id”

    There are also buttons in the Tools page to recreate these, but please backup your database before doing so.

    Thread Starter AstroNerdBoy

    (@astronerdboy)

    Sorry for the extremely long delay! I got busy once things started working and forgot to come back here. Naturally, if I’m coming back here, a new issue has arisen. Whenever I when to my site’s back in (wp-admin) from the front end, the site would choke down hard. My hosting company believes it is Top 10 doing it, which was hard to believe, but testing seems to bear that out.

    That aside, there is no index in wp_vry4pg_top_ten_daily. It says “No index defined!” I seem to recall this happening once before, a LONG time ago. The option exists to “Create an index on” and then it gives me a number selector for number of columns. So what do I need to do to create the index?

    Plugin Author Ajay

    (@ajay)

    In the Tools page, you should have an option to recreate the primary key for the tables

    https://ps.w.org/top-10/assets/screenshot-10.png?rev=2207639

    As always, I recommended backing up these tables before doing that.

    You also have the option to recreate the entire databases. The lack of the primary key could be the main reason for the slowness.

    Thread Starter AstroNerdBoy

    (@astronerdboy)

    I clicked the button (after a backup) and it says, “Primary Key has been recreated”

    But when I looked for the index, phpMyAdmin still shows no index.

    Update: Doing the recreation of a primary key did not work. When I click the link to go back to wp-admin URL, the site chokes down for several minutes. What my hosting company tells me is that somehow, Top 10 is causing a ton of deadlocks.

    • This reply was modified 2 years, 9 months ago by AstroNerdBoy.
    • This reply was modified 2 years, 9 months ago by AstroNerdBoy.
    Thread Starter AstroNerdBoy

    (@astronerdboy)

    Update: I’ve had Top-10 off and I’m still having deadlocks, though not as severe. That aside, I await your thoughts on the table still not showing an index after recreating the key.

    Plugin Author Ajay

    (@ajay)

    Two things you can try:

    1) Since you’re already in phpMyAdmin, you can run the SQL queries directly to create the PRIMARY KEYs – the ones in the Tools page as per screenshot above.

    2) Hit the recreate tables button – again making sure you’re backed up properly

Viewing 8 replies - 1 through 8 (of 8 total)
  • The topic ‘Top-10 Causing Slowness When Clicking “Posts” on Back End’ is closed to new replies.