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

Backup As Sql Vs Mysqldump Speed?

forums › forums › SQLyog › Using SQLyog › Backup As Sql Vs Mysqldump Speed?

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • July 29, 2009 at 8:00 am #29376
      peterlaursen
      Participant

      We had some benchmarks with the latest improvements to our backup where SJA was typically 5-10% faster than mysqldump as far as I remember. Provided of course that SJA is running on the MySQL machine.

      Maybe our test team can find more details (data types, database size etc).

    • July 29, 2009 at 9:19 am #29377
      Mahesh
      Member

      We tried with remote database within LAN for 20 tables ( having 500K rows) and few funcions, views, store procedures and triggers ( SQL file is 350 M:cool:.

      Both SQLyog and MySQLdump took same time to perform the export operation( 1 minute and 35 seconds).

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