Re: Deadlock Detection in InnoDB storage engine

[Manjunath C]

Hi Aftab/Rick,

Thanks for all the support we got.
We finally migrated from GUID to INTEGERS as our primary key using built in AUTO_INCREMENT feature with InnoDB Engine as default storage Engine.
We also moved from GUID to INTEGERS for WHO columns in our application.

I am very glad to update few of the performance improvement seen in our application.(4 compute units 7.5 GB ram)
We ran the test both on GUID and INT as Primary Keys for 15K records.
1. Database storage size reduced to nearly 400%.
2. We have Batch Billing module which improved 700%.
3. Creating the accounts I/O operations improved by nearly 400%.


I would like to thank again for the support from the forum.

Regards,
Manjunath.