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
: 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!
###