mysqldump locks all tables even when specifically grabbing a few? I'm using a mysqldump command pulling data from 3 tables of 7. Are the other 4 locked as well?
Use --single-transaction option, and it won't lock any, provided you are using a transaction-aware storage engine (pretty much anything except MyISAM and MEMORY engines)