Greetings. I have a simple oscommerce install hosted on a MediaTemple server. Yesterday the site was running slow so we called MT and the contact informed us that a query had been running for a long time (a few days). This is why the server was being bogged down.

I've been coding for about 2 years (self-taught) and never encountered this kind of issue before. My question is:

How do I detect these long-running queries so I can establish where they are coming from? Isn't there some kind of config in MySQL that I can set to keep this type of thing from happening?

Thanks

jw