Battle of best OS for MYSQL # Queries per second vs load?
 

Whats you avg mysql queries per second?

You can post screen shots etc if you like. Will post mine during peak traffic.

Also what OS are you on?

My specs:
x2 Intel xeon Dual core 5140 2.33ghz
Windows Server 2003 SP2
Mysql 5.0.45
3GB RAM
Queries per second average between 100 and 500
CPU usage between 3% and 10% MAX
RAM usage: between 15% and 20 %

Forum stats:
3,000+ members visit per day
1.500+ post per day
100+ New thread per day
600+ new members daily
175,000+ members
Almost 400,000 total posts (pruned)

My mysql is not used by a forum, so it might be a little offtopic here, but you wanted the OS+mysql combination, so I'm going to post it anyway:

Queries per second avg: 983.444

The OS is a 64-bit Linux, mysql 5.0.20 (I know I should upgrade, but it hasn't been stopped for over a year, I don't have the heart to shut it down :)). The machine is a dual-Xeon Intel.

I'm very satisfied with the mysql performance.

- MySQL queries/sec (avg): 325
- page impressions / day: ~150000 (according to Google Analytics - bot-traffic is much higher, of course...)

SuSE Linux, 2 GB RAM, P4 2,4 GHz, MySQL 4.1

Queries per second avg: 830.363

64-bit Linux, mysql 5.0.37, Dual Core 2.4 GHz with 2 GB RAM

2200~ uniq users logging in each day
10k~ unique visits
110K~ Page views
4k~ posts
450~ threds
150-200 new users each day

Threads: 2 Questions: 78104006 Slow queries: 489 Opens: 53922 Flush tables: 1 Open tables: 1024 Queries per second avg: 55.247

linux

this is akin to starting a thread called "how fast does your modded civic do zero to 60?".

the words loadbalancing, postgresql and clustering come to mind...