I am trying to diagnose repeated lock wait timeouts from my ASP.NET app to MySQL 5.1. I'm using MySQL Connector/NET 6.2.3.
I don't see anything MySQL-related in Perfmon's Performance Object dropdown list.
What else can I do to try to diagnose these issues?