Hi, The Server2 is not a slave. Seperate inserts were done on two different mysql servers.
Thanks, Abdul. On Fri, 2006-04-28 at 12:01 -0400, Kishore Jalleda wrote: > > > On 4/28/06, Mohammed Abdul Azeem <[EMAIL PROTECTED]> 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 ? > > Thanks, > Abdul. > > > ________________________________________ > 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? > [EMAIL PROTECTED] > > > > Is the server2 a slave of server1, and is the same insert on server2 > run directly on it or is itpart of a replicated query from server1. > This came to my mind as u mentioned the two servers are geographically > seperated .. > > Kishore Jalleda > http://kjalleda.googlepages.com/projects > ________________________________________ 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]