[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql
Subject:    Re: ~Mysql performance~
From:       Mohammed Abdul Azeem <abdul () riskspan ! com>
Date:       2006-04-30 9:37:54
Message-ID: 1146389154.2787.27.camel () linux0129 ! dev02 ! newbreak ! com
[Download RAW message or body]

Hi,

The insert queries are run from the localhost on both the machines.

-Abdul

On Fri, 2006-04-28 at 10:28 -0700, Atle Veka wrote:
> On Fri, 28 Apr 2006, Mohammed Abdul Azeem wrote:
> 
> > Hi,
> >
> > I have 2 mysql servers with version 5.0.15-standard-log running on
> > redhat es4 installed on 2 different geographic locations. The default
> > storage engine used is innodb on both the servers. I run an insert query
> > on both the servers that inserts 25,00,000 records. first server takes
> > 7.5 hrs, while the second server takes around 17 hrs for the same
> > process.
> 
> Are these queries run from localhost or from a remote location? It's very
> unusual for an IDE based system to outperform SCSI.
> 
> 
> Atle
> -
> Flying Crocodile Inc, Unix Systems Administrator
> 
> ========================================
> ________________________________________
> This email has been Scanned for Viruses!
>           www.newbreak.com

________________________________________
This email has been Scanned for Viruses!
          www.newbreak.com

========================================

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=mysql@progressive-comp.com

[prev in list] [next in list] [prev in thread] [next in thread]