Jatin Nansi <[EMAIL PROTECTED]> writes: > Hi list, > > 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. > > For eg: > on RH: > ---------------------------------------------------------------------------- > mysql> select straight_join docm.document_id, docm.document_title, > docm.document_date, sources.source_name, cliptypes.cliptype, byline.byline > from keywords, documents_7 as docm use index (PRIMARY), dockeys_7 as dock, > sources, cliptypes, byline where keywords.keyword_id=dock.keyword_id and > docm.document_id=dock.document_id and docm.document_source_id = > sources.source_id and docm.document_cliptype_id = cliptypes.cliptype_id and > docm.document_byline_id = byline.byline_id and ( keywords.keyword="assam" ) > order by docm.document_id; > > <Lots of results> > > | 219401 | WRONG POLICIES ARE THE BANE OF ASSAM > | 2000-08-21 | THE HINDUSTAN TIMES (DELHI) | N. A. | > PARASHAR, UTPAL | > >+-------------+--------------------------------------------------------------+---------------+------------------------------------------------+----------+------------------------+ > 276 rows in set (2.78 sec) > > same query on suse: > > <Lots of results> > > | 219401 | WRONG POLICIES ARE THE BANE OF ASSAM > | 2000-08-21 | THE HINDUSTAN TIMES (DELHI) | N. A. | > PARASHAR, UTPAL | > >+-------------+--------------------------------------------------------------+---------------+------------------------------------------------+----------+------------------------+ > 276 rows in set (7.06 sec) > > This happens for all queries.
> Of course the data is the same on both systems. The mysqld is what comes > with the distrib. (RH - mysql-3.23.22-6 / Suse - mysql-3.23.41-17). That's not what we shipped in RHL 7.2 - that was 3.23.41-1 As for reasons for speed difference, it could be different kernels with different options (the new VM in 2.4.10 and up was very suspect for a long time, and still has some warts), different compilers (we have a mature, stable and well performing compiler in 2.96RH - 2.95 was a bad release, 3.0 still has some warts). Our optimized glibc could also make a difference if Suse doesn't have this. Different filesystems could also mean a difference. -- Trond Eivind Glomsrød Red Hat, Inc. --------------------------------------------------------------------- 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
