How can I find out which queries are causing these errors?

Question

MySQL

Hello, how can I find out what requests are causing such errors?
I understand only why there is an error with blocking rows Innodb, tk. I have 750,000 visits per day with several updates on the same line (about 3M line updates) how can this be optimized? Will changing this table to myisam help?

Answer 1

for several updates on the same line (about 3M line updates) how can this be optimized?

Find it first, by profiling the application, or at least look at show full processlist and optimize slow queries.
Not