MySQL traffic - Programmers Heaven

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

MySQL traffic

compukatcompukat Posts: 18Member
I was wondering if anyone new how much of a load a MySQL database could hold. I have a pretty big web project in mind and I expect to see a lot of traffic interfacing with it. Can MySQL handle it, or should I seek another database?

Does anyone know where I can find reliable documentation on this topic? I went to MySQL.com, but I did not find anything.

Thanks
Kat

Comments

  • JonathanJonathan Posts: 2,914Member
    : I was wondering if anyone new how much of a load a MySQL database
    : could hold. I have a pretty big web project in mind and I expect to
    : see a lot of traffic interfacing with it. Can MySQL handle it, or
    : should I seek another database?
    It depends what you mean by a lot. It holds up fine under a system I run that can generate over 30 queries a second at peak load, but I know it can go much further than this and compared to some systems mine is pretty small!

    : Does anyone know where I can find reliable documentation on this
    : topic? I went to MySQL.com, but I did not find anything.
    This page may help:-
    http://www.mysql.com/information/benchmarks.html

    From what I've heard it is very capable, with optimisation, of handling thousands of queries a second and hunderds, if not thousands of concurrent connections. It all depends on how much time you can spend optimising it. I think you'll need something pretty big before you start to hit trouble though.

    Jonathan

    ###
    ('Is Perl Just Another Hack?' =~ /^w+ (w+) (w+) (w+)(er) (w+)?$/) and print "$2 $3$4 $1 $5$4";
    ###
    http://www.incrahost.com/ :: Great Hosting!
    ###

Sign In or Register to comment.