I have a INNODB table with txnno column without unique index but I have primary key on another column. Now I am inserting transaction from multiple places. And there are some concurrent insertion happening for same txnno.
So Is there it is required to use txnno as unique key or INNODB can have it implicitly.
And there is two type of entry. Form one place, I am using commit/rollback statment but there are some places Where I am not using that.
So how can I manage this without changing much code.
Also what is meant by 'no sessions' in the case of table locking.