Re: how to split database and index

2001-05-11 Thread Thalis A. Kalfigopoulos
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

Re: how to split database and index

2001-05-11 Thread Heikki Tuuri
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. Regar

Re: how to split database and index

2001-05-10 Thread roger westin
> 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