From: kevin lyda (kevin+dated+1032348360.db782c at domain ie.suberic.net)
Date: Fri 13 Sep 2002 - 12:26:25 IST
On Fri, Sep 13, 2002 at 11:52:44AM +0100, Niall James O'Higgins wrote:
> I use it for lots of stuff...one of my tables just went over 2Gb in
> size, no problem for it.
aw. how cute.
ok, sorry, i couldn't resist.
we have a mysql system at work. the one table with 20+ million rows
is 3.3gigs, followed by 2.6 and 1.3 gig tables. that first table
grows by about 50megs a week. it's been used in production for over 2
years now. and for over the first year of it's existance it was pretty
much unmaintained. only within the last year did we start running jobs
to optimise the tables and tune the db.
> (And fail to see why everyone touts MySQL as *the* free software db)
i think the fact that we got away for a year without doing any serious
dba type work is pretty amazing.
otoh if you have hardcore db programmers they'll be annoyed that mysql is
missing all the things they drool over - stored procedures and all that.
mysql does offer table types that are acid (another one of those db
programmer things).
as for oracle, well. kate said it all. i think a person buying oracle
in a world where mysql and postgres exist is pretty much criminally
negligent. some companies or applications require it so it just has
to be done, but the fact is that it's total crap. i don't think i can
stress that enough.
kevin
-- kevin at domain suberic.net that a believer is happier than a skeptic is no more to fork()'ed on 37058400 the point than the fact that a drunken man is happier meatspace place: home than a sober one. the happiness of credulity is a http://ie.suberic.net/~kevin cheap & dangerous quality -- g.b. shaw
This archive was generated by hypermail 2.1.6 : Thu 06 Feb 2003 - 13:18:50 GMT