Silver CHEN wrote:
> Dear Sir:
> Well, I have trouble on mysql 3.22.2x + freebsd 3.2.
> The question is simple, is this great software suitable for high-
> loading internet environments? I mean, there might be more than 20
> queries in one single second.
We have a system here, that at it's peak hits just over 1,100 _inserts_ per
second (each insert comprises of a number of lookups to find keys + a final
insert operation), so I'd imagine, in a properly designed, spec'd system -
running 20 queries a second (providing they don't have to return very large
result sets) should be easily achievable...
This is on a P2-450 w/512Mb RAM, with FreeBSD 3.2 & MySQL (running with