t;[EMAIL PROTECTED]>
To: "Jay 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
TED]>
Sent: Tuesday, April 30, 2002 3:34 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 configurati
times 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 configura
[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 use
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
, so more memory won't help
much unless you use it in my.cnf and the kernel configuration allows
it!
Hope this helps,
Ken
- Original Message -
From: "Jay Blanchard" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, April 30, 2002 2:04 PM
Subject
Howdy all,
We have a curious situation here, and I was wondering if any of you have
encountered this before.
We have MySQL installed on a FreeBSD machine (733mHz, 256Mb RAM). Compiled
from source.
We installed MySQL on another FreeBSD machine (dual 866mHz, 512Mb RAM).
Compiled from source.
The
