Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Synchronization Problems

forums › forums › SQLyog › Sync tools, Migration, Scheduled Backup and Notifications › Synchronization Problems

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • September 29, 2005 at 4:19 pm #19343
      Ritesh
      Member

      What is the error you are getting?

      Can you give me more info about your MySQL (source and target) & SQLyog versions? How big is the table that you are trying to sync?

    • September 29, 2005 at 7:31 pm #19344
      peterlaursen
      Participant
      Quote:
      but sometimes never finish

      You must understand the the client (the computer running the sync job) must do a lot of calculations (calculations of checksums). That can take a lot of time is there are many BIG field (BLObs etc) and many rows. Also database servers at ISP often are very slow at the type of queries that the sync job needs.

      The solution is to use the and options effectively so that no time is wasted doing a lot of calculations that there is no need to do.

      I persoanlly have an example where the time for a sync job was reduced from 11 hours to 5 minutes using these options.

      You can try if you can read this paper:

      http://www.webyog.com/forums/index.php?showtopic=1507

      I have a newer version that I can mail you, if you PM me your mail adress.

  • Author
    Posts
Viewing 1 reply thread
  • You must be logged in to reply to this topic.