Jeremy, Thanks for replying. It's CPU bound.
The 64 bit version has improved things a little - about 5-10%. I just expected an enterprise server to be faster than a laptop running win2k with an IDE, Tomcat, Outlook, Office all at the same time... I now know better. I'm thinking of putting a fast Intel Linux box behind the sun box as a database server, and leaving the sun to run apache and tomcat. Hopefully this will give me the best of both worlds. Thanks again, Andy > -----Original Message----- > From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]] > Sent: 14 January 2003 18:50 > To: Andy Eastham > Cc: [EMAIL PROTECTED] > Subject: Re: Solaris Performance > > > 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 > > --------------------------------------------------------------------- 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
