idle transactions - active transactions on hot-write tables that do nothing during their lifetime. rollbacks - fake invalid queries that generate errors and increase rollbacks counter. waiting transactions - transactions that lock hot-write tables and then idle, leading to other transactions getting stuck deadlocks - simultaneous transactions where each holds locks that the other transactions want