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
========================================
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
