Forums | Webyog
Tools to manage and monitor MySQL databases
forums › forums › SQLyog › SQLyog: Bugs / Feature Requests › Schema Synchronization Slow With Large Record Count
Tagged: Compare, schema, speed, Synchronization
I have several DB's that are to have the same schema. I have 1 as the master. I then do a Schema Synchronization between the Master and DB A or DB B.
Assuming DB A and DB B require the same exact updates, I have noticed that the Schema Sych may take 90 seconds for DB A, but 2 hours for DB B.
DB B is significantly larger (more records) than DB A, but how does that explain the huge time difference? Why does comparing schema's get so impacted by the records themselves?