On Tuesday 20 June 2006 08:49, Peter Van Dijck wrote: > 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.
http://www.google.co.uk/search?q=mysql+slow+query&ie=UTF-8&oe=UTF-8 Combined with show processlist / mysqltop, you can see if you have locking contention. -- Duncan Hill - Developer Critical Software +44 (0)870 770 8190 ---- Scanned by mailCritical. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
