Hi, Maybe you can use --log-slow-queries.
http://dev.mysql.com/doc/refman/5.0/en/slow-query-log.html Gu Lei ----- Original Message ----- From: "Peter Van Dijck" <[EMAIL PROTECTED]> To: <mysql@lists.mysql.com> Sent: Tuesday, June 20, 2006 3:49 PM Subject: finding the slow query > Hi, > I have some troubles finding the slowest queries. > > My server has regular high loads when a lot of queries that hit the > same tables slow down. The question is, which query is slowing it > down? The others are probably just slow because the whole thing is > slow. > > And a related question: what's a good strategy to figure out if table > locking is causing queries to be slow? > > Thanks for any pointers, > Peter > > -- > find videoblogs: http://mefeedia.com > my blog: http://poorbuthappy.com/ease/ > my job: http://petervandijck.net > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] >