On Mon, Jan 13, 2003 at 03:34:29PM -0000, Andy Eastham wrote: > > 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...
I'm not sure why you thought that, but... > 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. Is it disk or I/O bound? > 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. Then it probably wasn't the bottleneck. Have you looked at system activity to get an idea of what it is (or it not) doing? Disk I/O? Paging? CPU? Memory pressure? > 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)? Maybe. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 3.23.51: up 30 days, processed 1,007,094,133 queries (381/sec. avg) --------------------------------------------------------------------- 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
