Hi!
>>>>> "Mike" == Mike Blazer <[EMAIL PROTECTED]> writes: <cut> Mike> Well, I'm sure there are some better ways too - it's a pity that it such Mike> a useful feature fails on Win32. >> I have now changed MySQL 4.0.1 to ignore any DATA DIRECTORY >> directives, until we have come up with an acceptable workaround for >> windows. Mike> Oops! Sorry, I hope you removed this feature for Win32 only, because on Mike> *NIX it works perfectly. In fact we already started bulding the new Mike> multi-drive database using this kind of symlinking (on Linux and Mike> Solaris). Yes, we only removed this for windows. Mike> Well, may be I'm missing something - I'm preparing such a huge base for Mike> a 1st time - but except of DATA DIRECTORY it's only RAID mechanism that Mike> lets you use few disks and not fail after OPTIMIZE TABLE. RAID can't help you to use many disks on windows, because you can't symlink directories on windows as you can on Unix. Mike> But Raid has its unpleasant side - it puts all tables to the same Mike> 00,01,02 not to tab1.00, tab2.00 etc. So, you can't actually split the Mike> tables between disks. Parts of all tables will be on all disks. And you Mike> can't move index files at all. And also, if your disks are not equal, Mike> like 8GB and 18GB and all big tables are raid-ed seems like a big part Mike> of the bigger drive will always be empty - beause Raid writes equal Mike> portions of data. RAID was mainly designed to help overcome the 2G limit on old Linux filesystems, not to split things across many disks (even if it can be used for this on Linux). Mike> So, Michael, please, please open the DATA DIRECTORY feature for the Mike> systems that can handle it! It's a life-saving feature. Of course (I never intended to remove this for Unix). Mike> Thanks a lot! Mike> Mike Blazer Regards, Monty --------------------------------------------------------------------- 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