Hi Mark, Thanks for the reply. I have got more information.
1. We set only the port, basedir and datadir parameters for mysql on both Windows and Solaris machines. All other configuration parameters are default. 2. Setup for Windows Machine :- OS - Windows 2000 professional SP2 RAM - 196 MB CPU - Pentium III 600MHz Disk Drive - C:\- 14 GB No SCSI Setup for Solaris Server :- >System Configuration: Sun Microsystems sun4u 8-slot Sun > >Enterprise E4500/E5500 > >System clock frequency: 84 MHz > >Memory size: 2048Mb > > > >========================= CPUs ========================= > > > > Run Ecache CPU CPU > >Brd CPU Module MHz MB Impl. Mask > >--- --- ------- ----- ------ ------ ---- > > 0 0 0 336 4.0 US-II 2.0 > > 0 1 1 336 4.0 US-II 2.0 > > 2 4 0 336 4.0 US-II 2.0 > > 2 5 1 336 4.0 US-II 2.0 > > > > > >========================= Memory > > Intrlv. > > Intrlv. > >Brd Bank MB Status Condition Speed Factor > > With > >--- ----- ---- ------- ---------- ----- ------- > > ------- > > 0 0 1024 Active OK 60ns 2-way > > A > > 2 0 1024 Active OK 60ns 2-way > > A > > > >========================= IO Cards > >========================= > > > > Bus Freq > >Brd Type MHz Slot Name > > Model > >--- ---- ---- ---- -------------------------------- > > ---------------------- > > 1 SBus 25 0 fcaw/sd (block) > > FCW > > 1 SBus 25 1 fcaw/sd (block) > > FCW > > 1 SBus 25 2 SUNW,qfe > > SUNW,sbus-qfe > > 1 SBus 25 2 SUNW,qfe > > SUNW,sbus-qfe > > 1 SBus 25 2 SUNW,qfe > > SUNW,sbus-qfe > > 1 SBus 25 2 SUNW,qfe > > SUNW,sbus-qfe > > 1 SBus 25 3 SUNW,hme > > > > 1 SBus 25 3 SUNW,fas/sd (block) > > > > 1 SBus 25 13 SUNW,socal/sf (scsi-3) > > 501-3060 > > > >No failures found in System > >=========================== > > > >No System Faults found > >====================== > > Thanks for the help, Supriya. > ----- Original Message ----- > From: "Mark Matthews" <[EMAIL PROTECTED]> > To: "Supriya Shiyekar" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > Sent: Wednesday, August 28, 2002 7:02 AM > Subject: Re: MySql performance problem > > > > ----- Original Message ----- > > From: "Supriya Shiyekar" <[EMAIL PROTECTED]> > > To: <[EMAIL PROTECTED]> > > Sent: Tuesday, August 27, 2002 10:59 PM > > Subject: MySql performance problem > > > > > > > > > > Hi, > > > > > > We are having strange performance problem with mysql on > Solaris.Our > > > application makes JDBC calls to mysql database which resides locally on > > the > > > machine. > > > It takes 3 minutes to execute a piece of code(which involves > select, > > > insert and update queries) on a Windows machine but an hour on Solaris. > > Both > > > databases(on windows and solaris) have exactly same database structure > > > including indexes and table sizes. > > > We are using mysql 3.23.44. > > > Is this something to do with the memory allocated to mysql on > > Solaris > > > machine ? Do we need to check any server parameters for mysql ? > > > > What is the setup of the two machines? (CPU/RAM/Disk/SCSI/IDE, etc), and > > what configuration parameters are you using now? Without this, you're > asking > > us to guess, more information from you would get a better answer. > > > > -Mark > > > > > > > > --------------------------------------------------------------------- > > 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