Does mysql lock table while inserting new recored

Databases
1

hi there
does mysql lock table while inserting new recored? if yes, is there any solution to prevent it and what is the pros and cons of locking table while inserting?

thanks in advance.

2

Pros and cons http://www.databasejournal.com/features/mysql/the-pros-and-cons-of-mysql-table-locking.html

Know more about locking at https://dev.mysql.com/doc/refman/5.7/en/table-locking.html

3

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.