Hi Alec,
Thanks for the response. You are probably quite right about the gains,
mostly my query was through curiosity more than anything. I use raw
devices with Informix and a couple of other databases and there are
small improvements to be seen on these products. On very large scale
implementations, the small things can often translate into user
satisfaction and that is a big part of my job 8-)
Unfortunately I don't always get any say on the how and why of the
clients application design and so have to make the best of what I have
been given to manage. Often we are presented with the hardware as a
fait accompli so if we can get an improvement, no matter how small,
they tend to become important.
Regards
David Logan
Database Administrator
HP Managed Services
148 Frome Street,
Adelaide 5000
Australia
+61 8 8408 4273 - Work
+61 417 268 665 - Mobile
+61 8 8408 4259 - Fax
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Friday, 14 October 2005 6:53 PM
To: Logan, David (SST - Adelaide)
Cc: MySQL List
Subject: Re: Raw devices and MySQL
Logan, David (SST - Adelaide) [EMAIL PROTECTED] wrote on 14/10/2005
03:28:15:
Hi Listers,
Does anybody know if the MyISAM engine (apart from InnoDB) allows the
use of raw disk space rather than having cooked files? If not, is this
feature likely to be included in a future release? I had a quick scour
of the MySQL website but can't seem to find a page with upcoming
features. Is there such a beast?
Given the way MyISAM works, I would have thought it very unlikely that
this would ever happen. It would mean the SQL team developing their own
special-purpose file system. Why bother, when they already have such a
file system, called InnoDB? It is difficult to see what gain there would
be for investing a very large amount of effort which could probably
better
spent elsewhere. As I understand it, the gains of using raw devices with
InnoDB are, while not zero, small.
Why do you want such a feature?
Alec
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]