Re: Raid level suggestions for mysql-server

2009-11-02 Thread Michael Dykman
In one of the more effective high-loads shops I have worked in, we deployed RAID 1 for logs and RAID 10 for data. The number of disks we put into those RAID 10's depended on anticipated load of the specific application. We often found ourselves needing additional spindles to meet high I/O needs,

Re: Raid level suggestions for mysql-server

2009-11-01 Thread Per Jessen
Gšötz Reinicke - IT Koordinator wrote: > Hi, > > soon I'll get a SUN X4170 with 8*2,5" SAS 300 GB harddisks. (24 GB > RAM) > > This system could be our new central mysql-server for some > LAMP-systems. (right now about 50 GB mysql data total, roughly 60-70% > reads.) > > What would be a good ra

Re: RAID stripe size recommendations

2005-09-29 Thread Kevin Burton
On Sep 28, 2005, at 5:05 PM, Atle Veka wrote: I am planning on running some tests on a SATA server with a 3ware 9000 series RAID card to see if there's a stripe size that performs better than This might be able to help you out: http://hashmysql.org/index.php?title=Opteron_HOWTO These ar

Re: RAID/MySQL configuration question

2005-08-25 Thread Jason Pyeron
On Thu, 25 Aug 2005, Gary Richardson wrote: My guess is that the RAID has nothing to do with it -- it seems very unlikely. In any case, if you want top performance out of your raid, you may want to change things up. You'd get better performance if you didn't use RAID5. Use RAID1 or RAID10 for y

Re: RAID/MySQL configuration question

2005-08-25 Thread Gary Richardson
My guess is that the RAID has nothing to do with it -- it seems very unlikely. In any case, if you want top performance out of your raid, you may want to change things up. You'd get better performance if you didn't use RAID5. Use RAID1 or RAID10 for your data drives. RAID5 is slower than these oth

Re: RAID, MySQL and SATA - benchmarks

2005-03-09 Thread Gary Richardson
I found the article very interesting. It seems they couldn't trash 3ware cards enough. We swear by 3ware cards -- other than the PCIX riser card issue, we haven't a single problem with them. Our production database server is running off of a RAID1 for the OS and a RAID10 for the data and every tim

RE: RAID Question

