On Apr 18, 11:39 pm, Walter Vaughan <wvaug...@steelerubber.com> wrote:
> terence.par...@gmail.com wrote:
> > I've tried searching online for performance comparisons between MySQL
> > 32 and 64-bit platforms, but can only find benchmarks dating back a
> > few years using MySQL 4.x . Now we're on MySQL 5.0 and I cannot seem
> > to find such evidence backing up the speed benefits (or otherwise) of
> > a 64-bit processor.
>
> IANAL, but unless you have more than 4 gig of memory, you really don't get a
> gain from a 64bit OS vs. a 32bit. There are performance hits to look past the 4
> gig window with a 32bit OS. In a 2 gig box, their is almost imperceptable
> overhead of the 64bit OS, yet you have to also endure the lack of hardware
> driver intergration, so you buy yourself trouble for no gain.

Thanks for that...

Our server currently has 4gb memory but I can't rule out getting more
in the future - I guess that puts us just on the borderline!

I'm not to keen on downgrading to using 32-bit software, but failing
finding a solution to this Chinese language searching plugin I may
have to consider deploying a second server just for searching Chinese.

.... except it would help if federated tables supported FULLTEXT
search.

In any case, thanks for your input!

- Terence