Jatin Nansi wrote:
>I have 2 servers 1 running redhat 7.2 and the other running suse 7.3.
>the hardware config is :
>RH7.2: Fast desktop (IDE HDD/128 MB memory PIII 550 MHz).
>Suse 7.3: Low end server (Ultra SCSI 2, PIII 850 MHz, 256 MB RAM).
>Now i expect to see the suse server go faster than RH, but i am
>having the reverse happening. The RH server returns a query about
>5 times faster.
> [here be snippage....]
Jatin, not sure about the low level stuff in MySQL, but a couple of things
occur to my challenged brain:
1. It's not necessarily true that a U-SCSI system will go faster than an
IDE one. I've seen some pretty convincing
benchmarks with 'old' 7200 rpm SCSI disks against the latest 7200 ATA-100,
which show that the IDE system is faster
in real world tests. Now if it were a 10K UltraStar disk on a fancy U160
controller, that might be different....
2. Check what else the Suse system has installed and is running in the
background. I've migrated my two systems,
(Athlon-based 'base' station and PII/266 laptop) to Suse 7.3 from RH7.0,
and there appears to be way more background
systems running on Suse than on the old RH one. (Like why do
Mandrake/Suse/RedHat insist on running the PCMCIA service
on a system that doesn't have PCMCIA sockets?)
3. What file system are you running. I've heard that ReiserFS, and
journalling systems in particular, make better use
of the device-peering facilities that SCSI has, presumably where you've got
a multi disk setup.
That said, I'm concerned about the 5x difference. If this is the same RPM
binary (from MySQL where else?), then I'd be VERY
tempted to put in a support call or, failing that, raise it on one of the
Suse user lists. At the end of the day, the best way to benchmark
OSs is to put one on, do the tests, then clear system, install OS#2 and
repeat test.
Regards
Bob Cross.
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
This message is confidential. It may also be privileged or
protected by other legal rules. It does not constitute an
offer or acceptance of an offer, nor shall it form any part
of a legally binding contract. If you have received this
communication in error, please let us know by reply then
destroy it. You should not use, print, copy the message or
disclose its contents to anyone.
E-mail is subject to possible data corruption, is not
secure, and its content does not necessarily represent the
opinion of this Company. No representation or warranty is
made as to the accuracy or completeness of the information
and no liability can be accepted for any loss arising from
its use.
This e-mail and any attachments are not guaranteed to be
free from so-called computer viruses and it is recommended
that you check for such viruses before down-loading it to
your computer equipment. This Company has no control over
other websites to which there may be hypertext links and no
liability can be accepted in relation to those sites.
Scottish & Newcastle plc
Registered in Scotland, Registered Number 16288
Registered Office: 33, Ellersly Road, Edinburgh, EH12 6HX
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
