LOCK TABLES

[JULIANO KOCH ERP]

Good evening, I have a problem with a client. When executing an update routine for two tables, one performing an Update and the other an Insert, at certain times, not always, the system crashes. When I check the connections via MySQLAdministrador, I see that the hanging station has Lock Tables in a table. This lasts around 3 minutes until it comes back... and in this case, no one who is logged into the system can work... everything freezes. Is there something I can check and adjust in the bank settings?

I've already selected setup_instruments in performance_schema and there is no record so I can disable the lock tables function.


If anyone has experienced this or knows how to resolve it, I would appreciate it.

hugs,

Juliano Koch