----- Original Message -----
From: "Gabriel Ricard" <glists@stripped>
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
did you add the newraw keyword?
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.
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.
By using a raw disk you can on Windows and on some Unixes perform
In Windows raw disk i/o, starting from 4.1.1, you can allocate a disk
partition as a data file like this:
> - Gabriel
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - hot backup tool for InnoDB which also backs up MyISAM