MyISAM RAID Tables in the MySQL-MAX Binaries?

2002-02-25 Thread Jeremy Zawodny

Are RAID tables supposed to be enabled in the -MAX binaries?  They
appear not to be (in 4.0.1), and that surprises me a bit.  It thought
that the point of the -MAX binaries was to enable all the bells and
whistles by default.

Jeremy
-- 
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 18 days, processed 582,964,719 queries (361/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




Re: MyISAM RAID Tables in the MySQL-MAX Binaries?

2002-02-25 Thread Steven Roussey

 Are RAID tables supposed to be enabled in the -MAX binaries?  They
 appear not to be (in 4.0.1), and that surprises me a bit.

I thought RAID tables were retired in MySQL 4. It was only a split for
the data files anyhow, not the index files, so it was incomplete at best
for getting around the lack of large file support in some (now old)
OSes. For speed, RAID is best handled by the OS or hardware.

Sincerely,
Steven Roussey
http://Network54.com/?pp=e 




-
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: MyISAM RAID Tables in the MySQL-MAX Binaries?

2002-02-25 Thread Jeremy Zawodny

On Mon, Feb 25, 2002 at 11:21:26PM -0800, Steven Roussey wrote:
  Are RAID tables supposed to be enabled in the -MAX binaries?  They
  appear not to be (in 4.0.1), and that surprises me a bit.
 
 I thought RAID tables were retired in MySQL 4.

Hmm.  The have_raid variable is still there in SHOW VARIABLES.

 It was only a split for the data files anyhow, not the index files,
 so it was incomplete at best for getting around the lack of large
 file support in some (now old) OSes.

I agree.

 For speed, RAID is best handled by the OS or hardware.

And that's basically what I just finished writing. :-) But I also had
to write that in order you get RAID, you *must* recompile MySQL.  I'm
not sure if that's by design or a simple omission.

Jeremy
-- 
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 18 days, processed 584,411,183 queries (361/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