Xaprb

Stay curious!

How much network traffic does your MySQL server receive?

with 12 comments

This is a quick informal poll. I’d like to know how much network traffic your server receives (not sends), in bytes per second. Give both avg and max if you have them. I’m especially interested in hearing about big, heavily loaded systems.

I’ll start things off: just by looking at a couple of customer systems, I see one customer’s server is at 56k and 79k per second. Another slightly larger one is pulling 76k average and 200k max. A third who pushes the systems really hard is doing 1020k/second average and 1408k/sec max.

What about you? Get your friends at big enterprises to say how much traffic they get, too. Let’s get a broad look at how much traffic comes into big workhorse MySQL servers.

Written by Xaprb

November 22nd, 2008 at 5:22 pm

Posted in SQL

Tagged with ,

« An alternative to the MySQL Query Analyzer
Google Code rocks my world »

12 Responses to 'How much network traffic does your MySQL server receive?'

Subscribe to comments with RSS or TrackBack to 'How much network traffic does your MySQL server receive?'.

  1. Around 3mbit/sec inbound all day here.

    2 x dual core IBM x3655 server, 32GB RAM, 6 x 15k RPM SAS drives. 200ish threads connected. 2k questions/second. 192GB Data

    Volcane

    22 Nov 08 at 6:13 pm

  2. All numbers average/day
    server1:
    282,000 Bps (~ 1k/question)
    HP Proliant 4x dual core AMD, 32GB RAM
    12x 15K SCSI - 300GB data
    280 questions/sec 300 threads
    server 2:
    131,000 Bps (~1k/question)
    HP Proliant 4x dual core AMD, 20GB RAM
    6x 15K SCSI - 200GB data
    130 questions/sec 30 threads

    tessein

    22 Nov 08 at 6:56 pm

  3. Inbound avg 141.86Mbit/s, peak: 196.63Mbit/s
    Queries avg: 7650/s, peak: 11118/s

    Sun X4600 4 x Opteron 8220, 64Gb RAM and 30 x 15k FC SCSI

    Matte

    22 Nov 08 at 8:02 pm

  4. Each of our partitions has about 3Mbit/sec incoming for 2/3 of the day. It idles at about 1Mbit/sec for about 1/3 of the day. Each db server is on an Amazon EC2 4x box.

    I can send a snapshot of our metrics chart if you’re interested.

    MikeD

    22 Nov 08 at 8:26 pm

  5. We do about 350KB/s avg. Max is somewhere between 1.5 and 2.0MB/s I think (Innotop doesn’t list it, and I’m too lazy to find it elsewhere ;)

    rhesa

    22 Nov 08 at 8:42 pm

  6. We are about at 530.1k/s, ~1000 query/s.

    HP ProLiant BL460c, 1xQuadCore Xeon E5345@2.33GHz, 8G RAM

    safari

    22 Nov 08 at 9:53 pm

  7. From an email someone sent me:

    About 3500k/second on average, peaks at 4900k/second which is pretty high versus the figures in your blog post. It’s not a particularly busy master *however* we log 300-400 devices syslog into MySQL plus all of our Apaches send their access_log and error_log for entry too.

    Xaprb

    22 Nov 08 at 10:24 pm

  8. MySQL 5.0 master traffic on a dual AMD 2216, 16 GB, 4 disk 15K SCSI RAID-10:

    outgoing: 8.2 Mbps avg (35 Mbps max)
    incoming: 4.5 Mbps avg (24 Mbps max)

    Range is last 7 days.

    James Byers

    22 Nov 08 at 11:22 pm

  9. HP ProLiant DL380G5，4G RAM ,4 disk 15K SCSI RAID-10.
    sql queries avg 459/s,traffic avg 908kb/s

    wayne

    23 Nov 08 at 2:52 am

  10. One of our MySQL 5.0 master servers is doing a max of 48Mbps in and out (almost symmetric network traffic). This is a Dual QC Intel Xeon L5420 @ 2.50GHz with 8GB of RAM and 4 disk 15k SAS RAID-10.

    Spil Games

    24 Nov 08 at 4:10 am

  11. HP DL385 G2 dual core Opteron 2.2, 4G RAM, 5×72GB 15K SAS RAID-5 + 1.
    964 QPS.
    Outgoing: 3 Mbps (4.2 max)
    Incoming: 6.2 Mbps (15.7 max)

    Jason R

    24 Nov 08 at 11:34 am

  12. Dell PowerEdge R900
    32GB RAM
    4 x Intel Xeon E7320 2.13GHz, Model 15 Stepping 11

    MySQL - Bandwith:
    IN: avg 200 kBps (300 kBps)
    OUT: avg 3 MBps (5 MBps)

    Queries: avg 800 Qps (1200 Qps)

    Felix Borchers

    25 Nov 08 at 5:36 am

Leave a Reply