Recently one of the user tried to delete a test run created by him in our organization. While delete confirmation was given, a pop up showed the progress of delete process, suddenly an error message was thrown which starts like ‘[DeadlockException] Lock wait timeout exceeded; try restarting transaction’. While searching for solutions online, I was redirected by various causes and at the end I suspect it to be a SQL R/W issue due to less IBPS (MySql InnoDB buffer pool space ). Also, I tried to figure out how much is need and what might be the gap, it ended with 9 GB of required space where the current allocated space is just 512 MB. I am not sure whether this much buffer is required by one single application in a server. So please enlighten me on this.
I have referred following links for analysis: