improved performance (removed some unnecessary transactions) and upped mysql connector version number