Re: raid tables

2001-06-19 Thread Jeremy Zawodny
On Tue, Jun 19, 2001 at 04:49:58AM +0200, Tonu Samuel wrote: > On Mon, 18 Jun 2001, Jeremy Zawodny wrote: > > > I'd use a combination of my.cnf entries and SQL. The my.cnf entry (or > > entries) woudl list the available directories, like others have > > suggested. Then, using SQL, you could: > >

Re: raid tables

2001-06-18 Thread Tonu Samuel
On Mon, 18 Jun 2001, Jeremy Zawodny wrote: > I'd use a combination of my.cnf entries and SQL. The my.cnf entry (or > entries) woudl list the available directories, like others have > suggested. Then, using SQL, you could: > > * Mark a table to be "spread out" at creation time vis some > at

Re: raid tables

2001-06-18 Thread Jeremy Zawodny
On Mon, Jun 18, 2001 at 03:56:32AM -0700, Jamie Krasnoo wrote: > > [mysqld] > datadir=/data1;/data2;/data3 > > - or - > > datadir=/data1:/data2:/data3 > > As it stands now, both will produce an error and MySQL will not start. > > Other ways could be like: RAID_DIRS=/data1:/data2:/data3 Well,

RE: raid tables

2001-06-18 Thread Sander Pilon
mailto:[EMAIL PROTECTED]] > Sent: 18 June 2001 14:40 > To: Tonu Samuel > Cc: [EMAIL PROTECTED] > Subject: Re: raid tables > > > Hi Samuel > > I would do this in sql. I thinks this would be much more > convenient to administrate. It would be great if you would >

Re: raid tables

2001-06-18 Thread Markwalder Philip
unday, June 17, 2001 11:53 PM > > To: Jamie Krasnoo > > Cc: MySQL > > Subject: Re: raid tables > > > > > > On Sun, Jun 17, 2001 at 11:48:04PM -0700, Jamie Krasnoo wrote: > > > > > > Is there a way to tell MySQL to automatically spread its tables ove

Re: raid tables

2001-06-18 Thread Anthony W . Marino
Isn't this something that RAID O does for you on a larger scale anyway? I would expect that most would have some sort of raid on their mutliple drive system. On Monday 18 June 2001 01:52 am, you wrote: > On Sun, Jun 17, 2001 at 11:48:04PM -0700, Jamie Krasnoo wrote: > > Is there a way to tell My

RE: raid tables

2001-06-18 Thread Tonu Samuel
S you could tell how many directories MySQL should make. > The script could evenly distribute those directories and make the links and > directories for MySQL. > Sent: Sunday, June 17, 2001 11:53 PM > To: Jamie Krasnoo > Cc: MySQL > Subject: Re: raid tables > > > On Sun,

RE: raid tables

2001-06-18 Thread Jamie Krasnoo
could evenly distribute those directories and make the links and directories for MySQL. Jamie -Original Message- From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]] Sent: Sunday, June 17, 2001 11:53 PM To: Jamie Krasnoo Cc: MySQL Subject: Re: raid tables On Sun, Jun 17, 2001 at 11:48:04PM

Re: raid tables

2001-06-17 Thread Jeremy Zawodny
On Sun, Jun 17, 2001 at 11:48:04PM -0700, Jamie Krasnoo wrote: > > Is there a way to tell MySQL to automatically spread its tables over > a number of disks without going through the trouble of symbolic > linking the chunks to the different disks? There isn't yet, no. It'd certainly be a nice addi

RE: raid tables doesnt seem to split files.

2001-01-16 Thread Christian Teil Have
o: Firdaus Mah Cc: Jerome Abela; [EMAIL PROTECTED] Subject: Re: raid tables doesnt seem to split files. Hi Firdaus! On Thu, 12 Oct 2000, Firdaus Mah wrote: > Hi Jerome, > > Heh... I'm already doomed. I'ved just inserted 32 million records and its > stopped at 2GB eve

Re: raid tables doesnt seem to split files.

2001-01-16 Thread funky gao
Hi Firdaus! On Thu, 12 Oct 2000, Firdaus Mah wrote: > Hi Jerome, > > Heh... I'm already doomed. I'ved just inserted 32 million records and its > stopped at 2GB even using on reiserfs. > I'ved not checked the detail or experience in Postgress development. Does it > do stripping as well ie breaki