How to lock MYSQL Data Tables

When performing a data table check or repair, You can first lock the data table to ensure the security of the data table:
Mysql> lock table tbl_name READ;
Mysql> flush tables;
Lock the data table before performing the check or repair. Then unlock the instance:
Mysql> unlock tables;
// Lock table tbl_name READ indicates that you want to LOCK the TABLE to a READ-only State. In this state, you can only READ data tables and cannot write data.
Lock table tbl_name WRITE is more strictly locked, and users cannot read or WRITE data.