Hi ,
We are getting following message multiple times in mysqldb.err
file:--
----------------------------------------------------------------------------
--------------------
020829 13:46:39 Aborted connection 9556 to db: 'storageprofiler' user:
'root' host: `localhost' (Got an error reading communication packets)
----------------------------------------------------------------------------
----------------------
conect_timeout and all other configuration parameters are set to default.
Our queries are running extremely slow on Solaris server while it is
really fast on Windows. (I had posted this message yesterday which can be
found at the end of this e-mail).
Has anybody encountered such problem before?
Thanks,
Supriya
----- Original Message -----
From: "Supriya Shiyekar" <[EMAIL PROTECTED]>
To: "Mark Matthews" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, August 28, 2002 5:18 PM
Subject: Re: MySql performance problem
> 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
