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