I've considered raw filesystem, but it seems a bit difficult, or even impossible, to copy db file to other servers, especially when making replication slave servers. Any not bad means to backup MySQL db using raw filesystem?
-- Chung Ha-nyung <alita@[neowiz.com|kldp.org]> Sayclub <http://www.sayclub.com> NeoWiz <http://www.neowiz.com> > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]] On Behalf Of Harald Fuchs > Sent: Tuesday, October 15, 2002 7:03 PM > To: [EMAIL PROTECTED] > Subject: Re: What is the best suited file system for MySQL w/ InnoDB? > > > In article > <[EMAIL PROTECTED]>, > "Chung Ha-nyung" <[EMAIL PROTECTED]> writes: > > > Among ext3, reiserfs, ext2, and xfs, which one is the best > for MySQL > > w/ InnoDB? > > Since partition size is as small(!) as 60GB, I think that > ext2 could > > be plausible > > choice. But any other journaling filesystem can outperform ext2 in > > using MySQL? > > I'd say you'll get the best performance when using no filesystem or > buffer cache at all. Make your 60G partition a raw device and let > InnoDB use this raw device as its tablespace. > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
