Hi,
I would like to make one correction. The server one has 2 IDE hard disks
and not SATA hard disks.
Thanks,
Abdul.
On Fri, 2006-04-28 at 16:33 +0530, Mohammed Abdul Azeem wrote:
> Hi,
>
> The following is the hard disk specs for both the servers:
>
> server one: ( whose performance is good )
> -----------
>
> class: HD
> bus: IDE
> detached: 0
> device: hda
> driver: ignore
> desc: "ST3200822A"
> physical: 16383/16/63
> logical: 24321/255/63
> -
> class: HD
> bus: IDE
> detached: 0
> device: hdb
> driver: ignore
> desc: "ST3200822A"
> physical: 16383/16/63
> logical: 24321/255/63
>
> This has 2 SATA hard disks of 200 GB capacity. There is no RAID
> configured.
>
> server two: ( whose performance is poor )
> ----------
>
> class: HD
> bus: SCSI
> detached: 0
> device: sda
> driver: ignore
> desc: "Seagate ST3146707LC"
> host: 0
> id: 0
> channel: 0
> lun: 0
> generic: sg0
> -
> class: HD
> bus: SCSI
> detached: 0
> device: sdb
> driver: ignore
> desc: "Seagate ST3146707LC"
> host: 0
> id: 1
> channel: 0
> lun: 0
> generic: sg1
>
> This has 2 SCSI hard disks of capacity 146 GB each. There is no RAID
> configured.
>
>
> Thanks,
> Abdul.
>
>
> On Fri, 2006-04-28 at 12:52 +0200, living liquid | Christian Meisinger
> 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.
> > >
> > > However the configuration file my.cnf is the same for both the machines.
> > > The first server has a 1GB RAM and a single processor. While the second
> > > server has a 2 GB RAM and it has a dual processor as well.
> > >
> > > If we go by the hardware specs the second server should take less time
> > > as it has a better hardware than the first one. Iam really puzzled .
> > > Can anyone help me out in fixing the issue ?
> >
> > How does the harddisk setup looks like on both servers?
> >
> >
>
> ________________________________________
> 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/[EMAIL PROTECTED]
