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]
RE: Raw devices and MySQL
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]
Raw devices and MySQL
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? Thanks 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
Raw Devices in MySQL?
Have a feeling I know the answer already, but here goes! ... Does anyone know if (and how) MySQL supports raw devices? I¹ve been searching the docs; can find nothing... Thanks - Lou - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Raw Devices in MySQL?
On Thu, Feb 21, 2002 at 04:10:58PM -0500, Lou Picciano / Essex Systems wrote: Have a feeling I know the answer already, but here goes! ... Does anyone know if (and how) MySQL supports raw devices? I¹ve been searching the docs; can find nothing... InnoDB can use raw devices. -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.47-max: up 14 days, processed 460,706,325 queries (371/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php