Re: Innodb in production

2003-12-15 Thread Jeremy Zawodny
On Mon, Dec 15, 2003 at 10:13:44AM -0500, Nicolas Ross wrote: > Hi ! > > Our db server has about 140+ db's for a total of about 1.5 gigs of data. > > Some while ago, for a specific DB, I did testing using transaction tables > with bdb. This was a bad experience. I ran into some problems and I had

Re: Innodb in production

2003-12-15 Thread Eduardo D Piovesam
h.J. Koeleman" <[EMAIL PROTECTED]> To: "'Eduardo D Piovesam'" <[EMAIL PROTECTED]> Sent: Monday, December 15, 2003 1:38 PM Subject: RE: Innodb in production > How are you doing backups??? > > > -Original Message- > From: Eduardo D Piovesam [ma

Re: Innodb in production

2003-12-15 Thread Eduardo D Piovesam
> Is innodb stable enough to use un mass production environement ? Yes, it's. We use it on a 24x7 system (replicated), with 20GB w/no issues. We're using 4.0.16 on NetWare6.5. Eduardo - Original Message - From: "Nicolas Ross" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, De

Re: Innodb in production

2003-12-15 Thread Chris Nolan
InnoDB is extremely stable! I have a single InnoDB database that's currently holding about 20GB (with about 95% of that in a single table). All of this database is contained inside a single InnoDB tablespace file. In the last 12 months, the only command I've thrown at it by hand was "ALTER TABL