[SQOOP-539] getPrimaryKeyQuery is very slow in mysql 5.0.77

• 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: performance

Environment

mysql 5.0.77-percona-highperfb0805

• Assignee: Jhovanny
• Reporter: Jhovanny
• Created: 06/Aug/12 01:53
• Updated: 07/Aug/12 12:07
• Resolved: 07/Aug/12 06:13

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.