Gabriel, ----- Original Message ----- From: "Gabriel Ricard" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Monday, October 27, 2003 6:46 PM Subject: InnoDB on Raw partitions in OSX (was Re: MySQL/InnoDB-4.0.16 is released + sneak peek of 4.1.1)
> On Monday, October 27, 2003, at 07:45 AM, Chris Nolan wrote: > > > 2. I personally use ReiserFS for all of my stuff, most of which is > > based upon InnoDB. One thing you have to remember is that InnoDB > > treats the space inside the tablespace as a Berkeley Fast > > Filesystem-style space, using the underlaying filesystem minimally. To > > quote > > the manuals, raw partition usage can speed up IO on a number of UNIXes > > (and Windows too seemingly). Regarding backup, you'd > > need to use mysqldump or InnoDB Hot Backup to backup a raw-partition > > setup. This isn't a bad thing though - I use mysqldump and > > can get a consistant snapshot of a 12 GB DB without problems while the > > thing is running. > > Just out of curiosity, has anyone been able to get InnoDB to use a raw > partition in OSX? When I tried it, it complained about the file already > existing. did you add the newraw keyword? http://www.innodb.com/ibman.html#Disk_io_and_raw_devices " 12.1 Disk i/o and raw devices Starting from 3.23.41, you can also use a raw disk partition (a raw device) as a data file. When you create a new data file you have to put the keyword newraw immediately after the data file size in innodb_data_file_path. The partition must be equal to or larger than the size you specify. Note that 1M in InnoDB is 1024 x 1024 bytes, while in disk specifications 1 MB usually means 1000 000 bytes. innodb_data_home_dir= innodb_data_file_path=/dev/hdd1:3Gnewraw;/dev/hdd2:2Gnewraw When you start the database again you MUST change the keyword to raw. Otherwise InnoDB will write over your partition! Starting from 3.23.44, as a safety measure InnoDB prevents a user from modifying data when any partition with newraw is specified. After you have added a new partition, shut down the database, edit my.cnf replacing newraw with raw, and restart. innodb_data_home_dir= innodb_data_file_path=/dev/hdd1:3Graw;/dev/hdd2:2Graw By using a raw disk you can on Windows and on some Unixes perform non-buffered i/o. In Windows raw disk i/o, starting from 4.1.1, you can allocate a disk partition as a data file like this: innodb_data_home_dir= innodb_data_file_path=//./D::10Gnewraw " > - Gabriel Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Foreign keys, transactions, and row level locking for MySQL InnoDB Hot Backup - hot backup tool for InnoDB which also backs up MyISAM tables -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
