How to organize the import of bulk files and the work of other users in Laravel?

Question

Laravel

I have a price list for 500,000 lines imported into the database, the database is busy for about 10 minutes.
When the price list is loaded, the modal form with the file selection is hidden and the user can do what he wants.
Besides him, there are other users.
How to properly organize the work so that they do not edit records in the table when updates are loaded into it.
The same and other users can perform similar actions.
Can I make a global variable in which to display the state of the database, and check it every time it is accessed in the database?
Or make a record in a separate table in which to display the state of the database and check it?

Answer 1

https://dev.mysql.com/doc/refman/8.0/en/lock-table...
if you set a write lock, then no one except the existing connection can do anything with the table.
If you want reading to be possible, then you need to create a service table, which is locked at the beginning of any update (it turns out like a mutex), and the main table is not locked.