List:General Discussion« Previous MessageNext Message »
From:Adam Nelson Date:April 28 2003 2:35pm
Subject:RE: performance
View as plain text  
mysql raid is just software raid.  Since you have hardware raid, I think
it's useless to use mysql raid.

> -----Original Message-----
> From: Ryan R. Tharp [mailto:mysql@stripped] 
> Sent: Friday, April 25, 2003 11:48 AM
> To: Jonathan Disher
> Cc: mysql@stripped
> Subject: Re: performance
> 
> 
> Yes, our development server is FreeBSD however our production 
> server is
> Linux. However we still see problems with our table on both 
> platforms, so I
> was hoping I could find the ideal config for our server by 
> adjusting the
> buffers on the development server and then applying them to a 
> new production
> server when ready.
> 
> We have 6 Disks, 3x2, looks like I have a 64k chunk size. I 
> also have a
> raid0 stripe (64k chunk size as well), I run some tests with 
> that as well as
> using mysql raid.
> 
> -Ryan.
> 
> ----- Original Message -----
> From: "Jonathan Disher" <jdisher@stripped>
> To: "Ryan R. Tharp" <mysql@stripped>
> Cc: <mysql@stripped>
> Sent: Thursday, April 24, 2003 4:55 PM
> Subject: Re: performance
> 
> 
> > Unfortunately, FreeBSD is not the greatest for running a 
> database server
> on
> > an SMP architecture... Not yet, anyway.  Hopefully 5.1-R or 
> 5.2-R will fix
> > that.  And by the way, IMO, stay away from 5.0, it's not 
> ready for prime
> > time yet.  My testing showed (for our application, anyway) 
> that 4.7 and
> 4.8
> > with LinuxThreads was most excellent.
> >
> > I've succeeded in getting MySQL built against LinuxThreads 
> on FreeBSD,
> with
> > the gracious help of Jeremy Zawodny and his build 
> statements.  There's an
> > entry in his blog 
> (http://jeremy.zawodny.com/blog/archives/000458.html)
> that
> > is a good starting place to make this work.  I can forward 
> my personal
> > configure statement to you, if you like.
> >
> > Another question... You say that you're running a RAID10 
> array.  How many
> > disks?  A 2x2 array is decent, but a 4x2 will run much 
> faster.  What's
> your
> > stripe set size - 64k? 128k? 256k? a meg?  Can you afford 
> the risk of
> going
> > to a straight RAID0 of all your disks?
> >
> > Another person noted that you're doing a lot of "select *"'s, do you
> really
> > need to grab all the columns all the time?
> >
> > -j
> >
> > ----- Original Message -----
> > From: "Ryan R. Tharp" <mysql@stripped>
> > To: "Richard Clarke" <ric@stripped>
> > Cc: <mysql@stripped>
> > Sent: Thursday, April 24, 2003 7:31 PM
> > Subject: Re: performance
> >
> >
> > > No I'm not sure. Infact I believe the default for FreeBSD 4.8 is
> pthreads.
> > > So I'm pretty sure I'm using pthreads (how do I check?). I heard
> > > linuxthreads on freebsd had problems with mysql (though 
> that tid bit
> might
> > > be out-dated?).
> > >
> > > -Ryan.
> > >
> > > ----- Original Message -----
> > > From: "Richard Clarke" <ric@stripped>
> > > To: "Ryan R. Tharp" <mysql@stripped>
> > > Sent: Thursday, April 24, 2003 4:23 PM
> > > Subject: Re: performance
> > >
> > >
> > > > Are you sure you have mysql compiled against linuxthreads?
> > > >
> > > > Ric
> > > >
> > > > ----- Original Message -----
> > > > From: "Ryan R. Tharp" <mysql@stripped>
> > > > To: <mysql@stripped>
> > > > Sent: Friday, April 25, 2003 12:11 AM
> > > > Subject: performance
> > > >
> > > >
> > > > Running MySQL 4.0.12 on a dual Xeon 2.8ghz with 2gb 
> memory running
> > FreeBSD
> > > 4.8 on a Hardware RAID 0+1 SCSI HDDs
> > > >
> > > > Have this table that I'm trying to optimize for. It has 
> 1.1million
> rows
> > > with 29 fields averaging 506 Bytes per row. We've considered
> > > > splitting the table but we don't have enough developer 
> time available
> to
> > > convert all the code that uses the table. So we'd like just
> > > > to throw hardware/memory at it for the time being.
> > > >
> > > > Some software tricks I've tried are playing with:
> > > > Dynamic sized rows and static sized rows
> > > > InnoDB and MyISAM
> > > > Indexes and No Indexes
> > > > Primary Keys and No Primary Key (Just an Index for the 
> auto-increment)
> > > >
> > > > I wrote a benchmark that tests most of these scenarios 
> and then I
> began
> > to
> > > adjust the various mysql buffers but to my amazement the
> > > > benchmarks ran best when I didn't set any buffers in 
> the my.cnf at
> all.
> > > >
> > > > Also the fastest benchmark numbers aren't that fast. Is 
> this table too
> > > big? Any other optimization tips to try? Any one have any
> > > > ideas or suggestions?
> > > >
> > > > -Ryan.
> > > >
> > > >
> > > >
> > >
> > >
> > >
> > > --
> > > MySQL General Mailing List
> > > For list archives: http://lists.mysql.com/mysql
> > > To unsubscribe:    
> http://lists.mysql.com/mysql?> unsub=jdisher@stripped
> > >
> >
> 
> 
> 



Thread
performanceRyan R. Tharp25 Apr
  • Re: performanceDan Nelson25 Apr
  • Re: performanceRyan R. Tharp25 Apr
    • Re: performancecolbey25 Apr
    • Re: performanceDan Nelson25 Apr
  • Re: performancecolbey25 Apr
  • Re: performanceRyan R. Tharp25 Apr
  • Re: performanceRyan R. Tharp25 Apr
    • Re: performancecolbey25 Apr
      • RE: performanceAdam Nelson25 Apr
        • Re: performanceJeremy Zawodny15 May
  • Re: performanceJonathan Disher25 Apr
  • Re: performanceRyan R. Tharp25 Apr
    • Re: performancecolbey25 Apr
    • Re: performanceChristian Jaeger28 Apr
  • Re: performanceRyan R. Tharp25 Apr
    • RE: performanceAdam Nelson28 Apr