Hi Jay,
There are other things that could be affecting the performance
besides mysql. If both machines are idle. The long query should run
about the same on the new machine. One thread will only run on one
processor no matter how you compile mysql. For compiling MySQK on
FreeBSD use the
Hi,
I don't have any experience with FreeBSD; however, I use MySQL on SMP
servers with Linux.
1. due to MySQL architecture (1 thread per connection) you should not
expect any performance
inprovement on a dual processor for a SINGLE SQL query compared to an
uniprocessor machine.
This is what
[snip]
I would suspect other things first such as the my.cnf configuration
(show variables) or has the kernel been optimised on the old box.
Did you check kernel configurations and disk subsystems? Also the
default process size on FreeBSD is 256Meg, so more memory won't help
much unless you
the indexes don't
copy.
-Original Message-
From: Jay Blanchard [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 30, 2002 3:34 PM
To: [EMAIL PROTECTED]
Subject: RE: MySQL Performance on Dual Processor machine
[snip]
I would suspect other things first such as the my.cnf configuration
(show
PM
Subject: RE: MySQL Performance on Dual Processor machine
[snip]
I would suspect other things first such as the my.cnf configuration
(show variables) or has the kernel been optimised on the old box.
Did you check kernel configurations and disk subsystems? Also the
default process size
Blanchard [EMAIL PROTECTED];
[EMAIL PROTECTED]
Sent: Tuesday, April 30, 2002 5:09 PM
Subject: Re: MySQL Performance on Dual Processor machine
Just becareful not to use too much memory unless you raise the DMAX
and such values (see /usr/src/sys/i386/conf/LINT ) if mysql runs out
of memory things