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

Average 50K DB queries per second, is this normal?

Discussion in 'Server Configuration and Hosting' started by edan, May 2, 2014.

  1. edan

    edan Member


    A few days ago I am migrating my forum to XenForo, previously I use Drupal. Forum runs much faster now, very satisfied with XenForo. But there are little things that bother me, when running the following command:

    mysqladmin -u root -p status
    I find value if my average DB queries per second is 50K, is this normal for XenForo? users online between 500-800 (mostly anonymous). This is relatively new forum, members: 850, Discussions: 5700, Messages: 45K.

    I run it on a dedicated server with 16GB of RAM.

    Forum homepage generation:
    Timing: 0.1563 seconds, Memory: 5.562 MB, DB Queries: 8
    Using "top" command: load average: 0.22, 0.20, 0.21

    For caching backend I use APC.

  2. CyclingTribe

    CyclingTribe Well-Known Member

    Sounds high if you're only running the one forum as described. Can you post the full results so we can take a look. (y)

    For example, I'm running 8 XF forums on a dedicated server (one has 3 million posts and is active 24/7) and my averages are: Per hour: 121.37 k - Per minute: 2.02 k - Per second: 33.71
    Last edited: May 2, 2014
  3. edan

    edan Member

    Just reboting mysql server a few hours ago :) so here is the full result:

    Uptime: 29050  Threads: 4  Questions: 1676091  Slow queries: 4252  Opens: 1283  Flush tables: 1  Open tables: 321  Queries per second avg: 57.696
    I run one Drupal site as the URL shortener for my old forum (now still run).
  4. CyclingTribe

    CyclingTribe Well-Known Member

    That's 57 queries per second not 57 thousand! ;)

    I'm guessing you though the decimal point meant 57,696 (fifty seven thousand six hundred and ninety six)?
    edan and Slavik like this.
  5. RobParker

    RobParker Well-Known Member

    Damn europeans :p
    fEaRz, p4guru and CyclingTribe like this.
  6. edan

    edan Member

    Yes! I though.... LOL

    CyclingTribe likes this.
  7. p4guru

    p4guru Well-Known Member

    LOL that's what you get for living on the other side of the world :)
    Floren likes this.

Share This Page