Uploaded image for project: 'Sqoop'
  1. Sqoop
  2. SQOOP-539

getPrimaryKeyQuery is very slow in mysql 5.0.77

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 1.4.1-incubating
    • Fix Version/s: 1.4.2
    • Component/s: connectors/mysql
    • Labels:
    • Environment:

      mysql 5.0.77-percona-highperfb0805

      Description

      The current query used to get the primary key for a table takes 20 seconds in my production environment and 11 minutes in my QA environment. I simplified it and it now runs very fast (0.08 seconds in my production environment). I'm submitting the patch I applied locally.

        Attachments

        1. patch
          0.8 kB
          Jhovanny
        2. patch
          0.8 kB
          Jhovanny
        3. patch
          1 kB
          Jhovanny

          Activity

            People

            • Assignee:
              jhovanny Jhovanny
              Reporter:
              jhovanny Jhovanny
            • Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: