Greg,
----- Original Message ----- From: "Greg Whalin" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Thursday, February 24, 2005 12:04 AM
Subject: Innodb - raw partition vs filesystem store?
What are pros/cons as far as performance, reliability, and ease of backup/restore?
Anyone have any experience running Innodb on raw partition?
raw partitions are beneficial only in some old OS/hardware configurations where fsync is extremely slow. In most computers, you only get a < 5 % performance improvement from raw partitions.
Any thoughts as to best filesystem for Innodb? What about pros/cons of journaled filesystems when in use with Innodb (i.e. transactions)?
All major Linux file systems seem to have almost the same performance.
How do the recent experiences of LiveJournal/Wikipedia sway these answers?
A journaling file system like ReiserFS does not help if fsync does not work. A journaling file system itself is actually a bit like a transactional database. A broken fsync might cause bad damage there.
I would be happy if users tested the 'pull-the-plug' performance of Linux-2.6.10/InnoDB. Jens Axboe might have solved most fsync problems:
http://groups-beta.google.com/group/linux.kernel/browse_frm/thread/bbe45994b0277f7a/cc6d86c50514da81?q=axboe+fsync+linux&_done=%2Fgroups%3Fas_q%3Daxboe+fsync+linux%26safe%3Dimages%26as_scoring%3Dd%26lr%3D%26hl%3Den%26&_doneTitle=Back+to+Search&&d#cc6d86c50514da81
Just going over some thoughts in my head and want to see if any good discussion can come from this?
Greg -- [EMAIL PROTECTED] Meetup.com
Best regards,
Heikki Tuuri
Innobase Oy
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables
http://www.innodb.com/order.php
Order MySQL Network from http://www.mysql.com/network/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
