don't lock tables explicitly. That's a killer for (concurrent) performance.Just write queries properly, and use appropriate transaction level.And you are sorted.