List:General Discussion« Previous MessageNext Message »
From:Sasha Pachev Date:May 4 1999 9:58pm
Subject:Re: mysql is 10 time slowwer on Solaris 2.5.1 than Solaris 2.6
View as plain text  
Richard Skelton wrote:
> 
> Hi
> I have downloaded the mysql-3.22.22-sun-solaris2.6-sparc.tar.gz for my machine
> and mysql-3.22.22-sun-solaris2.5.1-sparc.tar.gz for my target machine.
> 
> It installed fine on both machine and runs my database instance.
> The Solaris 2.6 machine is an Ultra 1/170E with 192MB RAM
> The Solaris 2.5.1 machine is an Ultra 30 250MHz with 128 MB RAM
> My database has 18000 records and 30 100CHAR fields
> On Solaris 2.6 it takes 0.5 second to perform a simple select but on the faster
> Ultra 30 it take 5.0 seconds.
> Are there some settings for /etc/system that Solaris 2.5.1 needs to perform like
> Solaris 2.6
> 
> The disk on the Ultra 30 is much faster than my Ultra 1/170E

It is very possible that Ultra 1/170E can fit the entire
table into RAM, while Ultra 30 cannot. Can you add more
RAM to Ultra 30 to see if it will work faster? 

-- 
Sasha Pachev
http://www.sashanet.com/ (home)
http://www.direct1.com/ (work)
Thread
mysql is 10 time slowwer on Solaris 2.5.1 than Solaris 2.6Richard Skelton5 May
  • Re: mysql is 10 time slowwer on Solaris 2.5.1 than Solaris 2.6Sasha Pachev5 May