More Lock Contention

• Watch the lock counters

  • SHOW STATUS
    • Table_locks_immediate
    • Table_locks_waited
    • I like to see 100:1 ratio

• Optimize those queries

• Double-check indexes

• Use caching when possible

• InnoDB deadlocks

  • Transaction overuse