----- 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
