Will deadlocks affect me, even if I don't use transactions?

In short, deadlocks can occur because (default settings is AUTOCOMMIT = ON meaning) every single statement ( SELECT UPDATE INSERT DELETE ) is treated as a separate transaction in InnoDB - and is autocommitted immediately after execution See: Implicit Transaction Commit and Rollback But, as @Johan points, they should be less of a problem in InnoDB than MyISAM, as row-level locking is used, wherever possible Also check @MarkR's answer in this question, for more details: Explain Inexplicable Deadlock For the stress testing, I've heard about but haven't used Super Smack which is a benchmarking and stress testing tool for MySQL and PostgreSQL But since most users will probably be using your web interface, any stress testing tool for such an interface may be enough for your needs.

In short, deadlocks can occur because (default settings is AUTOCOMMIT = ON, meaning) every single statement (SELECT, UPDATE, INSERT, DELETE) is treated as a separate transaction in InnoDB - and is autocommitted immediately after execution. See: Implicit Transaction Commit and Rollback But, as @Johan points, they should be less of a problem in InnoDB than MyISAM, as row-level locking is used, wherever possible. Also check @MarkR's answer in this question, for more details: Explain Inexplicable Deadlock For the stress testing, I've heard about but haven't used Super Smack, which is a benchmarking and stress testing tool for MySQL and PostgreSQL.

But since most users will probably be using your web interface, any stress testing tool for such an interface may be enough for your needs.

You have 2 very different questions here. 1 Yes, deadlocks can happen even when you don't explicitly use transactions, since "under the hood" row-level locking is used for all insert/update/delete statements. Read more here.2 In general, stress/performance testing is not a trivial task and there aren't many generic tools that will do it well.

How do you stress test other database changes (adding/changing/removing indexes, table schema changes)?

Thanks a lot, I'll read up on the docs and the other answers above. We haven't done any stress testing, only manual testing. But we found some tools called loadimpact.Com and loadstorm.

Com, that sounds like it could be useful. – Niclas Oct 20 at 6:26.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.