• 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?

#1
Hello,

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:

Code:
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.

Thanks
 

CTXMedia

Formerly CyclingTribe
#2
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:
#3
Just reboting mysql server a few hours ago :) so here is the full result:

Code:
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).