[rt-users] Re: InnoDB questions

[Rick Ellis]

Hi Brent,

Not dumb questions at all

RT is using Innodb tables. We have observed on several occasions now
that even shutting down mysql cleanly, using mysqladmin shutdown, the
Innodb files sometimes get corrupted, resulting in us losing all data. I
now do a mysqldump every hour because I have no faith in the database
back-end.

These dumps have been used in anger to recover everything up to the last
save and get us up and running quickly.

We are using the settings from the .cnf files, customised to the two
machines RT is running on.

Hope this helps.

Rik

Message: 7
> Date: Tue, 30 Mar 2004 15:19:55 -0700
> From: "Brent Wiese" <brently at bjwcs.com>
> Subject: [rt-users] InnoDB question... Maybe lame
> To: <rt-users at lists.fsck.com>
> Message-ID: <20040330221956.IYOX2451.fed1mtao07.cox.net at SAMBA>
> Content-Type: text/plain;	charset="us-ascii"
> 
> I have little knowledge of InnoDB, so I apologize in advance if this ends up
> being a dumb question.
> 
> First, how do I know if RT is using InnoDB tables right now? I'm running
> 4.0.14. There are ibdata files and such.
> 
> Second, if I am using them and decide I want to tune them by using the
> different settings in the my-{small|large|huge}.cnf files, I've noticed in
> the past mysql complains when I restart. I usually have to delete the ibdata
> files and then restart. Is that safe?
> 
> Third, I assume doing a mysqldump of the DB will give me everything,
> including what would be in those tables, so I know my backups are complete?
> 
> I'm still reading thru the link I've been seeing floating around here:
> http://www.innodb.com/ibman.php
> 
> So no need to provide. ;)
> 
> Thanks in advance for answering probably simpleton questions...
> 
> Brent

-- 
Rick Ellis <Richard.Ellis at Sun.COM>