2004-11-11 Thread Kirti S. Bajwa
DuBois [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 10, 2004 8:18 PM To: Kirti S. Bajwa; [EMAIL PROTECTED] Subject: RE: RAID Question At 15:19 -0500 11/10/04, Kirti S. Bajwa wrote: >Hello List: > >System: RH9, MySQL 4.1.7 > >I am in the process of re-setting up (I have test

RE: RAID Question

2004-11-10 Thread Paul DuBois
At 15:19 -0500 11/10/04, Kirti S. Bajwa wrote: Hello List: System: RH9, MySQL 4.1.7 I am in the process of re-setting up (I have test setup 4-5 times) a data server with the above software. This server consists of 2-CPU (Intel) RAID-1, 1-40GB IDE HDD for O/S & 2-250GB IDE HDD for storing data. 250

RE: RAID Question

2004-11-10 Thread Kirti S. Bajwa
Hello List: System: RH9, MySQL 4.1.7 I am in the process of re-setting up (I have test setup 4-5 times) a data server with the above software. This server consists of 2-CPU (Intel) RAID-1, 1-40GB IDE HDD for O/S & 2-250GB IDE HDD for storing data. 250 GB IDE HDD are mirrored (RAID-1). Previously

Re: raid configure option?

2004-04-12 Thread Dan Nelson
In the last episode (Apr 13), Yonah Russ said: > Can anyone explain what the raid configure option does? Is this for > use when storing mysql on hardware raid? if so, what type(s)- ie. > striping, mirroring? It's mainly to support tables over 2gb on old Linux kernels that can't do large files. Yo

Re: RAID Strip size

2003-12-10 Thread Jeremy Zawodny
On Thu, Dec 04, 2003 at 10:33:17AM -0500, Brent Baisley wrote: > > Actually, you want to try to match the stripe size to your data size. > The ideal would be to have a stripe size equal to the size of a record > in your database. This way the disk needs only one read or write for > each database

Re: RAID Strip size

2003-12-04 Thread Brent Baisley
Actually, you want to try to match the stripe size to your data size. The ideal would be to have a stripe size equal to the size of a record in your database. This way the disk needs only one read or write for each database record. You really don't want to fragment a record. A large stripe size

RE: RAID, miiror OR replication?

2003-10-07 Thread Andrew Braithwaite
Hi, Having implemented all the solutions you suggest, I would need more information to answer this problem. 1. What is the acceptable uptime of the system? 95%, 99%, 99.9%, 99.99% ? 2. In the event of a failure, what is the acceptable recovery time? None, 20 mins, 1 hr, 5 hrs, 1 day ? 3. What

RE: RAID, miiror OR replication?

2003-10-07 Thread Andrew Braithwaite
Hi, Having implemented all the solutions you suggest, I would need more information to answer this problem. 1. What is the acceptable uptime of the system? 95%, 99%, 99.9%, 99.99% ? 2. In the event of a failure, what is the acceptable recovery time? None, 20 mins, 1 hr, 5 hrs, 1 day ? 3. What

RE: RAID, miiror OR replication?

2003-10-06 Thread Rob A. Brahier
Richard, If you want to protect against hard drive failures then a RAID setup is probably the best option. A RAID will ensure that you always have an up-to-the-instant backup of all of your data in case a drive goes bad; however, a RAID won'tstop a bug, virus, or error from screwing up you

Re: RAID, mirror OR replication?

2003-10-06 Thread woody at nfri dot com
On Mon, 2003-10-06 at 14:21, Richard Reina wrote: > I am wanting to protect myself against future potential hard drive > failures on my DB server running version 3.23.49a. Should I try and set > up a RAID, a mirror or would the best solution be to set up MySQL > replication. Any suggestions wo

Re: RAID or not?

2003-09-02 Thread Michael Loftis
--On Friday, August 22, 2003 8:37 PM -0600 Jim McAtee <[EMAIL PROTECTED]> wrote: I don't quite understand the need to read data before any write. Why wouldn't it just calculate the parity of whatever is being written and just write it to disk? Wouldn't there be slack space, as with any disk s

RE: RAID or not?

2003-09-02 Thread Michael Loftis
--On Friday, August 22, 2003 1:21 PM -0400 "Lefevre, Steven" <[EMAIL PROTECTED]> wrote: "that is not true. mirroring gives you double the read speed and half the write speed. RAID5 gives you less than half the write speed." - OK, I see how it can give you double the read speed, bu

Re: RAID or not?

2003-08-26 Thread Alec . Cawley
> [EMAIL PROTECTED] wrote: > > I do not think it is true that mirroring gives no performance benefit (on a > > well implemented controller). For reads, the raid controller can read > > either copy of the data, so that effectively two reads can be in progress > > at the same time, doubling read

Re: RAID or not?

2003-08-22 Thread Jim McAtee
[EMAIL PROTECTED] wrote: > > I say go with RAID 5, on a controller card. > > > Mirroring just gives you backup, and you lose half your diskspace. It > offers > > no performance benefit, and actually the computer might have to work > harder > > to make sure the drives are in sync. > > I do not thi

RE: RAID or not?

2003-08-22 Thread Lefevre, Steven
-Original Message- From: news [mailto:[EMAIL PROTECTED] Behalf Of Jon Drukman Sent: Thursday, August 21, 2003 9:24 PM To: [EMAIL PROTECTED] Subject: Re: RAID or not? Lefevre, Steven wrote: > I say go with RAID 5, on a controller card. > > Mirroring just gives you backup, and

RE: RAID or not?

2003-08-22 Thread Alec . Cawley
> I say go with RAID 5, on a controller card. > Mirroring just gives you backup, and you lose half your diskspace. It offers > no performance benefit, and actually the computer might have to work harder > to make sure the drives are in sync. I do not think it is true that mirroring gives no per

Re: RAID or not?

2003-08-21 Thread Dan Nelson
In the last episode (Aug 21), Jon Drukman said: > Lefevre, Steven wrote: > >I say go with RAID 5, on a controller card. > > Mirroring just gives you backup, and you lose half your diskspace. > > It offers no performance benefit, and actually the computer might > > have to work harder to make sure t

Re: RAID or not?

2003-08-21 Thread Jon Drukman
Lefevre, Steven wrote: I say go with RAID 5, on a controller card. Mirroring just gives you backup, and you lose half your diskspace. It offers no performance benefit, and actually the computer might have to work harder to make sure the drives are in sync. that is not true. mirroring gives you d

Re: RAID or not?

2003-08-21 Thread Per Andreas Buer
[EMAIL PROTECTED] (Lefevre, Steven) writes: > I say go with RAID 5, on a controller card. > .. > > You get better performance than mirroring or regular drive, because > the data is spread out over your drives. It's not as good as disk > striping, though. Ehh. Wrong. That is not how it works. If y

Re: RAID or not?

2003-08-21 Thread David Griffiths
ROTECTED]> To: "Jackson Miller" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, August 21, 2003 10:20 AM Subject: RE: RAID or not? > I say go with RAID 5, on a controller card. > > Mirroring just gives you backup, and you lose half your diskspace. It offers

RE: RAID or not?

2003-08-21 Thread Lefevre, Steven
lto:[EMAIL PROTECTED] Sent: Thursday, August 21, 2003 11:56 AM To: Jon Drukman Cc: [EMAIL PROTECTED] Subject: Re: RAID or not? On Thursday 21 August 2003 2:23, Jon Drukman wrote: > if you're mostly running SELECTs then i would recommend a mirrored > configuration. I would say I am runnin

Re: RAID or not?

2003-08-21 Thread Jackson Miller
On Thursday 21 August 2003 2:23, Jon Drukman wrote: > if you're mostly running SELECTs then i would recommend a mirrored > configuration. I would say I am running about %50 SELECTS, 30% UPDATE, 20% INSERT. However I don't know how to find that out for sure. Would that affect how I set up the RA

Re: RAID or not?

2003-08-21 Thread Per Andreas Buer
Jackson, Jackson Miller <[EMAIL PROTECTED]> writes: > I have 4 SCSI drives currently. Well, is you want Redundancy you don't have a choice. Mirror them. 2x 2 drives. You might want to put OS and write-ahead-log on one and InnoDB/MyISAM-data on the other. > I would like to have 1 drive run the

Re: RAID or not?

2003-08-21 Thread Colbey
I like using either raid 0+1.. it really cooks, or if you can'y spare the disks, raid 1 ...Something pushing that many queries, should probably be protected from disk failure. On Wed, 20 Aug 2003, Jackson Miller wrote: > I am setting up a dedicated MySQL server with some pretty heavy usage.

Re: RAID or not?

2003-08-21 Thread Jon Drukman
Jackson Miller wrote: I am setting up a dedicated MySQL server with some pretty heavy usage. I am not much of a sys admin (mostly a programmer). I have some questions about the best drive configuration. I have 4 SCSI drives currently. I would like to have 1 drive run the OS, 1 drive to be th

Re: RAID hardware suggestions/experience

2003-06-23 Thread Bernd Jagla
Thanks to everybody for the nice discussion. Just to let you know about my (not necessary final) decisions: We will upgrade our SCSI -II controller to an Ultra SCSI 160 controller (always a good idea). Next we are looking into buying a RAID-5 system from RAIDking. While we do this we hope for the

Re: RAID hardware suggestions/experience

2003-06-18 Thread Jeremy Zawodny
On Wed, Jun 18, 2003 at 03:20:17PM -0400, Adam Nelson wrote: > Where'd you get it. I've had bad experiences with generic machines but > I'll take a peak if you send the link? > > There are a couple of things I didn't mention > > 2U Form Factor with tool-less rails > Redundant Power Supply > Redu

RE: RAID hardware suggestions/experience

2003-06-18 Thread Steven Roussey
> A lot of table scans do to bitmasked column values. > Such that the above query will not utilize a key. That statement gave me a cold shiver up my spine. You could try an inverted index or match-cache technique, or denormalization. These type of techniques are very app specific, but can reduce

Re: RAID hardware suggestions/experience

2003-06-18 Thread Tomasz Korycki
At 13:14 2003-06-17, Bernd Jagla wrote: Sorry I forgot to mention: We are using IRIS on an Origion2000, 7GB memory, 8 CPUs. I was thinking of spending up to $10K. I also wanted the redundant data for speeding up the seeks, I also need to speed up the writes. Bernd I assume You mean "IRIX on O2k".

RE: RAID hardware suggestions/experience

2003-06-18 Thread Dathan Vance Pattishall
not quite there yet. It's a hard problem I can only think of a way by having every possible bit in an index but then that makes the index useless. -->-Original Message- -->From: Steven Roussey [mailto:[EMAIL PROTECTED] -->Sent: Wednesday, June 18, 2003 12:59 PM -->To: &

RE: RAID hardware suggestions/experience

2003-06-18 Thread Steven Roussey
2 x 2.8 GHZ Xeon 4 GB of RAM 5 15K SCSI Drives ICP SCSCI RAID control card with 1 Gb of ram on it. I just bought 30 of these boxes to build out my mysql farm for close to 400-600 queries a second with 60 connections a second of mix read / writes. What kind of queries are you doing? Our s

RE: RAID hardware suggestions/experience

2003-06-18 Thread Adam Nelson
June 18, 2003 2:39 PM > To: 'Adam Nelson'; 'mysql' > Subject: RE: RAID hardware suggestions/experience > > > > > -->-Original Message- > -->From: Adam Nelson [mailto:[EMAIL PROTECTED] > -->Sent: Tuesday, June 17, 2003 11:56 AM > -->

RE: RAID hardware suggestions/experience

2003-06-18 Thread Dathan Vance Pattishall
-->-Original Message- -->From: Adam Nelson [mailto:[EMAIL PROTECTED] -->Sent: Tuesday, June 17, 2003 11:56 AM -->To: 'Bernd Jagla'; 'mysql' -->Subject: RE: RAID hardware suggestions/experience --> -->We recently bought a kick $%#%% machine for ~10

RE: RAID hardware suggestions/experience

2003-06-18 Thread Steven Roussey
> What sort of throughput are you seeing in that setup? God, I can't remember anymore. I can run a test again though. If you have one you want me to run, just send it. We don't have other people's money to spend, so all our disks are U160 18GB 15K IBM. They were less than $100 each when we got the

Re: RAID hardware suggestions/experience

2003-06-18 Thread Jeremy Zawodny
On Wed, Jun 18, 2003 at 09:37:24AM -0700, Steven Roussey wrote: > > Don't stripe too many. More sets to stripe increase performance, but > syncing the rotations of many drives degrades performance. So there > are diminishing returns. For our calculations, 3-4 mirrors were > sufficient. Most of our

RE: RAID hardware suggestions/experience

2003-06-18 Thread Steven Roussey
After testing a lot of different configurations (which was quite a headache), I came up with the following. First of all, for both speed and reliability, you will want SCSI. The list of reasons are quite long for SCSI, and as you are doing research on the subject, it is an obvious choice and I don'

RE: RAID hardware suggestions/experience

2003-06-18 Thread Alec . Cawley
> RE: SCSI needed for best performance - > While this is true in some cases, if you are using striping or any > RAID level (RAID 5 for example) that splits reads and writes across > drives, then there will be several IDE channels feeding data to the > RAID card at a time. Two ATA100 IDE channel

RE: RAID hardware suggestions/experience

2003-06-17 Thread Adam Nelson
We recently bought a kick $%#%% machine for ~10k HP DL380 2x2.8GHz Xeon 1GB RAM 5 15k scsi drives (2 RAID 1 for OS and logs/3 RAID 5 for data) RedHat Linux Enterprise Edition 2.1 This machine easily handles 200 queries/sec and never gets a load average above 1.5. For your space requirements, yo

RE: RAID hardware suggestions/experience

2003-06-17 Thread Mike Hillyer
To me the question of reliability is that of the drive, not the interface. I cannot see SATA itself being any more or less reliable than ATA drives. I think certain controllers will accept a new drive that has similar characteristics as long as the replacement drive is larger than the lost drive.

RE: RAID hardware suggestions/experience

2003-06-17 Thread Christopher Knight
n get away with it w/o any adverse effects. -Original Message- From: William R. Mussatto [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 17, 2003 12:33 PM To: [EMAIL PROTECTED] Subject: RE: RAID hardware suggestions/experience > I have heard good thing about 3Ware, but I would suggest lo

Re: RAID hardware suggestions/experience

2003-06-17 Thread David Griffiths
t; Sent: Tuesday, June 17, 2003 10:41 AM Subject: RE: RAID hardware suggestions/experience > Optimally, Yes, you should replace with exact same brand/model etc... > but you CAN replace with a different brand/ model drive of the same > amount of disk space or more. It isn't recomende

Re: RAID hardware suggestions/experience

2003-06-17 Thread Gabriel Guzman
On Tue, 2003-06-17 at 09:58, David Griffiths wrote: > Anyone had any experience with 3Ware 7500-4 IDE RAID or the Promise SX-6000 > IDE RAID cards? Specifically for Linux. Heard bad things about Promise, good > about 3Ware. If I had to choose between the two, I would go with the 3wares. They wor

RE: RAID hardware suggestions/experience

2003-06-17 Thread William R. Mussatto
o:[EMAIL PROTECTED] > Sent: Tuesday, June 17, 2003 10:59 AM > To: [EMAIL PROTECTED] > Subject: Re: RAID hardware suggestions/experience > > > Anyone had any experience with 3Ware 7500-4 IDE RAID or the Promise > SX-6000 > IDE RAID cards? Specifically for Linux. Heard bad thin

RE: RAID hardware suggestions/experience

2003-06-17 Thread Quinlan, Grant
d what to do. Best of Luck, Grant Q -Original Message- From: Gabriel Guzman [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 17, 2003 10:06 AM To: Bernd Jagla Cc: [EMAIL PROTECTED]; mysql Subject: Re: RAID hardware suggestions/experience Bernd, here is a good resource on t

RE: RAID hardware suggestions/experience

2003-06-17 Thread Mike Hillyer
ECTED] Subject: Re: RAID hardware suggestions/experience Anyone had any experience with 3Ware 7500-4 IDE RAID or the Promise SX-6000 IDE RAID cards? Specifically for Linux. Heard bad things about Promise, good about 3Ware. David - Original Message - From: "Patrick Shoaf" <[EM

RE: RAID hardware suggestions/experience

2003-06-17 Thread Christopher Knight
Im using a 3ware (which has great linux support) Escalade 7800 with 8 120GB/8MB cache ide drives in RAID 10 under Debian with 2.4.20 kernel. I guess what we need to know is what platform and how much $$ you wanna spend -Original Message- From: Bernd Jagla [mailto:[EMAIL PROTECTED] Sent: T

RE: RAID hardware suggestions/experience

2003-06-17 Thread Kerry Colligan
Tried a Promise FastTrak 100 TX2 in a Dell; RH 7.3. Miserable. Bailed on it after one month. Kerry -Original Message- From: David Griffiths [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 17, 2003 12:59 PM To: [EMAIL PROTECTED] Subject: Re: RAID hardware suggestions/experience Anyone had

Re: RAID hardware suggestions/experience

2003-06-17 Thread David Griffiths
esday, June 17, 2003 9:40 AM Subject: Re: RAID hardware suggestions/experience > I am using 4 120G IDE Drives with an Adaptec IDE RAID Controller on RedHat > Linux providing 240G of RAID 5 storage. While not quite as fast as SCSI, I > have found this to work very well. You should

Re: RAID hardware suggestions/experience

2003-06-17 Thread Patrick Shoaf
I am using 4 120G IDE Drives with an Adaptec IDE RAID Controller on RedHat Linux providing 240G of RAID 5 storage. While not quite as fast as SCSI, I have found this to work very well. You should be able to pickup a nice dual processor XENON 2.4Ghz system w/1G Ram and IDE RAID loaded with RedH

Re: raid vs splitting the database

2002-10-04 Thread walt
Brent Baisley wrote: > Well, there is the ideal setup, which requires intimate knowledge of the > database, lots of disks and extra administration. And then there is the > easy setup. Ideally you don't want to have any "hot" disks which will > cause contention. This requires you to place your bu

Re: raid vs splitting the database

2002-10-04 Thread Brent Baisley
Well, there is the ideal setup, which requires intimate knowledge of the database, lots of disks and extra administration. And then there is the easy setup. Ideally you don't want to have any "hot" disks which will cause contention. This requires you to place your busy tables (read or write)

RE: raid vs splitting the database

2002-10-03 Thread Andrew Braithwaite
Hi, In my experience (assuming that you are using mysql for all of these operations) the best way is to separate your tables into read-heavy and write heavy and put each into separate databases. Put the write-heavy logs database onto a separate disk/spindle and use delayed inserts (so that the a

Re: RAID

2002-07-09 Thread toby -
ismaeel >Do you have good link for documentation ? http://www.mysql.com/doc/C/o/Configuring_MySQL.html good luck toby . _ Send and receive Hotmail on your mobile device: http://mobile.msn.com -

Re: RAID

2002-07-09 Thread Roger Baklund
* Ismael Touama > This is my first post... > I'm on redhat 7.2, using apache 1.3.23 (patched) > on a PowerEdge 2500 in RAID 1 and I want to install > MySQL 3.23.51... > Must I set to configure the --with-raid ? No, this is only if you need support for tables with file size bigger than your OS can

RE: RAID

2002-07-09 Thread Ismael Touama
Ok so it's to emulate it following you explanation. That's OK, I enter the line (without this option). thx bbsc ism -Message d'origine- De : Simon Green [mailto:[EMAIL PROTECTED]] Envoyé : mardi 9 juillet 2002 11:42 À : 'Ismael Touama'; [EMAIL PROTECTED] Objet

RE: RAID

2002-07-09 Thread Simon Green
RAID --with-raid splits tables up to stop size problems or put one table on more than one disk. So is not required for hardware raid. Simon -Original Message- From: Ismael Touama [mailto:[EMAIL PROTECTED]] Sent: 09 July 2002 10:26 To: [EMAIL PROTECTED] Subject: RAID Hi, This is my fir

RE: RAID

2002-03-18 Thread Greg_Cope
> -Original Message- > From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]] > > Here's what I recently wrote about RAID tables. Try to ignore the > funny markup. :-) > > snip lots of usefull stuff. > > Does that answer your question a bit? > Thanks Jeremy, I was a bit unsure as to RAID

Re: RAID

2002-03-18 Thread Jeremy Zawodny
On Wed, Mar 13, 2002 at 11:00:35AM +0500, Rizwan Majeed wrote: > is there a Raid Mode in MySQL.. I found a RAID_TYPE switch but dont know > much about it. Here's what I recently wrote about RAID tables. Try to ignore the funny markup. :-) ---snip--- P P C< CREATE TABLE mytable ( aINTEG

Re: RAID

2002-03-12 Thread Rizwan Majeed
is there a Raid Mode in MySQL.. I found a RAID_TYPE switch but dont know much about it. - Original Message - From: "Jeremy Zawodny" <[EMAIL PROTECTED]> To: "Rizwan Majeed" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Tuesday, March 12, 2002 11:5

Re: RAID

2002-03-12 Thread Jeremy Zawodny
On Tue, Mar 12, 2002 at 04:04:48PM +0500, Rizwan Majeed wrote: > > Can somebody give me an intro into using MySQL over RAID array or > direct me to a good resource on the net. I also want to know what > type of tables support RAID. Is it only MyISAM tables? If you're talking about a RAID disk co

Re: RAID RAID_CHUNKS speed differences

2001-11-16 Thread Michael Brunson
On Thu, 15 Nov 2001 23:29:27 -0800, Jeremy Zawodny used a few recycled electrons to form: | On Thu, Nov 15, 2001 at 04:14:58PM -0600, Michael Brunson wrote: | > | > Has anyone ran any benchmarks as to what affect different number of | > RAID_CHUNKS has on speed? | | The more chunks, the slower yo

Re: RAID RAID_CHUNKS speed differences

2001-11-15 Thread Jeremy Zawodny
On Thu, Nov 15, 2001 at 04:14:58PM -0600, Michael Brunson wrote: > > Has anyone ran any benchmarks as to what affect different number of > RAID_CHUNKS has on speed? The more chunks, the slower your retrieval speed is likely to be. But how many chunks do you really need? More than a few? > mysq

Re: RAID RAID_CHUNKS speed differences

2001-11-15 Thread Michael Brunson
Here is the same data in a little easy format. Raid Chunks count like %like % % 10.00 sec 0.33 sec 2 min 3.70 sec 30.00 sec 0.39 sec 14 min 59.83 sec 50.00 sec 0.38 sec 6 min 44.92 sec 15 0.00 sec 0.39 sec 6 min 33.72 sec

Re: RAID advice :> (fwd)

2001-06-22 Thread Seth Northrop
Sorry for the delayed reply.. the list marked my reply as spam ! ;) -- Forwarded message -- Date: Fri, 22 Jun 2001 02:48:14 -0700 (PDT) From: Seth Northrop <[EMAIL PROTECTED]> To: Wouter de Jong <[EMAIL PROTECTED]> Cc: [EMAIL PROTECTED] Subject: Re: RAID advice :>

Re: RAID advice :>

2001-06-22 Thread Alan W. Rateliff, II
On 22-Jun-01, Wouter de Jong said something totally profound about RAID advice :> that made me ponder... WdJ> We are planning to use RAID for backing-up MySQL-data. Is it adviced that WdJ> we put the OS on the RAID-array too, or just the data ? WdJ> WdJ> Let's say your OS crashes (Linux...bad l

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