Re: Deadlock while doing performance testing in clojure/mysql

[prasanna perumal]

Thanks Rick.

Please find the requested details below:

1. moin_id is not included in column values as it was set it as autoincrement.
2. We have more than 4GB of physical memory. Is it a good idea to increase the innodb_buffer_pool_size from innodb_buffer_pool_size=2G to 3G
3. All the fields are NULLable; this is probably a mistake as this is the requirement.
4. Deadlock error was thrown even after changing the value for innodb_flush_log_at_trx_commit from 1 to 2.
5. we don't have select query for that table.
6. Transaction is managed by framework itself.
7. We haven't implemented retry logic in our code. Should we try one more time if it fails or need to retry for 2 or 3 times.

Are there any parameters that we can change to fix this issue. Basically, I am a java developer. Can you please explain what exactly happening here.

Thanks & Regards,
P.Prasanna