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

[edan]

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:

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]

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

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

 

[edan]

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

 

[CTXMedia]

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

 

[RobParker]

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

Damn europeans

 

[edan]

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

Yes! I though.... LOL

Thanks,

 

[p4guru]

LOL that's what you get for living on the other side of the world