Hi! If you use the InnoDB table type, you can configure the InnoDB tablespace to consist of several 2 GB files which you can put on different disks or in different directories. Look at the online manual at www.mysql.com or www.innobase.fi on how to specify the my.cnf parameters for InnoDB. Regards, Heikki >> 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.2Hi 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-raidor 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.----- >/roger --------------------------------------------------------------------- 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
