Question :
I’m using a mysqldump command pulling data from 3 tables of 7. Are the other 4 locked as well?
Answer :
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)