One thing to bear in mind is that a good table design will often save you having to do any table locking. I have had some horrible experiences with having to lock tables which would have been avoided had the tables been well designed.

At this point I have to admit that most of the tables were designed by me, back when I knew less.

A decent primary key on a table can save a whole load of heartache later I can promise you :)