On Mon, Feb 25, 2002 at 11:21:26PM -0800, Steven Roussey wrote:
> > Are RAID tables supposed to be enabled in the -MAX binaries? They
> > appear not to be (in 4.0.1), and that surprises me a bit.
>
> I thought RAID tables were retired in MySQL 4.
Hmm. The "have_raid&q
> Are RAID tables supposed to be enabled in the -MAX binaries? They
> appear not to be (in 4.0.1), and that surprises me a bit.
I thought RAID tables were retired in MySQL 4. It was only a split for
the data files anyhow, not the index files, so it was incomplete at best
for getting arou
Are RAID tables supposed to be enabled in the -MAX binaries? They
appear not to be (in 4.0.1), and that surprises me a bit. It thought
that the point of the -MAX binaries was to enable all the bells and
whistles by default.
Jeremy
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical
Well, I successfully solved our 2 gig file limit problem with RAID
tables without too much hassle, despite a dearth of documentation.
However, it has introduced another significant problem. It would seem
mysqldump isn't smart enough to look for raided tables. Taking the
server down
I can't reproduce the error using a different database configuration and
I can't use the same database schema to make my test (the machine is now in
production state), so I attached to this mail te sql file used to create
the tables, this database is used by ASPseek 1.2.0, you can download it
at w
I can't reproduce the error using a different database configuration and
I can't use the same database schema to make my test (the machine is now in
production state), so I attached to this mail te sql file used to create
the tables, this database is used by ASPseek 1.2.0, you can download it
at w
On Tue, 19 Jun 2001, Patrizio Bruno wrote:
> > BTW, why did you change the chunksize? By default it is 256000 and I
> > tested it for speed with many different values. 256000 seemed to be best
> > value. If you have any experience showing that I was wrong, please share
> > it with me.
>
> I was
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:
> >
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
On Mon, 18 Jun 2001, Patrizio Bruno wrote:
> "select max(field) from table" returns the greatest field's value in the first
> file of the RAID table (successive files are not considered), adding a where
> clause (for ex. "select max(field) from table where field2 >= 200") the
> problem seems
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,
"select max(field) from table" returns the greatest field's value in the first
file of the RAID table (successive files are not considered), adding a where
clause (for ex. "select max(field) from table where field2 >= 200") the
problem seems not to exist. I don't know if the bug is limited to
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
>
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
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
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,
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
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
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?
Thanks,
Jamie Krasnoo
[EMAIL PROTECTED]
-
Before p
MySQL's raid function says that it can use multiple drives/directories to
put its database in to get over the 2GB limit. How do I configure MySQL to
make sure that it knows about the drives when its instructed to create a
table as RAID_TYPE = STRIPPED ?
Would I put in my.cnf:
[mysqld]
datadir=/db
RAID tables works fine for me.
I don't know which OS you are running, i got it to work with a
linux box like this:
1. Upgrade to the 2.4 linux kernel(Or patch an older kernel with the LFS
patch)
2. Recompile mysql 3.23 with the --with-raid configure option (the
precompiled binaries do
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
22 matches
Mail list logo
