On Thu, 10 May 2001, roger westin wrote: > > We have a database of size 10GB and its index is also > > almost of the same size. Now we want this database in MYSQL. > > Please let me know how we can slpit it across 3-4 hard > > disks.We are using Linux 6.2 > > Hi there, > My self I have a machine runnig RH Linux 6.0 with a 70Gb database. > And it works just fine. What you need to do is to, recompile tha source > using --with-raid > or download the -max version of mysql > Because what you should do is to use the raid option in create table. It > will then create several > subdirectorys in wich it puts the datafiles. (read more in the manual about > this feature (on CREATE TABLE)). And then just mount diffrent HD/partitions > to the diffrent subdirectoris (works fine for me) > > The problem you will have is the indexfile.... Because as far as I know.... > no solution has been made to split the index file into smaler files. The > ext2 has a max filesize about 2Gb so you will have a problem. > > So for your sake I hope this is not in one table. > Otherwise, my recomendation is to try to split the table into several > smaller tables and thus the indexfiles as well. > > ----- > For me that was not possible, so I had to drop all indexed columns (exept my > uniqe numric identifyer) in the main table, and create a kind of quick > serach system (187 tables) of the rest of the data. (so insted of having 1 > tabled of 70Gb and 1 index on 50Gb, I have 188 tables total 250Gb and 188 > indexes on about 90Gb), but I have some desent speed in on everything. > ----- Which is better? Creating a MERGE table or using the RAID options on create? TIA, thalis --------------------------------------------------------------------- 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