When mysqldump is run with --lock-tables against a database using MyISAM tables, the documentation states that each table is locked with READ LOCAL. As I understand it, READ LOCAL allows for concurrent inserts from other sessions.
I have a few questions regarding this.
With READ LOCAL, the only operations not available to other sessions are TRUNCATE, UPDATE, and DELETE. INSERTS and SELECTS will process normally on a table locked with READ LOCAL from other sessions, provided there are no 'holes' in the table. Is this a correct assumption?
In the case of making backups with mysqldump, since concurrent inserts are allowed and tables are locked sequentially (multiple table backups) then what is preventing relational tables from becoming inconsistent? Will the table dump contain data that was possibly added after the LOCK TABLE was issued?
Thank you for your time.