Particularly given MySQL AB's comments in 2.2.2 Operating Systems Supported by MySQL. =dn
> 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. --------------------------------------------------------------------- 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
