1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

High Handler_read_rnd_next

Discussion in 'Server Configuration and Hosting' started by hellreturn, Dec 13, 2013.

  1. hellreturn

    hellreturn Active Member

    Does anyone has any suggestion on how to fix high:


    For some reason both of my values are high.
  2. Slavik

    Slavik XenForo Moderator Staff Member

    Are you using a lot of addons by any chance?
  3. hellreturn

    hellreturn Active Member

    Nop, only few but I am also using 2 e-Commerce sites on same machine. But I don't get much traffic on it. On same machine I am running:

    One XF
    2 IP.Board
    2 e-Commerce

    Server Specs: Core i7 4700, 32GB RAM, RAID 1.

    Handler_read_rnd_next = 4GB within 10 days. Is that how it's supposed to be? Is it normal?
  4. Slavik

    Slavik XenForo Moderator Staff Member

    Definately not normal.

    Check your slow query log to see if theres anything showing up.
  5. hellreturn

    hellreturn Active Member

    Slow log doesn't have much queries. Only 3 slow queries over the period of 10 days. I am out of clue what's happening.
  6. Slavik

    Slavik XenForo Moderator Staff Member

    No easy answer, put simply you'll have to go digging.

    However I doubt its XF causing the problems.
  7. Tracy Perry

    Tracy Perry Well-Known Member

    I saw numerous references to IP.Board and problems with it when I did some research.

    That (and it's associated add-ons) would be the first place I started investigating.
  8. hellreturn

    hellreturn Active Member

    If you run the forums in debug mod how do you know which query is causing the issue? Is their any way to figure that out? Any pointers on how to figure out the issue?

    I know it's not XF but just looking for general help. Asking for help on IP Board is nothing but futile. Not many people help their over server configuration. Here? Instant help and most of all? People are eager to help.
  9. Slavik

    Slavik XenForo Moderator Staff Member

    Start reducing your slow query time until you start picking up more useful info.

    Your going to be looking for queries that do scans or joins without indexes, that will be your problem most likely.
  10. hellreturn

    hellreturn Active Member

    I have slow query time of 3 seconds i believe but only few queries logged so far in 10 days. Should I enable logs for queries without indexes? Would that tell me about the queries which I am looking for?

    Thank you!
  11. Slavik

    Slavik XenForo Moderator Staff Member

    Yea, that might fill up quickly though, but give it a shot.

Share This Page