List:General Discussion« Previous MessageNext Message »
From:Ryan R. Tharp Date:April 24 2003 11:31pm
Subject:Re: performance
View as plain text  
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.
>
>
>


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