Lock Contention

• MyISAM tables use table locks

  • Many readers or one writer

• Watch your read/write ratio

  • Many reads, few writes: good
  • Many writes, few reads: good
  • Many of both: bad
  • SHOW STATUS
    • Com_select, Com_insert
    • Com_update, Com_delete