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]