Re: Intermittent slow performance
Posted by:
Max Loeb
Date: March 03, 2009 11:17PM
Still having no luck. I noticed that some of my tables were set to type InnoDB for no reason that I was aware of, so I switched them to MyISAM in a desperate hope that magic would happen, but alas. I've also been going over my logs trying to notice some common pattern to the queries, but pretty much any query seems susceptible, regardless of complexity of size of the tables involved.
It almost seems like queries wind up in a holding pattern, waiting for something else to finish. Or could it be some kind of memory problem?
Can any of you recommend some kind of course of action for analyzing this problem to see what's going on? I'm out of ideas!
Subject
Written By
Posted
Re: Intermittent slow performance
March 03, 2009 11:17PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.