Re: Several "Lock wait timeout exceeded; try restarting the transcation"

[Rick James]

How are you writing your transactions?

1. autocommit=ON?

2. autocommit=OFF and eventually COMMIT?

3. BEGIN...COMMIT?

#2 is error prone -- programmers tend to forget to COMMIT.
I recommend #3.

If that does not answer the question, please tell us more about the transactions that are going on.

Another recommendation: Batch your INSERTs. 100 at a time is 10x faster than 1 at a time.

Suggest using CURDATE() instead of Date(now()).