Hi Andy Is MySQL loading the tables in to memory? MySQL AB say running MySQL on 64bit system should be faster. Sorry I can not be more help. Simon
-----Original Message----- From: Andy Eastham [mailto:[EMAIL PROTECTED]] Sent: 13 January 2003 15:34 To: [EMAIL PROTECTED] Subject: Solaris Performance Hi, I've got a mysql application that was developed on win32 and linux that is now going to be deployed on a Sun E250 Solaris 9 box with 3 36Gb non raided SCSI disks. No problem I thought - the performance is fine on my PIII 850MHz laptop, so it will rock on an E250... Not the case - the laptop seems to be performing at twice the speed of the E250 for a simple select from a table of 55 million simple rows (just 3 floating point numbers per row - the .MYD file is 700Mb and the .MYI index file is 2.7Gb). It takes 1.2 seconds on the laptop and 2.5 seconds on the sun. This is a big problem, as I have to do three of these queries plus processing and return in under 10 seconds. The laptop takes 6 seconds, the Sun takes 12. I've got a Linux PIII 933MHz Dell Server which at least half as much again faster than the laptop. I've increased the key cache to 250Mb on the Sun (it's at the default on the laptop), but no radical difference was apparent. The Sun install is pretty much out of the box, apart from the file system organisation. MySQL has its own disk. I'm running the 32 bit variants of MySQL. Would the 64 bit be any different (Solaris 9 is installed with 32 bit and 64 bit support)? Has anyone got any similar experience? Can any one recommend trying anything? Any help, comments or suggestions would be very much appreciated. Thanks very much, Andy [mysql query] --------------------------------------------------------------------- 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 --------------------------------------------------------------------- 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
