We have several lock issues on tabSeries, because we have lots of concurrent users creating heavy transactions that use naming series.
Since tabSeries currently uses InnoDB, several transactions are blocked during many seconds, waiting until current transaction is finished.
In order to avoid this, would it be advisable to change tabSeries to MyISAM? What would be the implications of it?
I know that if a transaction is rolled back, the number sequence would be lost. But it’s a minor setback when compared to the locking problem.
I saw here many discussions about the problem, but it seems there isn’t a clear solution.
1 Like
rmehta
2
Use separate series numbers (example for different warehouses) or use the random hash