100% CPU on MySQL: waiting locks and missing indexes
A small database server is shared by several websites, one of them a sales management application. At the start of the workday, staff open the orders page and it spins forever, while the database serv...











